PostgreSQL

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
12 Days of the cloud provider: Your Complete Guide — step-by-step Databases tutorial on Progressive Robot

12 Days of the cloud provider: Your Complete Guide

A recap of the 12 Days of the cloud provider tutorial series. Build a Birthday Reminder Service and an Email Receipt Processor while exploring the cloud provider services like managed databases, serverless functions, object storage, logging, and APIs like Twilio and GenAI.

Read more
CHAT