Re: postgresql module (was : Re: [Perfparse-devel] Using indexes with mysql)

[Viljo M. <na...@ma...>]

Hey,

Now me being quite ignorant about C stuff, but aren't there really any 
libraries or whatever that we could use to make this database thing more 
abstract? I'm perl programmer and I know there's plethora of different 
sql abstraction layers made in perl, which make is easy to use same code 
for different databases (my latest and favourite finding is Class::DBI).

Maybe it would be nice to get rid (I mean not to make at all) those 
different db storage modules and have one general module, which uses 
some smart lib to talk to SQL with whichever server.

I found this: http://libdbi.sourceforge.net/
and this: http://siag.nu/libsdb/

And ODBC??

Best regards,
Viljo

Yves Mettier wrote:
 >>Hi again,
 >>
 >>to show that handling date datatypes in different RDBMS is not easy
 >>portable, here some syntax examples (copied from sqlzoo.net):
 >
 >
 > [...]
 >
 >
 >>So you see, it's really hard to use ANSI SQL :-) But perfparse does not
 >>use to many of the special cases, so i think it will be easier to make it
 >>db independent.
 >
 >
 > [...]
 >
 > Remember that with modules, you can do something very different from 
one db module to
 > another. You don't need to follow the same database schema if you 
don't want to.
 >
 > Too much different modules is bad (more work, more bugs...)
 > But if you need speed and space, don't try to be 100% compatible. The 
mysql module will
 > never connect to a postgresql database :)
 >
 > And again, the main problem that you will have is in the CGIs : they 
don't use modules.
 > I have ideas for the CGIs and we can talk about that when you want.
 >
 > Yves