read: 106
This data as json
| rowid | url | title | description | image | date | hnurl | screenshot | domain | |
|---|---|---|---|---|---|---|---|---|---|
| 106 | https://www.geekytidbits.com/date-range-table-sqlite/ | Generating Date Ranges in SQLite | Geeky Tidbits | SQLite supports <a href="https://www.sqlite.org/lang_with.html#x1140">Recursive Common Table Expressions</a> which is very handy sometimes. Although you have to keep an eye on performance, they can help you accomplish something that would otherwise be non-trival. Something like generating a range of dates or months, as I recently had to do. | 2022-10-09T06:46:55.42432143Z | www.geekytidbits.com |