SQLite 3.9
Written by Kay Ewbank   
Thursday, 22 October 2015

The latest version of SQLite has been released with support for JSON and indexes on expressions.

sqlite

SQLLite is the world’s most widely used database, mainly due to its use as the database engine in memory constrained gadgets such as cellphones, PDAs, and MP3 players. It’s an in-process library that implements a self-contained, serverless, transactional SQL database engine. It doesn’t have a separate server process, and it reads and writes directly to ordinary files. The entire SQL database with multiple tables, indexes, triggers, and views, is contained in a single disk file.

The changes to the release start with the introduction of JSON SQL functions. The JSON support has been added as a loadable extension that implements eleven application-defined SQL functions and two table-valued functions that you can use to manage JSON content stored in a SQLite database. The functions deal with arrays and strings and let you validate, insert, delete and update values. The table-valued functions can be used to transform a JSON string into a virtual table, mapping the JSON elements to rows.

Version 5 of the full text search engine, FTS5, has also been added to this release. FTS5 is a SQLite virtual table module that provides full-text search features. It is an updated version of FTS4 that includes various fixes and solutions for problems that could not be fixed in FTS4 without sacrificing backwards compatibility. The main difference is that in FTS3/4, every instance-list is stored as a single large database record, whereas in FTS5 large instance-lists are divided between multiple database records. This means that is able to load instance-lists into memory incrementally to reduce memory usage and peak allocation size. This also means that if an instance-list grows so large that it exceeds the SQLITE_MAX_LENGTH limit, FTS3/4 is unable to handle it. FTS5 does not have this problem. The changes mean that complex queries may use less memory and run faster using FTS5.

Support for indexes on expressions is another addition to the new version, meaning you can create indexes on expressions referring to columns, in addition to the usual indexes on columns. Table-valued function support has also been added.  The full list of changes can be seen in the Release Log.

 

sqlite

More Information

SQLite

Release notes for SQLite 3.9

Download SQLite 

Related Articles

SQLite Updated

 

To be informed about new articles on I Programmer subscribe to the RSS feed, follow us on, Twitter, FacebookGoogle+ or Linkedin,  or sign up for our weekly newsletter.

 

Banner


JConference January 2024 Sessions Now Online
23/02/2024

The talks presented at the 4th JChampions Conference which took place between Jan 25 to Jan 30, are now available for free on YouTube. Topics ranged from Code and Tech to Career Advice.



Running PostgreSQL Inside Your Browser With PGLite
18/03/2024

Thanks to WebAssembly we can now enjoy PostgreSQL inside the browser so that we can build reactive, realtime, local-first apps directly on Postgres. PGLite is about to make this even easier.


More News

 

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Thursday, 22 October 2015 )