SQLite Databases Tutorial In Discord.js (JS & SQL 2020)

[metal-rain]

Some people had problems with their tables not being created.
IF you used the program to create the database, delete it. Then use DB Browser to create a blank database (named what you want) and then the program should make the tables just fine. Thanks for the support!


Lastly check description for the written tutorial I made!

[cameonn]

GOD finally a tutorial that uses RAW SQL any other tutorial uses ORM and i really wanted one just use SQL.

[Yoroiful]

Thank you, you didn't really go too much into depth but you said enough for me to figure out how to adjust things. This is a very newbie-friendly tutorial.

[makskolis]

you deserve them :)

[_blazing_eagle_]

yeah, not telling too much but It is true. This is the only video I understood

[crmcdonald]

please show how to get data out of the sqlite query

[vannssaa]

I got a question. I'm creating a bot and my best friend wants me to create an embed that shows how many male players are on a Server. He set up everything in the database so the only thing I have to do is create an embed (I did my database connection with 'npm mysql). So I created the embed and everything is ready besides my 'value Field' this is empty because there should the male players go from the database. (Btw. they often change that's what the database is for). The Bot can only read the information in the database and can't change anything. I tried to find any video about that but I can't find anything because everyone is just setting up the database. Could you help me with my problem or anyone else?

[maxh]

Question, how do I add to a score? This is what I tried but did not work
db.run(`UPDATE userstats SET warns = ? WHERE userid = ?`, [+1, userid])

[interyon]

idk what it is, but i keep getting error 14 that i can't open the database file?

[GaLzZy.]

How would you globalize the db variable so you create it once and you can use it everywhere in your bot? Is it possible ? Thanks

[advizedog]

The database isn’t doing anything for some reason, it just stays blank.

[knightt]

How does one install SQLite there r too many vids that say how to do it differently
help pls ill give u a cookie

[pewolo]

Sqlite3 installation seems to be deprecated currently for npm

[leobi]

SQLITE_ERROR: no such column: word


can please someone help me? thanks!

[dchills]

Why is every video outdatet i want better sqlite videos not outdated one xD

[fukspura]

I swear i have the same code as you but the table does not get created. The programs runs fine, the database file gets created. Only thing missing is the table.