We can use SQLite’s DATE() function to return the first Monday of each month for a given year, based on the date we provide.
But it’s not limited to Monday. We can also get the first Tuesday, Wednesday, Thursday, Friday, etc of each month.
Continue readingSQLite provides several functions for inserting, setting, and replacing values in a JSON document. Specifically, it provides json_insert(), json_set(), and json_replace().
These functions perform similar tasks, and you can sometimes use them interchangeably to a certain point.
But there is definitely a clear difference between each function.
Continue readingWe can use SQLite’s DATE() function to perform calculations on a given date. One of the things we can do is return the first, second, third, or fourth instance of a given day within a given month.
The following SQLite example returns all rows that contain at least one numerical digit.
Continue readingWhen using SQLite, we can use the following methods to extract data from a JSON document.
Continue readingIn SQLite, we can use the DATE() function to subtract one or more days from a date.
For datetime values, we can use the DATETIME() function.
In SQLite, we can use the DATE() function to add one or more months to a date.
When we’re dealing with datetime values, we can use the DATETIME() function.
Below are six examples that delete duplicate rows from a table in SQLite when those rows have a primary key or unique identifier column.
In these instances, the primary key must be ignored when comparing duplicates (due to the fact that primary keys prevent duplicate rows by definition).
Continue readingWhen using one of SQLite’s tabular output modes, you can enable the --wrap option in order to limit the width of each column. This can be handy when the data contains long lines of text.
When we do this, we have the option of specifying “word wrap”, so that words don’t get cut off halfway through.
There are two ways to specify word wrap: use --wordwrap on or its shortcut -ww.
The -> and ->> operators were introduced in SQLite version 3.38.0, which was released on 22 February 2022. Both operators are used for extracting subcomponents of JSON. But there’s a subtle difference between them.