News for hackers. Stuff that matters.
Re:Ask HN: Have you used SQLite as a primary database? by js2 on Monday April 25, 2022 @07:41PM (#31162292)
> my sweet spot has become a big honking Postgres instance in RDS

Why do you prefer PostgreSQL RDS over Aurora RDS? Aurora seems better in every way but price[1]. (I know it also had some growing pains at launch.)

[1]: Amazon RDS for PostgreSQL is ideal when you have a small-to-medium intense workload. It works best when you have limited concurrent connections to your database. If you’re moving from commercial database engines such as Oracle or Microsoft SQL Server, Aurora PostgreSQL is a better choice because it provides matching performance with a lower price.

https://aws.amazon.com/blogs/database/is-amazon-rds-for-post...

Re:Ask HN: Have you used SQLite as a primary database? by oppositelock on Monday April 25, 2022 @11:49PM (#31163744)
Price is the main reason. Write performance is a second one.
Re:Ask HN: Have you used SQLite as a primary database? by js2 on Tuesday April 26, 2022 @11:02AM (#31168329)
The article I linked implies that Aurora offers higher write performance:

> If your database workload reaches the Amazon RDS max limit of 80,000 IOPS, and it requires additional IOPS, Aurora PostgreSQL is the preferred database solution. If database workload requires less than 80,000 IOPS, you can choose either Amazon RDS for PostgreSQL or Aurora PostgreSQL based on supported features.