SQLite
SQLite 3.8.4.3
Your rating: Now say why...

(2) 4.75

SQL database connection development library.   Free
Add to my Watch List
Email me when discounted
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
What's New
Version 3.8.4.3:
  • Add a one-character fix for a problem that might cause incorrect query results on a query that mixes DISTINCT, GROUP BY in a subquery, and ORDER BY. Ticket 98825a79ce14.
  • SQLITE_SOURCE_ID: "2014-04-03 16:53:12 a611fa96c4a848614efe899130359c9f6fb889c3"
  • SHA1 for sqlite3.c: 310a1faeb9332a3cd8d1f53b4a2e055abf537bdc
Requirements
Intel, OS X 10.4 or later






SQLite User Discussion (Write a Review)
ver. 3.x:
(2)
Your rating: Now say why...
Overall:
(2)

sort: smiles | time
burypromote

+852
Negritude commented on 21 Sep 2011
FYI, this listing now points to the official source at sqlite.org, and no longer has anything to do with Michael Tsai.
[Version 3.7.8]


burypromote
-1


Anonymous reviewed on 09 Mar 2004
This is *not* an official version and thus shouldn't be taking the SQLite name. The author further doesn't provide their project so we can check that the build is unmodified. Use at your own risk.
[Version 2.8.13]

8 Replies

burypromote
+1
Anonymous commented on 09 Mar 2004
Yes, this is an unofficial version, just as the MySQL builds on MacUpdate and VersionTracker are unofficial, and have been for years.

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.
burypromote
-1
Anonymous commented on 10 Mar 2004
I think it's more about your willingness to supply the build project you used. As it stands, there is no way to audit that the binary downloaded is a clean SQLite build. You should either release your build project as a sign of good faith or change the name of your release so that it doesn't confuse people with the actual SQLite.
burypromote
Anonymous commented on 10 Mar 2004
By "build project," do you mean the Makefile? I wouldn't mind adding that to the .dmg.
burypromote
-1
Anonymous commented on 11 Mar 2004
It means releasing *everything* necessary to make an identical copy of the binary files. If you truthfully haven't modified the SQLite source, you should be able to put up just the Xcode (or Project Builder) project files and tell them where to get and put the other source.
burypromote
+2
Anonymous commented on 11 Mar 2004
I'm using Make instead of Xcode or Project Builder, so there are no other files except the source archives.
burypromote
+3
Anonymous commented on 15 Dec 2004
Thank you for doing it Michael. It is beneficial to the Mac community and I appreciate it.
burypromote
+2
Anonymous commented on 10 Aug 2005
Note that as of 10.4, Mac OS X comes with sqlite3 in /usr/bin/sqlite3, and has the library for slite3 pre-installed also.
burypromote
+1

+16
Hodagacz replied on 20 May 2011
Thanks Michael, I like the convenience.
There are currently no troubleshooting comments. If you are experiencing a problem with this app, please post a comment.


+1

Archibald.c rated on 10 Dec 2013

[Version 3.8.2]



+16

Hodagacz rated on 20 May 2011

[Version 3.7.6.3]


Downloads:12,211
Version Downloads:169
Type:Development : Libraries
License:Free
Date:06 Apr 2014
Platform:Intel 32 / OS X
Price:Free0.00
Overall (Version 3.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-2 of 2
Displaying 1-2 of 2
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Install with MacUpdate Desktop.
Save time moving files & cleaning
up space wasting archives.
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.


- -