Devart Forums

Lazarus/FreePascal is supported with the "professional with source" editions. You can use it for example on a Raspberry Pi (which isn't supported by Delphi), but I dunno about Android and iOS.

Did you try compiling this as a 64 bit program? Other suggestion: use ROWS, eg. SELECT * FROM foo ROWS 1 TO 100000, and so on.

As these "CData FireDAC components" are simply wrappers around ODBC, you can use any technology within Delphi, which supports ODBC, e.g. DBgo aka ADO, or UniDAC, if you wish so. CData delivers all it's connectors also as pure ODBC.

Is it possible, that "no internet access" really means "no access to router" which includes no access to DNS?

Problem is: SQLite doesn't really have a DATETIME field type. One must either use TEXT or REAL. In the source code of "LiteClassesUni.pas" you'll see that dtDateTime and dtSQLTimeStamp are internally mapped to SQLite's TEXT field type. The two parameters you mentioned should match the actually used format of dates und times in the database. Use a third party tool like the free "SQLite expert" to look, which format is actually used.

ViktorV wrote: ↑Fri 24 Sep 2021 14:43 This support is not available in this poduct version. But we plan to add it in the next IBDAC release.
Should you have any other questions, do not hesitate to ask!

So, was it added in 8.0.2? I don't see it mentioned in the revision history. Someone made a test [1] (in german) and found it 2 to 4 times faster compared to normal prepared inserts.



[1] https://firebirdforum.de/viewtopic.php?p=1253#p1253

Can anyone tell me if IBDAC is better than UniDAC in terms of functionality and speed?

As not all of the functions of IBDAC are included in UniDAC - yes. For example none of the management components (backup, restore, ...) are included in UniDAC.

By looking into the sources one can clearly see, that it's only working if you use IBDAC with UniDAC Express ("Lite"). If you don't, then you have to use the "WireCompression=true" method instead.

Neither FireDAC nor LiteDAC/UniDac use SQLite's own encryption (because it's very expensive). Instead, they have both their own proprietary encryption method, which is incompatible to each other. By providing a password you switch on encryption.

Protocol = Local is XNET.

For embedded leave "Protocol" empty.

UniDAC uses SQL engine of SQLite for this. So you are limited to SQLite compatible SQL.

Instead of "TOP" use "LIMIT":
becomes

Firebird 4 introduces the Batch Execution interface. This applies to Update and Insert queries only (i.e. not update/insert returning) and can be used to batch up many separate queries to be executed as a single operation. This can be used to minimize the client/server interfaces and to optimize server update/insert times. It is done using parameters, not using EXECUTE BLOCK.

IBX for Lazarus supports this (in version 2.4.2), does IBDAC support this too?

Couldn't you just replace the provided sqlite3.o object file with a newer one, e.g. from the mORMot project?

Now waiting for IBDAC/UniDAC...

https://firebirdsql.org/en/firebird-4-0/

Have you tried using ISO format for dates, e.g. '2021-04-22' instead of '22.04.2021'?