A list about the Perl support for MySQL with msql-mysql-modules.

Alessandro Ranellucci | 5 Jan 2007 12:06

Any license news?

Hello all,

I found this old thread: http://lists.mysql.com/perl/2651
and I thought that by DBD::mysql 4.00 the dual-license scheme would have
been replaced by the single GPL to comply with MySQL client libraries.
Why is DBD::mysql still distributed under Perl license, given that is
definitely "derivative work" of a GPL library?

Cheers,

  - alessandro ranellucci.

--

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

headers

Jay Savage | 5 Jan 2007 15:16

Re: Any license news?

On 1/5/07, Alessandro Ranellucci <aar <at> cpan.org> wrote:
> Hello all,
>
> I found this old thread: http://lists.mysql.com/perl/2651
> and I thought that by DBD::mysql 4.00 the dual-license scheme would have
> been replaced by the single GPL to comply with MySQL client libraries.
> Why is DBD::mysql still distributed under Perl license, given that is
> definitely "derivative work" of a GPL library?
>
> Cheers,
>
>   - alessandro ranellucci.
>

That thread is two years old and dates from a time when GPL fanatics
with a poor understanding of both the law and the GPL itself were
going crazy in ways that were later shown to be in error. Although I
don't know what was in there at the time, the current DBD::MySQL code
is certainly not a derrivative work, legally or otherwise, of libmysql
or any other GPL'd work. Simply using an API or connecting to a socket
doesn't make a work derrivative: that's what APIs and sockets are for.
By that logic, your web browser would be a derrivative work of every
website you visit and a SOAP or REST client would be derrivative of
the service it interfaces with. The whole idea was crazy two years
ago, and it reamins crazy today.

You'll notice that, despite the apparent gravity of the discussion,
the thread died almost immediately. Even at the height the GPL
paranoia nobody gave the idea more than a passing thought.

(Continue reading)

headers

Alessandro Ranellucci | 5 Jan 2007 16:24

Re: Any license news?

On 5-01-2007 at 15:16, Jay Savage wrote:

 >the current DBD::MySQL code is certainly not a derrivative work,
 >legally or otherwise, of libmysql or any other GPL'd work.

Just to clarify things, I'm not interested in GPL advocacy nor I want to
discuss here my personal point of view about the definition of
derivative work. I posted my question because in that thread Rudy Lippan
stated that "if the distributor uses 4.x", then DBD::mysql must be
distributed under the GPL. Given also that MySQL AB explicitely switched
from LGPL to GPL (and I assume this has a particular meaning), and that
they grant an explicit permission to PHP, I feel encouraged to think
that it's not just a matter of crazy GPL fanatics.

Cheers,

  - alessandro.

--

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

headers

Alessandro Ranellucci | 5 Jan 2007 17:58

Re: Any license news?

On 5-01-2007 at 17:31, Jim Winstead wrote:

 >The Artistic License is another of the licenses listed in the MySQL
 >FLOSS License Exception:
 >http://www.mysql.com/company/legal/licensing/foss-exception.html

Jim, thanks. Although I knew about the FLOSS exception, I didn't "link"
it to the DBD::mysql licensing matter.

  - alessandro.

--

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

headers

ademmler | 8 Jan 2007 21:49

"DBD::Mysql on Intel Mac i686 (Quadcore)" make problems

Hi folks!

I need all your help. I am trying to install DBD:mysql on an Quadcore  
Intel Mac (i686).

My Setup:
Perl 5.8.6	(ok)
MySQL mysql-max-5.0.27-osx10.4-i686 (ok)
DBI-1.53 (ok)

I tried on (Version 4) and on DBD-mysql-3.0008.
I can install this on Intel Mac DuoCore, but not on Quadcore.
I have done all the hints (about links, libs, cflags) from www - no  
result.

I have done also:
host:~ admin$ PATH=$PATH:/usr/local/mysql/bin/
host:~ admin$ export PATH
host:~ admin$ env . . . for control

While using the configure script I use this:
sudo perl Makefile.PL -cflags='-I/usr/local/mysql/include -Os -arch  
i386 -fno-common' -libs='-L/usr/local/mysql/lib -lmysqlclient -lz -lm'
##
I will use the following settings for compiling and testing:

   cflags        (User's choice) = -I/usr/local/mysql/include -Os - 
arch i386 -fno-common
   embedded      (mysql_config ) =
   libs          (User's choice) = -L/usr/local/mysql/lib -

(Continue reading)

headers

Jim Winstead | 9 Jan 2007 03:34

Re: "DBD::Mysql on Intel Mac i686 (Quadcore)" make problems

This is a bug with the version of the MySQL client library you are
compiling against.

More details at http://bugs.mysql.com/22227

Jim Winstead
MySQL Inc.

--

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

headers

Randy Burke | 18 Jan 2007 21:42

optimizing a query

I know this is not really a Perl question, Except that I use perl yo
generate the page.

I have a report that is displayed on a webpage in an 10 x 9 table

Originally we did it as one query per cell, then we combined it into one
monolithic query that returns one row with 72 columns

I am sure that there is some way to optimize this, maybe using sub-query,
which I have not been able to grasp yet.

so here is the beast:

    my ($newdata, $noanswerdata, $timeddata, $misseddata, $highdata,
$normaldata, $lowdata, $monitordata);

    # Open DB
    my $dbh = DBI->connect( "dbi:$datasrc", "$sqluser", "$sqlpassword") ||
error("Unable to open user database: $DBI::errstr");

    # Setup the Query
    my $query = qq{SELECT
            # New
            sum(TO_DAYS(creationdate)<TO_DAYS(now() - INTERVAL 6 DAY) AND
status='O' AND date_format(lastcontact, "%Y")='0000' AND noanswer='0'),
            sum(TO_DAYS(creationdate)=TO_DAYS(now() - INTERVAL 6 DAY) AND
status='O' AND date_format(lastcontact, "%Y")='0000' AND noanswer='0'),
            sum(TO_DAYS(creationdate)=TO_DAYS(now() - INTERVAL 5 DAY) AND
status='O' AND date_format(lastcontact, "%Y")='0000' AND noanswer='0'),
            sum(TO_DAYS(creationdate)=TO_DAYS(now() - INTERVAL 4 DAY) AND

(Continue reading)

headers

John Trammell | 18 Jan 2007 22:01

RE: optimizing a query

Marginally offtopic, but there is an upcoming free "webinar" being offered by MySQL on query execution:

http://www.mysql.com/news-and-events/web-seminars/query-execution.php 

Might be worthwhile attending.

-----Original Message-----
From: Randy Burke [mailto:uncle.ranny <at> gmail.com] 
Sent: Thursday, January 18, 2007 2:43 PM
To: perl <at> lists.mysql.com
Subject: optimizing a query

I know this is not really a Perl question, Except that I use perl yo generate the page.

I have a report that is displayed on a webpage in an 10 x 9 table

Originally we did it as one query per cell, then we combined it into one monolithic query that returns one row
with 72 columns

I am sure that there is some way to optimize this, maybe using sub-query, which I have not been able to grasp yet.

so here is the beast:

    my ($newdata, $noanswerdata, $timeddata, $misseddata, $highdata, $normaldata, $lowdata, $monitordata);

    # Open DB
    my $dbh = DBI->connect( "dbi:$datasrc", "$sqluser", "$sqlpassword") || error("Unable to open user
database: $DBI::errstr");

    # Setup the Query

(Continue reading)

headers

Michael Martin | 26 Jan 2007 07:27

"DBD::Mysql on Intel Mac i686 (Quadcore)" make problems

Adding the following line to mysql_com.h (on my Mac it's in /usr/ 
local/mysql/include) fixed the problem for me:

typedef unsigned long	ulong;		  /* Short for unsigned long */

I copied this from my_global.h. The line in dbimp.c causing the  
problem references 'CLIENT_MULTI_RESULTS' which is defined in  
mysql_com.h using 'ulong', which at that point has not yet been defined.

The bug mentioned in Jim Winstead's earlier reply was very helpful  
(http://bugs.mysql.com/22227).

Michael Martin

Attachment (smime.p7s): application/pkcs7-signature, 1741 bytes

headers

Girls | 28 Jan 2007 22:33

We have it all

Big Apple Geisha

The premier introduction agency in New York City

We cater to the desires and needs of the descriminating man and woman in The Big Apple desiring the companionship and friendship of educated and attractive Asian women, all women of color, attractive passable transsexuals and NYC's hottest men. All of our escorts dress accordingly to your desires and are as comfortable at a corporate dinner date as well as a cozy evening at home.

347.624.9326 For Outcall 24 / 7 sexygirls <at> bigapplegeisha.com Please no restricted or blocked calls

We are professional escorts NOT prostitutes. Therefore, the fees required, or money exchanged for legal adult personal services for modeling is simply for time and companionship ONLY. Anything else that may or may not occur is a matter of personal choice and personal preferences between two or more consenting adults of legal age and is not contracted for, nor is it requested to be contracted for in any manner. This is not an offer of, and or for solicitation or prostitution. Fees charged are for time spent only. I do reserve the right to decline appointments, as we deem necessary.By contacting us (either through phone or email) you agree to ALL of these terms and hereby CERTIFY that you are not part of any law enforcement agency using this advertisement for entrapment or for arrest. This is a contract you agree to by contacting us .I have legal representation and know my rights fully.


--

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

1	June 2013
4	April 2013
1	July 2012
5	February 2012
1	November 2011
1	October 2011
2	September 2011
2	August 2011
1	June 2011
4	May 2011
6	April 2011
10	March 2011
6	February 2011
1	January 2011
4	November 2010
2	October 2010
1	August 2010
9	July 2010
2	June 2010
3	May 2010
8	April 2010
3	March 2010
5	January 2010
6	December 2009
2	November 2009
5	October 2009
4	September 2009
2	August 2009
2	July 2009
4	June 2009
6	May 2009
3	April 2009
8	March 2009
6	February 2009
1	November 2008
4	October 2008
4	September 2008
3	August 2008
3	July 2008
7	June 2008
19	May 2008
15	April 2008
32	March 2008
7	February 2008
6	January 2008
47	December 2007
13	November 2007
18	October 2007
21	September 2007
7	August 2007
15	July 2007
5	June 2007
11	May 2007
13	April 2007
12	March 2007
13	February 2007
13	January 2007
6	December 2006
27	November 2006
6	October 2006
21	September 2006
25	August 2006
31	July 2006
25	June 2006
48	May 2006
13	April 2006
24	March 2006
48	February 2006
23	January 2006
21	December 2005
35	November 2005
19	October 2005
20	September 2005
18	August 2005
24	July 2005
27	June 2005
38	May 2005
28	April 2005
72	March 2005
24	February 2005
30	January 2005
47	December 2004
74	November 2004
20	October 2004
52	September 2004
60	August 2004
38	July 2004
80	June 2004
78	May 2004
88	April 2004
74	March 2004
50	February 2004
64	January 2004
50	December 2003
33	November 2003
103	October 2003
104	September 2003
128	August 2003
35	July 2003
11	June 2003
21	May 2003
7	April 2003
66	March 2003
37	February 2003
18	January 2003
14	December 2002
11	November 2002
24	October 2002
32	September 2002
22	August 2002
30	July 2002
11	June 2002

Mon	Tue	Wed	Thu	Fri	Sat	Sun

1	2	3	4	5	6	7
8	9	10	11	12	13	14
15	16	17	18	19	20	21
22	23	24	25	26	27	28
29	30	31