PostgreSQL

How To Build a REST API with Prisma and PostgreSQL — step-by-step Docker tutorial on Progressive Robot

How To Build a REST API with Prisma and PostgreSQL

Prisma is an open source database toolkit. In this tutorial, you will build a REST API for a small blogging application in TypeScript using Prisma and a PostgreSQL database. At the end of the tutorial, you will have a web server running locally on your machine that can respond to various HTTP requests and read and write data in the database.

Read more
How To Install and Use PostgreSQL on CentOS 8 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use PostgreSQL on CentOS 8

PostgreSQL, or Postgres, is a relational database management system that provides an implementation of the SQL querying language. It is a popular choice for many small and large projects and has the advantage of being standards-compliant and having many advanced features like reliable transactions and concurrency without read locks.

Read more
How To Install and Use TimescaleDB on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use TimescaleDB on Ubuntu 20.04

TimescaleDB is an open-source database optimized for storing time-series data. It is implemented as an extension of PostgreSQL and combines the ease-of-use of relational databases and the speed of NoSQL databases. By following this tutorial, you’ll set up TimescaleDB on Ubuntu 20.04, configure it, and learn how to work with it. You’ll run through creating time-series databases and making simple queries. Finally, you’ll see how to compress data and get rid of unnecessary data.

Read more
How To Install Umami Web Analytics Software on Ubuntu 20.04 — step-by-step Docker tutorial on Progressive Robot

How To Install Umami Web Analytics Software on Ubuntu 20.04

Umami is an open-source, self-hosted web analytics application written in Node.js. It focuses on being simple, well-designed, fast, and privacy-focused. It can store data about your website’s visitors in either a MySQL or PostgreSQL database. In this tutorial you will install Umami and a PostgreSQL database using Docker Compose, then install Nginx and Certbot to set up a secure HTTPS reverse proxy for Umami.

Read more
CHAT