1 00:00:00,210 --> 00:00:03,220 We've only scratched the surface of SQLite, but 2 00:00:03,220 --> 00:00:06,842 you should be in a good place to start using it in your projects. 3 00:00:06,842 --> 00:00:11,460 Before I sign off, let me show you the querying API in the documentation. 4 00:00:11,460 --> 00:00:16,210 The findAll method and the findById model methods can take in options. 5 00:00:16,210 --> 00:00:20,280 Remember, like the findAll method where we ordered by the createdAt column. 6 00:00:24,205 --> 00:00:28,902 If you go to the querying page, there's lots of examples of Sequelize code and 7 00:00:28,902 --> 00:00:30,550 the SQL code it generates. 8 00:00:39,380 --> 00:00:48,029 Here is a where clause that looks for 9 00:00:48,029 --> 00:00:54,380 author IDs that equal 2. 10 00:01:03,925 --> 00:01:08,073 Further down here, there's combinations of conditions using the or 11 00:01:08,073 --> 00:01:11,600 operator and operators other than the equality operator. 12 00:01:20,295 --> 00:01:25,971 You can also offset and limit, 13 00:01:25,971 --> 00:01:32,090 as shown in these examples here. 14 00:01:33,700 --> 00:01:35,830 And that's all we have time for. 15 00:01:35,830 --> 00:01:40,460 Remember, you're not required to memorize every ORM or library or framework. 16 00:01:40,460 --> 00:01:43,900 The documentation is there to help you, so use it. 17 00:01:43,900 --> 00:01:48,130 If you want to extend this project, why not add comments and authentication? 18 00:01:48,130 --> 00:01:51,780 You don't want any old user coming to your site and causing havoc. 19 00:01:51,780 --> 00:01:53,020 Take care. And I'll see you soon.