SQLite 3.15 Adds Row Value Support
SQLite 3.15 Adds Row Value Support
Monday, 24 October 2016

SQLite 3.15 is now available with support for row values, support for deterministic SQL functions in the WHERE clause of a partial index and the ability to VACUUM an attached database.

SQLite is an embeddable SQL database library. It is arguably 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 developers say that you should think of SQLite:

"not as a replacement for Oracle but as a replacement for fopen()"

The other main advantage of SQLite is its compact size. With all features enabled, the library size can be less than 500KB.

The latest version, SQLite 3.15.0 is now available. The main change for the new version is support for row values. A row value is an ordered list of two or more scalar values, so is another way of defining a vector.

Examples of the things you might do with row values include scrolling window queries where you want to show a limited number of items in a scrolling display; searches on multi-column keys; or updating of multiple columns in a table based on a query. There's a good description of various different uses on the SQLite site. 

Another improvement in the new version is support for deterministic SQL functions in the WHERE clause of a partial index. SQL deterministic functions always gives the same answer when given the same inputs; non-deterministic functions include those that depend on previous actions such as LastRowID, or Changes. 

The new release also adds the ability to VACUUM an attached database. The VACUUM command rebuilds the database file, repacking it into a minimal amount of disk space.

sqlite

More Information

SQLite 3.15 Release Log

VSQLite Version 3.15.0

Related Articles

Portable Version Of DB Browser For SQLite

SQLite 3.9 

SQLite Updated

 

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

 

Banner


Programmers Xmas - Alexa Suggest Some Presents
02/12/2017

You can guess the answer.

This is the first of our features on presents suitable for programmers and for programmers to give. Yes it s commercial and if you buy any of our suggestions we get a small [ ... ]



Azure Updates Announced At MS Connect()
17/11/2017

Microsoft has announced a number of extras and improvements for Azure at its Connect() virtual event this week, including support for Databricks, Cassandra API, and Maria DB. Poor old Access and SQL S [ ... ]


More News

 

 
 

 

blog comments powered by Disqus

Last Updated ( Sunday, 23 October 2016 )
 
 

   
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.