Top all-time · #1388
Wesley Aptekar-Cassels
Personal blog · blog.wesleyac.com/postsprogrammingsystemsdata
Wesley Aptekar-Cassels's personal blog at blog.wesleyac.com covers programming, systems and data. Since 2017, 50 different Hacker News readers have linked it 94 times, most often “Consider SQLite”. The last post was in 2024, but the archive is still widely read.
Too few sampled comments (29) to say how often HN recommends it.?
Why HN links it
HN readers link 'Consider SQLite', cited as a case for running SQLite in production with benchmarks and performance data. Also linked is a post on Robert Martin's ideas and views.
- Recommended for · 13 comments
- Called an all-time great post on using SQLite in production, with benchmarks; also called a good article on Robert Martin.
Summarised by Claude from a sample of 29 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Main page
Most-linked posts?
- Consider SQLite12 people · 27 mentions · first linked 2021-12-29
- The Curse of NixOS5 people · 5 mentions · first linked 2022-01-24
- Why Talk about Compensation?4 people · 6 mentions · first linked 2020-02-17
- Reasons to avoid JavaScript CDNs (2021)4 people · 4 mentions · first linked 2021-12-09
- Notes on Parsing in Rust3 people · 3 mentions · first linked 2020-04-30
- How I run my servers3 people · 3 mentions · first linked 2023-07-16
- Subdomains as Identity2 people · 2 mentions · first linked 2022-04-07
- Recursive Filesystem Entries2 people · 2 mentions · first linked 2017-08-28
- A simple but safe deploy script (2021)2 people · 2 mentions · first linked 2024-02-20
- Languages I want to write2 people · 2 mentions · first linked 2019-04-13
What Hacker News says?
Time to pull up my RSS reader! https://drewdevault.com/ http://jvns.ca/ https://www.benkuhn.net/ https://danluu.com/ https://scattered-thoughts.net/ http://antirez.com/ https://www.kalzumeus.com/ https://neilkakkar.com/ https://zachholman.com/ http://rachelbythebay.com/w/ https://endler.dev/ https://www.expatsoftware.com/articles/ https://www.the-paper-trail.org/ https://tonsky.me/ https://dave.cheney.net/ https://b…
Comment linking /
on “Ask HN: Favorite Blogs by Individuals?”Submitted The Curse of NixOS as a story · 583 points
HN discussionI was a fan for a while until I learned all this other stuff about him https://blog.wesleyac.com/posts/robert-martin - this is a good article > While Martin advocates for a small, dogmatic, and incorrect set of technical ideas for making code better, that's not why most people are upset with him — it's far more common for people to be upset about his views on race and gender, and particularly the way that someone in…
Comment linking /posts/robert-martin
on “Books that changed my career as a software engineer”Submitted Web3 is centralized as a story · 453 points
HN discussionI do not quite understand the premises: > Given the complexity Which complexity? It is the simplest possible widespread, reliable and effective solution. Which makes it a primary choice. > it seems like there are use cases or needs here that I'm not seeing On the contrary, the use cases for the traditional Relational DB engines are defined: when you need a concurrency manager better than filesystem access. (Or maybe…
Comment linking /posts/consider-sqlite
on “Ask HN: Have you used SQLite as a primary database?”Submitted Things I Believe About Software Engineering as a story · 420 points
HN discussionHere's an all-time great post about why you might consider SQLite in production with data about performance: https://blog.wesleyac.com/posts/consider-sqlite I use SQLite in production for my SaaS[1]. It's really great — saves me money, required basically no setup/configuration/management, and has had no scaling issues whatsoever with a few million hits a month. SQLite is really blazing fast for typical SaaS workload…
Comment linking /posts/consider-sqlite
on “Ask HN: Have you used SQLite as a primary database?”Submitted Timezone Bullshit as a story · 400 points
HN discussionYes, works great for my sites (they are mostly read-heavy). I used to default to Postgresql, now I default to sqlite. This [0] is a good article with some benchmarks, misconceptions about speed, and limitations. [0]: https://blog.wesleyac.com/posts/consider-sqlite
Comment linking /posts/consider-sqlite
on “Ask HN: Have you used SQLite as a primary database?”Submitted Consider SQLite as a story · 362 points
HN discussionhttps://blog.wesleyac.com/posts/robert-martin Part about politics, race, gender. He is insane.
Comment linking /posts/robert-martin
on “It's hard to write code for computers, but it's harder to write code for humans”Submitted Elliptic Curve Cryptography for Beginners as a story · 328 points
HN discussionNot an expert, however (lol) - even if the recommendations here are solid - this doesn't feel like a particularly well-reasoned comparison. IMHO maintaining a large number of files on disk (be it 16m or 1.5b) should be a non-starter (not to mention that zipping them to slightly reduce the count removes one of the benefits of having them in the first place). A database makes sense - as does SOC between generation and…
Comment linking /posts/consider-sqlite
on “2024: The year of the OpenStreetMap vector maps”Submitted The two questions I ask every interviewer as a story · 307 points
HN discussioncopying and pasting from a different thread: I use SQLite/Litestream for https://extensionpay.com ! 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 s…
Comment linking /posts/consider-sqlite
on “SQLite 3.45 released with JSONB support”Submitted SNES Development Part 1: Getting Started as a story · 265 points
HN discussionAlso: Part 2: https://blog.wesleyac.com/posts/snes-dev-2-background-graphi... Part 3: https://blog.wesleyac.com/posts/snes-dev-3-input Part 4: https://blog.wesleyac.com/posts/snes-dev-4-nmi-and-vblank Part 5: https://blog.wesleyac.com/posts/snes-dev-5-dma Part 6: https://blog.wesleyac.com/posts/snes-dev-6-sprites
Comment linking /posts/snes-dev-6-sprites
on “SNES Development Part 1: Getting Started”Submitted How many users block Google analytics? (2017) as a story · 265 points
HN discussionWhenever SQLite comes up, always have to link to this post about using SQLite in production: https://blog.wesleyac.com/posts/consider-sqlite :) I'm running https://extensionpay.com off SQLite and a $5/month DigitalOcean box and it's serving around 3 million requests a month with absolutely no issues and seriously low CPU load. I'm kind of astonished, frankly.
Comment linking /posts/consider-sqlite
on “Store SQLite in Cloudflare Durable Objects”Submitted Languages I want to write as a story · 186 points
HN discussionI've stopped taking it seriously after seeing blogs like this. https://blog.wesleyac.com/posts/the-curse-of-nixos
Comment linking /posts/the-curse-of-nixos
on “Nixery – Docker images on the fly with Nix”Submitted GetElementById vs. QuerySelector as a story · 147 points
HN discussion> I believe the idea of Web3/Crypto is that it's decentralized Web3 is Centralized: https://blog.wesleyac.com/posts/web3-centralized - discussed here a few days ago: https://news.ycombinator.com/item?id=29766497 Even if it were decentralized, the moment a technology appears to be decentralized, we do everything in our power to add a centralized (management) layer on top (e.g. github). That layer is what the masses w…
Comment linking /posts/web3-centralized
on “Crypto: The Good, the Bad and the Ugly”Submitted How fast are those packets moving? as a story · 89 points
HN discussionSince 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 al…
Comment linking /posts/consider-sqlite
on “How (and why) to run SQLite in production”Submitted A bogus study on code review as a story · 65 points
HN discussionI'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 wi…
Comment linking /posts/consider-sqlite
on “Ask HN: SQLite in Production?”Submitted Recursive Filesystem Entries as a story · 29 points
HN discussioncopying 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 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.wesle…
Comment linking /posts/consider-sqlite
on “Ask HN: Are you using SQLite and Litestream in production?”Submitted Languages I Want to Write as a story · 4 points
HN discussion
