SQL table design for Arrays, Dates and Indexes - what I learnt from ORM
In short, you can fix it with proper comments and sectioning. Also, don't fear Many-To-Many relationships.
Tag: sqlite
Pacharapol Withayasakpunt Thu, November 26, 2020
Pacharapol Withayasakpunt Mon, July 29, 2019
Creating and editing Anki's *.apkg and *.anki2 via SQLite
*.apkg and *.anki2 file structure is very simple, but with some quirks of incompleteness.
*.apkg file structure is a zip of at least two files.
Pacharapol Withayasakpunt Tue, July 16, 2019
Various Node.js sqlite packages. What is the best?
The official implementation is actually sqlite3, and there are at least 2 packages built on top of it -- sqlite and TypeORM. There are also other packages that can run SQLite including better-sqlite3 and sql.js.