SQLite 3.7.0

Operating systemsOS : Windows / Linux / Mac OS / BSD / Solaris
Program licensingScript Licensing : Other Free / Open Source License - Public Domain
CreatedCreated : Jul 25, 2010
Size downloadDownloads : 3
Program licensing
Thank you for voting...

The SQLite distribution comes with a standalone ...

The sqlite by D. Richard Hipp distribution comes with a standalone command-line access program (sqlite by D. Richard Hipp) that can be used to administer an sqlite by D. Richard Hipp database and which serves as an example of how to use the sqlite by D. Richard Hipp library.
Currently, sql 3.7.0 is one of the most used sql flat-file database engines in the world.
SQLite [sqlite3.7.0.exe] is recommended for usage as a website database, stand-in enterprise RDBMS, application file format or a database for gadgets.
Most important functions of SQLite - 0MB:
• Cross-platform: Unix (Linux and Mac OS X), OS/2, and Windows (Win32 and WinCE) are supported out of the box. Easy to port to other systems.
• Sources are in the public domain. Use for any purpose.
• Comes with a standalone command-line interface (CLI) client that can be used to administer SQLite 3.7.0 databases.
• Transactions are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
• Zero-configuration no setup or administration needed.
• Implements most of SQL92. (Features not supported)
• A complete database is stored in a single disk file.
• Database files can be freely shared between machines with different byte orders.
• Supports databases up to 2 tebibytes (241 bytes) in size.
• Strings and BLOBs up to 2 gibibytes (231 bytes) in size.
• Small code footprint: less than 250KB fully configured or less than 150KiB with optional features omitted.
• Faster than popular client/server database_engine for most common operations.
• Simple, easy to use API.
• TCL bindings included. Bindings for many other languages available separately.
• Well-commented source code with over 98% test coverage.
• Available as a single ANSI-C source-code file that you can easily drop into another project.
• Self-contained: no external dependencies.
News in the current SQLite version:
• Added support for write-ahead logging.
• Query planner enhancement - automatic transient indices are created when doing so reduces the estimated query time.
• Query planner enhancement - the ORDER BY becomes a no-op if the query also contains a GROUP BY clause that forces the correct output order.
• Add the SQLITE_DBSTATUS_CACHE_USED verb for sqlite3_db_status().
• The logical database size is now stored in the database header so that bytes can be appended to the end of the database file without corrupting it and so that SQLite will work correctly on systems that lack support for ftruncate().

SQLite 3.7.0 scripting tags: sql, data storage, sqlite, engine, database engine, file, sql database. What is new in SQLite 3.7.0 software script? - Unable to find SQLite 3.7.0 news. What is improvements are expecting? Newly-made SQLite 3.8 will be downloaded from here. You may download directly. Please write the reviews of the SQLite. License limitations are unspecified.