This database category contains information about a lot of database which I will encounter on my professional career.
Using Alembic with SQLAlchemy (which is often used under the hood, even with ORMs like SQLModel) is the standard approach for migrations. Here is a step-by-step guide to installing Alembic, configuring it, defining a User model, and creating your first migration. 1. Project Setup & Installation First, ensure you have a basic FastAPI project structure …
Export a PostgreSQL Database with pg_dump Command To export a database through command line. PostgreSQL has provided command-line utility to effectively backup your important information which is pg_dump and a pg_dumpall. The pg_dump is a command-line tool that allows you to dump the content of a specified database into a single file. The pg_dump command provides several options that …
Read more “How to export and import database in PostgreSQL through command line?”