All Stories
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, 2022How 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, Debian, Feb 14, 2022How to list sequences in PostgreSQL
Sequences in PostgreSQL are types of objects in a database that generates sequence of integers with specific requirements. Here are few ways to list them though.
In PostgreSQL, Feb 13, 2022How 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, Ubuntu, Feb 12, 2022How 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, 2022AWS 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, 2022How 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, 2022Resolve 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, 2022How to list indexes in PostgreSQL
This week is all about listing things in PostgreSQL, and I’m going to start with indexes. Indexes are basically tables that points to data in other tables, therefore speeding up the q...
In PostgreSQL, Feb 07, 2022How to install Apache on Amazon Linux 2
Once you have provisioned an AWS EC2 instance installing Apache on Amazon Linux 2 is a straightforward and easy process. Here I’m going to show you how to install Apache web server on...
In Apache, AWS, Amazon Linux 2, Feb 06, 2022