Glench
Joined 14 years ago
Karma
3,260
Submissions
652
Member since
Jul 2
http://glench.com
View on Hacker NewsRecent submissions
Comment · 3 months ago
There’s also the article “Consider SQLite”: https://blog.wesleyac.com/posts/consider-sqlite
The above article was what convinced me to use SQLite in my new business. 5 years later, serving 120+ million requests per month and still working great. To be fair, most of those requests are served out of redis, but I’m still running off of cheap digital ocean droplets.
Comment · 1 year ago
Archive.org link: https://web.archive.org/web/20241212091703/https://www.nytim...
Comment · 2 years ago
I needed something like this once but I forget why. Now I would probably just use val.town to build it instead of spinning up my own go server.
Comment · 2 years ago
I mean yeah, but we never start from nothing of course! Totally agree. But our experience should always be the ground truth we test against and if the science disagrees then we should hold the science lightly or ignore it. But if the science offers us something that works in our direct experience then great! And there is a progressive feedback loop as we continue to notice more about our experience and also learn more from research. That's been my experience anyway :)
Comment · 2 years ago
> I want to believe stuff like this, but the whole field is so mired in quackery and jingo it's hard to believe any of it.
Haha yes I just saw a youtube video last night of a personal account that said something that seemed to directly contradict what the author of this post learned ("static stretches don't work" whereas this author is saying they worked for him).
I feel like for these kinds of cases where there is contradictory information that it is better to rely on direct experience in my own body rather than just scientific information about what's supposed to work. Use mindful awareness to feel directly what's happening in the muscles and tissues and how it changes over time using the different types of techniques. Then I don't really need to believe anything anyone says. The downside of this approach is that we may miss out on important information if we're ONLY relying on direct experience. But direct experience should be the foundation in my opinion.
Comment · 2 years ago
Reading your question, I think Svelte or SvelteKit is probably a good option like you said. It's basically just JS/HTML/CSS as normal but if you want interactive UI stuff it's very simple to add. At this point SvelteKit is totally stable, it's just not as popular as React so it doesn't have as much community / LLM support.
Comment · 2 years ago
I don't know if the intention of the article was to stoke worry but actually embrace as opportunity! Users being able to make their own software for their own needs is a worthy and beautiful goal. It's like if people could only eat what was at restaurants and not cook for themselves.
And of course with iteration and feedback loops people can definitely learn how to specify what they want in a fairly precise way.
Comment · 2 years ago
Really heartening to see commenters in this thread concerned about plastic pollution! I have also tried to stopped buying clothes with plastic (polyester). Probably not our biggest environmental concern at the moment, but still might as well develop good habits of consuming in a way that minimizes my impact on the environment.
Comment · 2 years ago
Glad to see other comments bringing this to light. As Saul Griffith likes to point out, physics indicates that stuffing CO2 back into the ground is not an easy or cost-effective job. Stopping it from entering the atmosphere is much simpler. Also Saul mentioned that the IPCC models have a disproportionate amount of faith in CO2 removal technologies which at this point is an unproven and uneconomical option and for physics-related reasons will probably remain so.
Also, there doesn't seem to be an appreciation of the speed at which we need to stop emissions to meet 1.5C or even 2C of warming. It's at the point where if we don't replace almost every car, furnace, stove, etc with its electric counterpart and power them with clean electricity (due to the continuous emissions of those machines for their lifetime, assuming no early retirement), we can guarantee breaching the 1.5C limit. We need a World War 2 level buy-in from government, industry, and consumers. I wish this was more widely known.
Comment · 2 years ago
I don't! I take the moment of downtime. It's usually instant — only as long as it takes to stop and restart the server. Occasionally a DB migration will take longer — the longest I've so far was 10-15 seconds — and the site is down for that time. I think this is acceptable, but it would be nice to have a more seamless automated solution.
Comment · 2 years ago
I've been using SQLite/Litestream for https://extensionpay.com for about 3 years now! Serves about 120m requests per month (most of those are cached and don't hit the db), but it's been great!
I was convinced that SQLite could be a viable db option from this great post about it called Consider SQLite: https://blog.wesleyac.com/posts/consider-sqlite
Using SQLite with Litestream helped me to launch the site quickly without having to pay for or configure/manage a db server, especially when I didn't know if the site would make any money and didn't have any personal experience with running production databases. Litestream streams to blackblaze b2 for literally $0 per month which is great. I already had a backblaze account for personal backups and it was easy to just add b2 storage. I've never had to restore from backup so far.
There's a pleasing operational simplicity in this setup — one $14 DigitalOcean droplet serves my entire app (single-threaded still!) and it's been easy to scale vertically by just upgrading the server to the next tier when I started pushing the limits of a droplet (or doing some obvious SQLite config optimizations). DigitalOcean's "premium" intel and amd droplets use NVMe drives which seem to be especially good with SQLite.
One downside of using SQLite is that there's just not as much community knowledge about using and tuning it for web applications. For example, I'm using it with SvelteKit and there's not much written online about deploying multi-threaded SvelteKit apps with SQLite. Also, not many example configs to learn from. By far the biggest performance improvement I found was turning on memory mapping for SQLite.
Comment · 2 years ago
Since the page didn't seem to link to it, here's a really great article about using SQLite in production for moderately-sized web apps: https://blog.wesleyac.com/posts/consider-sqlite
That article, along with the ability to have streaming backups with Litestream and not wanting to pay for a separate DB server, inspired me to use SQLite in my SaaS four years ago. I've been enjoying the operational simplicity a lot although there is not a lot of community documentation currently about tuning SQLite for web app loads. My app does about 120m hits a month (mostly cached and not hitting the DB) on a $14/month single-processor DigitalOcean droplet.
Comment · 2 years ago
I use Litestream for my production web app and stream to Backblaze B2. It's S3 compatible and literally free!