SQLite as a no-SQL database
SQLite offers through its JSON1 extension a lot of capability. Generating JSON outputs from SQL, even complex structured, multi-level JSON is very straightforward.
But what about the opposite use case ? When you have store data as JSON in an SQLite database, and you want to search or filter it ? This is a short exploration of what to expect.
We all need more battery life, and for quad-core i7 & i5, a simple way to gain more battery is to simply turn off extra cores.