On 2014/05/09 16:20, Ralf Junker wrote:
On 09.05.2014 13:50, Carlos Ferreira wrote:
XE6 itself seems to native have access to both...
FireDAC only, and outdated by 2 months at the day of release. Delphi XE5 SQLite
is still at 3.7.17, almost one year behind.
Very true - the one disadvantage of not being a client-server based system is that any upgrades in a normal C-S DB system can happen
server side without affecting how the clients connect, which in turn gets updated only typically on major versions. With SQLite, the
DB is either embedded or connected directly to the executing system, which means if you use libraries (DLLs etc) you can upgrade
those separate from the application, but if you link in compiled libraries into used componentry etc you are stuck with whatever
version you compiled it with (Such as FireDAC).
Note that you can very much just drop any SQlite DLL in Delphi's bin folder and add the reference to the DB explorer, it will work
fine, as I use it regularly for quick viewing purposes (you can just google the details for this or mail me direct since it will
bore the list) - BUT deploying an app that was made using this method is finicky and plain silly - and that's why they don't add it
natively, and that's why FireDAC compiles it into the components.
Personally I prefer using a dedicated connection thing for actual DB comms to which I have insight into the code etc. and which
connects to a DLL which I can upgrade my side or user-side at any point. For this, DISQLite3 is a fine example.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
