SQLite

Timeline
Login

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

100 check-ins occurring around 97aa54bb70715934.

2004-06-14
11:58
Do not authenticate statements when reading the schema. Backport of bug fix in (1588) to version 2. (CVS 1591) (check-in: 24adf9ed user: drh tags: version_2)
11:54
Fix a bug in the auth.test script. (CVS 1590) (check-in: 1fa97dd8 user: danielk1977 tags: trunk)
11:43
Have the TCL 'errorcode' interface call sqlite3_errcode(). (CVS 1589) (check-in: f4b4df65 user: danielk1977 tags: trunk)
11:35
Don't invoke authorisation callback during database initialisation. (CVS 1588) (check-in: 293fbf0a user: danielk1977 tags: trunk)
09:41
Bugfix for previous checkin. (CVS 1587) (check-in: 2737505f user: danielk1977 tags: trunk)
09:35
Ensure master journal file is deleted when a transaction is committed. (CVS 1586) (check-in: cb3cbe00 user: danielk1977 tags: trunk)
08:26
Check the value of the schema cookie before reading the sqlite_master table. (CVS 1585) (check-in: 80c299f8 user: danielk1977 tags: trunk)
06:13
Change tests in pager.test to account for the extra cache hit in the code that updates file change counter. (CVS 1584) (check-in: 76ac9a78 user: danielk1977 tags: trunk)
06:03
Ensure the master journal directory is synced. Also, change the master journal format to store journal file names. (CVS 1583) (check-in: 73cd0aab user: danielk1977 tags: trunk)
05:10
Update the file change counter just before each transaction is committed. (CVS 1582) (check-in: 4649abcb user: danielk1977 tags: trunk)
2004-06-13
23:07
os_win.c is now working with the new locking protocol. (CVS 1581) (check-in: 77c5eaa1 user: drh tags: trunk)
00:54
More speed improvements. (CVS 1580) (check-in: c5ebc1c0 user: drh tags: trunk)
2004-06-12
20:42
The VDBE aggregate functions use an in-memory btree instead of a disk-based btree for improved performance. (CVS 1579) (check-in: 8029f1e4 user: drh tags: trunk)
20:12
Speed up in the handling of VDBE cursors. (CVS 1578) (check-in: e42316f5 user: drh tags: trunk)
18:12
Improve the speed of OP_Column through better caching. (CVS 1577) (check-in: f687977a user: drh tags: trunk)
14:11
Fix typo in the locking document. (CVS 1576) (check-in: 99a7bd83 user: drh tags: trunk)
09:25
(1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) (check-in: 5903f538 user: danielk1977 tags: trunk)
02:17
Bug fix in the unix locking code. (CVS 1574) (check-in: dcad244f user: drh tags: trunk)
01:43
Change prototype for busy callbacks to "int xBusy(void *, int);" (CVS 1573) (check-in: 4f1cfca5 user: danielk1977 tags: trunk)
00:42
Use the SQLITE_UTF* symbols instead of the old internal TEXT_Utf* symbols. (CVS 1572) (check-in: 9b84f2f4 user: danielk1977 tags: trunk)
2004-06-11
22:04
Fix typos in the new locking document. (CVS 1571) (check-in: 02207551 user: drh tags: trunk)
17:48
Documentation of the new pager locking mechanism. (CVS 1570) (check-in: 13cf1ba8 user: drh tags: trunk)
13:19
Have the vdbe aggregator use a btree table instead of a hash table. (CVS 1569) (check-in: 8d56118f user: danielk1977 tags: trunk)
10:51
Fix various collation sequence issues. (CVS 1568) (check-in: 66835ee6 user: danielk1977 tags: trunk)
2004-06-10
23:35
Comment changes in pager.c. (CVS 1567) (check-in: 0e420f72 user: drh tags: trunk)
22:51
Add new contributed logo TIFF. (CVS 1566) (check-in: 86744c9a user: drh tags: trunk)
14:01
Correctly handle the situation where a collation sequence is available, but not in the preferred encoding. (CVS 1565) (check-in: 49ab4794 user: danielk1977 tags: trunk)
10:51
Add the sqlite3_collation_needed() API and fix some error handling cases involving unknown collation sequences. (CVS 1564) (check-in: 67500546 user: danielk1977 tags: trunk)
10:51
Add the sqlite3_collation_needed() API and fix some error handling cases involving unknown collation sequences. (CVS 1563) (check-in: 518d82d3 user: danielk1977 tags: trunk)
10:50
Add the sqlite3_collation_needed() API and fix some error handling cases involving unknown collation sequences. (CVS 1562) (check-in: edf069b9 user: danielk1977 tags: trunk)
05:59
Misc fixes for test cases failing due to the new locking model. (CVS 1561) (check-in: 71e98d0d user: danielk1977 tags: trunk)
04:32
When in PAGER_RESERVED state, don't write to the main file when rolling back a statement transaction. (CVS 1560) (check-in: adb2bd61 user: danielk1977 tags: trunk)
02:16
Change the collation sequence interface to allow collation sequences that use UTF-16 in non-native byte order to be registered. (CVS 1559) (check-in: b8aaa3a2 user: danielk1977 tags: trunk)
01:30
Add the vdbe_listing and sql_trace pragmas used for debugging. (CVS 1558) (check-in: 28c3cc08 user: drh tags: trunk)
01:08
Tests in lock.test no conform to the new locking scheme. (CVS 1557) (check-in: a60afd04 user: drh tags: trunk)
00:51
Fix a buffer overrun in the atomic multifile commit logic of the pager. (CVS 1556) (check-in: 3b78ffe0 user: drh tags: trunk)
00:29
Check for schema updates if the parser fails to find a table. More locking test updates. (CVS 1555) (check-in: a2228351 user: drh tags: trunk)
2004-06-09
23:20
Version 2.8.14 (CVS 1554) (check-in: 7d393774 user: drh tags: version_2)
23:15
Website changes for version 2.8.14. (CVS 1553) (check-in: 73afa14a user: drh tags: trunk)
22:49
Update the version number to 2.8.14. For whatever reason, the version at the tip of the 2.8 branch fixes ticket #757. (CVS 1552) (check-in: 7538d2e5 user: drh tags: version_2)
21:01
If a commit fails due to lock contention right after the COMMIT command, take the database back out of autocommit mode. Do not rollback. This gives the user the chance to try the COMMIT again. (CVS 1551) (check-in: 39b4ba95 user: drh tags: trunk)
20:03
Turn on the atomic multifile commit logic. It does not work right yet, but it has at least stopped failing asserts. (CVS 1550) (check-in: 3674b25e user: drh tags: trunk)
19:03
Remove legacy journal formats. (CVS 1549) (check-in: a12bef4a user: drh tags: trunk)
17:37
Fixes to the file locking. 109 tests are now failing. (CVS 1548) (check-in: dc076345 user: drh tags: trunk)
14:17
Add the "lock_status" pragma - only available when SQLITE_DEBUG is defined. Used for testing only. (CVS 1547) (check-in: 0ecbba78 user: drh tags: trunk)
14:01
Change the MEMORY_DEBUG macro to SQLITE_DEBUG. (CVS 1546) (check-in: 428b685b user: drh tags: trunk)
12:30
Fix error reporting when trying to attach a database with a foriegn text encoding. (CVS 1545) (check-in: beab038c user: danielk1977 tags: trunk)
09:55
Some progress on user-defined collation sequences. (CVS 1544) (check-in: c634e71f user: danielk1977 tags: trunk)
00:48
Start all transactions and verify all schema cookies near the beginning of of each vdbe program. (CVS 1543) (check-in: 10861964 user: drh tags: trunk)
2004-06-08
00:47
Do not require a RESERVED lock when transitioning from SHARED to EXCLUSIVE. (CVS 1542) (check-in: 4dfdea73 user: drh tags: trunk)
00:39
Enhance the built-in function quote() to support blob values. (CVS 1541) (check-in: 97aa54bb user: danielk1977 tags: trunk)
00:02
Remove the third argument from the sqlite3_open() API. (CVS 1540) (check-in: 62e31f39 user: danielk1977 tags: trunk)
2004-06-07
16:27
More work on windows locking. Fix some problems with unix locking. There is still an assertion failure on windows locking in attach2.test. (CVS 1539) (check-in: 0c2d169c user: drh tags: trunk)
10:00
Tables created with the CREATE TABLE <tbl> AS SELECT ... syntax now inherit column declaration types from the SELECT statement. (CVS 1538) (check-in: 31c1668d user: danielk1977 tags: trunk)
07:52
Add pragma to set/get text encoding. Also fix an obscure problem where a temp trigger could be accidently dropped. (CVS 1537) (check-in: 983221b0 user: danielk1977 tags: trunk)
01:52
Progress towards getting locking to work on windows. (CVS 1536) (check-in: 4f7c0961 user: drh tags: trunk)
2004-06-06
12:41
Performance improvements for LIKE. It is still too slow though. (CVS 1535) (check-in: 30b81507 user: danielk1977 tags: trunk)
09:44
Enhance user function API to support association of meta-data with constant arguments and the specification of text encoding preference. The LIKE operator takes advantage of both. (CVS 1534) (check-in: 92337d8f user: danielk1977 tags: trunk)
00:42
Added sqlite3OsLock for win32. Assertion fault in attach.test. (CVS 1533) (check-in: 9e6cd9ec user: drh tags: trunk)
2004-06-05
10:22
Add the sqlite3_set_auxdata() and sqlite3_get_auxdata() APIs. (CVS 1532) (check-in: c2899b43 user: danielk1977 tags: trunk)
08:04
Ensure blob values survive the ".dump" command of the shell. (CVS 1531) (check-in: e82eb722 user: danielk1977 tags: trunk)
00:01
Critical bugs fixed in btree.c. Incompatible file format change. Unrelated comment fix in select.c (CVS 1530) (check-in: cb1ffabf user: drh tags: trunk)
2004-06-04
19:07
Calling sqlite_interrupt() while VACUUM is running should not cause an error. (CVS 1529) (check-in: 1cf94a7c user: drh tags: version_2)
10:38
Defer the exclusive db lock until the pager cache is flushed to disk. 41 tests now fail. (CVS 1528) (check-in: d2f69e5e user: danielk1977 tags: trunk)
06:22
Move the 'busy-callback' logic to the pager layer. (CVS 1527) (check-in: ff70b6d2 user: danielk1977 tags: trunk)
2004-06-03
16:08
Untested updates to support atomic multi-file transactions (CVS 1526) (check-in: d57e5252 user: danielk1977 tags: trunk)
2004-06-02
06:30
Fix a segfault in sqlite3OsLock() (CVS 1525) (check-in: 51348b82 user: danielk1977 tags: trunk)
01:22
Work toward combining the OP_MakeKey, OP_MakeIdxKey, and OP_MakeRecord opcodes into one. The work is incomplete. (CVS 1524) (check-in: 165d69a0 user: drh tags: trunk)
00:41
Remove the sqlite3_libencoding() api and the ISO8859 encoding option. (CVS 1523) (check-in: b53640ed user: drh tags: trunk)
00:29
Fix a bug with UTF-16 byte-order-marks on big-endian hosts. (CVS 1522) (check-in: c17b8641 user: danielk1977 tags: trunk)
00:08
Fix another website typo. (CVS 1521) (check-in: 24e2bbd0 user: drh tags: trunk)
2004-06-01
14:09
Unix version of sqlite3OsLock(). (CVS 1520) (check-in: 023d1760 user: danielk1977 tags: trunk)
12:59
Fix typo on homepage (CVS 1519) (check-in: a84ece25 user: drh tags: trunk)
10:01
Fix typos in version 3 documents. (CVS 1518) (check-in: 915cba57 user: drh tags: trunk)
01:45
Makefile changes for building windows DLLs. (CVS 1517) (check-in: 11c5d6ab user: drh tags: trunk)
01:22
Add the capi3ref.html page to the website. (CVS 1516) (check-in: 89f54f1f user: drh tags: trunk)
00:03
Remove the sqlite3_open_varargs() API. (CVS 1515) (check-in: 6902fb1b user: danielk1977 tags: trunk)
2004-05-31
23:56
Remove the sqlite3_error_string() API. (CVS 1514) (check-in: af8e2006 user: danielk1977 tags: trunk)
23:13
Synchronize lemon.c to the version on the 2.8 branch. (CVS 1513) (check-in: 6ab3af88 user: drh tags: trunk)
19:34
Change the name of the sqlite3_freemem API function to just sqlite3_free. (CVS 1512) (check-in: f3b80bbb user: drh tags: trunk)
18:51
Change all SQLITE3 preprocessor macros to SQLITE. Documentation updates. (CVS 1511) (check-in: adf7e29f user: drh tags: trunk)
18:23
Change the name of the include file to "sqlite3.h". The names of the shell command and static library become "sqlite3" and "libsqlite3.a". (CVS 1510) (check-in: 4c37b6d2 user: drh tags: trunk)
18:22
Begin adding documentation for version 3.0. (CVS 1509) (check-in: 2005bfda user: drh tags: trunk)
18:21
Get the attach.test working on windows. (CVS 1508) (check-in: 48226a73 user: drh tags: trunk)
16:04
More website updates. (CVS 1507) (check-in: 460f2361 user: drh tags: trunk)
15:06
Website redesign in preparation for adding version 3 documentation. (CVS 1506) (check-in: 2052911b user: drh tags: trunk)
12:34
Some test cases for read locks (CVS 1505) (check-in: 0e070067 user: danielk1977 tags: trunk)
11:51
Use read-only transactions. (CVS 1504) (check-in: 6c100887 user: danielk1977 tags: trunk)
10:08
Bugfix for previous checkin. (CVS 1503) (check-in: 5f869fbf user: danielk1977 tags: trunk)
10:01
Add read-transactions to the btree and vdbe. The compiler doesn't invoke them yet. (CVS 1502) (check-in: 6b43633a user: danielk1977 tags: trunk)
08:55
Remove the <ON CONFLICT> clause from BEGIN (CVS 1501) (check-in: 9029274b user: danielk1977 tags: trunk)
08:26
Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) (check-in: b8ed812c user: danielk1977 tags: trunk)
2004-05-30
21:14
Add 3-byte and 6-byte integer serial types. This makes databases smaller and faster. Should we go ahead and add 5- and 7-byte integer types too? (CVS 1499) (check-in: e6685af8 user: drh tags: trunk)
20:46
Various speed enhancements. (CVS 1498) (check-in: a0db15bb user: drh tags: trunk)
19:19
Improved comments and speed tweaks to btree.c. (CVS 1497) (check-in: c86b7c06 user: drh tags: trunk)
02:14
Additional minor speed improvements. (CVS 1496) (check-in: a90264c0 user: drh tags: trunk)
01:51
Faster version of sqlite3VdbeSerialGet. (CVS 1495) (check-in: 80985505 user: drh tags: trunk)
01:38
Do not include the P3 parameter on OP_Integer opcodes if the integer will fit in 32 bits. The P3 conversion is slow. (CVS 1494) (check-in: fcd84eba user: drh tags: trunk)
2004-05-29
21:46
A file format change for btree.c makes it between 10 and 20% faster. (CVS 1493) (check-in: cbcaece7 user: drh tags: trunk)
11:24
Transform OP_HexBlob and OP_String8 to OP_Blob and OP_String the first time they are executed. (CVS 1492) (check-in: 3225de89 user: danielk1977 tags: trunk)