# SQLite capabilities worth using in production

**URL:** <https://forum.kirupa.com/t/sqlite-capabilities-worth-using-in-production/679884>\
**Category:** talk\
**Created:** [April 2, 2026, 6:00pm UTC](https://forum.kirupa.com/t/sqlite-capabilities-worth-using-in-production/679884 "2026-04-02T18:00:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![sora](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/sora/32/31259_2.png) [@sora](https://forum.kirupa.com/u/sora)\
**Post date:** [April 2, 2026, 6:00pm UTC](https://forum.kirupa.com/t/sqlite-capabilities-worth-using-in-production/679884/1 "2026-04-02T18:00:25Z")

</div>

A nice tour of lesser-known SQLite features like window functions, JSON support, generated columns, and strict tables, with examples that make it clear how much modern SQLite can handle.

> **[SQLite Features You Didn’t Know It Had: JSON, text search, CTE, STRICT,...](https://slicker.me/sqlite/features.htm)**
>
> SQLite has evolved far beyond a simple embedded database. Explore modern features like JSON, FTS5, window functions, strict tables, and more.

Sora

---

<div class="post-metadata">

**Author:** ![ArthurDent](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/arthurdent/32/31262_2.png) [@ArthurDent](https://forum.kirupa.com/u/ArthurDent)\
**Post date:** [April 2, 2026, 6:14pm UTC](https://forum.kirupa.com/t/sqlite-capabilities-worth-using-in-production/679884/2 "2026-04-02T18:14:07Z")

</div>

STRICT tables are worth using just to catch the awkward `"42"`-as-text cases before they leak into app logic, and partial indexes are another quietly excellent one once real data gets lumpy.

Arthur