Re:Lessons Learned from 11 Years of Hosting a SaaS
by mejutoco on Thursday June 15, 2023 @05:34AM
(#36338191)
I agree with you about the worse type system not being a feature. Also missing the json features of postgres is inconvenient.
Only one file to backup or deploy is the biggest advantage of sqlite IMO.
Re:Lessons Learned from 11 Years of Hosting a SaaS
by roblh on Thursday June 15, 2023 @08:41AM
(#36339643)
It may not quite have all of the JSON features of Postgres, but recently the JSON handling has become way more usable in SQLite. More than usable for sure.
Re:Lessons Learned from 11 Years of Hosting a SaaS
by throwaway2037 on Thursday June 15, 2023 @09:02AM
(#36339840)
Hat tip to both the amazing native JSON support from Postgres, and the SQLite module with JSON functions: https://www.sqlite.org/json1.html
Re:Lessons Learned from 11 Years of Hosting a SaaS
by rozenmd on Thursday June 15, 2023 @05:20AM
(#36338089)
Check out Cloudflare D1
Re:Lessons Learned from 11 Years of Hosting a SaaS
by kristiandupont on Thursday June 15, 2023 @05:38AM
(#36338220)
It looks neat but I am still not sure what the appeal is exactly. Is it cost reduction?
Re:Lessons Learned from 11 Years of Hosting a SaaS
by rozenmd on Thursday June 15, 2023 @06:11AM
(#36338413)
Cost reduction and simplicity - costs nothing if no one is using it
Re:Lessons Learned from 11 Years of Hosting a SaaS
by Glench on Thursday June 15, 2023 @06:19AM
(#36338471)
Here’s a great article explaining some of the benefits of using SQLite in production: https://blog.wesleyac.com/posts/consider-sqlite
I use it in my production SaaS serving around 4 million requests per month on one of the lowest DigitalOcean tiers. The big ones for me were cost, operating simplicity and performance. I don’t need a separate process or server running which has saved me some money and time, and the app’s workload doesn’t need a ton of inserts so the speed is blazing fast.
Re:Lessons Learned from 11 Years of Hosting a SaaS
by throwaway2037 on Thursday June 15, 2023 @09:03AM
(#36339863)
"4 million requests per month"
There are 2,592,000 seconds in a month. So, 1.5 requests per second?
Re:Lessons Learned from 11 Years of Hosting a SaaS
by Glench on Thursday June 15, 2023 @09:16AM
(#36340004)
Oh whoops it’s actually 4 million per day! Good catch.
Re:Lessons Learned from 11 Years of Hosting a SaaS
by pravus on Thursday June 15, 2023 @06:50AM
(#36338664)
It has an extremely low barrier of entry while providing the features of a relational database when all you need is a local data store. The files are trivially easy to transport using standard tools when needed. I've been in back-end automation/integration for my entire career and use these kinds of things all the time. The overhead of maintaining a full networked RDBMS isn't always something I want (or need) to do.
Other than that, it's not like queries are any simpler and the "simple" type system is, in my opinion, not a feature. I get that some might disagree with that.
Is there some other reason why you would prefer it?