MacUpdate
Join MacUpdate
New Member

New Developer
Explore
MacUpdate Desktop
Hot Apps

Business
Dashboard
Development
Drivers
Education
MacUpdate Promo
Popular Apps

Games
Home & Personal
Internet
Multimedia & Design
Utilities
iPhone
Apps

Login
Member Login

Developer Login
About
Search Mac Apps

Search iPhone Apps

Advanced Search
SQLite
SQLite 3.7.8
Your rating: Now say why...

(1) 4.5

SQL database connection development library.   Free
Add to my Watch List
Email me when discounted
  • Download Now
    308 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
What's New
Version 3.7.8:
  • Orders of magnitude performance improvement for CREATE INDEX on very large tables.
  • Improved the windows VFS to better defend against interference from anti-virus software.
  • Improved query plan optimization when the DISTINCT keyword is present.
  • Allow more system calls to be overridden in the unix VFS - to provide better support for chromium sandboxes.
  • Increase the default size of a lookahead cache line from 100 to 128 bytes.
  • Enhancements to the test_quota.c module so that it can track preexisting files.
  • Bug fix: Virtual tables now handle IS NOT NULL constraints correctly.
  • Bug fixes: Correctly handle nested correlated subqueries used with indices in a WHERE clause.
Version 3.7.8:
  • Orders of magnitude performance improvement for CREATE INDEX on very large tables.
  • Improved the windows VFS to better defend against interference from anti-virus software.
  • Improved query plan optimization when the DISTINCT keyword is present.
  • Allow more system calls to be overridden in the unix VFS - to provide better support for chromium sandboxes.
  • Increase more...
Requirements
PPC / Intel, Mac OS X 10.4 or later







  • PostgreSQL for...
    +3
    Free
    SQL database server.

  • MySQL
    +1
    Free
    Industry-leading open-source ...
SQLite User Discussion (Write a Review)
ver. 3.x:
(1)
Your rating: Now say why...
Overall:
(1)

sort: smiles | time
burypromote

+480
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


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
+1

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
+2

Anonymous commented on 15 Dec 2004
Thank you for doing it Michael. It is beneficial to the Mac community and I appreciate it.
burypromote
+1

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

+14
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.


+14

Hodagacz rated on 20 May 2011

[Version 3.7.6.3]


Downloads:7,498
Version Downloads:739
Type:Development : Libraries
License:Free
Date:19 Sep 2011
Platform:PPC / Intel
Price:Free0.00
Overall (Version 3.x):
Features:
Ease of Use:
Value:
Stability:
Displaying 1-2 of 2
Displaying 1-1 of 1
-
-
-
Please login or create a new
MacUpdate Member account
to use this feature
Watch Lists are available to
MacUpdate Desktop Members
Upgrade Now
Download and auto-install
using MacUpdate Desktop. Save
time moving folders and cleaning-up.
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.
Add/Update Listing About MacUpdate Desktop Career Opportunities RSS Twitter Facebook Advertise Sitemap
Copyright © 2012 MacUpdate LLC


- -