The Future of Database Development: TypeScript Code Generation with Xata

Keeping code models and database models in sync is a pain. This database can generate TypeScript types that you can work with directly in your code!

***SPONSORED BY XATA***

**QUESTIONS ABOUT MY SETUP**

**STAY IN TOUCH 👋**

**DISCORD**

***TIMESTAMPS***
00:00 - Intro
01:45 - Problems with Keeping Database Models in Sync with TypeScript
02:50 - Xata Codegen
06:30 - Wrap Up

[alexandersedeke]

I have been an Oracle DBA and Certified Developer since version 6, working with many databases such as DB2, Informix, SyBase, today MS SQL Server, MySQL, MongoDB, Neo4j, Exasol and so on. Today I write web applications for companies that need a database that is reliable, stable, fast and highly scalable.
What strikes me again and again, with these concepts as described here, is that they use by their kind only few possibilities of a database. Basically they use it as a storage dump. In most cases I was able to improve the speed and security significantly by adapting the data layout to the database. An important aspect here is also that JUST the api has no influence on the stored type. The concept of passing through the data definition usually only works in very small projects. Just a thought of mine since.

[EluviumMC]

For our legacy software we've been using SQL Server, but for new dev, we're using Postgres. We already use typescript, so yay!

[sbdev]

I have been using MySQL as my main DB. I want to go away from PHP and use Astro with MySQL. It's been a learning curve. I came close with another option but needed to rewrite all my queries. Maybe showing Xata working with Astro be an excellent video.

[Joshuahendrix]

Hey there James, great vid, I usually use mongo with typescript and express.

[iPankBMW]

Using AWS DynamoDB via Amplify. And the Types are autogenerated from the codegen :)

[alcb]

Hey James, I’m using Postgres with Prisma to communicate my NextJS project to it

[kumarvishalben]

Using MongoDB with mongoose client and Postgres with primsa