SQLite 3.33 Increases Maximum Database Size
Written by Kay Ewbank   
Monday, 17 August 2020

SQLite has been updated, taking the maximum supported database size to 281TB, and adding support for UPDATE FROM. The new version also improves the integrity check verification.

SQLite is the most widely deployed database in the world, and is compact, with a library size of under 600KB with all features enabled. It is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. In addition, the developers describe it as a language-agnostic development environment, with high-quality language kernels for languages including Python, C++, R and Julia.

sqliteThe new support for the UPDATE FROM clause in version 3.33 follows the PostgreSQL syntax. UPDATE FROM enables one table to be updated from a second table, but it isn't part of the SQL Standards, and difference products implement it slightly differently. The SQLite implementation has been written to be compatible with the way PostgreSQL interprets it, rather than the versions implemented in Microsoft SQL Server and MySQL.

Another improvement is an extension of the PRAGMA integrity_check statement so you can choose to limit it to verifying just a single table and its indexes, rather than the entire database file, making the operation faster and more flexible.

Decimal arithmetic is another area to have been targeted for improvement in this release, with the addition of a decimal extension for use in arbitrary-precision decimal arithmetic on numbers stored as text strings.  Functions for addition, subtraction and multiplication have been added - there's no division function yet.

The Query planner has been improved, so it's now possible to find a full index scan query plan for queries using INDEXED BY which previously would fail with "no query solution".

The planner also has better handling of missing, incomplete, or suspect sqlite_stat1 data and generates good query plans in spite of the misinformation. Finally, the performance has been improved of queries that find a minimum value in a table using a WHERE .... IN clause, so long as they have an appropriate index. 

sqlite

More Information

SQLite Site

Related Articles

SQLite Improves Nulls Support

SQLite 3.27 Introduces Vacuum Into

SQLite Adds Zipfile Support

SQLite 3.20 Improves Query Planner

SQLite 3.17 Adds SHA1 Extensions 

SQLite 3.16 Adds Pragma Functions  

SQLite 3.15 Adds Row Value Support

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, Facebook or Linkedin.

Banner


PyTorch Adds New APIs
10/11/2020

PyTorch has been updated with several new APIs including support for NumPy-Compatible FFT operations, profiling tools and major updates to both distributed data parallel (DDP) and remote procedure cal [ ... ]



The State of Computer Science Education 2020
18/11/2020

The majority of US schools still do not teach Computer Science, despite the concerted efforts of Code.org Advocacy Coalition. On the other hand, a lot of progress has been made and the number of  [ ... ]


More News

square

 



 

Comments




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

Last Updated ( Monday, 17 August 2020 )