This course is great. Not only is it an insightful deep dive on performant SQLite, but it also helps one understand a lot about modern databases in general.Steven Fox
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.