How to Stop SELECT * From Breaking Backfills

New columns can silently change app behavior.

#mysql #selectstar #schemachanges #howto #bug #production

https://www.youtube.com/watch?v=HoTlcVSESYI

🎩✨ Behold the mystical "expand and contract pattern" for database schemas! Because who doesn't love a guide that turns simple schema changes into a quest for the Holy Grail? 🏰🔍 Spoiler: it's just another way to say "do it carefully," but with extra steps and a touch of #wizardry. 🧙‍♂️🗃️
https://www.prisma.io/dataguide/types/relational/expand-and-contract-pattern #expandAndContract #databaseSchemas #schemaChanges #databaseDesign #HackerNews #ngated

Using the expand and contract pattern for schema changes

https://www.prisma.io/dataguide/types/relational/expand-and-contract-pattern

#HackerNews #expandAndContract #schemaChanges #dataPatterns #databaseManagement #relationalDatabases #prisma

Db2 Prepared Statement Cache can be tricky after ALTER TABLE. Learn how to manage it effectively, from limiting cache size to implementing schema change detection. Ensure your app uses the correct query plan! #Db2PreparedStatements #DatabaseCaching #SchemaChanges #SQLPerformance #DB2LUW #ALTERTABLE https://tech-champion.com/database/db2-prepared-statement-cache-resolving-schema-change-issues-after-alter-table

Upgrading to Rails 7? 🚂 Brace yourself for some schema changes! Learn what's new and how to handle it like a pro.

Don't let it catch you off guard when you upgrade: https://www.fastruby.io/blog/dealing-with-schema-changes-in-rails-7.html?utm_source=Mastodon&utm_medium=Organic&utm_campaign=Blogpromo&utm_term=schemachanges-rails7&utm_content=Textonly

#schemachanges #Rails7 #rubyonrails