Does anybody know any working example of using embedded MySQL library
for Win32 (libmysqld.dll) ? That example from MySQL manual does not
work for me. I am looking for Python API to libmysqld.dll.. .
--
JZ 10 2707
JZ wrote: Does anybody know any working example of using embedded MySQL library for Win32 (libmysqld.dll) ?That example from MySQL manual does not work for me. I am looking for Python API to libmysqld.dll.. .
You may want to consider this, which doesn't require you to ship any
external DLLs: http://sourceforge.net/projects/mysql-python
Joe
On Wed, 26 Nov 2003 17:31:35 GMT, Joe Francia <us****@soraia. com>
wrote: Does anybody know any working example of using embedded MySQL library for Win32 (libmysqld.dll) ?That example from MySQL manual does not work for me. I am looking for Python API to libmysqld.dll.. .
You may want to consider this, which doesn't require you to ship any external DLLs: http://sourceforge.net/projects/mysql-python
No, you did not understand me. I know this library and I have been
using it for a long time. But the problem is I want to move my web
(pythonic) application to CD and I wanted it to work with MySQL as a
DLL library. I do not want to install full mysql serwer.
I know how to use MySQLdb connection for a server, but I do not know
how to connect to that dll. If MySQLdb can do this I do not know how
use it. (MySQLdb.Connec t() method has parameters of host, login but
libmysql.dll do not need such parameters.)
--
JZ
JZ fed this fish to the penguins on Wednesday 26 November 2003 03:30 am:
Does anybody know any working example of using embedded MySQL library for Win32 (libmysqld.dll) ? That example from MySQL manual does not work for me. I am looking for Python API to libmysqld.dll.. .
If I understand my book (hmmm, looks like New Riders has been
swallowed by SAMS and renamed to "Developer' s Library"), that DLL would
have to be specified to the linker in place of the regular client
protocol library. If so, to get Python to use it will likely require
rebuilding the MySQLdb modules changing the linkage option.
-- =============== =============== =============== =============== == < wl*****@ix.netc om.com | Wulfraed Dennis Lee Bieber KD6MOG < wu******@dm.net | Bestiaria Support Staff < =============== =============== =============== =============== == < Bestiaria Home Page: http://www.beastie.dm.net/ < Home Page: http://www.dm.net/~wulfraed/ <
On Sat, 29 Nov 2003 01:00:34 GMT, Dennis Lee Bieber
<wl*****@ix.net com.com> wrote: Does anybody know any working example of using embedded MySQL library for Win32 (libmysqld.dll) ? That example from MySQL manual does not work for me. I am looking for Python API to libmysqld.dll.. . If I understand my book (hmmm, looks like New Riders has been swallowed by SAMS and renamed to "Developer' s Library"), that DLL would have to be specified to the linker in place of the regular client protocol library. If so, to get Python to use it will likely require rebuilding the MySQLdb modules changing the linkage option.
Do you know how to rebuild this module using Visual Studio 7 instead
of v6? Is it possible?
--
JZ
On Sat, 29 Nov 2003 01:00:34 GMT, Dennis Lee Bieber
<wl*****@ix.net com.com> wrote: Does anybody know any working example of using embedded MySQL library for Win32 (libmysqld.dll) ? That example from MySQL manual does not work for me. I am looking for Python API to libmysqld.dll.. . If I understand my book (hmmm, looks like New Riders has been swallowed by SAMS and renamed to "Developer' s Library"), that DLL would have to be specified to the linker in place of the regular client protocol library. If so, to get Python to use it will likely require rebuilding the MySQLdb modules changing the linkage option.
I recompiled MySQLdb but I still do not know how to connect to embed
server... :( MySQL.Connect(h ost=...)???? There is no example nor
explanation. Not at all.
--
JZ
JZ wrote: On Sat, 29 Nov 2003 01:00:34 GMT, Dennis Lee Bieber <wl*****@ix.net com.com> wrote:
Does anybody know any working example of using embedded MySQL library for Win32 (libmysqld.dll) ? That example from MySQL manual does not work for me. I am looking for Python API to libmysqld.dll.. .
If I understand my book (hmmm, looks like New Riders has been swallowed by SAMS and renamed to "Developer' s Library"), that DLL would have to be specified to the linker in place of the regular client protocol library. If so, to get Python to use it will likely require rebuilding the MySQLdb modules changing the linkage option.
Do you know how to rebuild this module using Visual Studio 7 instead of v6? Is it possible?
-- JZ
Unless you're totally married to MySQL, you may want to consider using
one of the embeddable databases for Python, such as Sleepycat's
Berkeley, Metakit, PySQLite, Kinterbase, etc. I've used Berkeley,
Metakit and PySQLite, and they're all very good, each serving somewhat
different needs. Shouldn't be too much effort to pull the data out of
MySQL and into something else.
Peace,
Joe
On Sat, 29 Nov 2003 08:40:56 GMT, Joe Francia <us****@soraia. com>
wrote: Unless you're totally married to MySQL, you may want to consider using one of the embeddable databases for Python, such as Sleepycat's Berkeley, Metakit, PySQLite, Kinterbase, etc. I've used Berkeley, Metakit and PySQLite, and they're all very good, each serving somewhat different needs. Shouldn't be too much effort to pull the data out of MySQL and into something else.
I do not want to use other database because my application *have to*
work in full mysql server *and* (with _very_ little effort) with embed
sql *without changing any sql queries*. It is multiplatform
application (MySQL/Linux & MSSQL2k/Win32) I thought about SQlite, but
it is no compatible with some queries. and I do not want to parse them
with regular expressions.
I checked mysql.h and I found the following piece of code:
/*
Set up and bring down the server; to ensure that applications will
work when linked against either the standard client library or the
embedded server library, these functions should be called.
*/
int STDCALL mysql_server_in it(int argc, char **argv, char **groups);
void STDCALL mysql_server_en d(void);
Those functions seems to be *no implemented* in MySQLdb (I could not
find them in _mysql.c file) :(
If I understood the comment above, MySQLdb could be compiled with
standard client library or with embed server library - not with both
of them, right? :(
--
JZ
JZ fed this fish to the penguins on Friday 28 November 2003 17:51 pm: Do you know how to rebuild this module using Visual Studio 7 instead of v6? Is it possible?
Sorry, all I have is the training wheels edition of VC6 (IE, the
nagware executable type). I've always relied upon the pre-built files
when I can find them.
-- =============== =============== =============== =============== == < wl*****@ix.netc om.com | Wulfraed Dennis Lee Bieber KD6MOG < wu******@dm.net | Bestiaria Support Staff < =============== =============== =============== =============== == < Bestiaria Home Page: http://www.beastie.dm.net/ < Home Page: http://www.dm.net/~wulfraed/ <
JZ fed this fish to the penguins on Saturday 29 November 2003 01:07 am: If I understood the comment above, MySQLdb could be compiled with standard client library or with embed server library - not with both of them, right? :(
According to the book I have, the "final application" would have to be
linked to one or the other; the calls made are the same, those that
don't mean anything in one form are no-ops.
For Python usage, I hypothesize that one could possibly build a
version of MySQLdb (recommend modifying the name... maybe call it
MySQLdbe for embedded) linking to the second library. Changing the
import statement /should/ then be all that is needed to change
libraries. (I suspect it is much too late to make MySQLdb a package
with .client and .embedded subparts.)
Getting someone to actually /do/ the work of dual builds is another
matter. Hopefully the link is not tied to any particular library
version.
-- =============== =============== =============== =============== == < wl*****@ix.netc om.com | Wulfraed Dennis Lee Bieber KD6MOG < wu******@dm.net | Bestiaria Support Staff < =============== =============== =============== =============== == < Bestiaria Home Page: http://www.beastie.dm.net/ < Home Page: http://www.dm.net/~wulfraed/ < This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: David Jackson |
last post by:
Can we usr libmysqld (embedded MySQL server) and PHP?
If this is possible I would greatly appreciatedif someone would eiter point me
to example,docs,tutorials or provide a brief example.
Anther way to ask this might, how do I make a call to a library in general?
TIA,
David
|
by: Rajas Sambhare |
last post by:
Hi,
This is a followup on a previous thread by JZ
http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=ki39sv8s7ui622uriis8mfsg1daca34qqu%404ax.com&rnum=1&prev=/groups%3Fhl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3Dki39sv8s7ui622uriis8mfsg1daca34qqu%25404ax.com
The mysql-python page at sourceforge.net contains beta versions of
mysqldb (specifically 0.9.3b2). This does have the necessary embedded
server support. Some amount tweaking of...
|
by: MSDNAndi |
last post by:
Hi,
I have a set of simple webservices calls that worked fine using .NET
Framework 1.0.
I am calling a Java/Apache based webservices, the calling side is not able
to supply a proper WSDL.
What it does is to call a webservice with two parameters, one being a
integer, the other one being a "String" which contains XML (not the best
practice, however that is the target interface and we cannot change that).
|
by: Tom |
last post by:
By my estimate, greater than 90% of the online doco code does not work
without additional coding effort. Fully working solutions are
invaluable for the student. A guru's work measured in minutes can take
a newb ages to duplicate. Imagine the improved teaching efficiency of
being able to direct someone to a working solution! Gurus would not
have to teach the same lesson repeatedly and their work would be more
persistent.
A picture is...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |