News for hackers. Stuff that matters.
Re:PostgreSQL is enough by bun_terminator on Tuesday February 06, 2024 @10:19AM (#39275124)
ok I get that, but at least our applications usually only have one thing (one thread of one process on one machine) operating on the database. So maybe it's just our silly usecase
Re:PostgreSQL is enough by marcosdumay on Tuesday February 06, 2024 @10:52AM (#39275695)
That's unusual. The rule is that you replicate the database consumers lots and lots of times.

Still then, a database will improve your data access, validate your data, and provide interop in case you need to use the file with different software.

It's also a very high quality serialization library, that replaces one of the most vulnerability-enabling layers of your software. (But then, I've just read you use Oracle, so maybe forget that one.)

Re:PostgreSQL is enough by afandian on Tuesday February 06, 2024 @10:46AM (#39275583)
It's a narrow use-case that doesn't cover RDMS. SQLite fits it though.
Re:PostgreSQL is enough by bun_terminator on Tuesday February 06, 2024 @10:50AM (#39275656)
The first thing I did was ask why we don't use sqlite or at least postgres. The answer was that they are free and therefore we don't trust them. So Oracle it is. Which is bananas because our customers have to buy an oracle license, which is money that we don't get. Pretty wild
Re:PostgreSQL is enough by vhcr on Tuesday February 06, 2024 @11:35AM (#39276453)
Your experience with databases was probably clouded by having to use Oracle.
Re:PostgreSQL is enough by int_19h on Tuesday February 06, 2024 @09:52PM (#39283880)
It could be worse; there's always DB2...
Re:PostgreSQL is enough by themerone on Tuesday February 06, 2024 @11:08AM (#39275954)
Sqlite is running on billions of devices and has a test suite with 100% branch coverage.

Only a fool would put more trust in Oracle.

Re:PostgreSQL is enough by realaleris149 on Friday February 09, 2024 @02:30AM (#39312377)
> has a test suite with 100% branch coverage

Is actually even more than that, has 100% MC/DC coverage [1], which is something that is not easily achievable for most projects.

[1] https://www.sqlite.org/testing.html#:~:text=In%20this%20way%....

Re:PostgreSQL is enough by edwardsdl on Tuesday February 06, 2024 @11:06PM (#39284376)
> The answer was that they are free and therefore we don't trust them.

If you don’t mind a bit of unsolicited advice: run.

Re:PostgreSQL is enough by bun_terminator on Tuesday February 06, 2024 @11:58PM (#39284668)
I mean you do a job because of the pay, not because you like the people or they are particularly competent. So it's a good gig for two years or so
Re:PostgreSQL is enough by edwardsdl on Wednesday February 07, 2024 @12:12AM (#39284762)
I’ve found that surrounding myself with competent people - or better yet, people far better than me - has lead me to much better paying jobs.
Re:PostgreSQL is enough by bun_terminator on Wednesday February 07, 2024 @04:23AM (#39286369)
It also makes you look less like a genius haha. Yeah maybe you're right. It wasn't the best choice in hindsight. But switching jobs is a relatively rare thing in Europe. You only can do that ever so often, so I'll have a bit of waiting to do
Re:PostgreSQL is enough by tootie on Tuesday February 06, 2024 @11:16AM (#39276102)
I think it's important context that gets lost in so many tech conversations. Software engineering is a vast field covering almost every domain of human endeavor and they're all going to have different constraints. Some are technical and some are social. If you're working with 30 other engineers trying to marshal and unmarshal the same set of data for different purposes, it's really easy to tell them all "use SQL" instead of "here's the binary format invented by the guy who quit 7 years ago" even if that binary format was technically superior.