Managing PostgreSQL from VS Code using SQLTools • Full-Stack TypeScript with Kretes • E12

In this tutorial we are building a full-stack TypeScript application, which means we are using a single programming language on the back-end and on the front-end. Specifically, on the back-end we are using Node.js and on the front-end we are using Vue.js version 3 - the upcoming version of this UI framework.

The goal for this tutorial is to build yet another todo application. Contrary to other tutorials, we will not stop on the front-end, we will go deeper to the back-end and then I want to show you everything in between.

Today we will see how to use the SQLTools extension to manage the interactions with a PostgreSQL database. This extension allows to quickly connect to a running database engine and to write SQL queries as files in VS Code. It also provides contextual command directly in SQL commands to execute specific SQL statements directly. On top of that, by using regular files for SQL we not only have a proper syntax highlighting, but also the autocompletion feature from SQLTools. This way we can see SQL keywords to quickly create SQL statements. The SQLTools extension also lists the existing tables as a part of the autocompetion.

#typescript #postgresql #vscode

Looking for a source code? Support me on GitHub Sponsors to access all resources for my tutorials: https://github.com/sponsors/zaiste