All Stories

How to Install, Enable and List TimescaleDB version in PostgreSQL

TimescaleDB is a PostgreSQL extension that enables easier approach when working with time-series data. Today we are going to see how can we install, enable / disable, get the Timescal...

In PostgreSQL, Feb 17, 2022

How to Run Django Application Server

Django is a python free and open-source framework that is widely used nowadays. It offers a lot of libraries and functions that can be easily invoked. Running Django app with a local ...

In Django, Feb 16, 2022

How to Limit Number of Rows in PostgreSQL

Limiting SQL queries is most likely a useful feature especially if you want to get a sample data chunk from a big table. The LIMIT clause in PostgreSQL is pretty much the same as the ...

In PostgreSQL, Feb 15, 2022

How to install DBeaver on Debian 11

Installing DBeaver on Debian 11 follows pretty much the same steps from Ubuntu 21.10. The two methods of installing are: snap package

In DBeaver, Feb 14, 2022

How to list Sequences in PostgreSQL

Sequences in PostgreSQL are types of objects in a database that generates sequence of integers with a specific requirements. Here’s few ways to list them though.

In PostgreSQL, Feb 13, 2022

How to install DBeaver on Ubuntu 21.10

One of the great alternative for MySQL workbench is DBeaver. So instead of connecting only Mysql servers, DBeaver offers a lot of different database connections like PostgreSQL, SQLit...

In DBeaver, Feb 12, 2022

How to list Triggers in PostgreSQL

Triggers are types of stored procedures that run automatically whenever an event occurs, something like webhooks. And, a few ways to list them.

In PostgreSQL, Feb 11, 2022

AWS Error 1290 (HY000): The MySQL server is running with the --read-only

Using AWS Aurora auto-scaling will increase the resources to handle the workload and connections. So that way you can see a bunch of replicas that are taking care of the workload. Con...

In MySQL, Feb 10, 2022

How to list Stored Procedures in PostgreSQL

Stored procedures or simply put procedures are just SQL codes that can be saved for later use. There are few ways you could list them though, found below.

In PostgreSQL, Feb 09, 2022

Resolve couldn't connect to docker daemon at http+docker //localhost - is it running?

Using Docker with a non-root user can cause issues connected with the docker daemon. The docker daemon binds to a Unix socket, so the docker client will try to communicate to the daem...

In Docker, Feb 08, 2022