SQLite User Forum

Today In History
Login

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