libsql - sqlite, mysql, odbc for pascal / News: Recent posts

LibSQL compiles on macOSX!
Patrick made few modifications (mainly some ifdefs for darwin) and reported he was succesfully able to compile on OSX using freepascal!

TDataSet compliance
Some more work on TDataSet compliant components has been done. Attach one of the database (TLiteDB, TMyDB, TODBCDB) components to TlsTable or TlsQuery component and off you go interfacing with other TDataSet compliant components like DBGrids and edits - well, in theory, since there probably are some bugs and issues around, should have them fixed before 0.80 release. [And yes, i also find it ironic though funny to first walk away from borlands data-aware, and then again start interfacing with it. Anyhow, it is optional]... read more

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.... read more

As of version 0.31 i implemented embedded mysql. There are definitively some issues. One of those issues is that the embedded mysql library also seems experimental, i encountered some bugs which i cannot help. Like the mysql_create_database api succeeding if the database does not yet exist, but generating an Access Violation (!) if the database already exists.. You can circumvent that be just doing a query like 'create database somebase', but that is of course only a workaround.
Anyhow, the library works with current (4.0.18) production version on windows. haven't test unix platforms.
Another thingy is the library loading. Currently i use the same unit for that, because all api's are almost identical. I do not really feel like copying the unit, so i have to find another way. For the momemt being, you just cannot just mysql client and embedded mysql simultaniously. Ideas for fixes welcome, i have some ideas myself but have to think it over.

libsql is now compatible with Kylix and with Freepascal for windows.
If someone can verify that it is also compatible with fpc on unix (loadlibrary support), please drop me a message!