Linux

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

How To Install and Use ClickHouse on Ubuntu 20.04

ClickHouse is an open source, column-oriented analytics database created by Yandex for OLAP and big data use cases. In this tutorial, you’ll install the ClickHouse database server and client on your machine. You’ll use the DBMS for typical tasks and optionally enable remote access from another server so that you’ll be able to connect to the database from another machine. Then you’ll test ClickHouse by modeling and querying example website-visit data.

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

How To Install and Use Composer on Ubuntu 22.04

Composer is a popular dependency management tool for PHP, created mainly to facilitate installation and updates for project dependencies.It will check which other packages a specific project depends on and install them for you, using the appropriate versions according to the project requirements.

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

How To Install and Use PostgreSQL on CentOS 7

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 18.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use TimescaleDB on Ubuntu 18.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 18.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
CHAT