309
top 50 comments
sorted by: hot top controversial new old
[-] muhyb@programming.dev 132 points 2 weeks ago

Jesus Christ, that's JSON Bourne.

[-] ThePyroPython@lemmy.world 118 points 2 weeks ago

Yes that's right, it goes into postgres.

[-] fargeol@lemmy.world 69 points 2 weeks ago

“You know what ELSE everybody likes? Postgres! Have you ever met a person, you say, ‘Let’s use some Postgres,’ they say, ‘Hell no, I don’t like Postgres’? Postgres is perfect!”

Yeah! Postgres is great!

  • Mutters something under his breath about MariaDB.
[-] marcos@lemmy.world 16 points 2 weeks ago

MariaDB

Let's schedule a meet-up at 00/00 year 0000 to talk about it.

[-] somerandomperson@lemmy.dbzer0.com 11 points 2 weeks ago* (last edited 2 weeks ago)

elephant walks in

[-] RustyNova@lemmy.world 15 points 2 weeks ago

I 100% agree... If you don't need portable databases. For those, everybody like SQLite (even if it can be annoying sometimes)

[-] wetbeardhairs@lemmy.dbzer0.com 4 points 2 weeks ago

You can pry sqlite out of my cold dead hands. Because I'll probably die while using it out of frustration due to the poor performance of triggers.

[-] RustyNova@lemmy.world 3 points 2 weeks ago

Tbh trigger performance isn't that much of a concern unless you need to write lots of data, which most usage don't need.

Also try check statements instead or even re-evaluate your schema to prevent them if you really need to.

Personally my death would be multiple write transaction deadlocks. Sadly it doesn't play that well with async code, like with sqlx (rust).

load more comments (2 replies)
[-] r00ty@kbin.life 37 points 2 weeks ago

Yeah, but is it web scale?

[-] zea_64 44 points 2 weeks ago

/dev/null is web scale, it maintains sub 1ms times no matter how much load you give it!

[-] r00ty@kbin.life 21 points 2 weeks ago

Does /dev/null support sharding?

[-] marcos@lemmy.world 22 points 2 weeks ago

Yes, you can run as many replicas as you want. It's also incredibly lean on the synchronization bandwidth.

[-] squaresinger@lemmy.world 21 points 2 weeks ago

It certainly supports the admin sharting when he finds out where all the data went.

[-] Bakkoda@sh.itjust.works 4 points 2 weeks ago
[-] ThunderComplex@lemmy.today 3 points 2 weeks ago

How to avoid a alien invasion according to war of the worlds 2025

[-] desmosthenes@lemmy.world 6 points 2 weeks ago

lololol yusssss

[-] fxdave@lemmy.ml 11 points 2 weeks ago

With SQL you scale it when it is required by sharding, read replicas, cache layers, and denormalization.

With NoSQL afaik, we have to deal with the scaling from the beginning by keeping the consistency of denormalized data, that has additional code overhead. Is mongoDB different in this regard?

[-] floquant@lemmy.dbzer0.com 7 points 2 weeks ago* (last edited 2 weeks ago)

EDIT: I got whooshed. Thanks for the reference :)

edit edit: Holt shit how did I miss this for 15 years. This is great, stayed accurate all this time.

Shoutout to software that had to deal with y2k and is still popular, gotta be one of my favourite genders.

[-] magic_lobster_party@fedia.io 25 points 2 weeks ago
[-] Thedogdrinkscoffee@lemmy.ca 5 points 2 weeks ago

I've never seen that one. It's a masterpiece for sure. Thanks.

[-] Feyd@programming.dev 6 points 2 weeks ago

Just fyi you're taking a meme seriously

[-] cupcakezealot@piefed.blahaj.zone 32 points 2 weeks ago

who needs any of that when you have microsoft access

[-] qaz@lemmy.world 16 points 2 weeks ago

There is actually an open source alternative for that in the Libreoffice suite called "Base"

[-] tyfon@sh.itjust.works 5 points 2 weeks ago

I have used libre office base and found it's buggy mess.

  1. Not all drivers support all functions, so if you are wondering why some options are not present it's probably adapter not supporting it.
  2. Errors and help are usually empty or super generic like 'syntax incorrect'.
  3. Interface sometimes bugs out when long syntax is present in input fields
  4. Because of 1. It also doesn't support all syntax from Microsoft SQL, MySQL etc.

I sugest to use dbbever for any DB, it's different but at least it's not a buggy mess. Or pgAdmin for Postgresql. Or DB Browser for SQLite

[-] ksh@aussie.zone 3 points 2 weeks ago

Is it actually any good for small personal projects? Just want someone who has used it to answer as I’m considering putting some work into it.

load more comments (1 replies)
[-] SCmSTR 10 points 2 weeks ago

Ow, my integrity

[-] rikudou@lemmings.world 26 points 2 weeks ago

Just use Mongo, it scales so well!

Never understood why anyone chose Mongo. Though I have some funny memories getting rid of it because it was slowing the app down sooo much.

If you need something for storing JSONs and querying, just use ElasticSearch/OpenSearch.

[-] NigelFrobisher@aussie.zone 11 points 2 weeks ago

Oh god, all the people storing massive JSON documents, and then having to lock the whole thing to modify sub-entities.

[-] magic_lobster_party@fedia.io 6 points 2 weeks ago

But is Elasticsearch web scale?

[-] nik9000@programming.dev 3 points 2 weeks ago

I say this with all appropriate irony: as the guy that deployed it at for Wikipedia, yes.

[-] Venator@lemmy.nz 4 points 2 weeks ago

Or add a column next to the json with some data about the json and index that.

[-] Mirror Giraffe@piefed.social 2 points 2 weeks ago

Where I work we use mongo, it's not what I would've picked but i guess it helped early dev speed and bad practices like having productus do direct db edits to save a situation because the app isn't mature yet.

By now when collections are getting huge and documents as well we've had to archive more and more recent data, which causes problems, and we have to really make sure our queries are sharp or cost and lag will go through the roof.

With that said, it actually works pretty ok for a production platform with quite a big customer base, and there are many improvements we could do if we had the time.

If I were there at day one I'd have rooted for sql, mainly based on how much these different collections have to relate, but I don't think mongo is as horrible as many people make it out to be and it does have upsides.

[-] Flamekebab@piefed.social 2 points 2 weeks ago

I've used it for one small project and quite liked it. I struggle with the concepts behind relational databases and Mongo's approach was understandable for me.

load more comments (1 replies)
[-] umbraroze@slrpnk.net 24 points 2 weeks ago

Yeah, I took one course where we used MongoDB. I was like "still unconvinced, but I'll keep this in mind if I run into situations not covered by PostgreSQL." ...I've not run into situations not covered by PostgreSQL. Everything will be covered by PostgreSQL.

[-] Psaldorn@lemmy.world 4 points 2 weeks ago

Had to roll my own JSON storage system after spending weeks trying to get sqlite to work on Godot/android.

It took a day and will suck at scale because there are no indexes. It just goes through the whole file, line by line when you search for an id.

BUT IT WORKS.

Hopefully the repos and stuff I piled on top have made it abstract able enough I can move it to a real database if the issue ever gets resolved.

[-] sunbeam60@lemmy.ml 20 points 2 weeks ago

I’m confused about your SQLite troubles … it compiles for pretty much everything - as long as you have a file system mapping.

[-] Psaldorn@lemmy.world 6 points 2 weeks ago

It's not just me, but seems to affect Godot c# deployments to mobile

https://github.com/godotengine/godot/issues/97859

Worked fine on desktop

[-] sunbeam60@lemmy.ml 6 points 2 weeks ago

Ahh, it’s not an issue about SQLite but about whether the right libraries are bundled by Godot. Got it, that explains it.

load more comments (1 replies)
load more comments (2 replies)
[-] velxundussa@sh.itjust.works 4 points 2 weeks ago

I manage instances of both mongo and postgres at work.

I'll say Mongo OpsManager is pretty sweet, and HA is way easier on Mongo.

[-] goatinspace@feddit.org 3 points 2 weeks ago* (last edited 2 weeks ago)
load more comments
view more: next ›
this post was submitted on 13 Sep 2025
309 points (100.0% liked)

Programmer Humor

26679 readers
1635 users here now

Welcome to Programmer Humor!

This is a place where you can post jokes, memes, humor, etc. related to programming!

For sharing awful code theres also Programming Horror.

Rules

founded 2 years ago
MODERATORS