Summary
Getting the timing right of heading to the bus stop is a challenge that most can relate to. The first step in architecting a solution involves building a strong foundation for the application with a database. Azure SQL Database is a modern database with the capabilities required for modern applications like catching the bus. Azure SQL Database supports JSON, geospatial, and GitHub Actions. The features in Azure SQL Database make it easy to meet the requirements of the scenario and enables you to build a CI/CD pipeline from the start.
Azure SQL Database makes it easier to develop the foundations of applications like the serverless, full-stack application discussed for catching the bus.
References to further your learning
There are many references for you to go as deep into the topics discussed as you want, now or at a later time.
Modern database development with Azure SQL Database
The following references are related to Azure SQL Database's modern capabilities.
- Azure SQL YouTube Channel featuring Data Exposed
- Video: Using Azure Pipelines for Azure SQL deployments
- 10 reasons to use Azure SQL in your next project.
- Azure SQL JSON support sample
- Geospatial support
- OpenLayers library
- Graph models
- Columnstore indexes
- Introduction to Memory-Optimized Tables
Implement DevOps using Azure SQL Database
The following references will be useful if you want to learn about DevOps generally and as it relates to Azure SQL Database.
- What is DevOps?
- CI/CD
- GitHub Actions
- Azure DevOps
- Video: Getting Started with DevOps for Azure SQL
- Video: Using Azure Pipelines for Azure SQL Deployments
- DevOps for Azure SQL.
- GitHub Action types
- Azure SQL Deploy Action
- Azure Pipelines task reference
- Azure SQL Database Deployment Task
Frameworks that support code first migrations
- .NET Core - Entity Framework
- Node - Sequelize
- Node - Prisma
- Python - Django
- Python - SQLAlchemy Alembic
Other samples for diving into modern database development
A sample of a fully featured solution that shows how to use the Manual Script approach along with database unit testing options is available here: Modern development: creating a REST API, via CI/CD and back.