this post was submitted on 14 Jun 2023
5 points (100.0% liked)

SQL - any and all

305 readers
1 users here now

For discussion about SQL and databases. All versions welcome.

founded 1 year ago
MODERATORS
shertson
5
Your favorite database engine? (self.sql)
submitted 1 year ago by pahakala to c/sql
11 comments fedilink hide all child comments
 

Obviously Microsoft Access is the best but it would be cool to hear your opinion.

you are viewing a single comment's thread
view the rest of the comments
[โ€“] callcc 1 points 1 year ago (1 children)

Just curious, why would anyone use such a fringe technology? Is there any feature that other FLOSS db engines miss?

[โ€“] TitanLaGrange 2 points 1 year ago

In our case, history mostly. The application we are using with it was originally developed (not by me) in the late 1980s in Borland Pascal and, I think, dBase. At some point in the early 1990s the original developers decided that dBase wasn't good enough and because Borland owned Interbase at that time and supported it with their coding tools, they decided to move to Interbase (later when Firebird was forked from Interbase they switched over to Firebird to avoid potentially needing to pay licensing fees on the numerous client computers).

The application, hugely expanded compared to what it was in the early days, has a great deal of Firebird-related code in it now, so moving off of it would be expensive and not really provide any return on the investment.