@vic0de

Connecting to a PostgreSQL DB on CloudSQL via Python server running on Cloud Run

May 8, 2024 · 4 min read · Once we have our PostgreSQL database running on CloudSQL, with the flag cloudsql.iam_authentication set to on. We can now have a look at how we could create a Python FastAPI backend that connects to the database. Let's start by creating a project fol...

Getting started with PostgreSQL and Python

May 5, 2024 · 3 min read · Start by running your Docker Desktop application. Then via the command line run the following command to pull the latest postgres image and start an instance. docker run -d -p 5432:5432 -e POSTGRES_PASSWORD=mysecretpassword --name postgres_docker pos...

Dockerizing a Hello World Express App and Uploading to GCP Artifact Registry

Jan 14, 2024 · 4 min read · Our express app is a very simple API that listens on port 3000. And has a single endpoint of root, which returns a JSON message of Hello World. Create a new folder named hello-express-app and cd into it. mkdir hello-express-app && cd hello-express-ap...

Building a simple REST API using Nodejs, Expressjs, Prisma, and SQL - Part 04

Oct 2, 2023 · 6 min read · In the last three articles, we created a new database project in PlanetScale to power our SQL DB. Then we created a user route for handling crud operations via Prisma client. And then we went on to add TypeScript and input validation using Zod. We wi...

Building a simple REST API using Nodejs, Expressjs, Prisma, and SQL - Part 03

Oct 1, 2023 · 4 min read · In the last two articles, we dealt with setting up a MySQL database on PlanetScale and creating an Express API to do CRUD operations on the User table in our database. Now we will add TypeScript to our project. Let's begin by installing the following...