Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Fix documentation typo: The name of the competing database engine is "Firebird", not "Firefox". (CVS 3185) |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 8be6a39d7108839b0fb298a2d536d68e |
| User & Date: | drh 2006-05-11 13:33:15 |
Context
|
2006-05-11
| ||
| 23:14 | Adjust the default weights on indices so that an index that matches more terms of the where clause wins (by default) over one that matches fewer. Ticket #1808. (CVS 3186) check-in: 249b579f user: drh tags: trunk | |
| 13:33 | Fix documentation typo: The name of the competing database engine is "Firebird", not "Firefox". (CVS 3185) check-in: 8be6a39d user: drh tags: trunk | |
| 13:26 | Correctly handle multi-column indices where multiple columns are constrained by IN operators with subqueries on the right-hand side. Ticket #1807. (CVS 3184) check-in: b16541ba user: drh tags: trunk | |
Changes
Changes to www/different.tcl.
1
2
3
4
5
6
7
8
..
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
set rcsid {$Id: different.tcl,v 1.6 2005/09/08 11:04:57 drh Exp $}
source common.tcl
header {Distinctive Features Of SQLite}
puts {
<p>
This page highlights some of the characteristics of SQLite that are
unusual and which make SQLite different from many other SQL
database engines.
................................................................................
utility from the GNU compiler suite.) Unneeded features can be disabled
at compile-time to further reduce the size of the library to under
170KiB if desired.
<p>
Most other SQL database engines are much larger than this. IBM boasts
that it's recently released CloudScape database engine is "only" a 2MiB
jar file - 10 times larger than SQLite even after it is compressed!
Firefox boasts that it's client-side library is only 350KiB. That's
50% larger than SQLite and does not even contain the database engine.
The Berkeley DB library from Sleepycat is 450KiB and it omits SQL
support, providing the programmer with only simple key/value pairs.
}
feature typing {Manifest typing} {
Most SQL database engines use static typing. A datatype is associated
|
|
|
|
1
2
3
4
5
6
7
8
..
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
|
set rcsid {$Id: different.tcl,v 1.7 2006/05/11 13:33:15 drh Exp $}
source common.tcl
header {Distinctive Features Of SQLite}
puts {
<p>
This page highlights some of the characteristics of SQLite that are
unusual and which make SQLite different from many other SQL
database engines.
................................................................................
utility from the GNU compiler suite.) Unneeded features can be disabled
at compile-time to further reduce the size of the library to under
170KiB if desired.
<p>
Most other SQL database engines are much larger than this. IBM boasts
that it's recently released CloudScape database engine is "only" a 2MiB
jar file - 10 times larger than SQLite even after it is compressed!
Firebird boasts that it's client-side library is only 350KiB. That's
50% larger than SQLite and does not even contain the database engine.
The Berkeley DB library from Sleepycat is 450KiB and it omits SQL
support, providing the programmer with only simple key/value pairs.
}
feature typing {Manifest typing} {
Most SQL database engines use static typing. A datatype is associated
|