Why use a Database:
- Databases are accessible in any programming language
, meaning you can communicate large amount of datas between apps.
- Querying a database is really fast as it is relation based
. So looking for all the items in a database matching specific criteria is lighting fast.
- Database are portable
WTF is seems so burried and inaccessible:
- At first databases concept if not explained right seems
complex. The other reason for that is the amount of different uses for databases leading in different ways to explain it.
- If your just starting I suggest you to use both the terminal
and a visual representation (GUI)
of your database.
If your using it for the web using PHP or else, there should be a webapp to view your databases. For desktop your have MYSQL Workbench
, SQL Workbench
(opensource/crossplatform and use drivers
for each database frameworks, hateful UI) or Postico
($). Specific to mac
you have PSequel
I personaly use pgAdmin