SQLite Introduces Vacuum Into
Written by Kay Ewbank   
Tuesday, 12 February 2019

The team at SQLite has added a Vacuum Into command that lets you back up a database atomically so that the backup is as small as possible and contains no forensic traces of deleted content.

SQLite is an in-process library that implements a self-contained, serverless, transactional SQL database engine. The entire SQL database with multiple tables, indexes, triggers, and views, is contained in a single disk file. The developers say SQLite is the most used database engine in the world, as it is built into all mobile phones and most computers and is often used by other applications. 

sqliteSQLite already had a Vacuum command that rebuilds the database file, repacking it into a minimal amount of disk space. Using Vacuum with an Into clause means that the original database file is unchanged and a new database is created in the filename given by the argument to the Into clause. The new database will contain the same logical content as the original database, fully vacuumed. Vacuum Into provides an alternative to the backup API for generating backup copies of a live database. The advantage it offers is that the resulting backup database is as small as it can be.

The other improvements to this release, SQLite 3.27. are to the command-line interface, mostly to support testing and debugging; and to the Deserialize API. This has a new control for setting an upper bound on the size of the in-memory database it creates; and it now honors its own read-only flag, which until now was ignored. Elsewhere, there are general improvements to the robustness of SQLite when it is reading and writing maliciously corrupted database files.

The developers have also fixed a bug in the query optimizer that caused an adverse interaction between the OR optimization and the optimization that tries to use values read directly from an expression index instead of recomputing the expression. 

sqlite

More Information

SQLite Site

Related Articles

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

LiteCLI - SQLite Client with Autocomplete

  

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


Eclipse Renames Java EE Specifications to Jakarta EE
08/07/2019

One of the final stages of the move from Java EE to Jakarta EE has taken place as the Eclipse Foundation has renamed all the specifications of the Java EE standard to instead be part of Jakarta EE. Th [ ... ]



Chrome Cryptocode Generator Revealed
24/06/2019

A system that automatically generates optimized cryptography code is in use in Google Chrome. The details were revealed at the recent IEEE Symposium on Security and Privacy by MIT researchers.


More News

appC

 



 

Comments




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

Last Updated ( Tuesday, 12 February 2019 )