Setup
To get started with our database we first need two thing.
- A database
- A client to access our database
Database Setup
I won't explain the setup of every database here in detail. A lot of people did this already. I will link the debian, ubuntu and windows installation guides here. If you are an "I use arch btw" user you will find your own way like you always do.
If you are a docker user you know what to do.
MySQL
Many guides out there will include an installation of apache with a phpmyadmin instance.
I highly discourage the usage of phpmyadmin. It has several known exploits and is in general a pure security issue on your server. There are much better ways.
MariaDB
Many guides out there will include an installation of apache with a phpmyadmin instance.
I highly discourage the usage of phpmyadmin. It has several known exploits and is in general a pure security issue on your server. There are much better ways.
PostgreSQL
Some installation processes will suggest you to install pgadmin as well. I do not recommend this. It is a good tool, but superseded by the desktop tools I will show you next.
SQLite
No installation required. Your desktop tool of your choice can create this database for you.
Desktop Tool
After we have our database running we need to connect to it.
For this we need to choose our tool.
Free
Paid
- Unix and Windows DataGrip (Free if you are part of GitHub Education)
Connect
If you have installed the database locally on your machine this part will be simple since you can skip the ssh tunnel fun.
You may be tempted to open the port of your remote database to access it, but DON'T do this! Database software is in general not designed to be secure enough to withstand outside attacks. It's always better to keep it secure behind your firewall.
All three tools have an option to use an ssh tunnel for connection to your database.
If you haven't set up an ssh connection yet, you should do it now.
Now you need to connect to your database via an ssh tunnel.
That's it. Now you are ready for some fun with the database.