As I was working on a side project, I noticed I wanted to use SQLite like a Document Database on the server. So I built Doculite. DocuLite lets you use SQLite like Firebase Firestore. It's written in Typescript and an adapter on top of sqlite3 and sqlite.
Reasons:
1) Using an SQL Database meant having less flexibility and iterating slower.
2) Alternative, proven Document Databases only offered client/server support.
3) No network. Having SQLite server-side next to the application is extremely fast.
4) Replicating Firestore's API makes it easy to use.
5) Listeners and real-time updates enhance UX greatly.
6) SQLite is a proven, stable, and well-liked standard. And, apparently one of the most deployed software modules right now. (src: https://www.sqlite.org/mostdeployed.html)
What do you think? Feel free to comment with questions, remarks, and thoughts.
Happy to hear them.
Thanks