One thing I do know is your videos are top quality. Personally, I learned 100x more from your videos than I have from previous courses on Udemy or Pluralsight, and I will always advocate for devs to take your courses.Lawrence
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.