Aaron is anything but boring, he makes learning engaging and has given me more than one trick up my sleeve. I have been working with relational databases both professionally and for all my side projects and I've learned things about databases I didn't even know existed. Any course this man produces is an instant auto-buy because he makes it easy to do. You can tell he's put his heart and soul into this course and it'll stick with me longer than the current season of 'The House of the Dragon.' Wow is there any topic this guy can't make fun!Alex Maven
Build with and integrate SQLite into your production applications.
I've made my test data available for you to use and follow along.
Not having a boolean type is not a problem. You can just store it all as an integer. SQLite understands select true, that's gonna give us 1, and select false, that's gonna give us 0. So we can say, create table example and we can put boolean as an integer. And if we were to insert into example values 1 and true and 0 and false, we should be okay.
Select * from example. There you go. It it will transform it into an integer and you can use those keywords if you want. Select * from example where bool equals true. Select * from example where bool equals 1.
Totally fine. Not a big deal. If you need to store boolean values just declare it as an integer column, then use ones or zeros or true or false. Either way, you're gonna be fine.