8 posts tagged with "sqlite-for-beginners"

Did you know that you can store and manipulate JSON in SQLite?

Watch this video to learn more about how and when to use JSON in SQLite.

SQLite doesn't have as many features as the other popular databases, but don't let that scare you away from using SQLite, because even though there aren't as many built-in features, there are excellent ways of extending SQLite to add any missing features you might need.

Want to learn more about extending SQLite? Check out this video.

If you want to level up your database skills, the area you should probably focus on first is Indexes.

So, are you familiar with the various types of indexes you can create?

Check out this video to learn more.

SQLite doesn't automatically free up disk space as it becomes available. In other words, if your database is 1 GB in size and you delete some or all of the data, in the database, the final size of the database will still be 1 GB.

So how do you free up unused space in SQLite?

You need to vacuum your database.

So, how do you vacuum your database?

Watch this video to learn more.

SQLite has an extension called FTS5, which provides full-text search capabilities to your SQLite database.

So, how do you use the full-text search features in SQLite?

Watch this short video to learn more.

Did you know that SQLite offers profiling tools to help you identify the cause of slow queries? There's even a tool that suggests indexes you should add to improve a query's performance.

Watch this video to learn more.

Datatypes in SQLite are handled differently than pretty much every other popular relational database.

How is it different?

Well, SQLite uses a flexible, dynamic type system, whereas the other popular relational databases use a strict, static type system.

What does this mean to developers?

Watch this video to learn more.

SQLite is really easy to start using, you just need to add the library to your project and start issuing SQL statements.

Now, because it's so easy to start using SQLite, it might feel like it's configuration free, but that's not exactly true.

There are a few key configurations you should be familiar with, and in this video we'll look at one of the most important configuration options, the journal_mode option.