3 ms·
A bit off-topic, but SQLite continues to impress me. This year, we've added a simple form builder to our product which allows creators to quickly gather feedbac
by jstsch 5y ago
A bit off-topic, but SQLite continues to impress me. This year, we've added a simple form builder to our product which allows creators to quickly gather feedback/input from their audiences. Basically each form has it's own small sqlite database as a datastore and a json file for the form definition (field styling/constraints, etc). It's 'low tech', but performs great. Not having an additional service running also means having one less thing to maintain.
- ruslan_talpa 5y agoBeen feeling lately the fatigue of managing 3-5 different services for a every single trivial project. This pushed me to explore adding SQLite support in my product [1], i think I'll wrap a Litestream [2] process in the same container and call it "Backed in a Box" :) [1] https://github.com/subzerocloud/blue-steel https://github.com/subzerocloud/blue-steel [2] https://github.com/benbjohnson/litestream https://github.com/benbjohnson/litestream edit: typo
- ergocoder 5y agoI used Sqlite and wasn't impressed. Their SQL dialect is lacking. Parsing a date or regex extraction are extremely difficult. You have to resort to WITH RECURSIVE.
- quietbritishjim 5y agoYou can just supply your own function to parse the date. In most database systems that would be a disaster, because the database would have a send a request over the network back to your program for each argument it needs to process. For SQLite, it's no big deal, because it's executing in the same address space as your program so it's a simple function call. I'll admit that it does make it harder to port your program to another language, so it's more of a workaround than an ideal solution.
- ergocoder 5y agoHow would do that easily? Did you mean writing a c extension of Sqlite?