2 ms·
> There have been a lot of new features over the new years, the latest being window functions. Window functions were added in 3.25, 4 years ago. Since then sq
by masklinn 4y ago
> There have been a lot of new features over the new years, the latest being window functions.
Window functions were added in 3.25, 4 years ago.
Since then sqlite added a bunch of stuff like RETURNING clauses, upserts, json operators (and enabled json functions by default though they’d been there a while), update from, generated columns, …