(1)
Your rating: Now say why...
- Download Now
326 KB -
Visit Developer's Site
SQLite
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is currently found in more applications than we can count, including several high-profile projects.
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process.
SQLite reads and writes directly to ordinary disk files. A complete SQL database with
The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is currently found in more applications than we can count, including several high-profile projects.
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process.
SQLite reads and writes directly to ordinary disk files. A complete SQL database with
What's New
Version 3.7.12:
- Add the SQLITE_DBSTATUS_CACHE_WRITE option for sqlite3_db_status().
- Optimize the typeof() and length() SQL functions so that they avoid unnecessary reading of database content from disk.
- Add the FTS4 "merge" command, the FTS4 "automerge" command, and the FTS4 "integrity-check" command.
- Report the name of specific CHECK constraints that fail.
- In the command-line shell, use popen() instead of fopen() if the first character of the argument to the ".output" command is "|".
- Make use of OVERLAPPED in the windows VFS to avoid some system calls and thereby obtain a performance improvement.
- More aggressive optimization of the AND operator when one side or the other is always false.
- Improved performance of queries with many OR-connected terms in the WHERE clause that can all be indexed.
- Add the SQLITE_RTREE_INT_ONLY compile-time option to force the R*Tree Extension Module to use integer instead of floating point values for both storage and computation.
- Enhance the PRAGMA integrity_check command to use much less memory when processing multi-gigabyte databases.
- New interfaces added to the test_quota.c add-on module.
- Added the ".trace" dot-command to the command-line shell.
- Allow virtual table constructors to be invoked recursively.
- Improved optimization of ORDER BY clauses on compound queries.
- Improved optimization of aggregate subqueries contained within an aggregate query.
- Bug fix: Fix the RELEASE command so that it does not cancel pending queries. This repairs a problem introduced in 3.7.11.
- Bug fix: Do not discard the DISTINCT as superfluous unless a subset of the result set is subject to a UNIQUE constraint and it none of the columns in that subset can be NULL. Ticket 385a5b56b9.
- Bug fix: Do not optimize away an ORDER BY clause that has the same terms as a UNIQUE index unless those terms are also NOT NULL. Ticket 2a5629202f.
- SQLITE_SOURCE_ID: "2012-05-14 01:41:23 8654aa9540fe9fd210899d83d17f3f407096c004"
- SHA1 for sqlite3.c: 57e2104a0f7b3f528e7f6b7a8e553e2357ccd2e1
Version 3.7.12:
- Add the SQLITE_DBSTATUS_CACHE_WRITE option for sqlite3_db_status().
- Optimize the typeof() and length() SQL functions so that they avoid unnecessary reading of database content from disk.
- Add the FTS4 "merge" command, the FTS4 "automerge" command, and the FTS4 "integrity-check" command.
- Report the name of specific CHECK constraints that fail.
- In the more...
Requirements
PPC / Intel, Mac OS X 10.4 or later
PPC / Intel, Mac OS X 10.4 or later
SQLite User Discussion (Write a Review)
Overall:
(1)
(1)
| Downloads:8,344 |
| Version Downloads:717 |
| Type:Development : Libraries |
| License:Free |
| Date:14 May 2012 |
| Platform:PPC / Intel |
| Price:Free |
Overall (Version 3.x):  |
Features: |
| Ease of Use: |
| Value: |
| Stability: |
-
-
-
SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.
The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is currently found in more applications than we can count, including several high-profile projects.
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process.
SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures.
These features make SQLite a popular choice as an Application File Format.
Think of SQLite not as a replacement for Oracle but as a replacement for fopen() If you need a GUI for database management, you can install NAVICAT.
SQLite is a compact library. With all features enabled, the library size can be less than 300KiB, depending on compiler optimization settings. (Some compiler optimizations such as aggressive function inlining and loop unrolling can cause the object code to be much larger.)
If optional features are omitted, the size of the SQLite library can be reduced below 180KiB.
SQLite can also be made to run in minimal stack space (4KiB) and very little heap (100KiB), making SQLite a popular database engine choice on memory constrained gadgets such as cellphones, PDAs, and MP3 players.
There is a tradeoff between memory usage and speed. SQLite generally runs faster the more memory you give it. Nevertheless, performance is usually quite good even in low-memory environments.
The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is currently found in more applications than we can count, including several high-profile projects.
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process.
SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file.
The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures.
These features make SQLite a popular choice as an Application File Format.
Think of SQLite not as a replacement for Oracle but as a replacement for fopen() If you need a GUI for database management, you can install NAVICAT.
SQLite is a compact library. With all features enabled, the library size can be less than 300KiB, depending on compiler optimization settings. (Some compiler optimizations such as aggressive function inlining and loop unrolling can cause the object code to be much larger.)
If optional features are omitted, the size of the SQLite library can be reduced below 180KiB.
SQLite can also be made to run in minimal stack space (4KiB) and very little heap (100KiB), making SQLite a popular database engine choice on memory constrained gadgets such as cellphones, PDAs, and MP3 players.
There is a tradeoff between memory usage and speed. SQLite generally runs faster the more memory you give it. Nevertheless, performance is usually quite good even in low-memory environments.
Copyright © 2012 MacUpdate LLC
- -
+544
-1
Anonymous reviewed on 09 Mar 2004
+1
The reason I posted this is that the standard "make; make test; make install" doesn't do what most people want on Mac OS X.
If you don't trust that it's unmodified, you can download the SQLite and readline source archives and build them for yourself. I don't see any point in including them on the .dmg file, though, since if you really doubt that this is the real SQLite, you wouldn't trust that I included the real source, either.
-1
-1
+2
+3
+1
+15
+15
Hodagacz rated on 20 May 2011