3 ms·

I still remember interbase, now called firebird. Of course, sqlite is much more prominent today for an embeded database, but for the times without sqlite...

Xelbair 7y ago
Sadly i have to use that piece of shit called firebird. It has all the downsides of service based DB without all the advantages of file based DB. And the documentation is way below average, backwards compatibility is a joke. Not to mention the 3rd party software had to design their own(horribly bad) way to handle geometry in firebird... and they keep transactions open forever - and bloody firebird prior to 2.5 had no way to drop the dead connections.
- thijsvandien 7y ago
  I’m genuinely interested in your frustrations, because I’ve been using Firebird to great satisfaction for about a decade. Some more substance would be required, however...
weavie 7y ago
Interbase was a proper client server db. If you wanted embedded you needed Paradox. Ah, I have many happy memories of pulling all nighters repairing corrupted Paradox files...
- barrkel 7y ago
  No, you can (dynamically) link Interbase into your app, so the server runs in-process. You can also do it with Firebird: https://www.firebirdsql.org/pdfmanual/html/ufb-cs-embedded.html https://www.firebirdsql.org/pdfmanual/html/ufb-cs-embedded.h...
  - weavie 7y ago
    Was it always that way? My memory is failing me.. I'd hate to think those nights in the 90's were completely wasted!
    - nottorp 7y ago
      I vaguely remember that Interbase was a proper client/server thing at first. I'm pretty sure we were using Paradox databases with all their quirks in 1998-2000, including support people fixing broken db files for customers.
- kstrauser 7y ago
  Heh, good memories of hitting ^Z in the Interbase command line client app to suspend it, and it pausing the entire server until the client was unpaused or killed. I'm not even sure how that could possibly happen (unless there was some blocking heartbeat thing), but it was 100% reproducible.
wolfgke 7y ago
Firebird is still actively developed as open source software: http://firebirdsql.org/ http://firebirdsql.org/
- 0-_-0 7y ago
  Firefox was originally to be named Firebird, but they had to rename it because the name was already taken.
  - jp_sc 7y ago
    An it was called Phoenix before that because, you know, "Netscape, reborn", but they had to rename it because of a trademark complain. And that's why Firebird was choosen.
    - TsomArp 7y ago
      Exactly. Phoenix bios company made the complain. That said, I think Firefox is the better name.
wdb 7y ago
I always thought NexusDB was the database to use in Delphi days?

Xelbair 7y ago

Sadly i have to use that piece of shit called firebird. It has all the downsides of service based DB without all the advantages of file based DB. And the documentation is way below average, backwards compatibility is a joke. Not to mention the 3rd party software had to design their own(horribly bad) way to handle geometry in firebird... and they keep transactions open forever - and bloody firebird prior to 2.5 had no way to drop the dead connections.

thijsvandien 7y ago
I’m genuinely interested in your frustrations, because I’ve been using Firebird to great satisfaction for about a decade. Some more substance would be required, however...

weavie 7y ago

Interbase was a proper client server db. If you wanted embedded you needed Paradox. Ah, I have many happy memories of pulling all nighters repairing corrupted Paradox files...

barrkel 7y ago
No, you can (dynamically) link Interbase into your app, so the server runs in-process. You can also do it with Firebird: https://www.firebirdsql.org/pdfmanual/html/ufb-cs-embedded.html https://www.firebirdsql.org/pdfmanual/html/ufb-cs-embedded.h...
- weavie 7y ago
  Was it always that way? My memory is failing me.. I'd hate to think those nights in the 90's were completely wasted!
  - nottorp 7y ago
    I vaguely remember that Interbase was a proper client/server thing at first. I'm pretty sure we were using Paradox databases with all their quirks in 1998-2000, including support people fixing broken db files for customers.
kstrauser 7y ago
Heh, good memories of hitting ^Z in the Interbase command line client app to suspend it, and it pausing the entire server until the client was unpaused or killed. I'm not even sure how that could possibly happen (unless there was some blocking heartbeat thing), but it was 100% reproducible.

wolfgke 7y ago

Firebird is still actively developed as open source software: http://firebirdsql.org/ http://firebirdsql.org/

0-_-0 7y ago
Firefox was originally to be named Firebird, but they had to rename it because the name was already taken.
- jp_sc 7y ago
  An it was called Phoenix before that because, you know, "Netscape, reborn", but they had to rename it because of a trademark complain. And that's why Firebird was choosen.
  - TsomArp 7y ago
    Exactly. Phoenix bios company made the complain. That said, I think Firefox is the better name.

wdb 7y ago

I always thought NexusDB was the database to use in Delphi days?