DBeaver, Postgres, Aiven, and Other SQL Shenanigans

When working with data, you need a way to store it, a way to access it, and maybe even share it. The platforms that allow this are called Database Management Systems (DBMS). One way to store it is in the form of rows and columns eg. customer table where the rows have customer names, ids, etc. When data is stored in this way, it is called structured data. Data might also not have rows and columns, eg, images and videos. This means the information is just clustered together, which is often called unstructured data. You choose the DBMS to use based on the type of data you are storing, whether it is structured or unstructured, and how you need to query and scale it. One of the DBMS for structured data is Postgres - this is the one I am currently learning. You can install Postgres and host it yourself, but managing it requires a lot of work. So instead, it is easier to use a cloud hosting platform like Aiven , which hosts this database for you. Now that you have your database and it is alre