By default, we use the public schema when we connect to PostgreSQL. Some applications use multiple schemas to store data in the database. Therefore, they need to specify explicitly which PostgreSQL schemas to use. This post shows how to connect
PHP 7.4 – Enable PostgreSQL Driver
This post shows how to configure PHP 7.4 (or PHP 7.x, in general) php.ini to enable the PostgreSQL driver, which comes in handy when I need to work on a new version of PHP after a very long break (like
docker-compose.yml For PgAdmin And PostgreSQL
In this post, we’ll set up PgAdmin and PostgreSQL containers with docker-compose.yml for local development. We’ll also configure PgAdmin to access the PostgreSQL database under the same bridge network. Typically, we don’t deploy a PgAdmin container alongside a PostgreSQL container
Migrate from MySQL to PostgreSQL Using Pgloader Docker Container
This post shows how to migrate a database from MySQL to a PostgreSQL instance running on Windows using the pgloader (running as a Docker container) to perform the migration from MySQL to PostgreSQL. From within the container, we use docker.for.win.localhost
docker-compose.yml for PostgreSQL
This post provides a basic docker-compose.yml to create a PostgreSQL container with initial user account with password.
Rust REST API, Actix-web, PostgreSQL – Part 1: Overview
This post shows a simple example of a REST API with Rust, Actix-web, and PostgreSQL and its requirements. Rust Actix-web PostgreSQL Requirements These are the items used for these posts and the subsequent ones. Windows 10 Please see How to install
Rust REST API, Actix-web, PostgreSQL – Part 2: The Project
Previously, we had a bit of an overview and prerequisites of the stuff needed to start creating a REST API example in Rust using Actix-web and PostgreSQL project. This post is the second part and gives an overview of the
Rust REST API, Actix-web, PostgreSQL – Part 3: The Codes
We had an overview of the project structure. This post shows the codes of the files mentioned in the previous post.
How to connect Java to PostgreSQL using JDBC
This is a simple post that shows how to connect Java to PostgreSQL using JDBC. Although most Java developers do not use this technique anymore, frameworks still do, and the codes are abstracted away from us. Meanwhile, some may still
Rust – Connect to PostgreSQL Database Using Crate
Is this your sudden foray into Rust? Although not totally for beginners, this post shows how to connect to a PostgreSQL database from Rust. Note that we have updated the content of this post to use a newer version of