Trap TFDConnection error on data module create etc?

[Stano 143]

No way! I tried it once. I didn't get along with the date at all. FB suits me just fine. In my case, the connection isn't that big of a deal.
I also bought tools to go with FB. It would be a shame to throw them away.

[Uwe Raabe 2057]

It is also much easier to switch from Embedded to Server when necessary. With SQLite you are nailed to embedded.

[weirdo12 19]

6 hours ago, Stano said:

I also bought tools to go with FB. It would be a shame to throw them away.

Okay that is a good reason to stick with what your using.

[weirdo12 19]

5 hours ago, Uwe Raabe said:

It is also much easier to switch from Embedded to Server when necessary. With SQLite you are nailed to embedded.

If you are using components built specifically for Interbase/Firebird (or some other server) - absolutely.

[Uwe Raabe 2057]

... and the ability to simply move the database file from embedded to server and vice versa.

[Anders Melander 1783]

...and the ability to not corrupt the database if the application crashes.

[weirdo12 19]

5 hours ago, Anders Melander said:

...and the ability to not corrupt the database if the application crashes.

Was that meant as a dis of SQLite - did I read that right?

[Anders Melander 1783]

17 hours ago, weirdo12 said:

Was that meant as a dis of SQLite - did I read that right?

It was aimed at SQLite but it was not meant as a dis. As long as the limitations and risks are taken into account it's a fine embedded database engine.

 

I haven't used it in a while but I have just read through the technical documentation and I can see that a lot has been done with regard to reliability since then. Still, after having read the docs I couldn't help but feel that there were problem areas that were brushed over or simply left out.