In this workshop, we will learn how to create a complete application using DAB, Azure SQL, and Vue.js. We will create an employee management application where we can add, edit, and delete employees.
The Data API builder (DAB) is an open-source tool from Microsoft that converts REST and GraphQL into database queries. With Data API builder, you can generate code based on your database schema that can be accessed through a REST or GraphQL API that will work with any language, platform, or device.
It also comes with support for data organization behaviors that require additional code, such as pagination, filtering, and ready-to-use sorting, reducing the time needed to create the Back-End of your application. Another important point to mention is that DAB can be run locally, in a container, or as a Managed Service in Azure through the new Database Connection feature available in Azure Static Web Apps.
With this service, we can easily manipulate data with support for CRUD (Create, Read, Update, and Delete) operations. It also includes support for integrated authorization and relationships.
The most interesting part of the Data API builder is that you can use it offline (or locally) or in the cloud with Azure. This allows you to quickly create a fully functional Back-end with a database of your choice, aiming to accelerate the development process.
If you want to learn more about the Data API builder, the databases supported by DAB are:
To follow this workshop, you will need to have the following software installed on your machine:
-
- Algumas extensões do Visual Studio Code: