Building a Discord Bot in Python (2024) Episode Eight: Leveling System (Database)

Hey guys, today we use a SQL database to create ourselves a more professional and practical leveling system for our Discord bot. Subscribe!
MY DISCORD: / discord
MY GITHUB: github.com/Paradoxial8172
MY WEBSITE: houseofcode.xyz/index.html
DONATE: paypal.me/TamerBoi?country.x=...
Music Credits:
Song 1:
Lost In Thought by Ghostrifter bit.ly/ghostrifter-yt
Creative Commons - Attribution-NoDerivs 3.0 Unported - CC BY-ND 3.0
Free Download: hypeddit.com/pwwwco
Song 2:
Hot Coffee by Ghostrifter bit.ly/ghostrifter-yt
Creative Commons - Attribution-NoDerivs 3.0 Unported - CC BY-ND 3.0
Free Download: hypeddit.com/track/qhwjph
Song 3:
Morning Routine by Ghostrifter bit.ly/ghostrifter-yt
Creative Commons - Attribution-NoDerivs 3.0 Unported - CC BY-ND 3.0
Free Download: hypeddit.com/track/24bkbw
Song 4:
On My Way by Ghostrifter bit.ly/ghostrifter-yt
Creative Commons - Attribution-NoDerivs 3.0 Unported - CC BY-ND 3.0
Free Download: hypeddit.com/track/lvf9kk
Song 5:
Still Awake by Ghostrifter bit.ly/ghostrifter-yt
Creative Commons - Attribution-NoDerivs 3.0 Unported - CC BY-ND 3.0
Free Download: hypeddit.com/track/3vqwnk
Song 6:
Waiting by Ghostrifter bit.ly/ghostrifter-yt
Creative Commons - Attribution-NoDerivs 3.0 Unported - CC BY-ND 3.0
Free Download: hypeddit.com/track/nqdzhh
If a video is rather long, video sountracks may loop back to the very first song
Intro is made by somebody else on panzoid, only changed the music Tranquillity - ProdRiddiman)
Outro is made by me :)
Outro Music is "In A Cabin By The Lake" by Lazarus Moment!

[@unnamed-7353]

most useful tutorial ever

[@IDKPlaythroughs]

still on this series

[@exceldreal]

Please next show how to write a full working moderation system into the bot.

[@gamersgame43]

make a new one on how to activate slash commands with normal commands

[@anamzakir-gi3zc]

i love the video series!!! ive been watching you for a year now. i was just wondering is .json more efficient than .db for accessing data in terms of computer resources? also the same question but for changing data. thanks alot in advance!!

[@paradoxial7665]

Hi, thank you! I am glad you are enjoying my videos. To answer your question, using databases are actually much for efficient. But it all depends on the task at hand. To better explain this. Databases are better for large volumes of data such as for the context of this video, a leveling system. JSON files are good for smaller volumes of data. The problem with JSON is that the file must all be loaded into memory before it can be read. Meaning that if you are using JSON to store lots of data, more memory will need to be allocated to perform that task. So to answer your question, databases are far more efficient than JSON. But JSON is still a good way to store data depending on your project.

[@anamzakir-gi3zc]

@@paradoxial7665 thank you for responding!!! All the databases I use in .json are all super mega big, and the ram on the cloud gets used up loads, as it is accessed it veeery frequently, hence why I asked. It looks like I'm going to be changing these giant .json files to .db files lol. I'm seriously grateful to you and your content and I wish you a great life ❤❤

[@shivranj]

Hey, amazing tutorial !, I'm making a discord bot and I needed a function that runs and sends a message everyday automatically, and that message is to be taken from a list. How do i do this?

[@paradoxial7665]

Hello, join my discord server so we can further discuss this. Link to it is in the description