SQLite User Forum

Today In History
Login

This Day In History For 2024-03-17

1 Year Ago (more context)

2023-03-17
21:41 Reply: Metadata missing for generated columns artifact: d332a682a2 user: midijohnny
21:11 Reply: The Bytecode() And Tables_Used() Table-Valued Functions artifact: 37a43e78e1 user: anonymous
20:38 Reply: How to use VACUUM INTO? artifact: c2a67c5270 user: drh
20:06 Post: How to use VACUUM INTO? artifact: 5bc9fadbaa user: anonymous
19:56 Reply: BLOB and Lazarus artifact: 3443aca806 user: anonymous
19:34 Reply: macos vs Linux using sqlite3_column_text artifact: dd0862912f user: ghenry
19:33 Reply: macos vs Linux using sqlite3_column_text artifact: d225c317db user: ghenry
19:33 Reply: macos vs Linux using sqlite3_column_text artifact: 8495d39c1e user: ghenry
19:28 Reply: Close all open connections artifact: d45e58791a user: kmedcalf
19:15 Reply: Close all open connections artifact: fb227d183b user: AAsk1902
17:32 Reply: Close all open connections artifact: 86b59fac44 user: 111111
17:10 Reply: Close all open connections artifact: fcf1be2587 user: kmedcalf
17:07 Reply: ANN SQLite in the Cloud: The Future of Lightweight Databases artifact: 8c5e4fdee8 user: kmedcalf
17:00 Reply: ANN SQLite in the Cloud: The Future of Lightweight Databases artifact: 047ef2f21a user: kmedcalf
16:57 Reply: BLOB and Lazarus artifact: ed2ea9d141 user: kmedcalf
16:55 Reply: Close all open connections artifact: 1c155a30d6 user: 111111
16:53 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: 27a208c5cc user: slavin
16:49 Reply: ANN SQLite in the Cloud: The Future of Lightweight Databases artifact: 0415988cea user: slavin
16:31 Reply: BLOB and Lazarus artifact: f9d8ef5938 user: anonymous
16:26 Reply: Close all open connections artifact: 490e7b89e7 user: stephan
16:22 Post: Close all open connections artifact: 8de8807665 user: 111111
16:03 Reply: VACUUM changing ROWID on tables without an index artifact: b9fca923f0 user: larrybr
16:01 Reply: macos vs Linux using sqlite3_column_text artifact: d3b4448a45 user: dkfellows
16:00 Reply: VACUUM changing ROWID on tables without an index artifact: 9d2d4796c1 user: drh
15:53 Post: VACUUM changing ROWID on tables without an index artifact: 5c5a8b0eef user: nackerma
15:44 Reply: BLOB and Lazarus artifact: e3079e8392 user: dkfellows
15:39 Reply: BLOB and Lazarus artifact: afa51efd4a user: antlor
15:38 Reply: How to create a custom function that imitates LEFT() from MySQL? artifact: ff0bac4fe5 user: dkfellows
15:36 Reply: macos vs Linux using sqlite3_column_text artifact: 9c21577fff user: larrybr
15:32 Reply: macos vs Linux using sqlite3_column_text artifact: cb946043e8 user: larrybr
15:23 Reply: macos vs Linux using sqlite3_column_text artifact: 74f1553db6 user: ghenry
15:21 Post: BLOB and Lazarus artifact: f27bb9988f user: anonymous
15:15 Reply: Which package provides SQLite Java driver on Ubuntu 22.04? artifact: ebd0683949 user: dkfellows
15:12 Reply: LTR language support (Hebrew in this case) artifact: cd1c8524a2 user: mandolyte
15:10 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: ddb5e29dc9 user: larrybr
14:55 Edit reply: Add IMMEDIATE/EXCLUSIVE support to SAVEPOINT? artifact: 41939e2c99 user: kmedcalf
14:45 Reply: Add IMMEDIATE/EXCLUSIVE support to SAVEPOINT? artifact: 0ec48af04d user: kmedcalf
14:09 Reply: macos vs Linux using sqlite3_column_text artifact: e6181c41ff user: drh
14:05 Reply: macos vs Linux using sqlite3_column_text artifact: 0e6845fe50 user: ghenry
14:02 Reply: JOIN using IN operator artifact: 904a5341de user: kmedcalf
13:51 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: 89d15f78db user: jicman
13:51 Edit reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: d83b1966e5 user: maikbe
13:50 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: c921965db1 user: maikbe
13:42 Edit reply: JOIN using IN operator artifact: b71649b82b user: kmedcalf
13:40 Delete reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: 06e3e6b7aa user: maikbe
13:39 Reply: JOIN using IN operator artifact: 6bdb88054d user: kmedcalf
13:22 Reply: Incorrect updated valued caused by subquery in the set list artifact: 3adb8a074e user: zuming_jiang
13:10 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: cd92f0aee1 user: maikbe
13:07 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: 2177aa92b4 user: maikbe
12:32 Reply: macos vs Linux using sqlite3_column_text artifact: 9681fb3200 user: drh
12:12 Post: macos vs Linux using sqlite3_column_text artifact: e77cc2c24e user: ghenry
12:11 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: 84b2597014 user: drh
12:03 Reply: Incorrect updated valued caused by subquery in the set list artifact: 33151fde55 user: drh
11:39 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: 1f4f450786 user: jicman
11:28 Reply: Some additions to the Next.js demos artifact: f5b6a08a25 user: stephan
11:22 Reply: Which package provides SQLite Java driver on Ubuntu 22.04? artifact: 40a05a4c1f user: bobhairgrove
10:42 Reply: JOIN using IN operator artifact: 2bd2b5084e user: communy
10:05 Post: The Bytecode() And Tables_Used() Table-Valued Functions artifact: 7ff7d76d76 user: curmudgeon
08:49 Post: Which package provides SQLite Java driver on Ubuntu 22.04? artifact: effee5818a user: noloader
03:19 Reply: Linux process cannot write to sqlite database artifact: ec7807987d user: sqweek
03:10 Reply: LTR language support (Hebrew in this case) artifact: 32c7f5b526 user: larrybr
03:09 Reply: LTR language support (Hebrew in this case) artifact: 8794542810 user: sqweek
02:49 Reply: LTR language support (Hebrew in this case) artifact: aedac910d7 user: codehz
02:35 Reply: LTR language support (Hebrew in this case) artifact: 632ff1d32f user: codehz
02:07 Post: LTR language support (Hebrew in this case) artifact: d1bda4e17b user: mandolyte
00:53 Reply: Assertion violation and Heap Buffer Overflow - Grammar-based Fuzzers artifact: c23afee308 user: drh

2 Years Ago (more context)

2022-03-17
23:40 Reply: Introduction a Quick SQLite Cmd/Script Tools artifact: 3908dd1405 user: anonymous
20:55 Reply: .mode column artifact: b57ff67877 user: SeverKetor
20:18 Post: Inconsistent error codes after SQLITE_DENY from authorization callback artifact: b3224d0914 user: sjlombardo
18:46 Reply: .mode column artifact: b7802eb222 user: anonymous
18:04 Edit reply: .mode column artifact: 8f3ceb0ca0 user: stephan
17:58 Reply: .mode column artifact: 4b0823c33d user: larrybr
17:39 Reply: .mode column artifact: 18ac464781 user: kmedcalf
17:33 Reply: .mode column artifact: b4d0912c92 user: anonymous
17:21 Reply: .mode column artifact: 282d0ed197 user: anonymous
15:59 Reply: .mode column artifact: 8f29bd3b90 user: kmedcalf
15:46 Reply: Dump and insert instead of vacuum artifact: bf66d4e3b7 user: lexfiend
14:59 Reply: .mode column artifact: 3975e714d3 user: larrybr
11:11 Edit reply: Performance Analysis artifact: 9aa5e1dcff user: danshearer
11:08 Reply: Performance Analysis artifact: 4c324e1422 user: danshearer
10:30 Post: Dump and insert instead of vacuum artifact: 8f99fbb8c5 user: anonymous
09:43 Post: .mode column artifact: fb79d3dc2f user: anonymous
06:52 Reply: Performance Analysis artifact: 7067d3de83 user: slavin
02:26 Edit reply: Prevent Automatic Rounding? artifact: 8fd0d20781 user: sqlitening
02:24 Edit reply: Prevent Automatic Rounding? artifact: 6ca3c45b47 user: sqlitening
02:24 Edit reply: Prevent Automatic Rounding? artifact: 45cf70d1dc user: sqlitening
02:16 Edit reply: Prevent Automatic Rounding? artifact: dfc7c952f8 user: sqlitening
02:13 Edit reply: Prevent Automatic Rounding? artifact: 3245872cc6 user: sqlitening
02:10 Edit reply: Prevent Automatic Rounding? artifact: 972f3a68af user: sqlitening
00:46 Edit reply: Prevent Automatic Rounding? artifact: ca4226851c user: sqlitening
00:28 Edit reply: Prevent Automatic Rounding? artifact: b1e11f9548 user: sqlitening
00:27 Edit reply: Prevent Automatic Rounding? artifact: 4b07ecdbf1 user: sqlitening
00:26 Edit reply: Prevent Automatic Rounding? artifact: c48ac66442 user: sqlitening
00:23 Edit reply: Prevent Automatic Rounding? artifact: 32850feee0 user: sqlitening
00:22 Edit reply: Prevent Automatic Rounding? artifact: af10ad57ce user: sqlitening
00:19 Edit reply: Prevent Automatic Rounding? artifact: 86b7b06d1d user: sqlitening
00:17 Edit reply: Prevent Automatic Rounding? artifact: adb6ff3fc9 user: sqlitening
00:14 Reply: Prevent Automatic Rounding? artifact: 570578c703 user: sqlitening

3 Years Ago (more context)

2021-03-17
23:48 Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: 07c3936a79 user: TripeHound
23:41 Reply: SQL to return list of PRAGMAs artifact: 864a367842 user: anonymous
23:37 Reply: Serious problems with STORED columns artifact: 019b1d1880 user: cuz
23:36 Reply: SQL to return list of PRAGMAs artifact: a4f01b607d user: anonymous
23:05 Edit reply: SQL to return list of PRAGMAs artifact: 42a42397df user: vman59
23:02 Reply: Serious problems with STORED columns artifact: 696547a787 user: larrybr
23:02 Post: Minor typo in documentation artifact: b971bc8fb7 user: balaji
22:58 Reply: Serious problems with STORED columns artifact: f2b54614c7 user: cuz
22:56 Reply: SQL to return list of PRAGMAs artifact: 1953aeea9e user: vman59
22:45 Reply: Serious problems with STORED columns artifact: 893643be83 user: cuz
22:16 Reply: Serious problems with STORED columns artifact: aa913a775c user: doug9forester
20:22 Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: 02ee2dc2dd user: kmedcalf
20:18 Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: 6077aefb38 user: kmedcalf
20:15 Reply: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: c0c79cb0d7 user: kmedcalf
18:59 Reply: sqlite 3.35 stalls tracker-miner-fs-3 artifact: 737cf80ece user: drh
18:31 Reply: Runtime of and opcode counts of ANALYZE artifact: 7a16bb0d02 user: macsql20
18:25 Reply: Serious problems with STORED columns artifact: 33283001e1 user: dvdraymond
17:52 Reply: Serious problems with STORED columns artifact: e21f2ff0be user: knu
17:46 Reply: SQL to return list of PRAGMAs artifact: 318944bf6b user: knu
17:34 Reply: Serious problems with STORED columns artifact: ce9c92228e user: doug9forester
16:42 Reply: Getting the error artifact: dfdca248ad user: oneeyeman
16:40 Reply: Getting the error artifact: c6f8091325 user: oneeyeman
16:05 Edit reply: Getting the error artifact: 00695d669d user: gunter_hick
16:04 Reply: Getting the error artifact: f36dca5982 user: gunter_hick
16:00 Reply: Getting the error artifact: a59c7ba43f user: dvdraymond
15:57 Edit reply: Getting the error artifact: bbb733aa7b user: gunter_hick
15:56 Reply: Getting the error artifact: 58a0ef46bb user: gunter_hick
15:45 Edit reply: Getting the error artifact: 59eb2f5751 user: oneeyeman
15:44 Reply: Getting the error artifact: 78fd7a3ace user: oneeyeman
14:21 Reply: Missing records from the IN list artifact: 611ec72a6b user: jicman
14:13 Edit: Math functions for arguments outside the domain should raise exception according to SQL Standard artifact: a2b131febb user: tarest
14:03 Reply: Getting the error artifact: d924caf0b4 user: oneeyeman
12:51 Edit reply: sqlite 3.35 stalls tracker-miner-fs-3 artifact: 140a67d3d2 user: drh
12:46 Reply: sqlite 3.35 stalls tracker-miner-fs-3 artifact: e859b13c2d user: anonymous
12:17 Edit reply: INSERT SELECT form can leak (tested on 3.28.0) artifact: 347dc39334 user: drh
11:31 Reply: SQL to return list of PRAGMAs artifact: 07a93b0068 user: anonymous
11:28 Post: Parametrized queries with table-valued syntax (suggestion and virtual tables solution) artifact: 8f0351af38 user: Maxulite
11:10 Reply: Runtime of and opcode counts of ANALYZE artifact: 1c4a62d569 user: larrybr
10:43 Reply: SQL to return list of PRAGMAs artifact: 7c3e45c4ec user: ddevienne
09:35 Post: SQL to return list of PRAGMAs artifact: ff153ba0b5 user: anonymous
08:11 Reply: Runtime of and opcode counts of ANALYZE artifact: 0877dc8b5a user: macsql20
07:49 Edit reply: Getting the error artifact: 8f41067afb user: gunter_hick
07:48 Reply: Getting the error artifact: d9c033ae6a user: gunter_hick
06:40 Post: Getting the error artifact: 7f4dda1460 user: oneeyeman
03:44 Reply: INSERT SELECT form can leak (tested on 3.28.0) artifact: c5f7ccd9a0 user: rmariani
03:36 Reply: INSERT SELECT form can leak (tested on 3.28.0) artifact: b61d8f551f user: rmariani
00:53 Reply: Serious problems with STORED columns artifact: 7c47c8fd97 user: RichardDamon

4 Years Ago (more context)

2020-03-17
20:21 Reply: Convert datetime string to second since Epoch with millisecond precision artifact: f6e48c509f user: anonymous
20:07 Reply: Convert datetime string to second since Epoch with millisecond precision artifact: 5f4e1aa322 user: kmedcalf
17:57 Reply: Improved virtual tables artifact: 0d8a18dd00 user: anonymous
17:54 Reply: Convert datetime string to second since Epoch with millisecond precision artifact: b5f94212df user: punkish
17:23 Reply: Convert datetime string to second since Epoch with millisecond precision artifact: 387f55b7a5 user: ddevienne
17:15 Reply: Convert datetime string to second since Epoch with millisecond precision artifact: 6072cce000 user: kmedcalf
16:09 Post: Convert datetime string to second since Epoch with millisecond precision artifact: 0d9c338ff1 user: ddevienne
15:06 Reply: Renaming a database artifact: 0fac4800f5 user: stephan
14:42 Post: Renaming a database artifact: 8f5fd27bc5 user: tobydickenson
08:33 Reply: Compiling without the amalgamation process artifact: e5b37b3a74 user: anonymous
06:00 Reply: Slow query (~20x faster when run as two separate queries) artifact: 9f287a4aec user: kmedcalf
03:53 Post: Slow query (~20x faster when run as two separate queries) artifact: e4091b433a user: Izkata
01:55 Reply: sqlite write performance is slower than the filesystem artifact: 3f7b7f9530 user: sqweek
00:25 Edit: (Deleted) artifact: 953c471596 user: MikeRixWolfe