Alpha Launch Postmortem
Everything that went wrong with Supabase's launch
July 10, 2020
July 09, 2020
What are PostgreSQL Templates?
What are PostgreSQL templates and what are they used for?
July 07, 2020
Physical vs Logical Backups in PostgreSQL
What are physical and logical backups in Postgres?
July 05, 2020
What the Flush?
Yves Trudeau and Francisco Bordenave, MySQL experts at Percona, recently published a three-part post: (1) Give Love to Your SSDs – Reduce innodb_io_capacity_max!; (2) InnoDB Flushing in Action for Percona Server for MySQL; (3) Tuning MySQL/InnoDB Flushing for a Write-Intensive Workload. It’s a fantastic read from start to finish, and it made me realize: dirty pages sound bad, but they are good. I suspect the opposite (“dirty pages are not good”) is a misconception due to an incomplete picture. Let’s complete the picture.
July 01, 2020
Supabase Alpha June 2020
Four months of building
June 29, 2020
21 Parameter Group Values to Change in Amazon RDS for MySQL
Amazon RDS for MySQL uses many default values for system variables, but it also sets a few “sys vars” with different values. As with any database, neither product (MySQL) nor provider (AWS) defaults can best suite all use cases. It’s our responsibility to carefully review and set every important system variable. This is tedious and difficult, but I’ve done it for you.
Below are are 21 MySQL 5.7 system variables that I recommend changing by creating a new parameter group. This presumes new RDS instances; some of these sys vars cannot be changed easily after provisioning MySQL. This only applies to RDS for MySQL, not Amazon Aurora.
June 15, 2020
Steve Chavez has joined Supabase
Steve joins Supabase to help build Auth.