What are database migrations?ĭatabase migrations, also known as schema migrations, database schema migrations, or simply migrations, are controlled sets of changes developed to modify the structure of the objects within a relational database. We'll take a look at the various pain points they address as well as some potential pitfalls they introduce. In this article, we'll go over what database schema migrations are, what problems they solve, and different implementation strategies. And since the schema manages the shape and boundaries of your data, changes must be carefully applied to match the expectations of the applications that use it and avoid losing data currently held by the database system. While it is important to develop a well-thought out schema at the beginning of your projects, evolving requirements make changes to your initial schema difficult or impossible to avoid. The United States' Most Popular Databases by state going into 2022ĭatabase schemas define the structure and interrelations of data managed by relational databases.Traditional databases vs serverless databases.Introduction to common serverless challenges.Top 13 serverless computing and database providers.Serverless architecture | Prisma's Data Guide.How microservices and monoliths impact the database.Syncing Development Databases Between Team Members.Troubleshooting Database Outages and Connection Issues.Managing databases | Prisma's Data Guide.Top 8 TypeScript ORMs, Query Builders, & Database Libraries: Evaluating Type Safety.Top 11 Node.js ORMs, Query Builders & Database Libraries in 2022.Database tools | SQL, MySQL, Postgres | Prisma's Data Guide.Introduction to MongoDB database tools & utilities.Working with dates and times in MongoDB.Introduction to MongoDB connection URIs.How to query and filter documents in MongoDB.How to manage databases and collections in MongoDB.How to manage authorization and privileges in MongoDB.How to manage users and authentication in MongoDB.Introduction to provisioning MongoDB Atlas.How to update existing data with SQLite.How to perform basic queries with `SELECT` with SQLite.Inserting and deleting data with SQLite.Creating and deleting databases and tables with SQLite.An introduction to MySQL column and table constraints.How to create and delete databases and tables in MySQL.An introduction to PostgreSQL column and table constraints.An introduction to PostgreSQL data types.How to create and delete databases and tables in PostgreSQL.How to configure a PostgreSQL database on RDS.Comparing common database infrastructure patterns.Using the expand and contract pattern for schema changes.Strategies for deploying database migrations.Comparing SQL, query builders, and ORMs.Comparing relational and document databases. Glossary of common database terminology.Comparing database types: how database types evolved to meet different needs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |