Build your own SQL fiddle with Docker & Visual Studio Code
A walkthrough on using Docker + VSCode to set up a lightweight PostgreSQL environment. Code and docs below. Prerequisites are listed in the Github README.
CODE: https://github.com/dsynkov/pg-sql-doc...
BLOG POST: / build-your-own-sql-fiddle-with-docker-vscode
The goal of this video is to demonstrate that spinning up an ephemeral database instance for ad-hoc querying can be quite simple with docker-compose. Please note that this is not a production-ready environment and should be used for local development and testing only. In the next two videos we will:
PART 2: Go over how to add authentication to our Dockerized PostgreSQL DB ( • Add authentication to your Dockerized... )
PART 3: Explore another user case for this approach with the AdventureWorks dataset ( • Loading the AdventureWorks dataset wi... )