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: sql
Pacharapol Withayasakpunt Thu, November 26, 2020
Pacharapol Withayasakpunt Sat, February 15, 2020
I wrote an ORM for SQLite
It starts with inter-op with mongoose, and inspired from Typegoose.
It is an ORM that
- Can query by Mongo-like query
- Auto-convert back-and-forth for JSON \<=> TEXT, Date \<=> INTEGER and Boolean \<=> INTEGER
For Mongo-like query, it can be tested here -- https://q2search.herokuapp.com/LiteORM (The actual Mongo-like query is in the console)