>>19323figure out the basics of SQL and fuck around with it, just go and use it
postgresql is the best sql database you can use, it has the best performance and a is pretty easy to use
lets say you set up a matrix server with a synapse database
sudo -u postgres psql synapse
now you can fuck around, \d lists all the shit in the db, or \l lists all databases
you can switch DBs with \c database user
try \d and pick something, like users
\d users
it will list a bunch of columns like name, password_hash, user_type, etc…
Post too long. Click here to view the full text.