I let Copilot build my database. Here’s what I learned – and everything I’d do differently next time (part two)

 dans Sites anglophones  étiqueté AI / Database / Database Administration / Databases / Featured / How I built an app AI LLM / LLM / MySQL / PostGreSQL / SQL Server par

 

I handed Microsoft Copilot the keys to design a PostgreSQL schema for Azure Database for PostgreSQL Flexible Server, with as little intervention from me as I could stand. What came back was a working four-table schema (dialects, terms, translations, artifacts) with foreign keys, JSONB metadata, seed data for three SQL dialects, and a deployment checklist that actually ran.

But that’s just a small part of the story. In this article, I’ll shout about what it got right – but also emphasize what it got wrong, why it happened, and what I’ve learned. Includes tips, advice, and the full