qaz@lemmy.world to Programmer Humor@programming.devEnglish · 2 months agoWho needs MongoDB when you have JSONB?lemmy.worldimagemessage-square60fedilinkarrow-up1324arrow-down13
arrow-up1321arrow-down1imageWho needs MongoDB when you have JSONB?lemmy.worldqaz@lemmy.world to Programmer Humor@programming.devEnglish · 2 months agomessage-square60fedilink
minus-squarePsaldorn@lemmy.worldlinkfedilinkarrow-up6arrow-down1·2 months 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-squaresunbeam60@lemmy.mllinkfedilinkarrow-up21·2 months 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-up6·2 months 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-up6·2 months 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 months agoIt’s weird tho because everything looks like it’s there inside the apk. 🤷
minus-squarewetbeardhairs@lemmy.dbzer0.comlinkfedilinkarrow-up1·2 months agoJust store the JSON in a sqlite table with an extra column or two for commonly indexed stuff…?
minus-squarePsaldorn@lemmy.worldlinkfedilinkarrow-up2·2 months 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
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.
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. 🤷
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