Glench

5 ms·

1.
by Glench 2mo 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 mon
2.
by Glench 2y ago
Archive.org link: https://web.archive.org/web/20241212091703/https://www.nytim...
3.
How Much Cleaner Energy Could Save America, in Lives and Money(nytimes.com)
2 points by Glench 2y ago|1 comments
4.
by Glench 2y 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.
5.
by Glench 2y 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 scienc
6.
by Glench 2y 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 direc
7.
by Glench 2y 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
8.
by Glench 2y 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 ea
9.
Zuckerman vs. Meta Platforms(ethanzuckerman.com)
2 points by Glench 2y ago|1 comments
10.
by Glench 2y 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 wel
11.
by Glench 2y 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.
12.
by Glench 2y 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 i
13.
by Glench 2y 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
14.
by Glench 2y 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
15.
by Glench 2y ago
I use Litestream for my production web app and stream to Backblaze B2. It's S3 compatible and literally free!
16.
by Glench 2y ago
Came here to recommend doing good deeds for others. I find when I'm doing things for the benefit others I feel a lot better (as long as I'm resourced enough to do it). A therapist used to tell me that gratitude and doing good thin
17.
by Glench 3y ago
> What I don't like about stock is that you end up throwing out food. I have the perfect solution for this. Keep a container in the freezer. Whenever you have an extra unusable vegetable bit from chopping, chuck it in the container.
18.
Running a scheduled function on ValTown to import Atom feeds into Datasette(til.simonwillison.net)
2 points by Glench 3y ago|0 comments
19.
by Glench 3y ago
About a month ago I made a chrome extension that adds a "sometime this week" todo list at the bottom of google calendar (a feature I copied from Hey calendar). Any items that don't get done roll over to the next week and I ca
20.
by Glench 3y ago
This is one of the best resources I know for how to come up with good business ideas (which is probably one of the hardest parts if you've never done it before): https://www.indiehackers.com/post/how-to-brainstorm-
21.
by Glench 3y ago
I started the career transition away from tech to therapy: http://glench.com/WhyIQuitTechAndBecameATherapist/
22.
by Glench 3y ago
I have been really impressed with SvelteKit in my production SaaS for about a year now! You can make any type of static/dynamic/combination site, the dev experience is really good, and it feels like it elegantly bridges the front-
23.
by Glench 3y ago
> what are the heuristics I can use to understand that this is the right time for me to start a business that does not create huge opportunity costs and is not an impulse that is the result of my impatience? I'm wondering if it make
24.
by Glench 3y ago
I made a couple browser extensions that make over $500/month each. The key seems to be naming your extension after high-volume search terms and getting good reviews on the chrome store (and obviously having an extension that works well
25.
by Glench 3y ago
Here's another great resource about SQLite performance, Consider SQLite: https://blog.wesleyac.com/posts/consider-sqlite
26.
by Glench 3y ago
Yeah I hear you. I recently started logging slow queries to a text file. It was really easy to do but yeah I didn’t really look into more complex monitoring. I wonder if there’s anything out there!
27.
by Glench 3y ago
Is there something you want to know specifically? It’s pretty standard basically. I used sequelize (might have chosen something different if starting today) and I build for node running on a single machine. I use pm2 to deploy with nginx i
28.
by Glench 3y ago
copying and pasting from a different thread because this keeps coming up and I want to share my experience in case it's helpful: I use SQLite/Litestream for https://extensionpay.com ! Serves about 120m requests per mont
29.
by Glench 3y ago
> Is this a "good, old fashioned" single durable server type of deployment? Yep! > I like my systems made such that the server can die, get scaled vertically and oops data disk wiped, forget to mount volume in a container, e
30.
by Glench 3y ago
Nope!

More ›