SQLite 3.9
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


AlphaGo The Movie - Who Is The Hero?
15/10/2017

A movie about a program that beats a human at a game? Probably not what you might expect, but AlphaGo is a movie about man versus machine and in this case the machine wins.



Stack Overflow Considered Harmful?
11/10/2017

What proportion of Android apps in the Play store include security-related code snippets copied directly from Stack Overflow? Does the copied code increase or decrease application security?


More News

 

 
 

 

blog comments powered by Disqus

Last Updated ( Thursday, 22 October 2015 )
 
 

   
Banner
Banner
RSS feed of news items only
I Programmer News
Copyright © 2017 i-programmer.info. All Rights Reserved.
Joomla! is Free Software released under the GNU/GPL License.