{"id":1116,"date":"2022-01-18T10:20:17","date_gmt":"2022-01-18T18:20:17","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/azure-sql\/?p=1116"},"modified":"2022-01-18T10:41:32","modified_gmt":"2022-01-18T18:41:32","slug":"automatic-graphql-and-rest-endpoint-for-azure-sql-with-directus","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/azure-sql\/automatic-graphql-and-rest-endpoint-for-azure-sql-with-directus\/","title":{"rendered":"Automatic GraphQL and REST endpoint for Azure SQL with Directus"},"content":{"rendered":"

\"Image<\/a><\/p>\n

<\/i>Guest Post<\/strong><\/p>This post has been originally written by Rijk van Zanten (@rijkvanzanten<\/a>), CTO & Co-Founder @Directus<\/a>. Thanks Rijk! <\/div><\/p>\n

Extremely performant and built entirely on Node.js, Directus<\/a> is an open-source Data Platform that enables anyone in an organization \u2014 from developers to data scientists to business users \u2014 to access and manage the database content that powers all your applications and digital experiences. It installs as a layer on top of your existing SQL database, mirroring its content and schema, so there is no need to migrate or alter your data. Once installed, you instantly get a dynamic API (REST and GraphQL) and no-code app that democratizes data so you can extract maximum value from it across your organization.<\/p>\n

\"Directus<\/p>\n

Sounds interesting? Good!<\/p>\n

So, now you\u2019ve decided to get Directus up and running on Azure SQL, but don\u2019t have a lot of time to spend messing around with the installation. The good news is there\u2019s a quick and easy way to deploy and get started with Directus, and in this post, I\u2019ll show you how.<\/p>\n

The fastest way to get up and running with Directus is by using <\/span>this sample implementation<\/span><\/a>. To make it even easier, in this post, I\u2019ll demonstrate how to spin up a Directus instance running on Azure SQL and Azure App Service, beginning with setting up a local project working directory and configuring the connection to Azure SQL. Then, I\u2019ll show you how to host Directus itself on Azure App Service, making your app and APIs accessible from anywhere!\u00a0<\/span><\/p>\n

Prerequisites\u00a0<\/span><\/h2>\n

To get started, you\u2019ll need Node.js version 12.20 or later, and an Azure SQL database server that’s accessible from your local machine.<\/span><\/p>\n

Creating the Database\u00a0<\/span><\/h2>\n

Here\u2019s how to create a Directus compatible Azure SQL database using CLI commands.\u00a0<\/span><\/p>\n

Create a resource group to hold the resources for this project:\u00a0<\/span><\/p>\n

az group create --location eastus --name {GROUP_NAME}<\/pre>\n
Create the database server: <\/span><\/p>\n
az sql server create -l eastus -g {GROUP_NAME} --name {DB_SERVER_NAME} --admin user {DB_ADMIN_USER} --admin-password {DB_PASSWORD} --enable-public-network true<\/pre>\n
Make sure to note the database name, username and password somewhere safe.<\/span><\/p>\n
Create the database:\u00a0<\/span><\/p>\n
az sql db create --resource-group {GROUP_NAME} --server {DB_SERVER_NAME} --name {DB_NAME} --service-objective Basic<\/pre>\n
Allow your computer to access the database:<\/span><\/p>\n
az sql server firewall-rule create --resource-group {GROUP_NAME} --server {DB_SERVER_NAME} --name allow-local-access --start-ip-address {YOUR_PUBLIC_IP} --end-ip-address {YOUR_PUBLIC_IP}<\/pre>\n
Creating the Project & Installing Directus\u00a0<\/span><\/h2>\n
Create a project directory, and install Directus by running:\u00a0<\/span><\/p>\n
npm init directus-project .\/directus-example<\/pre>\n
Then, in the prompts, enter:\u00a0<\/span><\/p>\n