289: Have You Ever Ridden a Horse?

The Bike Shed

• Episode: 289: Have You Ever Ridden a Horse?
• Website: The Bike Shed
• Feed URL: https://www.bikeshed.fm/rss
• Duration: 00:37:58
• Published: 2021-04-20 06:15

On this week's episode, Steph and Chris tackle a pair of questions -- the first dealing with how closely we might want to map an API to the underlying database schema, and the second dealing with back of the envelope math and horses (it makes more sense in context.... mostly). They also discuss the subtleties of the javascript date API across browsers, and a quick adventure in tuning database indexes for fun and profit. This episode is brought to you by ScoutAPM (https://scoutapm.com/bikeshed). Give Scout a try for free today and Scout will donate $5 to the open source project of your choice when you deploy Testing LiveView (https://www.testingliveview.com/) Inspecting Postgres Indexes (https://www.postgresqltutorial.com/postgresql-database-indexes-table-size) Postgres Partial Indexes (https://www.postgresql.org/docs/current/indexes-partial.html) Postgres Create Index Concurrently (https://www.postgresql.org/docs/9.1/sql-createindex.html#SQL-CREATEINDEX-CONCURRENTLY)