SQLite

SQLite Description

SQLite is an open source, free and small C library that implements a self-contained, embeddable and zero-configuration SQL database engine.The SQLite distribution comes with a standalone command-line access program (sqlite) that can be used to administer an SQLite database and which serves as an example of how to use the SQLite library.Among its features, we can mention that transactions are atomic, isolated, durable and consistent, implements most of SQL92, database files can be freely shared between computers, supports databases up to 2 terabytes, small code footprint, as well as an easy to use API. What's New in This Release: [ read full changelog ]Version 3.8.2 adds support for WITHOUT ROWID tables. This is a significant extension to SQLite. Database files that contain WITHOUT ROWID tables are not readable or writable by prior versions of SQLite, however databases that do not use WITHOUT ROWID tables are fully backwards and forwards compatible.The 3.8.2 release contains a potentially incompatible change. In all prior versions of SQLite, a cast from a very large positive floating point number into an integer resulted in the most negative integer. In other words, CAST(+99.9e99 to INT) would yield -9223372036854775808. This behavior came about because it is what x86/x64 hardware does for the equivalent cast in the C language. But the behavior is bizarre. And so it has been changed effective with this release so that a cast from a floating point number into an integer returns the integer between the floating point value and zero that is closest to the floating point value. Hence, CAST(+99.9e99 to INT) now returns +92233720368547... �.You can free download SQLite from Softpedia now.