setting it up is a pain in the ass
i still havent set it up, frankly i gave up on trying
im just going to use my trusty txt files
sql
posted in
Off Topic
i found a nice vct dataset
however it is like 30 different tables
and they decided to name NRG mega minors for some tourneys for some reason
SQL is quite fun tho
my current issue is that i have no acces to sql
im struggling to setup mariaDB and linking it to VSC
generally when i try to excess mariadb to create a user it throws me the error code 2002
yeah
i already looked it up and decided to spare myself the headache and just not use sql (for now)
i just looked up on arch wiki, and apparently the database directory isnt initialized on installation, this was on the arch wiki :
Install mariadb or mariadb-lts, and run the following command before starting the mariadb.service:
mariadb-install-db --user=mysql --basedir=/usr --datadir=/var/lib/mysql
its throwing me this error
chown: changing ownership of '/var/lib/mysql': Operation not permitted
Cannot change ownership of the database directories to the 'mysql'
user. Check that you have the necessary permissions and try again.
im just gonna use txt files as i know how they work...
Why not use a docker container with volume instead of setting it up manually?
the table thing?
i just create the table in db browser sqlite and drag the file to whatever i need
sqlite seems to be working,
thank you
i even can manage it in python which is much more my forte
Discord