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

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

Dudhi [#2]

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

Foxym [#3]

my current issue is that i have no acces to sql
im struggling to setup mariaDB and linking it to VSC

whats the problem with linking on vscode, i can maybe help you

Lordsalih [#4]

whats the problem with linking on vscode, i can maybe help you

generally when i try to excess mariadb to create a user it throws me the error code 2002

Foxym [#5]

generally when i try to excess mariadb to create a user it throws me the error code 2002

cant connect to local server ?

Lordsalih [#6]

cant connect to local server ?

yeah
i already looked it up and decided to spare myself the headache and just not use sql (for now)

Why not use a docker container with volume instead of setting it up manually?

Foxym [#7]

yeah
i already looked it up and decided to spare myself the headache and just not use sql (for now)

u on linux or windows ?

AvgRossiFan [#8]

Why not use a docker container with volume instead of setting it up manually?

tbh i havent heard about that yet
might give it a try

Lordsalih [#9]

u on linux or windows ?

Linux primarily
CachyOs (Arch Infrastructure)

Foxym [#11]

Linux primarily
CachyOs (Arch Infrastructure)

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

the table thing?
i just create the table in db browser sqlite and drag the file to whatever i need

Lordsalih [#12]

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...

Foxym [#14]

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...

ig just try with sudo before

fungame024 [#13]

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

Foxym [#16]

sqlite seems to be working,
thank you

i even can manage it in python which is much more my forte

yeah its pretty easy, alg bro