This Day In History For 2024-04-14
1 Year Ago (more context)
2023-04-14
| ||
21:14 | • Reply: A new option, possibly, for CLI: -utf8 artifact: 88e69e126d user: jicman | |
20:49 | • Reply: A new option, possibly, for CLI: -utf8 artifact: b932aa52e4 user: jicman | |
20:16 | • Reply: A new option, possibly, for CLI: -utf8 artifact: ea6b5b7121 user: larrybr | |
19:56 | • Reply: Dealing with a larger database artifact: 4ce1957ff0 user: anonymous | |
16:26 | • Reply: Safari error for latest SQLite WASM artifact: 44163f9ddd user: tomayac | |
16:25 | • Reply: SQLite Wasm for Safari And Firefox progress artifact: 4b16f2f465 user: tomayac | |
16:23 | • Post: Dealing with a larger database artifact: 733d57e0e6 user: TimKendal | |
14:55 | • Reply: Can't migrate auto-increment bigint columns artifact: e5f3408ac9 user: kmedcalf | |
14:18 | • Reply: Can't migrate auto-increment bigint columns artifact: dd3e6d86f9 user: anonymous | |
14:15 | • Post: UNION in a SELECT artifact: f08620e9db user: RayNeverLearns | |
13:35 | • Reply: Error in executing recoverbuild.test from "make test" after cloning and building sqlite artifact: 4ceec82346 user: dan | |
12:53 | • Reply: Windows Page Code 65001 makes CLI hang artifact: 4245401c2d user: jicman | |
12:50 | • Reply: Get the count from line to col artifact: aceb7cef6e user: Pogzy321 | |
12:47 | • Reply: Get the count from line to col artifact: 0b04ea9d43 user: Pogzy321 | |
12:23 | • Reply: Get the count from line to col artifact: 04c2035c32 user: dvdraymond | |
11:31 | • Edit reply: Get the count from line to col artifact: bb245a30fe user: chrisjlocke1 | |
11:29 | • Edit reply: Get the count from line to col artifact: c12bb44a93 user: chrisjlocke1 | |
11:25 | • Edit reply: Get the count from line to col artifact: d863a57f1a user: chrisjlocke1 | |
11:18 | • Reply: Get the count from line to col artifact: 357b853486 user: chrisjlocke1 | |
11:11 | • Reply: Heap buffer overflow in sqlite3StrICmp function artifact: 0d3bbc22a9 user: drh | |
10:40 | • Reply: Can't migrate auto-increment bigint columns artifact: e0f53edc03 user: anonymous | |
10:01 | • Post: Get the count from line to col artifact: c2f7ebcec9 user: Pogzy321 | |
09:44 | • Reply: System.Data.SQLite Downloads artifact: 0896917136 user: AAsk1902 | |
09:19 | • Edit reply: System.Data.SQLite Downloads artifact: 78045df4f8 user: chrisjlocke1 | |
09:18 | • Edit reply: System.Data.SQLite Downloads artifact: e74739924d user: chrisjlocke1 | |
09:17 | • Edit reply: System.Data.SQLite Downloads artifact: e7d9fb0de0 user: chrisjlocke1 | |
09:17 | • Edit reply: System.Data.SQLite Downloads artifact: 415f9a4e41 user: chrisjlocke1 | |
09:17 | • Reply: System.Data.SQLite Downloads artifact: 9b7768200a user: chrisjlocke1 | |
09:10 | • Reply: Windows Page Code 65001 makes CLI hang artifact: 2fda4e3045 user: larrybr | |
07:19 | • Reply: sqlite Update not work correctly but not return error artifact: deff59e882 user: faustf | |
07:08 | • Edit reply: Windows Page Code 65001 makes CLI hang artifact: b4f2d2a8b4 user: AAsk1902 | |
07:00 | • Reply: Windows Page Code 65001 makes CLI hang artifact: c1c42435f0 user: AAsk1902 | |
06:56 | • Post: Heap buffer overflow in sqlite3StrICmp function artifact: 6916dacf83 user: songliu | |
06:55 | • Reply: Incorrect update caused by subquery in where clause artifact: a6819e8a01 user: TinaCurtis | |
06:53 | • Post: System.Data.SQLite Downloads artifact: 007bb3e5b0 user: AAsk1902 | |
06:46 | • Post: Error in executing recoverbuild.test from "make test" after cloning and building sqlite artifact: 52939e54a5 user: KevinYouren | |
02:44 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 1d11497de7 user: anonymous | |
2 Years Ago (more context)
2022-04-14
| ||
20:31 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 92ab54f8be user: cuz | |
20:13 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: e825bf8207 user: larrybr | |
19:57 | • Reply: USING Clause on Full Outer Join Gives Nulls? artifact: e062da8a98 user: drh | |
18:54 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 39a1317d8b user: parker_lutron1101 | |
18:52 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: bcb38843a9 user: parker_lutron1101 | |
18:35 | • Reply: Compare keys without AND statements? artifact: c7a57c7c97 user: cuz | |
18:34 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 880f31fa3c user: dan | |
18:23 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 65d2c99687 user: parker_lutron1101 | |
18:17 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: a4c7a346fd user: larrybr | |
17:33 | • Edit reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 542982906b user: dan | |
17:33 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 5cde70092c user: dan | |
17:16 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 642d4aac2b user: parker_lutron1101 | |
16:46 | • Edit reply: Compare keys without AND statements? artifact: 096c0b71ce user: AAsk1902 | |
16:40 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 6c58ebdd63 user: TripeHound | |
15:57 | • Reply: Compare keys without AND statements? artifact: 8a648c5f9a user: AAsk1902 | |
15:22 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 958c411097 user: larrybr | |
14:48 | • Post: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: 9306d0ee38 user: parker_lutron1101 | |
14:43 | • Reply: Compare keys without AND statements? artifact: ccd461179e user: sqlitening | |
14:33 | • Reply: Compare keys without AND statements? artifact: 8e49230cb0 user: cuz | |
14:18 | • Edit reply: Compare keys without AND statements? artifact: 1fcdc223ca user: sqlitening | |
14:17 | • Reply: Compare keys without AND statements? artifact: 232316eee7 user: sqlitening | |
14:17 | • Reply: Compare keys without AND statements? artifact: a6538550a7 user: gunter_hick | |
14:06 | • Edit reply: Compare keys without AND statements? artifact: 6ef5607ff6 user: sqlitening | |
14:06 | • Reply: Compare keys without AND statements? artifact: 79ea5bc03c user: cuz | |
14:05 | • Reply: Compare keys without AND statements? artifact: 3c108dce05 user: sqlitening | |
13:16 | • Reply: Compare keys without AND statements? artifact: ab41292f26 user: gunter_hick | |
12:41 | • Reply: USING Clause on Full Outer Join Gives Nulls? artifact: 608b658451 user: drh | |
12:39 | • Post: Compare keys without AND statements? artifact: 810e61992f user: sqlitening | |
10:43 | • Reply: USING Clause on Full Outer Join Gives Nulls? artifact: 20ba9748f2 user: ddevienne | |
09:28 | • Post: Understanding SQL queries artifact: 4e67f3780c user: jpandradealmeida | |
09:20 | • Reply: USING Clause on Full Outer Join Gives Nulls? artifact: 9ededf8dba user: larrybr | |
08:10 | • Reply: Learning SQLite Virtual tables artifact: 9d40a1bc19 user: AAsk1902 | |
07:22 | • Reply: USING Clause on Full Outer Join Gives Nulls? artifact: 355d5c0ee4 user: ddevienne | |
06:00 | • Reply: USING Clause on Full Outer Join Gives Nulls? artifact: 1a07333643 user: hanche | |
05:31 | • Reply: Two ways to ALTER TABLE CHANGE COLUMN artifact: ff6b4ff283 user: simonw | |
05:08 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 98a160a216 user: vijayst | |
04:07 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: e667911475 user: vijayst | |
03:23 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 1ab3c0ef08 user: vijayst | |
03:21 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: e79e9716b5 user: vijayst | |
03:18 | • Edit reply: SQLite query takes a longer time for retrieving TEXT fields artifact: 096c95a0f6 user: vijayst | |
03:14 | • Reply: SQLite query takes a longer time for retrieving TEXT fields artifact: afea3ffbec user: vijayst | |
03:05 | • Post: USING Clause on Full Outer Join Gives Nulls? artifact: 2be9589060 user: SeverKetor | |
3 Years Ago (more context)
2021-04-14
| ||
19:23 | • Reply: Pragma compile_options does not show some options artifact: 1b2b604483 user: gonzus | |
18:35 | • Reply: bug:update from virtual table (geopoly),and no return received artifact: 3f833d25e8 user: larrybr | |
18:32 | • Reply: Pragma compile_options does not show some options artifact: 557605027b user: larrybr | |
18:03 | • Reply: Pragma compile_options does not show some options artifact: 2b1cf8d7bd user: kmedcalf | |
17:43 | • Reply: bug:update from virtual table (geopoly),and no return received artifact: 2652003d2a user: kmedcalf | |
17:25 | • Edit reply: Select of text that matches scientific notation format automatically converted to number artifact: 5140b9b103 user: kmedcalf | |
17:21 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: e8d951003b user: kmedcalf | |
17:07 | • Reply: suggest:for geopoly,advice to add primary key like rtree artifact: a2f9cfdebf user: kmedcalf | |
16:50 | • Reply: bug:update from virtual table (geopoly),and no return received artifact: 4142d76a33 user: larrybr | |
15:04 | • Reply: bug:update from virtual table (geopoly),and no return received artifact: 11de38f5a7 user: yh2216 | |
14:35 | • Reply: Only Column Names read from table artifact: fa0346a14a user: yuvraj.jambhle | |
14:27 | • Post: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: abdecf801d user: gonzus | |
14:18 | • Reply: Only Column Names read from table artifact: 89714a7d60 user: yuvraj.jambhle | |
14:14 | • Reply: usage of SHA-1 artifact: 1d1af5fa18 user: odubaj | |
14:10 | • Reply: Pragma compile_options does not show some options artifact: 11b11f756a user: gonzus | |
14:03 | • Reply: usage of SHA-1 artifact: d225ef5b13 user: drh | |
13:59 | • Reply: usage of SHA-1 artifact: eca522e06d user: odubaj | |
13:50 | • Reply: usage of SHA-1 artifact: 91a19b36c6 user: anonymous | |
13:14 | • Reply: usage of SHA-1 artifact: 225af6f87d user: wyoung | |
12:52 | • Reply: bug:update from virtual table (geopoly),and no return received artifact: 0d55e37339 user: larrybr | |
12:33 | • Reply: object name reserved for internal use: sqlite_parameters artifact: e8705f22a0 user: larrybr | |
12:25 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: 28e855b0e0 user: slavin | |
12:14 | • Reply: usage of SHA-1 artifact: 64a67433e7 user: wyoung | |
12:12 | • Reply: object name reserved for internal use: sqlite_parameters artifact: 7a1db0c1f4 user: anonymous | |
11:51 | • Reply: object name reserved for internal use: sqlite_parameters artifact: 78905344f8 user: larrybr | |
11:44 | • Post: usage of SHA-1 artifact: de1c4a92f3 user: odubaj | |
11:36 | • Post: why index table use b-tree not b+tree artifact: b9e0cec903 user: XiongZaiBingGan | |
11:07 | • Edit: bug:update from virtual table (geopoly),and no return received artifact: 5377f0d74b user: yh2216 | |
11:03 | • Reply: Only Column Names read from table artifact: b5788bffc7 user: knu | |
10:50 | • Reply: object name reserved for internal use: sqlite_parameters artifact: 436fc3996d user: stephan | |
10:28 | • Post: object name reserved for internal use: sqlite_parameters artifact: 2457828f46 user: anonymous | |
10:07 | • Post: suggest:for geopoly,advice to add primary key like rtree artifact: 81df8ba14e user: yh2216 | |
09:55 | • Post: bug:update from virtual table (geopoly),and no return received artifact: b8520e11ec user: yh2216 | |
09:35 | • Reply: Only Column Names read from table artifact: 8e7fa4ac7f user: anonymous | |
05:14 | • Reply: Only Column Names read from table artifact: 1c9fd5bbda user: yuvraj.jambhle | |
04:48 | • Reply: Only Column Names read from table artifact: 851bc475cd user: wyoung | |
04:27 | • Reply: Only Column Names read from table artifact: 150057b782 user: yuvraj.jambhle | |
4 Years Ago (more context)
2020-04-14
| ||
21:18 | • Reply: Why is foreign key support based on the connection? artifact: f99d13712f user: kmedcalf | |
19:23 | • Reply: Return boolean if item EXISTS in database artifact: fbb6969012 user: cladisch | |
19:21 | • Reply: Possible transaction issues on handling multiple databases shared by multiple connections artifact: d4e9cf6b7c user: kmedcalf | |
19:17 | • Reply: Memory leak when calling sqlite3_exec() artifact: 7105d87f73 user: kmedcalf | |
18:55 | • Reply: sqlite3_bind_text16 & weird AI artifact: 0950e7a65b user: LarryBrasfield | |
18:53 | • Reply: Why is foreign key support based on the connection? artifact: 516ddec1c1 user: Cubi73 | |
18:44 | • Reply: Why is foreign key support based on the connection? artifact: 4b8e5fc6a4 user: Cubi73 | |
18:41 | • Post: Update Crashed my Program artifact: f6d0ebb753 user: anonymous | |
18:30 | • Reply: doc: prepare.html: nByte performance advantage? artifact: f0fc8eab35 user: ma11hew28 | |
18:28 | • Reply: doc: prepare.html: nByte performance advantage? artifact: 76ba57b613 user: ma11hew28 | |
18:05 | • Post: sqlite3_bind_text16 & weird AI artifact: f488a388ad user: anonymous | |
17:56 | • Reply: Speed optimization for big single tabel searches artifact: 6cc7422de4 user: andytolle | |
17:51 | • Reply: Troubleshooting corrupt indexes artifact: 1ac80bdcb6 user: drh | |
17:48 | • Reply: Troubleshooting corrupt indexes artifact: f934a0708e user: snej | |
17:34 | • Reply: Troubleshooting corrupt indexes artifact: 9912f266da user: snej | |
17:14 | • Reply: Troubleshooting corrupt indexes artifact: 6f0059d018 user: snej | |
17:08 | • Reply: Multi-column Foreign Key with one "hard-coded" column value artifact: 2d98182ec9 user: ddevienne | |
16:32 | • Reply: Trace queries from external application on SQLite file artifact: 2c7313d3b5 user: ddevienne | |
16:22 | • Reply: Multi-column Foreign Key with one "hard-coded" column value artifact: acd259b417 user: ddevienne | |
16:06 | • Reply: Trace queries from external application on SQLite file artifact: bd0a870fc0 user: slavin | |
16:01 | • Reply: doc: prepare.html: nByte performance advantage? artifact: 6d2099ce17 user: dan | |
16:00 | • Reply: Why is foreign key support based on the connection? artifact: c5dc50f61b user: vman59 | |
15:59 | • Reply: Why is foreign key support based on the connection? artifact: dc28eab7bd user: slavin | |
15:56 | • Reply: doc: prepare.html: nByte performance advantage? artifact: a3ad7e9ed8 user: RichardDamon | |
15:44 | • Reply: doc: prepare.html: nByte performance advantage? artifact: bed10ccb0a user: stephan | |
15:37 | • Reply: Multi-column Foreign Key with one "hard-coded" column value artifact: 8957f3582d user: ddevienne | |
15:27 | • Reply: doc: prepare.html: nByte performance advantage? artifact: 16a4c9ac46 user: ma11hew28 | |
15:08 | • Reply: Multi-column Foreign Key with one "hard-coded" column value artifact: cf45505ecf user: ddevienne | |
15:02 | • Reply: Speed optimization for big single tabel searches artifact: afd22ce59e user: dvdraymond | |
14:52 | • Reply: Multi-column Foreign Key with one "hard-coded" column value artifact: 8f49dbdfc4 user: dvdraymond | |
14:42 | • Post: Speed optimization for big single tabel searches artifact: fdfa527726 user: andytolle | |
14:18 | • Post: Multi-column Foreign Key with one "hard-coded" column value artifact: 8a2744dc22 user: ddevienne | |
14:16 | • Reply: Retrieve match context with FTS5 artifact: b192c0e673 user: dan | |
14:02 | • Reply: Possible transaction issues on handling multiple databases shared by multiple connections artifact: de50afcbc8 user: dan | |
13:55 | • Reply: Troubleshooting corrupt indexes artifact: cb78ada959 user: dan | |
13:37 | • Post: Why is foreign key support based on the connection? artifact: 1b7de075bc user: Cubi73 | |
11:06 | • Reply: Possible transaction issues on handling multiple databases shared by multiple connections artifact: a552e54f7c user: leandro | |
11:04 | • Reply: Possible transaction issues on handling multiple databases shared by multiple connections artifact: b54ddf3b45 user: leandro | |
11:01 | • Edit reply: Memory leak when calling sqlite3_exec() artifact: 127dec782d user: drh | |
10:30 | • Reply: Return boolean if item EXISTS in database artifact: c5b17895ab user: PongoZ | |
09:27 | • Reply: Memory leak when calling sqlite3_exec() artifact: 0280b9919f user: kwontmdwo | |
09:25 | • Reply: Memory leak when calling sqlite3_exec() artifact: 7a4041911d user: kwontmdwo | |
09:22 | • Reply: Memory leak when calling sqlite3_exec() artifact: 70b9a19a19 user: kwontmdwo | |
07:55 | • Reply: Trace queries from external application on SQLite file artifact: d9087cef8c user: stephan | |
07:46 | • Reply: How does one search this forum? artifact: c38e5f791d user: anonymous | |
07:44 | • Post: Trace queries from external application on SQLite file artifact: ef11197163 user: pseduo-nym | |
07:39 | • Reply: Memory leak when calling sqlite3_exec() artifact: 8b34b741fc user: anonymous | |
05:30 | • Reply: Memory leak when calling sqlite3_exec() artifact: c0d8e04a98 user: kmedcalf | |
05:14 | • Edit reply: Memory leak when calling sqlite3_exec() artifact: 6dea02b87d user: slavin | |
05:14 | • Reply: Memory leak when calling sqlite3_exec() artifact: be05ef15a5 user: slavin | |
01:17 | • Edit reply: doc: prepare.html: nByte performance advantage? artifact: e4c52591bb user: LarryBrasfield | |
01:17 | • Reply: doc: prepare.html: nByte performance advantage? artifact: 2a88757e05 user: LarryBrasfield | |
00:58 | • Post: Memory leak when calling sqlite3_exec() artifact: 4b0694a1e0 user: kwontmdwo | |