this post was submitted on 13 Sep 2025
303 points (99.0% liked)

Programmer Humor

27412 readers
2251 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
anzo@programming.dev
Feyter@programming.dev
BurningTurtle@programming.dev
pylapp@programming.dev
303
Who needs MongoDB when you have JSONB? (lemmy.world)
submitted 2 months ago by qaz@lemmy.world to c/programmer_humor@programming.dev
40 comments fedilink hide all child comments
 
you are viewing a single comment's thread
view the rest of the comments
[–] Psaldorn@lemmy.world 3 points 2 months ago (1 children)

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.

[–] wetbeardhairs@lemmy.dbzer0.com 1 points 2 months ago (1 children)

Just store the JSON in a sqlite table with an extra column or two for commonly indexed stuff....?

[–] Psaldorn@lemmy.world 2 points 2 months ago

No, you misunderstand. Sqlite just does not work when it's packaged by Godot mono for mobile (see the ticket in the other replies)

It worked fine on desktop which made it more frustrating