SQLite 3.25 Released With Window Functions, Optimizations & Geopoly Module

Written by Michael Larabel in Free Software on 16 September 2018 at 09:44 AM EDT. 1 Comment
FREE SOFTWARE
SQLite 3.25 was released this weekend as the newest feature update to this embed-friendly SQL database library.

The big feature to SQLite 3.25 is support for window functions inspired by PostgreSQL where input values are taken from a "window" of 1+ rows in the results set of a SELECT query. SQLite window functions should be compatible with similar PostgreSQL queries and described well in the documentation.

SQLite 3.25 also has support for renaming columns using the ALTER TABLE command, various query optimizer improvements, better concurrency in multi-threaded environments by using a separate mutex on every inode within the Unix VFS, enhanced PRAGMA integrity_check, and more.

SQLite 3.25 also introduces a Geopoly module as an alternative interface to its R-Tree extension and using GeoJSON notation. That is described here.

More details on SQLite 3.25 via SQLite.org.
Related News
About The Author
Michael Larabel

Michael Larabel is the principal author of Phoronix.com and founded the site in 2004 with a focus on enriching the Linux hardware experience. Michael has written more than 20,000 articles covering the state of Linux hardware support, Linux performance, graphics drivers, and other topics. Michael is also the lead developer of the Phoronix Test Suite, Phoromatic, and OpenBenchmarking.org automated benchmarking software. He can be followed via Twitter, LinkedIn, or contacted via MichaelLarabel.com.

Popular News This Week