vic0de.hashnode.devConnecting to a PostgreSQL DB on CloudSQL via Python server running on Cloud RunOnce 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...May 8, 2024·4 min read
vic0de.hashnode.devGetting started with PostgreSQL and PythonStart 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...May 5, 2024·3 min read
vic0de.hashnode.devDockerizing a Hello World Express App and Uploading to GCP Artifact RegistryOur 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...Jan 14, 2024·4 min read
vic0de.hashnode.devBuilding a simple REST API using Nodejs, Expressjs, Prisma, and SQL - Part 04In 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...Oct 2, 2023·6 min read
vic0de.hashnode.devBuilding a simple REST API using Nodejs, Expressjs, Prisma, and SQL - Part 03In 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...Oct 1, 2023·4 min read
