PostgreSQL, Software Development

Log In As Different User To pgAdmin 4 Web UI

This post shows how to log in as another user to pgAdmin 4 accessible via a web browser.

Read More...

Docker, PostgreSQL, Software Development

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,

Read More...

PHP, Software Development

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

Read More...

Software Development

How to connect to PostgreSQL using JDBC

This article demonstrates how to connect to Postgres using JDBC.

Read More...

Java, Software Development

Specify Non-default PostgreSQL Schema When Connecting Using JDBC

PostgreSQL is a better choice than MySQL. Not only that, I have a client who has plans to migrate from Oracle 11g to PostgreSQL. Now imagine that! One of things you need to know when working with PostgreSQL is how to set a default schema when connecting to it.

Read More...

Docker, PostgreSQL, Software Development

Using pgloader in docker container for host’s databases

This post demonstrates how to migrate from MySQL to PostgreSQL instance running in Windows using pgloader running in a Docker container.

Read More...

Docker, PostgreSQL, Software Development

docker-compose.yml for PostgreSQL

This post provides a basic docker-compose.yml to create a PostgreSQL container with initial user account with password.

Read More...

PostgreSQL, Rust, Software Development

Rust – Connect to PostgreSQL

This post is about how to connect to PostgreSQL from Rust.

Read More...

Rust, Software Development

REST API with Rust, Actix-web, and PostgreSQL – Part 1

This is the first part post that demonstrates a simple example of a RESTful API with Rust, Actix-web and PostgreSQL.

Read More...

Rust, Software Development

REST API with Rust, Actix-web, and PostgreSQL – Part 2

Previously, we have a bit of overview of the stuff needed to start creating a REST API example. This post is the second part post.

Read More...