03-08-2012, 06:30 PM
(03-08-2012, 06:17 PM)engelant Wrote: Hi there,
i tried to install LetoDMS using the AdoDB driver "postgres8", but the sql files for database initialisation won't run, as they are written for mysql. Now, is there a way to use PostgreSQL, are there some special init sql files? Also, did i get it right, that AdoDB takes a SQL statement and translates it to any of the given drivers? Or is it just a ODBC wrapper that still requires a specific syntax for each type of database?
Thank you in advance
The bad news is, there is currently nor support for other database than mysql. The good news is, I'm aware of it and try to eliminate that restrictrion. All those database abstraction libraries provide a common api to different databases but they do not handle different sql dialects. That is still up to the user. I already started to support more databases and the next version will hopefully have support for sqlite3. PostgreSQL is probably not as difficult to support but not planed for the near future.
Uwe