Integrating SQLite Into Godot 4.2! Advanced Godot!

Subscribe and learn more from me about Game Development and Programming!

In this video, we discuss how to integrate SQLite with Godot 4.x! We cover the steps to get database integration working, including setting up SQLite, creating and managing databases, executing SQL queries, and utilizing SQLite for storing game data such as player progress, settings, and high scores.

RESOURCES

BE MY FRIEND:

TIMESTAMPS
00:00 – Start
00:48 – Discussing the Plugin
03:12 – Initalizing the Plugin
03:41 – Creating the Databse
04:31 – Setting Up Our Buttons for Interactions
07:37 – How To Create a Table
09:12 – Inserting Data Into Our DB
09:52 – Seeing the Contents of Our Database With DB Browser for SQLite
11:41 – Inserting Data Into Our Database
14:14 – How Do We Select Our Data?
17:12 – How To Update Your Database Rows
19:56 – How To Delete From the Database
20:59 – Using Custom Queries
27:26 – Teaching About the Most Common Mistake People Make in SQLite
28:38 – How To Store Photos in Your Database
32:35 – Loading an Image From the Database
35:03 – Outro and Recap

MUSIC
Music provided by TheRelaxedMovement.

HASHTAGS:
#SQLite #Godot4.2 #gamedev

ABOUT MY CHANNEL:
I've been a software developer for over 7 years. I've worked in the game industry for 3 of those years. This channel is used for news on the gaming\programming industry and for tutorials for game\programming development.

Integrating SQLite Into Godot 4.2! Advanced Godot!

[dueddel]

I somehow didn't expect an SQLite integration being that easy! Awesome.

As a web developer for a living an actual database is definitely an alternative to using resources in Godot (which I somehow prefer over JSON files). Thank you for your efforts of creating such more in-depth videos (unlike others who explain how to add a node to the scene tree and nothing else which doesn't help anyone at all).

[Xero_Wolf]

THANK YOU! I can't believe it took me so long to integrate SQL databases into my workflow. It's so simple it feels like I was a caveman just mucking about in the dirt before. lol

[adenashiscave]

This is fantastic! I've been wishing I could use a database in Godot, and this is exactly what I wanted. Great video!

[astrahcat]

Yes of course want a database tutorial, trying to learn it for resume

[owenlloyd]

Thank you for this. Edit: SQLite in user:/ seems the way to go, handling data for more complex and/or larger projects, eg quest systems, own dialogues, achievements and etc.

[dwiss]

This was a life saver for my current project. I was banging my head in dealing with loads of people in a world that i dont need to actively show but handle nonetheless and keep persistent over sessions. This just solved all my issues!

[statixvfx]

+1 for a crazy database tutorial! Fantastic work!

[njdarda]

incredible, comprehensive tutorial. exactly what i was looking for.

[BrnLng]

Very nice to know! Seems to be a good way to handle complexity better.

[acoalexdev]

I would like to ask for some guidance on how to make this database accessible from different devices. My ideal scenario would be to have a mobile app where the database is online and every app can insert/remove data. I apologize if this is a basic question, but I am new to this topic. Thank you for the awsome video and your help.

[_devcat]

thank you so much for this tutorial everything is perfect and working just like what you uploaded 2yrs ago is really helpful for someone who used to be in making queries sql

[KenReed-zx]

Once you realize your multiplayer RPG can only handle so many networked objects (players and mobs) so now you use real world solution by using docker so you can spin up instances of your map and they all need to connect to the same database without overloading your database connection so you have to use cockroachdb so you can have multiple instances of the database. Disclaimer: Not all games are the same.

[ArkhKGB]

Sorry if you've done it in other videos but I think you should mention parameterized queries (you don't want to get a Bobby table incident) and transactions. For example if you make a crafting system it would be better to wrap the loss of materials and inserting new item inside a transaction so you don't get a way to duplicate things if the player crashes the game at the right moment.

[izk]

Thank you, this is a great video and is helping me with a school project!

[dumpworth]

Thanks for the tutorial. This will be very helpful!

[robertbutchko]

I have no idea how you made SQL seem approachable but thank you so much! Forgive me if this is a dumb question, but would it be straightforward to make the database an online database so different players could share it at once?

[Amipotsophspond]

when would you want to use a SQLight data base vs some other storage? is it faster for X data, smaller for Y data, easier to use with Z data, able to handle huge amounts of A data, really easy to store B data remotely, really useful with C data, perhaps D data can be encrypted in a easy way, E data has low overhead storage, or something else with F data. I guess you address my question at 24:13 data normalization, I would like to know more about selecting the best storage from available options. if you do make the data base video perhaps you could have a section on it, but don't go out of your way too much.

[kronos]

for any wondering, i just tested. you can just build your database in the db browser, no need to construct it in godot (assuming doing something like an item db, that doesn't need to be written during play)

[HuangShengHong]

Are the args in select_row(), update_row(), insert_row() sanitized and using prepared statement to avoid sql injections? I didn't see it mentioned in the document.

[proatgaimz]

awesome plugin, although i would not use the wrapper functions that takes in dicts, sql is easy to learn and i think i prefer the control of forming my of queries.