GraphQL & REST with Typescript, Prisma and Azure SQL: love at first sight!

If you’re into Typescript and prefer a code-first approach when working with databases, you’ll be happy to learn about Prisma! Prisma is a next-generation Node.js and TypeScript ORM, that allows you to define a schema using a dedicated DSL so that you …


This content originally appeared on DEV Community and was authored by Davide Mauri

If you're into Typescript and prefer a code-first approach when working with databases, you'll be happy to learn about Prisma! Prisma is a next-generation Node.js and TypeScript ORM, that allows you to define a schema using a dedicated DSL so that you can then have all the comforts of modern development environments like intellisense, static type checking, automatic scaffolding and more.

To help everyone, even those who just started working as coders - or those who want to start a career as software engineers - we have created a fully working end-to-end full-stack solution that has:

  • a frontend written with Vue.Js
  • a backend, written in Typescript and using Prisma
  • an Azure SQL database (for the reasons explained here)

to make it consumable be really everyone, we also decided to support both REST and GraphQL protocols

and we also decided to make sure that everyone can take advantage of a streamlined CI/CD experience, so we used Azure Static Web Apps and GitHub Actions to glue everything together.

Last, but not least, the sample also support Authentication and Authorization (which is super simple thanks to Azure Static Web Apps!)

I must say I'm happy and proud of what has been done, as this example is a great learning experience and starting point for everyone interested in becoming a better developer.

So, look at the article here to learn more about Prisma:

Modern application development with Prisma, GraphQL (or REST) and Azure SQL

and to the repository hear to deploy the code on your own:

GitHub logo Azure-Samples / azure-sql-db-prisma

Full-Stack End-To-End implementation - both with REST and GraphQL support - with Azure SQL and Prisma.io of the well-known To-do list sample.

The repository is fully documented. You should be easily able to set up your working environment in no time. If you want to see it in action and learn about it before starting to use it, I did a session at the Prima Meetup that you can watch here:


This content originally appeared on DEV Community and was authored by Davide Mauri


Print Share Comment Cite Upload Translate Updates
APA

Davide Mauri | Sciencx (2021-10-11T19:07:35+00:00) GraphQL & REST with Typescript, Prisma and Azure SQL: love at first sight!. Retrieved from https://www.scien.cx/2021/10/11/graphql-rest-with-typescript-prisma-and-azure-sql-love-at-first-sight/

MLA
" » GraphQL & REST with Typescript, Prisma and Azure SQL: love at first sight!." Davide Mauri | Sciencx - Monday October 11, 2021, https://www.scien.cx/2021/10/11/graphql-rest-with-typescript-prisma-and-azure-sql-love-at-first-sight/
HARVARD
Davide Mauri | Sciencx Monday October 11, 2021 » GraphQL & REST with Typescript, Prisma and Azure SQL: love at first sight!., viewed ,<https://www.scien.cx/2021/10/11/graphql-rest-with-typescript-prisma-and-azure-sql-love-at-first-sight/>
VANCOUVER
Davide Mauri | Sciencx - » GraphQL & REST with Typescript, Prisma and Azure SQL: love at first sight!. [Internet]. [Accessed ]. Available from: https://www.scien.cx/2021/10/11/graphql-rest-with-typescript-prisma-and-azure-sql-love-at-first-sight/
CHICAGO
" » GraphQL & REST with Typescript, Prisma and Azure SQL: love at first sight!." Davide Mauri | Sciencx - Accessed . https://www.scien.cx/2021/10/11/graphql-rest-with-typescript-prisma-and-azure-sql-love-at-first-sight/
IEEE
" » GraphQL & REST with Typescript, Prisma and Azure SQL: love at first sight!." Davide Mauri | Sciencx [Online]. Available: https://www.scien.cx/2021/10/11/graphql-rest-with-typescript-prisma-and-azure-sql-love-at-first-sight/. [Accessed: ]
rf:citation
» GraphQL & REST with Typescript, Prisma and Azure SQL: love at first sight! | Davide Mauri | Sciencx | https://www.scien.cx/2021/10/11/graphql-rest-with-typescript-prisma-and-azure-sql-love-at-first-sight/ |

Please log in to upload a file.




There are no updates yet.
Click the Upload button above to add an update.

You must be logged in to translate posts. Please log in or register.