Conversation

Notices

1. Luci for Chai Tea (zens@merveilles.town)'s status on Friday, 20-Jan-2023 16:08:39 JST Luci for Chai Tea

   A lot of people recoil at the idea of using SQLite, because SQL. Or, especially at the idea of just storing JSON in JSON fields and using SQL as something like a document store- but there has actually been a heap of work recently on SQLite for this exact usecase, and making it way nicer and more reliable to use than most document stores

   JSON functions and operators:
   https://www.sqlite.org/json1.html

   recent json function enhancements
   https://sqlite.org/src/doc/json-in-core/doc/json-enhancements.md

   json virtual columns
   https://antonz.org/json-virtual-columns/

   • Adrian Cochrane repeated this.
   • Luci for Chai Tea (zens@merveilles.town)'s status on Friday, 20-Jan-2023 16:39:31 JST Luci for Chai Tea

     in reply to

     Here's the thing about SQLite:
     if you're writing your program in

     C

     SQLite is a far more robust JSON parsing and manipulation library than pretty much any C library I've been able to find made specifically for that purpose.

     SQLite is not just a database, it's a swiss army knife of functionality that is *really* hard to piece together out of what's available for just plain C for free.