/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 check-ins occurring around fdcc31f0c6106dac.

2004-11-19
08:02
Update the sqlite_sequence table when a table is renamed with ALTER_TABLE. (CVS 2114) check-in: 6e971868 user: danielk1977 tags: trunk
07:07
When dropping a table, update the sqlite_sequence table first, as auto-vacuum mode may need to move sqlite_sequence when the btree table is dropped. (CVS 2113) check-in: 0514107b user: danielk1977 tags: trunk
05:14
Fix bugs in ALTER TABLE related to (a) whitespace in table defn, (b) temp triggers. (CVS 2112) check-in: 1fd8e835 user: danielk1977 tags: trunk
2004-11-18
15:44
Handle triggers correctly in ALTER TABLE. (CVS 2111) check-in: c61b7de1 user: danielk1977 tags: trunk
13:49
Speed improvement on the LIKE command. (CVS 2110) check-in: 85d56beb user: drh tags: trunk
02:10
Fix an obsolete comment that resulted in incorrect documentation. Ticket #1003. (CVS 2109) check-in: c93a9e18 user: drh tags: trunk
02:04
Clarify the documentation of the sqlite3_create_function API. Ticket #1004. (CVS 2108) check-in: ae45ad86 user: drh tags: trunk
2004-11-17
16:41
Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107) check-in: 49268c2b user: danielk1977 tags: trunk
10:22
Extra tests and resulting bugfixes for btree cursors. (CVS 2106) check-in: e1530854 user: danielk1977 tags: trunk
2004-11-16
23:21
Clarify the LIMIT clause in the documentation. Ticket #1002. (CVS 2105) check-in: e05f52d9 user: drh tags: trunk
15:50
Perform deletes in a single pass. (CVS 2104) check-in: a2e1c35b user: danielk1977 tags: trunk
04:57
Allow btree cursors to persist through BtreeDelete() calls. (CVS 2103) check-in: 6ad5fc8e user: danielk1977 tags: trunk
2004-11-15
23:42
Fix a typo in the header comment to the MakeRecord opcode so that the documentation generator will actually see the opcode description. Ticket #1001. (CVS 2102) check-in: 33c9b647 user: drh tags: trunk
01:40
Add test cases for escape characters in the GLOB operator. (CVS 2101) check-in: bb2d9ff8 user: drh tags: trunk
2004-11-14
21:56
The SQLITE_OMIT_UTF16 macro now removes lots of code and all tests still pass. (CVS 2100) check-in: 98c7a554 user: drh tags: trunk
04:04
Changes toward reducing code size when SQLITE_OMIT_UTF16 is enabled. (CVS 2099) check-in: 59a0a8b7 user: drh tags: trunk
2004-11-13
15:59
More compile-time options for removing components. (CVS 2098) check-in: dcbc0c22 user: drh tags: trunk
13:19
Code toward having btree cursors persist when their table is written too. Doesn't work properly yet. (CVS 2097) check-in: 5eaa18d4 user: danielk1977 tags: trunk
03:59
Fix the keyword generator so that it works with SQLITE_OMIT_ALTERTABLE. (CVS 2096) check-in: 60ace998 user: drh tags: trunk
03:48
Autoincrement is now working and has regression tests. (CVS 2095) check-in: 10c712a2 user: drh tags: trunk
2004-11-12
16:12
Change pragmas schema_cookie and user_cookie to schema_version and user_version. (CVS 2094) check-in: 5e058318 user: danielk1977 tags: trunk
15:53
Add authorization callbacks to ALTER TABLE. (CVS 2093) check-in: c4115aa3 user: danielk1977 tags: trunk
13:42
Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092) check-in: a1b2cc63 user: danielk1977 tags: trunk
03:56
Autoincrement code installed. Simple smoke-testing only. No regression tests developed yet. (CVS 2091) check-in: 8fde833c user: drh tags: trunk
2004-11-11
19:32
Website updates. (CVS 2090) check-in: 60fb0cef user: drh tags: trunk
05:10
Add the schema_cookie and user_cookie pragmas. (CVS 2089) check-in: d28d1d68 user: danielk1977 tags: trunk
01:50
Add documentation for DEFAULT CURRENT_TIME & co. (CVS 2088) check-in: c85f13f8 user: danielk1977 tags: trunk
2004-11-10
15:27
Ensure the test suite can run with either SQLITE_OMIT_AUTOVACUUM or SQLITE_DEFAULT_AUTOVACUUM=1 defined. (CVS 2087) check-in: 0747b558 user: danielk1977 tags: trunk
12:34
Fix expr.test so that it works when the date-time functions are compiled out of the library. (CVS 2086) check-in: 540ce7de user: danielk1977 tags: trunk
11:55
Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085) check-in: 8e5c2e5d user: danielk1977 tags: trunk
05:48
Add user documentation for the "pragma auto_vacuum" command. (CVS 2084) check-in: fe200eaf user: danielk1977 tags: trunk
2004-11-09
16:13
Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083) check-in: f81b9c1c user: danielk1977 tags: trunk
12:44
Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) check-in: 0d27c8ff user: danielk1977 tags: trunk
07:42
Refactor the space-analysis script for readability. (CVS 2081) check-in: 63f2ee22 user: danielk1977 tags: trunk
2004-11-08
16:15
Update the space-analyzer tool to support auto-vacuum databases. (CVS 2080) check-in: 1cb80866 user: danielk1977 tags: trunk
12:32
A few more auto-vacuum tests. (CVS 2079) check-in: 9d4a60bb user: danielk1977 tags: trunk
09:51
Check in the file autovacuum_crash.test that should be part of the previous check-in. (CVS 2078) check-in: 9d7cd1f7 user: danielk1977 tags: trunk
09:26
Test auto-vacuum mode for crash-proofness. Also fix a bug related to the same. (CVS 2077) check-in: 839ad771 user: danielk1977 tags: trunk
07:13
Auto-vacuum: Account for the page reserved for windows locking (PENDING_BYTE). (CVS 2076) check-in: d6335698 user: danielk1977 tags: trunk
2004-11-07
13:01
Reindex tests added and bugs fixed. (CVS 2075) check-in: ad433ec2 user: drh tags: trunk
2004-11-06
12:26
Auto-vacuum: Ensure pages to be removed by database truncation are in the journal file. Also fix an sqlite3pager_movepage() bug. (CVS 2074) check-in: 081676e4 user: danielk1977 tags: trunk
00:02
Compile and pass the quick regression tests with autovacuum disabled. (CVS 2073) check-in: 89b9026a user: drh tags: trunk
2004-11-05
23:46
First cut at a REINDEX command. Basic testing only. No documentation. (CVS 2072) check-in: 11dba47e user: drh tags: trunk
22:18
Use sqlite3NestedParse to implement DROP INDEX. (CVS 2071) check-in: 0f81aa5b user: drh tags: trunk
20:58
Use sqlite3NestedParse to implement CREATE INDEX. (CVS 2070) check-in: 47d8ebda user: drh tags: trunk
17:17
Create table now works with sqlite3NestedParse. This changed uncovered a latent bug in xprintf which is also fixed. (CVS 2069) check-in: b0506bdd user: drh tags: trunk
16:37
Do not truncate a database file until after fsync() has been called on the journal. (CVS 2068) check-in: cfee7f4a user: danielk1977 tags: trunk
15:45
Make auto-vacuum a run-time option (default determined by SQLITE_DEFAULT_AUTOVACUUM macro). (CVS 2067) check-in: b9d5f007 user: danielk1977 tags: trunk
12:58
Auto-vacuum bug: Don't set meta(3) to a pointer-map page number when deleting a table. (CVS 2066) check-in: 44a015b3 user: danielk1977 tags: trunk
12:27
Fix allocation of tables in an auto-vacuum database when the required root-page is on the free-list. (CVS 2065) check-in: 4e243337 user: danielk1977 tags: trunk
09:19
Don't code an OP_Statement within sqlite3NestedParse(). Also a correction to the UPDATE statement used within destroyRootPage(). (CVS 2064) check-in: fdcc31f0 user: danielk1977 tags: trunk
06:02
When using sqlite3NestedParse() to modify the sqlite_master table, do not code OP_Callback. (CVS 2063) check-in: 296a298c user: danielk1977 tags: trunk
05:23
Another bug fix from two check-ins ago. (CVS 2062) check-in: c46eef2f user: drh tags: trunk
05:20
Fix a bug in the previous check-in. (CVS 2061) check-in: 9d259d48 user: drh tags: trunk
05:10
More use of sqlite3NestedParse. This version of the code does not work. (CVS 2060) check-in: ac2d5a60 user: drh tags: trunk
03:56
Begin using sqlite3NestedParse() to generate sections of code. (CVS 2059) check-in: 2d302931 user: drh tags: trunk
01:45
Fix bug introduced with (2057). (CVS 2058) check-in: aed2e623 user: danielk1977 tags: trunk
01:24
Pop the value pushed by OP_Destroy if SQLITE_OMIT_AUTOVACUUM is defined. (CVS 2057) check-in: b0c10334 user: danielk1977 tags: trunk
00:43
Incremental check-in of changes that will ultimately lead to a working autoincrement. (CVS 2056) check-in: 10c3d883 user: drh tags: trunk
2004-11-04
14:47
All tests pass when SQLITE_OMIT_INTEGRITY_CHECK is defined. (CVS 2055) check-in: 158a2d16 user: drh tags: trunk
14:30
Support root-page allocation/deallocation in auto-vacuum databases. Still a few problems. (CVS 2054) check-in: 1da361fa user: danielk1977 tags: trunk
04:42
All tests pass even if OMIT_TRIGGER is defined. (CVS 2053) check-in: c33b3a61 user: drh tags: trunk
04:34
Fix a #ifdef in util.c. Ticket #984. (CVS 2052) check-in: da045bd1 user: drh tags: trunk
02:57
Add support for table allocation (not deallocation) in auto-vacuum databases. (CVS 2051) check-in: 571de523 user: danielk1977 tags: trunk
2004-11-03
16:27
Update tests to work even if some features of the library are disabled. (CVS 2050) check-in: b11fc9b3 user: drh tags: trunk
13:59
More work on optionally removing unused features at compile-time. (CVS 2049) check-in: a82980fd user: drh tags: trunk
11:37
Auto-vacuum bug: Deallocate pointer-map pages when shrinking a database file. (CVS 2048) check-in: bec6a65a user: danielk1977 tags: trunk
09:30
Comment the autovacuum.test script. No code or test-case changes. (CVS 2047) check-in: 2eacd386 user: danielk1977 tags: trunk
08:44
Auto-vacuum bug: Correctly manipulate page cache hash-table entries in sqlite3pager_movepage(). (CVS 2046) check-in: 719c1b79 user: danielk1977 tags: trunk
03:59
The makefile now runs mkkeywordhash.c. Keywords that are unused are omitted from the keyword hash table. (CVS 2045) check-in: 007aec11 user: drh tags: trunk
03:52
Auto-vacuum bugfix: Do not attempt to move a pointer-map page during auto-vacuum. (CVS 2044) check-in: bd50fbb5 user: danielk1977 tags: trunk
03:01
Fix an auto-vacuum bug that occurs when a btree cell is promoted to the parent page during a delete. (CVS 2043) check-in: b7d953e1 user: danielk1977 tags: trunk
2004-11-02
18:30
Disable trigger tests that use ATTACH in version 2.8 when there is a codec enabled. (CVS 2042) check-in: f77f7753 user: drh tags: version_2
18:15
Fix a problem in the pragma.test script. (CVS 2041) check-in: a2c9c45c user: drh tags: trunk
18:05
Get btree.c to compile with -DNDEBUG=1. (CVS 2040) check-in: 8378c144 user: drh tags: trunk
14:40
Fix an auto-vacuum bug for btree entries that span more than one overflow page. (CVS 2039) check-in: 40249ed1 user: danielk1977 tags: trunk
14:24
Require that the page size be a power of 2. (CVS 2038) check-in: c33b34db user: drh tags: trunk
12:56
Code to auto-vacuum the database if all root pages happen to be in the right place. Not active by default and largely untested. (CVS 2037) check-in: d12481f0 user: danielk1977 tags: trunk
2004-11-01
16:03
Updates to the support.html page. (CVS 2036) check-in: 5515acce user: drh tags: trunk
2004-10-31
16:25
Add code to create/update the btree 'pointer-map' for auto-vacuum mode. (CVS 2035) check-in: bebd967f user: danielk1977 tags: trunk
02:22
Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) check-in: be661acf user: drh tags: trunk
2004-10-30
20:23
Begin adding the ability to remove unused features at compile-time and still have all the tests pass. (CVS 2033) check-in: 2aa506cc user: drh tags: trunk
2004-10-26
16:34
Move affinity.html into the attic. (CVS 2032) check-in: 87a3c668 user: drh tags: trunk
16:33
Mark the affinity.html file as obsolete. (CVS 2031) check-in: 09de96b6 user: drh tags: trunk
00:08
Fix a bug in the ".databases" command of the command-line shell. Ticket #973 (CVS 2030) check-in: 507d8e6f user: drh tags: trunk
2004-10-25
20:33
Minor optimizations in the pragma module. (CVS 2029) check-in: 63efd50a user: drh tags: trunk
2004-10-23
05:10
Tighter encoding of the keyword hash table in the tokenizer. (CVS 2028) check-in: 7b9886f8 user: drh tags: trunk
2004-10-22
20:29
Add the experimental and scary pragma "writable_schema". (CVS 2027) check-in: 39f7870a user: drh tags: trunk
16:22
Fix alignment problems in btree and pager and allow page sizes that are not a multiple of 8. (CVS 2026) check-in: 0539c2d2 user: drh tags: trunk
2004-10-19
16:40
Reinsert code deleted by (1998) that we thought was unused but was in fact needed. Fix for ticket #966. (CVS 2025) check-in: 370ca539 user: drh tags: trunk
01:31
Fix a typo in the quickstart document. (CVS 2024) check-in: 55b03c56 user: drh tags: trunk
2004-10-18
21:34
Fix typos in the names of some regression tests. Ticket #962. (CVS 2023) check-in: 77542beb user: drh tags: trunk
2004-10-12
02:38
Fix typo on homepage. Ticket #956. (CVS 2022) check-in: 552ec677 user: drh tags: trunk
00:56
Version 3.0.8 (CVS 2021) check-in: 7dd66d76 user: drh tags: trunk
00:50
Updates to the README file (CVS 2020) check-in: d3d0d7a8 user: drh tags: trunk
2004-10-11
22:26
Increment the version number. Prepare for release of version 3.0.8. (CVS 2019) check-in: ff04d7d4 user: drh tags: trunk
21:49
Fix typo on the homepage. (CVS 2018) check-in: 7f190f85 user: drh tags: trunk
21:48
Fix typo in the lockingv3.html page on the website. (CVS 2017) check-in: a31b6477 user: drh tags: trunk
2004-10-10
19:11
The mkopcodeh.awk script removes \r for use with msys. Ticket #954. (CVS 2016) check-in: c4fb44fd user: drh tags: trunk
18:00
Documentation updates (CVS 2015) check-in: a4546c09 user: drh tags: trunk