Shows
Laravel Creator SpotlightMySql Explain with Tobias PetryThis week, we welcome Tobias Petry to the Laravel Creator Series show to discuss his journey into database optimization, the development of his MySQL Explain tool, and the acquisition of the domain `mysqlexplain.com`. Tobias also shares insights about his other projects, including Stack Bricks, a tool for managing different database versions, and his contributions to the Laravel Debug Bar. ➡️ Save 10% on his Indexing Beyond the Basics book and video package with the coupon code `LARAVELNEWS` Show Linkshttps://x.com/tobias_petryhttps://tpetry.mehttps://mysqlexplain.comhttps://stackbricks.apphttps://sqlfordevs.comhttps://goodindexes.com2024-09-2026 min
Postgres FMSlow countNikolay and Michael discuss why counting can be slow in Postgres, and what the options are for counting things quickly at scale. Here are some links to things they mentioned:Aggregate functions (docs) https://www.postgresql.org/docs/current/functions-aggregate.htmlPostgREST https://github.com/PostgREST/postgrest Get rid of count by default in PostgREST https://github.com/PostgREST/postgrest/issues/273 Faster PostgreSQL Counting (by Joe Nelson on the Citus blog) https://www.citusdata.com/blog/2016/10/12/count-performance Our episode on Index-Only Scans https://postgres.fm/episodes/index-only-scansPostgres HyperLogLog https://github.com/citusdata/postgresql-hllOur episode on Row estimates http...2024-09-1343 min
IndieRailsAndrew Atkinson - The Postgres SpecialistAndrew Atkinson is a Rails developer, turned Postgres specialist, turned author and consultant. He joins us to talk about his developer journey, how he found his niche with Postgres, writing his new book, High Performance PostgreSQL for Rails, and the launch of his consulting practice.Relevant LinksTwitterWebsite (Consulting page)High Performance PostgreSQL for RailsNewsletterHow we made PG Fitter, Happier, More Productive at PGConf NYC 2021 (slides, blog post)More videosOther ShoutoutsRailsConf 2022 blog postMichael Hartl's RailsSpace bookWendy's spicy chicken, GOATedDavid Rowley, PG committer and past mentor, recently writing about PostgreSQL 16 query planner enhancements. P...2024-05-2853 minPostgres FMPostgres year in review 2022Here are links to a few things we mentioned: 1. Startups building momentumAiven raised $210m Timescale raised $110m Hasura raised $100m Supabase raised $80m Neon raised $30m Hydra OrioleDB 2. Educational resourcesPostgres FM started 👋Postgres TV became more active (including topic playlists) Tobias Petry tips on Twitter and SQL for Devs Hussein Nasser YouTube channel (backend engineering) Postgres Weekly (newsletter) 3. Sharding progressCitus goes fully open source SPQR pgcat Sharding Postgres at Notion (blog post) PlanetScale (MySQL) 4. Database branching is comingDatabase Lab Engine Neon branching OrioleDB branching Crunchy Bridge Database branching episo...2022-12-3033 min