Menu

libmysql 0.40: support for sqlite 3 and freepascal

Libsql 0.40 is released. This is the merge between my latest work and contributions by Vladimir and Miha.

Vladimir made the necessary changes to let libsql compile on freepascal on both windows and linux platforms. Miha made an implementation of the sqlite 3 interface and adjusted TLiteDB accordingly.
Vladimir's work mainly involves setting the right compiler switches, and he did a rework of the libmysql dll api interface.

Miha's contribution is available as seperate files (libsqlite3.pas, passqlite3.pas). The dll api will remain identical, i will try to merge TLiteDB3 with TLiteDB. These units are not compatible with freepascal yet.

If you encounter any issues, please report them so i can fix them in 0.41 release.

What is on the to-do list (in arbitrary order)
* Implementing multiple result sets
* Fully merging sqlite 3 and make it fpc compatible
* Implementing mysql 4.1 (clients < 4.1 cannot connect to 4.1 servers by default due to password validation changes).
* Rewriting the dll interface to be more flexible, this also involves next point
* Adjusting embedded mysql support to run with mysqlclient simultaniously, i.e. so you can im/export data from an embedded environment to a mysql server.
* Creating interfaces for dumping and importing tables / databases.
* Creating a demonstration application

Also, i've written some draft documentation.

All files are available at sourforge's libsql project page.

happy programming :)

Posted by René Tegel 2004-08-19

Log in to post a comment.