Embedded (Compiled) Database Engine Options lazarus / 16-Databases ---------------------------------------------------------------------- tshahzad · 2017-02-22 07:31 What are embeded database options like Absolute Database or DBIsam for Lazarus with SQL support. I am developing a cross platform application to be deployed on Windows,Linux and Mac. I do not want to deploy database DLL or .do files with my applicatiion. Database is small with 20 Tables and maximum of 20,000 rows in some tables. What are the options other than DBF and PDX file formats ??? ---------------------------------------------------------------------- Thaddy · 2017-02-22 07:40 Use Sqlite and link it statically. Note dbf never supported SQL anyway. Sqlite is a modern format that fully supports SQL. SQlite is also the de facto standard for embedded, statically linked, databases. (Before anyone starts shouting firemonkeybirdapes again  ) which means the database is in an easily interchangeable format. If you don't need SQL there are many more options, like TBufDataset or - indeed - TDbf, which supports dBase language queries. ---------------------------------------------------------------------- mangakissa · 2017-02-22 07:49 QuoteBefore anyone starts shouting firemonkeybirdapes again[/quoted] Only if you're working on desktops/laptops ---------------------------------------------------------------------- Thaddy · 2017-02-22 07:51 Quote from: mangakissa on February 22, 2017, 08:49:34 amOnly if you're working on desktops/laptops No. Also for Android  sqlite is the default. It's Google's favorite. It's Mozilla's favorite Nothing to do with desktop.... silly... We are talking about embedded, even more precise:statically linked embedded: one executable to deploy. BTW: We are lucky to have mOrMoT which is an exemplary implementation for servers, using Sqlite as the default... If you want to have full SQL support in a single executable, use SQlite. As it stands, any other advice puts you on the wrong track. ---------------------------------------------------------------------- mig-31 · 2017-02-22 08:24 Other option, Firebird, but in this case you still should distribute dll/so with your application in application folder. ---------------------------------------------------------------------- Thaddy · 2017-02-22 08:29 Quote from: mig-31 on February 22, 2017, 09:24:52 amOther option, Firebird, but in this case  with your application in application folder. "you still should distribute dll/so" Can you READ? "you still should distribute dll/so" Obviously not... "you still should distribute dll/so" And plz: never ever recommend that firemonkybirdyape thing again. It works - sometimes -, but that's about it. And nobody uses it outside of the Object Pascal community and only because of historical reasons. Could have been good, should be better. Time caught up with it. "you still should distribute dll/so" The question was about a SINGLE executable, with NO dependencies and supporting sql as a query language. "you still should distribute dll/so" Oh, well... I hereby grant you permission to use Firebird if you must. Just don't let us know you do... Just lie and tell us you are actually using Sqlite ... "you still should distribute dll/so" is plain sick. ---------------------------------------------------------------------- d.ioannidis · 2017-02-22 10:26 @tshahzad Quote from: tshahzad on February 22, 2017, 08:31:57 amWhat are embeded database options like Absolute Database or DBIsam for Lazarus with SQL support. I am developing a cross platform application to be deployed on Windows,Linux and Mac. I do not want to deploy database DLL or .do files with my applicatiion. Database is small with 20 Tables and maximum of 20,000 rows in some tables. What are the options other than DBF and PDX file formats ??? You could use ZMSQL ( written in Free Pascal ) or the mighty mORMot which use SQLite statically linked ( warning shallow learning curve ) ... @Thaddy, Quote from: Thaddy on February 22, 2017, 09:29:53 amAnd plz: never ever recommend that firemonkybirdyape thing again. It works - sometimes -, but that's about it. And nobody uses it outside of the Object Pascal community and only because of historical reasons. You don't know what you are talking about ... Quote from: Thaddy on February 22, 2017, 09:29:53 amThe question was about a SINGLE executable, with NO dependencies and supporting sql as a query language. I used to have fb embed in delphi 7 single exe apps with BTMemoryModule for years ... regards,