[isf-wifidog] MySQL support

[Francois Proulx]

DB abstraction is essentially two things. First there is pure DB API abstraction, this is what we're doing right now. This way we have one way of sending a SQL query, as mysql_query != pg_query. Their parameters are also different and the way they react. 

Another problem is making sure the queries are as standard as possible... most of our queries are OK... The biggest issue I'm seeing here is the BLOBS are managed in MySQL. It's a totally different approach... PostgreSQL relies heavily on OIDs to grab data, on the other hand MySQL simply uses normal datafields... Thus even if we try to make the File objects ( sidenote : BLOBS are only used for the content management system, when using database stored files ) MySQL will never been as efficient on BLOB use since you have to escape binary chars before sending it... First it's a memory hog, second it can break easily if something goes wrong during the conversion.

As I said, I will see try to import the schema in a MySQL database. But I sincerely doubt I can rewrite the BLOB thing in an efficient way using MySQL...
--- Philippe April <isf_lists at philippeapril.com> wrote:

From: Philippe April <isf_lists at philippeapril.com>
Date: Mon, 30 May 2005 08:34:47 -0400
To: WiFiDog Captive Portal <wifidog at listes.ilesansfil.org>
Subject: Re: [isf-wifidog] MySQL support

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I'm not sure why we have a layer of abstraction for the database, if  
the only supported database is PostgreSQL.

Also, I don't think people would mind if it was not as optimized, as  
long as we have support for it! And personally I think it's really  
important for us to have MySQL support, it's not the first time we  
hear this request.

As long as the abstraction is done properly, then once MySQL supports  
the "missing features" in the future, it can just be added to make it  
faster/make less queries to the database.

On 30-May-05, at 7:03 AM, Proulx François wrote:

> The MySQL schema has not been updated since december. We've added  
> so many new complex features that has become a headache to convert  
> some of these... Last time I checked ( back in february ), I think  
> we needed the very very latest version of MySQL 4 to support most  
> datatypes we're using. For example we have some fields that default  
> to NOW(), which is a SQL function. Mysql supports is only in the  
> latest builds. Also,  we would need to add functions to the  
> database abstraction layer to support BLOBS. I *hope* they work in  
> a similar way... If I get some time this week I might try to create  
> a new instance just to see how far we are from supporting it....
>
> Stay tuned
>
>
>> Hi all,
>> a few friends and i run a little community network here in  
>> Germany. I've investigate a lot of time to test wifidog. We want  
>> to use it now for our network.
>>
>> I know this question is not new but whats with the MySQL support  
>> for wifidog? I ask cause i already run mysqld on my server . I  
>> don't want to run a additional db server (postresql) only for the  
>> wifidog repository. My memory is limited (dedicated server in a  
>> colocation) and it's expensive to increase memory.
>>
>> Anybody has a running wifidog-auth / mysql setup? Hints, Tips or  
>> the working db scheme. Will it work with the latest cvs snapshot?
>>
>> Ok bye
>> Daniel
>>
>> _______________________________________________
>> WiFiDog mailing list
>> WiFiDog at listes.ilesansfil.org
>> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog
>>
>>
>
> _______________________________________________
> WiFiDog mailing list
> WiFiDog at listes.ilesansfil.org
> http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog

Philippe April
GnuPG http://key.philippeapril.com

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFCmwhnOq+Ep5Xn/aARAgbAAJ9mX6g47PKgkKGLIWLuat5wmrmD/gCguZUa
6IlMPZ51/bYfAD3rPLjKBbE=
=KXA8
-----END PGP SIGNATURE-----
_______________________________________________
WiFiDog mailing list
WiFiDog at listes.ilesansfil.org
http://listes.ilesansfil.org/cgi-bin/mailman/listinfo/wifidog