this post was submitted on 13 Sep 2025
319 points (99.1% liked)

Programmer Humor

26372 readers
1269 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
 
you are viewing a single comment's thread
view the rest of the comments
[–] Psaldorn@lemmy.world 5 points 4 days ago (2 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.

[–] sunbeam60@lemmy.ml 22 points 4 days ago (1 children)

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 5 points 3 days ago (1 children)

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 5 points 3 days ago (1 children)

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

[–] Psaldorn@lemmy.world 1 points 3 days ago

It's weird tho because everything looks like it's there inside the apk. 🤷

[–] wetbeardhairs@lemmy.dbzer0.com 1 points 2 days 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 days 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