Conversation

Notices

1. Embed this notice
   Alex Gleason (alex@gleasonator.com)'s status on Sunday, 10-Dec-2023 10:19:54 JST Alex Gleason
   SQLite is getting jsonb support: https://sqlite.org/draft/json1.html
   • Embed this notice
     Tassoman (tassoman@orwell.fun)'s status on Sunday, 10-Dec-2023 23:41:02 JST Tassoman

     in reply to
     when you stated postgres is too much bigger versus SQLite, I forgot to mention PGSql can be a nosql database, also.
     JSONb support for SQLite makes sort of nosql available some how ?
     Alex Gleason likes this.
   • Embed this notice
     Nekobit (neko@posting.lolicon.rocks)'s status on Monday, 11-Dec-2023 03:50:57 JST Nekobit

     in reply to
     @alex jsonb is pretty ciol. i remember it being used for a thing called Slippi and it was not only easy to parse without a library but really damn simple. The name is rather unfortunate but i guess pretty understandable. I know nintendo uses byml which i was writing a tool for mario wonder level editor which parsed those, but that used hashmaps for efficient parsing.
     
     I wanted to provide jsonb support for the api wrapper (/treebird_api) behind Treebird which is used to proxy requests from pleroma/mastodon because those tend to be massive (i.e. hellthreads). Instead i designed the treebird json api (soon, bjson, but json was easier for me to parse with js) to only provide info the treebird client actually uses, because it was nicer to only proxy information the frontend needed. honestly though treebird is largely considered a proxy frontend (like bloat-fe) and not a true frontend like pleroma and soapbox are.
     Alex Gleason likes this.