
Jilles Soeters
@Jilles
Followers
220
Following
983
Media
200
Statuses
3K
0 times #1 New York Times bestselling author #6 all time upvotes in /r/fitness Staff Software Engineer at Udemy
Austin, Texas
Joined November 2021
Tried to update to @TryGhost 6. Got a 502 on ERROR Could not get webhook secret for ActivityPub FetchError: invalid json response body at reason: Unexpected token '<', "<!DOCTYPE ". is not valid JSON.[2025-08-09 14:25:54] ERROR.
jilles.me
Articles written by a human. Mostly about web programming stuff.
1
0
1
This is exactly right. Start with a simple SQLite database if you have no users. Then once you start getting write locks, switch to MySQL or Postgres. Then once your database is struggling to keep up with demand, look at PlanetScale or RDS/Aurora. Don't start there.
It feels like we lost an entire generation. You were supposed to learn how things work and then choose a 3rd party PaaS if it supported your tradeoffs, not blindly choose PaaS because you don’t understand how anything works.
1
0
2
Half of this is solved by just thinking. The other half is solved by @PlanetScale.
Databases are simple…. You only need to:. - Use proper indexing (avoid over and under indexing). - Use proper data types. - Optimise queries. - Set up read replicas. - Manage spiky data volumes. - Handle transactions and concurrency . - Manage security and access policies. -.
0
0
4