SQLite for MAC

v 3.35.5
Category  Developer Tools

About SQLite For MAC

SQLite a library that implements a self contained, serverless, zero configuration, transactional SQL database engine.

The code for SQLite is available in the public domain. It is therefore free to use for commercial and private purposes. SQLite can be found in many applications, including some high-profile ones. SQLite is an embedded SQL engine. SQLite is an embedded SQL database engine that does not require a separate server process, unlike other SQL databases. SQLite can read and write to any disk file. A single disk file contains a complete SQL database that includes multiple tables, triggers, triggers, views, and indices.

The database file format can be copied between 32-bit and 64 bit systems. These features make SQLite an attractive choice for Application File Format. SQLite is not meant to replace Oracle, but rather fopen(). If you require a GUI for database management you can install NAVICAT. SQLite is a small library. The library size can be reduced to less than 300KiB if all features are enabled. This depends on the compiler optimization settings. (Some compiler optimizations, such as loop unrolling and aggressive function inlining, can cause the object code size to be larger. The size of the SQLite database can be reduced to 180KiB if you don't use optional features.

SQLite can be run with very little heap (4KiB) or stack space (4KiB), making it a popular choice for memory constrained gadgets like cellphones, PDAs, MP3 players, and MP3 players. There is a tradeoff in memory usage and speed. SQLite runs faster if you give it more memory. However, performance is still good even in low-memory environments.

Download SQLite For MAC

Whats New

Version 3.35.5:

  • Fix defects in the new ALTER TABLE DROP COLUMN feature that could corrupt the database file
  • Fix an obscure query optimizer problem that might cause an incorrect query result