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

SQL - any and all

306 readers
1 users here now

For discussion about SQL and databases. All versions welcome.

founded 1 year ago
MODERATORS
 

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

top 11 comments
sorted by: hot top controversial new old
[–] [email protected] 5 points 1 year ago (1 children)

Out of the pretty small number of database systems I've used:

  • Postgres: Pretty standard choice, can't go wrong with it
  • MySQL/MariaDB: Also very safe choice, I feel like it's more feature rich than Postgres but I'm not sure
  • Oracle: It reeks of proprietary bloat and it's unnecessarily different than the previous two in some things, but you can get some official enteprise support if you're a company
  • Influx: It solves a specific problem (time series) but it's very cool, modern and with api support for many languages
  • Microsoft Excel: Obviously the best choice
[–] Crackhappy 3 points 1 year ago

Pffffttt. Access is clearly the winner.

[–] schmalls 3 points 1 year ago

Punch cards

[–] shertson 2 points 1 year ago (1 children)

Can't believe no one mentioned Paradox. There has to be like tens of people that use it!

[–] TitanLaGrange 1 points 1 year ago (1 children)

Oh lord. If you're still using Paradox, I'm so sorry.

[–] shertson 1 points 1 year ago

Thankfully no! But someone must, it's still being updated and sold

[–] [email protected] 1 points 1 year ago

Lotus Notes

[–] TitanLaGrange 1 points 1 year ago* (last edited 1 year ago) (1 children)

Unpopular opinion probably, but Firebird has been really good to us for a couple of decades. We have thousands of users running it to provide offline data and it's been extremely reliable and trouble-free. Good support for features like stored procedures, triggers, etc. without requiring much in the way of maintenance.

My biggest complaints are that the database file size tends to bloat up with lots of transactions, and it needs a better bulk-load feature (it has an 'external table' feature that works well and that we use heavily, but it's kind of a pain). And prior to v4 it didn't have a good replication system. No idea how good the replication in v4 is.

[–] 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.

[–] DinosaurSr 1 points 1 year ago

We still have multiple systems using access in production 🤗