Is there a specific reason to want to use a commercial product? There are many opensource solutions with equal or better features and stability. (implied by user scale)
Note that the source editions - according to their website also advertise Lazarus as a target (probably only windows), so contact the nexusdb and ElevatDb service desk.
[The reason why I chose NexusDB instead of Firebird 15 years ago is that NeuxsDB support cross-database query,Well Firebird supports external tables. That feature comes close to what you want.
"select into #table" syntax with (#context-local, ##session-local and ###global temp. tables) that is great for reporting,
[The reason why I chose NexusDB instead of Firebird 15 years ago is that NeuxsDB support cross-database query,Well Firebird supports external tables. That feature comes close to what you want.
"select into #table" syntax with (#context-local, ##session-local and ###global temp. tables) that is great for reporting,
Note that you are then making another niche choice, although an open source one.
[The reason why I chose NexusDB instead of Firebird 15 years ago is that NeuxsDB support cross-database query,Well Firebird supports external tables. That feature comes close to what you want.
"select into #table" syntax with (#context-local, ##session-local and ###global temp. tables) that is great for reporting,
Note that you are then making another niche choice, although an open source one.
Thank you all for your replies.
After lots of testing, I decided to go with FirebridSQL.
I made tests on win7/10, Linux, and Linux on Raspberry PI and decide to use IBX.
https://www.mwasoftware.co.uk/ibx
I was testing with DevArt IBDAC too, but IBDAC doesn't compile under ARM Linux on Raspberry Pi.
Seems the only thing that I need to be aware of with Firebird is
how to handle transactions. In Firebird even the "Select" statement is a transaction.