learn-awesome/learndb

Move from CSV/Sqlite/Datasette to JSON format

nileshtrivedi opened this issue · 0 comments

By eliminating Datasette, we'd simplify the development, deployment and usage a lot more easier - as only Javascript would be needed and the app could run on many more platforms like Netlify functions, or Cloudflare workers etc.

Using JSON would also allow nested object that simplifies things like Reviews, links as an array of {format, url, image} objects, tags/topics etc.

For convenience, we can use JSON5 or JSONLines / NDJson.

We'd lose some features offered by SQLite (Views, Joins, Full-text search etc), but the tradeoff seems worth it.