Notes & ideas

Writing about code, systems, and the things I learn.

A collection of practical notes from building backend software and exploring technology.

ARTICLE

Django ORM Standalone⁽¹⁾: Querying an existing database

Introduction For a long time I wanted to document something I have done many times in production systems but never explained clearly: using Django OR…

Read article
ARTICLE

Create a PostgreSQL Database in Docker

PostgreSQL is a well-known relational DBMS that provides a variety of features, such as built-in or user-defined functions, operators, data types, an…

Read article
ARTICLE

Dumping and Restoring a PostgreSQL Database

To dump a PostgreSQL database located at a specific IP address and restore it to a new database, you can follow these steps: 1. Dumping the database:…

Read article
ARTICLE

Connecting to a PostgreSQL Database

Here are a few steps you can take to resolve connect to db with another IP: Verify the PostgreSQL server is running: Ensure that the PostgreSQL serve…

Read article
ARTICLE

Setting Up PostgreSQL

To create a database and an owner with a password in PostgreSQL, you can follow these steps: 1. First, make sure you have PostgreSQL installed and ru…

Read article
ARTICLE

Accessing a PostgreSQL Server Locally

To access and use your PostgreSQL database on your local machine, you will first need to ensure that you have a PostgreSQL server installed on your l…

Read article
ARTICLE

Reverse lookup in Django

In Django, reverse lookup refers to the process of accessing related objects in a database relationship from the "reverse" side. It allows you to ret…

Read article