SQLite User Forum

Today In History
Login

This Day In History For 2024-04-03

1 Year Ago (more context)

2023-04-03
23:53 Reply: Assertion failure in sqlite3WhereEnd function (2) artifact: 40e08497b0 user: songliu
20:15 Reply: wal.c - walChecksumBytes() artifact: 13a0d2a25b user: larrybr
19:48 Post: wal.c - walChecksumBytes() artifact: d1b226262d user: Martijn37
18:02 Reply: Assertion failure in sqlite3ExprAffinity function artifact: dcd5f35496 user: songliu
18:02 Reply: Assertion failure in sqlite3ExprSkipCollateAndLikely function artifact: ab2247b44f user: songliu
18:02 Reply: SQLite compilation error in VxWorks RTP project artifact: 9b6213c6be user: larrybr
17:36 Reply: Support Binary representation like 0b01 artifact: 5e0649abb4 user: larrybr
17:34 Reply: Complex condition: comparing and min artifact: 9def75bf24 user: dvdraymond
17:23 Reply: Support Binary representation like 0b01 artifact: 93f5d25e3d user: anonymous
17:21 Reply: Should I copy the DB to tmpfs? artifact: 37fb38a972 user: LcccXmm
17:16 Reply: Complex condition: comparing and min artifact: d90375f449 user: Clothears
17:09 Post: Assertion failure in sqlite3WhereEnd function (2) artifact: 409ebc7368 user: songliu
17:05 Post: Assertion failure in sqlite3ExprSkipCollateAndLikely function artifact: 44270909bb user: songliu
17:02 Post: Assertion failure in sqlite3ExprAffinity function artifact: e45108732c user: songliu
16:55 Reply: Support Binary representation like 0b01 artifact: 0b4b84ffa8 user: kmedcalf
16:54 Reply: Support Binary representation like 0b01 artifact: c8dc8b990a user: kmedcalf
16:46 Reply: Support Binary representation like 0b01 artifact: 5412ef371b user: larrybr
16:09 Reply: Support Binary representation like 0b01 artifact: b37e7af50a user: anonymous
16:06 Post: Complex condition: comparing and min artifact: 6d1efb2f16 user: Eugen0ru
16:03 Reply: Questions about sequence of Triggers with same conditions artifact: 92fd43401d user: kmedcalf
15:45 Reply: Android - SQL Commands artifact: 5f50817d0a user: JonathanD
15:39 Reply: Support Binary representation like 0b01 artifact: 6d04d2b2f5 user: kmedcalf
15:36 Post: Questions about sequence of Triggers with same conditions artifact: fc3ec12cf9 user: UserMBL
15:31 Reply: Support Binary representation like 0b01 artifact: 8ecff686ae user: jicman
15:30 Reply: Should I copy the DB to tmpfs? artifact: 4acbde66c9 user: kmedcalf
15:26 Reply: Support Binary representation like 0b01 artifact: 81b8981ea4 user: anonymous
15:25 Reply: Should I copy the DB to tmpfs? artifact: c91aea0035 user: dkfellows
15:19 Reply: Support Binary representation like 0b01 artifact: b452187879 user: dkfellows
14:15 Edit reply: Error 141 ?? artifact: 352ca80953 user: lexfiend
14:13 Edit reply: Error 141 ?? artifact: 7a7c9b5702 user: lexfiend
14:04 Reply: Error 141 ?? artifact: 065e136c9e user: lexfiend
11:01 Reply: On secondary indexes is rowid automatically sorted artifact: 0e6316ac9e user: curmudgeon
10:49 Reply: On secondary indexes is rowid automatically sorted artifact: aea4c60cc1 user: drh
10:45 Reply: Is SHM needed for Main DB? artifact: 101de816f3 user: drh
10:37 Reply: base64.c is executable? artifact: 85a2ad5da5 user: drh
09:59 Post: SQLite compilation error in VxWorks RTP project artifact: 0f9d6ea16a user: SwapnilV
08:46 Post: Is SHM needed for Main DB? artifact: 97b3be2754 user: Nikratio
08:23 Reply: On secondary indexes is rowid automatically sorted artifact: dfdef5c91c user: curmudgeon
07:31 Edit: how to insert multiple records at the same location: Geopoly artifact: d1d7685614 user: punkish
07:31 Post: how to insert multiple records at the same location: Geopoly artifact: bb046a4c08 user: punkish
07:17 Reply: Android - SQL Commands artifact: 1b7290c78d user: DiamondJohn
07:15 Reply: Should I copy the DB to tmpfs? artifact: 18b25657b7 user: DiamondJohn
07:10 Post: with app.app_context: artifact: 69bf680dd0 user: anonymous
06:24 Reply: Should I copy the DB to tmpfs? artifact: 72d9728213 user: spindrift
03:38 Reply: Should I copy the DB to tmpfs? artifact: 9c52ed021f user: kmedcalf
03:34 Reply: Importing csv Files artifact: 04c1e161b5 user: kmedcalf
03:15 Edit reply: invalid handling of named parameters in sqlite3.wasm artifact: a239ba528a user: stephan
02:07 Post: How can a window function replace this subquery to form a grouping? artifact: e4d1b055e3 user: 1codedebugger
00:51 Post: Should I copy the DB to tmpfs? artifact: b2269f964e user: LcccXmm
00:39 Reply: base64.c is executable? artifact: e25cfaf9c5 user: brickviking
00:26 Reply: base64.c is executable? artifact: c43cdc3849 user: brickviking
00:04 Reply: Importing csv Files artifact: e6c08afd39 user: anonymous

2 Years Ago (more context)

2022-04-03
20:55 Post: SQLIte v3.37.0 and sqlite3_create_function issue artifact: e6cb309c3b user: spiedave
16:43 Edit reply: Multi-threaded C# test for SQLite fails with 'database table is locked' artifact: f916e5f262 user: kmedcalf
15:15 Reply: load_extension to overide existing function artifact: 5a28211b36 user: nalgeon
14:40 Reply: Documentation error? artifact: fce6348fed user: kmedcalf
13:59 Post: Documentation error? artifact: 1caeb3a86f user: paulvh
13:10 Reply: Creating an empty table with no columns artifact: 8bae4e4086 user: kjames3411
12:08 Reply: unable to open database file on server artifact: bfdf3d973b user: slavin
09:47 Post: unable to open database file on server artifact: 2543ecc014 user: xela.sw
08:15 Reply: Links in documentation artifact: be7fb0a595 user: larrybr
07:16 Edit reply: Links in documentation artifact: e5410c1448 user: baruch
07:11 Reply: Links in documentation artifact: a800d50c93 user: baruch

3 Years Ago (more context)

2021-04-03
23:27 Reply: Command Line Shell set parameter as date artifact: 7dc925fc87 user: kmedcalf
23:19 Post: SQLite Plus: all the missing SQLite functions artifact: 2574e65458 user: slavin
21:06 Reply: In C API, do prepared statements of simple inserts execute repeatedly even if not reset? artifact: 4b0f6e0ca4 user: itandetnik
20:18 Post: .import csv and NULL values artifact: 9da85fe4fc user: w.oertl
20:13 Reply: Command Line Shell set parameter as date artifact: cce8a228de user: hanche
19:12 Reply: In C API, do prepared statements of simple inserts execute repeatedly even if not reset? artifact: 77f344e74d user: 1codedebugger
19:06 Reply: How to dump a table to a TSV file but escape characters properly artifact: 572925f16e user: anonymous
18:12 Reply: How to dump a table to a TSV file but escape characters properly artifact: 6c74cf7d40 user: kmedcalf
17:05 Post: How to dump a table to a TSV file but escape characters properly artifact: f68281a41d user: 6kEs4Majrd
16:50 Post: SQLITE with Roundcube performance artifact: 505b664749 user: StefanoLeandro
16:14 Edit: Usable size bugs in dbdata.c and showdb.c artifact: 7a415a0f0c user: hardisk0
16:05 Post: Usable size bugs in dbdata.c and showdb.c artifact: b50ac99ad3 user: hardisk0
15:58 Reply: Problem with single quotes Swift/MacOS artifact: 2f67794269 user: frameworker74
14:36 Reply: Problem with single quotes Swift/MacOS artifact: 58ca3c3b67 user: anonymous
14:35 Reply: In C API, do prepared statements of simple inserts execute repeatedly even if not reset? artifact: 72040cc6ec user: kmedcalf
14:25 Reply: In C API, do prepared statements of simple inserts execute repeatedly even if not reset? artifact: 0045cf952d user: kmedcalf
14:19 Reply: In C API, do prepared statements of simple inserts execute repeatedly even if not reset? artifact: ac041041cf user: kmedcalf
13:51 Edit reply: Problem with single quotes Swift/MacOS artifact: b2a737c09d user: larrybr
13:48 Reply: Problem with single quotes Swift/MacOS artifact: ff3283bb27 user: kmedcalf
13:40 Reply: Problem with single quotes Swift/MacOS artifact: 5f981c2d59 user: larrybr
13:13 Post: Problem with single quotes Swift/MacOS artifact: ae2e931b46 user: frameworker74
07:49 Reply: In C API, do prepared statements of simple inserts execute repeatedly even if not reset? artifact: ef5cd6780c user: SirHumphreyAppleby
06:17 Post: In C API, do prepared statements of simple inserts execute repeatedly even if not reset? artifact: 5d1b54dd09 user: 1codedebugger
05:08 Post: About virutal table and FTS4 artifact: 43cac36b7e user: 6kEs4Majrd
02:21 Edit: Lemon - Unexpected frees artifact: f50df93e2d user: SirHumphreyAppleby
02:21 Edit: Lemon - Unexpected frees artifact: 5c7f483c0f user: SirHumphreyAppleby (unpublished)
01:14 Post: Lemon - Unexpected frees artifact: 86a0929035 user: SirHumphreyAppleby

4 Years Ago (more context)

2020-04-03
22:57 Post: How does one search this forum? artifact: d13c2f6f48 user: lcarlp
22:20 Reply: -nocreate -- shell tool feature request/offer artifact: 8ebfc83cb0 user: tonyp
21:36 Reply: PROBLEM WITH TRANSACTION artifact: 077b7fcd94 user: wyoung
20:11 Post: -nocreate -- shell tool feature request/offer artifact: 07e3158098 user: LarryBrasfield
19:33 Reply: Inserting multiple rows in table artifact: c28d18c9b2 user: richs
19:25 Reply: Best order to vaccum, analyze, create indexes, etc.. ? artifact: 4982b03455 user: kmedcalf
19:17 Reply: PROBLEM WITH TRANSACTION artifact: 107ba7da9d user: kmedcalf
19:12 Post: PSA: All books in the ACM digital library are free to download for the next 3 months artifact: 6453c37af7 user: andreas-kupries
19:10 Reply: PROBLEM WITH TRANSACTION artifact: 615c0b62bd user: stephan
19:03 Post: PROBLEM WITH TRANSACTION artifact: ab185c1bc7 user: anonymous
17:45 Reply: Best order to vaccum, analyze, create indexes, etc.. ? artifact: d4a5564bfc user: ddevienne
17:37 Reply: Inserting multiple rows in table artifact: 4565eb8cd9 user: kmedcalf
17:24 Reply: Best order to vaccum, analyze, create indexes, etc.. ? artifact: 41d907af3b user: dvdraymond
17:19 Reply: Inserting multiple rows in table artifact: 9e275aa217 user: LarryBrasfield
17:12 Reply: Inserting multiple rows in table artifact: fd555b3037 user: stephan
16:48 Reply: Inserting multiple rows in table artifact: 31ffcb6f1f user: richs
16:33 Reply: Best order to vaccum, analyze, create indexes, etc.. ? artifact: 214e8324c3 user: ddevienne
16:17 Reply: Inserting multiple rows in table artifact: ffb93636ef user: richs
16:09 Reply: Inserting multiple rows in table artifact: c556834e42 user: LarryBrasfield
16:08 Edit reply: Opening a database without creating a new one and Error logging artifact: ce4f502e98 user: drh
16:05 Reply: Inserting multiple rows in table artifact: a0465a2f0a user: richs
16:02 Reply: Opening a database without creating a new one and Error logging artifact: 8824fc13a6 user: luuk
15:57 Reply: Inserting multiple rows in table artifact: 919dab46df user: TripeHound
15:41 Post: Inserting multiple rows in table artifact: 6210f4cdfe user: richs
15:40 Reply: Best order to vaccum, analyze, create indexes, etc.. ? artifact: 62fb63a29c user: drh
15:28 Post: Best order to vaccum, analyze, create indexes, etc.. ? artifact: c3f766ce9d user: ddevienne
14:35 Reply: Natural sort order artifact: 51f6f9dbe3 user: hatfinch
14:16 Reply: Natural sort order artifact: 562eb5b4c7 user: resuna
14:14 Reply: Natural sort order artifact: 4d63f77951 user: resuna
05:45 Post: RENAME COLUMN incomplete documentation artifact: d1d30e8d37 user: jeffrey
00:39 Reply: Not seeing error, fresh eyeballs may help artifact: 3351cd33ea user: richs
00:38 Reply: Not seeing error, fresh eyeballs may help artifact: b27ed12ca9 user: richs
00:22 Edit reply: Not seeing error, fresh eyeballs may help artifact: 5cd315145c user: vman59
00:20 Delete reply: Not seeing error, fresh eyeballs may help artifact: 00846b6e4b user: vman59
00:20 Reply: Not seeing error, fresh eyeballs may help artifact: e817f08081 user: vman59
00:06 Reply: Not seeing error, fresh eyeballs may help artifact: 2de0c7d808 user: richs
00:02 Reply: Not seeing error, fresh eyeballs may help artifact: 3a70e49b04 user: kmedcalf