Re: Embeded MySQL w/ Perl

Hello,

Turns out that as it exists, the Perl DBD::mysql drivers to NOT support the
embedded MySQL server on any platform as far as I know.

I have been able to create a patch for the DBD::mysql XS code that permits
this functionality -- transparently while still supporting client/server --
really a big win for me, it's fast and works transparently for my Perl code.

I am certain that others are excited to try using MySQL in an embedded form
via the DBD::mysql drivers, and I am preparing to distribute a patch
proposal for the library.

- Cory

Matt Fredrickson writes:

> Hi Cory,
>
> You can view our supported platforms here,
> http://dev.mysql.com/doc/mysql/en/Which_OS.html and our libraries are
> available for download here, http://dev.mysql.com/downloads/. Let me know
> if you have additional questions.
>
> Regards,
>
> Mr. Matt Fredrickson,

>> -----Original Message-----
>> From: CoryTrese [mailto:digital@frognet.net]
>> Sent: Sunday, May 09, 2004 9:23 PM

>> Hello,
>>
>> I need to know if it is possible to use the DBD::mysql
>> interfaces with the embedded MySQL libraries (-lmysqld).
>>


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Embeded MySQL w/ Perl

On Wed, 12 May 2004, Cory James Trese wrote:

> Hello,
>
> Turns out that as it exists, the Perl DBD::mysql drivers to NOT support the
> embedded MySQL server on any platform as far as I know.
>

I am about to start working on this, but if you have some code ;)

> I have been able to create a patch for the DBD::mysql XS code that permits
> this functionality -- transparently while still supporting client/server --
> really a big win for me, it's fast and works transparently for my Perl code.
>

How do you do this transparetntly since you have to link against the embedded
mysql libraries? My plan was to create a DBD::EmbeddedMySQL or a
DBD::mysql::embedded package (or something along those lines) so as to avoid
namespace problem and allow you to have access to both an embedded mysql and
have a regular mysql without having to recompile the driver.

> I am certain that others are excited to try using MySQL in an embedded form
> via the DBD::mysql drivers, and I am preparing to distribute a patch
> proposal for the library.

You might want to take a look at the the current CVS Dev-3_0 branch, since that
is where most of the new development is going on right now. I have been side
traced with some bric->krang conversions have not not done anything in the past
few weeks, but I expect to have my schedule open up sometime next week.

Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Embeded MySQL w/ Perl

On Wed, 12 May 2004, Cory James Trese wrote:

> Hello,
>
> Turns out that as it exists, the Perl DBD::mysql drivers to NOT support the
> embedded MySQL server on any platform as far as I know.
>

I am about to start working on this, but if you have some code ;)

> I have been able to create a patch for the DBD::mysql XS code that permits
> this functionality -- transparently while still supporting client/server --
> really a big win for me, it's fast and works transparently for my Perl code.
>

How do you do this transparetntly since you have to link against the embedded
mysql libraries? My plan was to create a DBD::EmbeddedMySQL or a
DBD::mysql::embedded package (or something along those lines) so as to avoid
namespace problem and allow you to have access to both an embedded mysql and
have a regular mysql without having to recompile the driver.

> I am certain that others are excited to try using MySQL in an embedded form
> via the DBD::mysql drivers, and I am preparing to distribute a patch
> proposal for the library.

You might want to take a look at the the current CVS Dev-3_0 branch, since that
is where most of the new development is going on right now. I have been side
traced with some bric->krang conversions have not not done anything in the past
few weeks, but I expect to have my schedule open up sometime next week.

Rudy


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Embeded MySQL w/ Perl

On Wed, 2004-05-12 at 19:36, Rudy Lippan wrote:
> On Wed, 12 May 2004, Cory James Trese wrote:
>
> > Hello,
> >
> > Turns out that as it exists, the Perl DBD::mysql drivers to NOT support the
> > embedded MySQL server on any platform as far as I know.
> >
>
> I am about to start working on this, but if you have some code ;)

Yeah, I will send it to the list this week. I am suffering deadlines.

>
> > I have been able to create a patch for the DBD::mysql XS code that permits
> > this functionality -- transparently while still supporting client/server --
> > really a big win for me, it's fast and works transparently for my Perl code.
> >
>
> How do you do this transparetntly since you have to link against the embedded
> mysql libraries? My plan was to create a DBD::EmbeddedMySQL or a
> DBD::mysql::embedded package (or something along those lines) so as to avoid
> namespace problem and allow you to have access to both an embedded mysql and
> have a regular mysql without having to recompile the driver.

I do not need to change my internal API; it is transparent when you
switch the library you are linkin -- embedded vs. client/server. This
was my reading of the MySQL documentation which suggests this approach.

I do see the potential merit of another namespace.

>
> > I am certain that others are excited to try using MySQL in an embedded form
> > via the DBD::mysql drivers, and I am preparing to distribute a patch
> > proposal for the library.
>
> You might want to take a look at the the current CVS Dev-3_0 branch, since that
> is where most of the new development is going on right now. I have been side
> traced with some bric->krang conversions have not not done anything in the past
> few weeks, but I expect to have my schedule open up sometime next week.

I expect to be able to work on this Tuesday afternoon of next week, so I'll start by looking in CVS.

On a side note I am also building this into a CGI::Application framework
I'm creating. Fun fun =)


- Cory


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Embeded MySQL w/ Perl

On Wed, 2004-05-12 at 19:36, Rudy Lippan wrote:
> On Wed, 12 May 2004, Cory James Trese wrote:
>
> > Hello,
> >
> > Turns out that as it exists, the Perl DBD::mysql drivers to NOT support the
> > embedded MySQL server on any platform as far as I know.
> >
>
> I am about to start working on this, but if you have some code ;)

Yeah, I will send it to the list this week. I am suffering deadlines.

>
> > I have been able to create a patch for the DBD::mysql XS code that permits
> > this functionality -- transparently while still supporting client/server --
> > really a big win for me, it's fast and works transparently for my Perl code.
> >
>
> How do you do this transparetntly since you have to link against the embedded
> mysql libraries? My plan was to create a DBD::EmbeddedMySQL or a
> DBD::mysql::embedded package (or something along those lines) so as to avoid
> namespace problem and allow you to have access to both an embedded mysql and
> have a regular mysql without having to recompile the driver.

I do not need to change my internal API; it is transparent when you
switch the library you are linkin -- embedded vs. client/server. This
was my reading of the MySQL documentation which suggests this approach.

I do see the potential merit of another namespace.

>
> > I am certain that others are excited to try using MySQL in an embedded form
> > via the DBD::mysql drivers, and I am preparing to distribute a patch
> > proposal for the library.
>
> You might want to take a look at the the current CVS Dev-3_0 branch, since that
> is where most of the new development is going on right now. I have been side
> traced with some bric->krang conversions have not not done anything in the past
> few weeks, but I expect to have my schedule open up sometime next week.

I expect to be able to work on this Tuesday afternoon of next week, so I'll start by looking in CVS.

On a side note I am also building this into a CGI::Application framework
I'm creating. Fun fun =)


- Cory


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org