<story><title>SQLite 3.45 released with JSONB support</title><url>https://www.sqlite.org/changes.html#version_3_45_0</url></story><parent_chain></parent_chain><comment><author>simonw</author><text>If anyone wants to try this out on macOS here&amp;#x27;s the fastest way I&amp;#x27;ve found to try a new SQLite version there: &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;til.simonwillison.net&amp;#x2F;sqlite&amp;#x2F;sqlite-version-macos-python&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;til.simonwillison.net&amp;#x2F;sqlite&amp;#x2F;sqlite-version-macos-py...&lt;/a&gt;&lt;p&gt;Short version:&lt;p&gt;&lt;pre&gt;&lt;code&gt;    cd &amp;#x2F;tmp
    wget &amp;#x27;https:&amp;#x2F;&amp;#x2F;www.sqlite.org&amp;#x2F;2024&amp;#x2F;sqlite-amalgamation-3450000.zip&amp;#x27;
    unzip sqlite-amalgamation-3450000.zip
    cd sqlite-amalgamation-3450000
    gcc -dynamiclib sqlite3.c -o libsqlite3.0.dylib -lm -lpthread
    DYLD_LIBRARY_PATH=$PWD python3 -c &amp;quot;import sqlite3; print(sqlite3.sqlite_version)&amp;quot;
&lt;/code&gt;&lt;/pre&gt;
That prints &amp;quot;3.45.0&amp;quot; for me.&lt;p&gt;If you have &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;datasette.io&amp;#x2F;&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;datasette.io&amp;#x2F;&lt;/a&gt; installed you can then get a web UI for trying it out by running:&lt;p&gt;&lt;pre&gt;&lt;code&gt;    DYLD_LIBRARY_PATH=$PWD datasette&lt;/code&gt;&lt;/pre&gt;</text></comment>
<story><title>SQLite 3.45 released with JSONB support</title><url>https://www.sqlite.org/changes.html#version_3_45_0</url></story><parent_chain></parent_chain><comment><author>jitl</author><text>From the original forum post [0] announcing this improvement:&lt;p&gt;&amp;gt; But if you modify your application to start storing JSONB instead of text JSON, you might see a 3-times performance improvement, at least for the JSON-intensive operations. JSONB is also slightly smaller than text JSON in most cases (about 5% or 10% smaller) so you might also see a modest reduction in your database size if you use a lot of JSON.&lt;p&gt;I for one am excited about these improvements (specifically the disk use reduction) since we store a lot of JSON here at Notion Labs, and we’re increasing our use of SQLite.&lt;p&gt;[0]: &lt;a href=&quot;https:&amp;#x2F;&amp;#x2F;sqlite.org&amp;#x2F;forum&amp;#x2F;forumpost&amp;#x2F;fa6f64e3dc1a5d97&quot; rel=&quot;nofollow&quot;&gt;https:&amp;#x2F;&amp;#x2F;sqlite.org&amp;#x2F;forum&amp;#x2F;forumpost&amp;#x2F;fa6f64e3dc1a5d97&lt;/a&gt;</text></comment>