qaz@lemmy.world to Programmer Humor@programming.devEnglish · 3 days agoWho needs MongoDB when you have JSONB?lemmy.worldimagemessage-square60fedilinkarrow-up1316arrow-down12
arrow-up1314arrow-down1imageWho needs MongoDB when you have JSONB?lemmy.worldqaz@lemmy.world to Programmer Humor@programming.devEnglish · 3 days agomessage-square60fedilink
minus-squarePsaldorn@lemmy.worldlinkfedilinkarrow-up6arrow-down1·3 days agoHad 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.
minus-squarewetbeardhairs@lemmy.dbzer0.comlinkfedilinkarrow-up1·1 day agoJust store the JSON in a sqlite table with an extra column or two for commonly indexed stuff…?
minus-squarePsaldorn@lemmy.worldlinkfedilinkarrow-up2·1 day agoNo, 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
minus-squaresunbeam60@lemmy.mllinkfedilinkarrow-up22·3 days agoI’m confused about your SQLite troubles … it compiles for pretty much everything - as long as you have a file system mapping.
minus-squarePsaldorn@lemmy.worldlinkfedilinkarrow-up5·2 days agoIt’s not just me, but seems to affect Godot c# deployments to mobile https://github.com/godotengine/godot/issues/97859 Worked fine on desktop
minus-squaresunbeam60@lemmy.mllinkfedilinkarrow-up5·2 days agoAhh, it’s not an issue about SQLite but about whether the right libraries are bundled by Godot. Got it, that explains it.
minus-squarePsaldorn@lemmy.worldlinkfedilinkarrow-up1·2 days agoIt’s weird tho because everything looks like it’s there inside the apk. 🤷
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.
Just store the JSON in a sqlite table with an extra column or two for commonly indexed stuff…?
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
I’m confused about your SQLite troubles … it compiles for pretty much everything - as long as you have a file system mapping.
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
Ahh, it’s not an issue about SQLite but about whether the right libraries are bundled by Godot. Got it, that explains it.
It’s weird tho because everything looks like it’s there inside the apk. 🤷