Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Update the "small footprint" docs to put the size at 600KB instead of 500KB, as we have crossed that threshold with the addition of window functions. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
eeaadb7da2fe79ba1810451bbb156fc9 |
User & Date: | drh 2018-07-07 17:44:20.064 |
Context
2018-07-11
| ||
11:08 | Update the keyword list with all of the new keywords added for UPSERT and window functions. (check-in: 824b38d28e user: drh tags: trunk) | |
2018-07-07
| ||
17:44 | Update the "small footprint" docs to put the size at 600KB instead of 500KB, as we have crossed that threshold with the addition of window functions. (check-in: eeaadb7da2 user: drh tags: trunk) | |
17:36 | Minor changes to the windows function documentation. (check-in: ff1e1e885a user: drh tags: trunk) | |
Changes
Changes to pages/about.in.
︙ | ︙ | |||
49 50 51 52 53 54 55 | an [Application File Format]. SQLite database files are a [recommended storage format] by the US Library of Congress. Think of SQLite not as a replacement for [http://www.oracle.com/database/index.html|Oracle] but as a replacement for [http://man.he.net/man3/fopen|fopen()]</p> <p>SQLite is a compact library. | | | 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 | an [Application File Format]. SQLite database files are a [recommended storage format] by the US Library of Congress. Think of SQLite not as a replacement for [http://www.oracle.com/database/index.html|Oracle] but as a replacement for [http://man.he.net/man3/fopen|fopen()]</p> <p>SQLite is a compact library. With all features enabled, the [library size] can be less than 600KiB, depending on the target platform and compiler optimization settings. (64-bit code is larger. And some compiler optimizations such as aggressive function inlining and loop unrolling can cause the object code to be much larger.) 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 |
︙ | ︙ |
Changes to pages/features.in.
︙ | ︙ | |||
15 16 17 18 19 20 21 | (<a href="omitted.html">Omitted features</a>)</li> <li>A complete database is stored in a <a href="onefile.html">single cross-platform disk file</a>. Great for use as an [application file format].</li> <li>Supports terabyte-sized databases and gigabyte-sized strings and blobs. (See <a href="limits.html">limits.html</a>.) <li>Small code [footprint]: | | | 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | (<a href="omitted.html">Omitted features</a>)</li> <li>A complete database is stored in a <a href="onefile.html">single cross-platform disk file</a>. Great for use as an [application file format].</li> <li>Supports terabyte-sized databases and gigabyte-sized strings and blobs. (See <a href="limits.html">limits.html</a>.) <li>Small code [footprint]: less than 600KiB fully configured or much less with optional features omitted.</li> <li>Simple, easy to use <a href="cintro.html">API</a>.</li> <li>Fast: In some cases, SQLite is [faster than the filesystem|faster than direct filesystem I/O] <li>Written in ANSI-C. <a href="tclsqlite.html">TCL bindings</a> included. Bindings for dozens of other languages available separately.</li> <li>Well-commented source code with |
︙ | ︙ |
Changes to pages/footprint.in.
︙ | ︙ | |||
26 27 28 29 30 31 32 | <li><p> GCC-7 generates binaries that are smaller and faster than GCC-5, though the difference is not that great. <li><p> Compiling with GCC and -Os results in a binary that is slightly less | | > > | 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 | <li><p> GCC-7 generates binaries that are smaller and faster than GCC-5, though the difference is not that great. <li><p> Compiling with GCC and -Os results in a binary that is slightly less than 500KB in size. (Update 2018-07-07: Due to the addition of new features such as [UPSERT] and [window functions], the library footprint is now slightly larger than 500KB.) <li><p> The only significant design decision that developers need to make is whether to use -Os (optimize for size) or -O6 (optimize for speed). The -O6 setting makes binaries that run about 2% or 3% faster, but which are also 66% larger. The performance here is measured by counting CPU cycles using cachegrind. I-cache misses are not considered in the |
︙ | ︙ |