SQLite User Forum

Today In History
Login

This Day In History For 2023-07-23

1 Year Ago (more context)

2022-07-23
21:19 Reply: Copy file while transaction runs on a read-only connection? artifact: d683fddb2a user: shawnbrown
19:28 Reply: question about SQLITE_FULL error and Rollback. artifact: 656007ab6f user: kmedcalf
19:07 Reply: question about SQLITE_FULL error and Rollback. artifact: a5d3edcbff user: kmedcalf
16:54 Reply: question about SQLITE_FULL error and Rollback. artifact: 8b65ea6b2f user: anonymous
16:18 Edit reply: question about SQLITE_FULL error and Rollback. artifact: bf3eee8a1c user: kmedcalf
16:17 Reply: question about SQLITE_FULL error and Rollback. artifact: ccc9b71594 user: kmedcalf
13:19 Reply: question about SQLITE_FULL error and Rollback. artifact: 28d3045a4e user: anonymous
11:39 Reply: Data-modifying query in CTE artifact: fa7bf95021 user: coleifer
10:09 Reply: Request for JSON column affinity artifact: 9e39f3e45e user: stephan
09:21 Edit: Request for JSON column affinity artifact: b0c87d538d user: EriccG
09:21 Post: Request for JSON column affinity artifact: 76b6870926 user: EriccG
05:43 Post: question about SQLITE_FULL error and Rollback. artifact: 1f77b0921c user: anonymous
00:41 Reply: max() function broken artifact: b0d80dc775 user: SunnySaini_com

2 Years Ago (more context)

2021-07-23
23:54 Reply: ALTER TABLE DROP COLUMN corrupts data artifact: ec86256907 user: drh
23:36 Reply: ALTER TABLE DROP COLUMN corrupts data artifact: e6a6b862d6 user: chrisbrody
23:17 Reply: ALTER TABLE DROP COLUMN corrupts data artifact: ac6086ecde user: drh
22:31 Reply: ALTER TABLE DROP COLUMN corrupts data artifact: 6485501bbe user: chrisbrody
22:03 Reply: Can SQLite be used with AWS Elastic File System (EFS)? artifact: d2591c0c6e user: wyoung
21:29 Edit reply: sqlite3 LIKE clause with parameters for c api artifact: 9cc83fb7a8 user: stephan
21:27 Reply: sqlite3 LIKE clause with parameters for c api artifact: 644c06438c user: anonymous
20:59 Reply: sqlite3 LIKE clause with parameters for c api artifact: 9a7993e907 user: stephan
20:52 Post: sqlite3 LIKE clause with parameters for c api artifact: cf208c4d6a user: anonymous
20:12 Reply: Can SQLite be used with AWS Elastic File System (EFS)? artifact: 339d237d65 user: anonymous
17:41 Reply: Random crash doing SELECT artifact: 40d94bcb9d user: rmariani
17:13 Reply: how can i identify the data is just inserted into the database or updated the existed item when i use upsert-clause artifact: 93a759ecd6 user: kmedcalf
15:08 Reply: Random crash doing SELECT artifact: bca162b9fa user: jicman
13:46 Reply: Parse failure doing UPDATE FROM artifact: 69c49867fc user: jicman
12:44 Reply: Parse failure doing UPDATE FROM artifact: 78fc63e142 user: anonymous
12:36 Reply: Parse failure doing UPDATE FROM artifact: 7e1f3d21cf user: stephan
12:30 Post: Parse failure doing UPDATE FROM artifact: 6a4416f903 user: anonymous
11:37 Reply: how can i identify the data is just inserted into the database or updated the existed item when i use upsert-clause artifact: 230045404d user: cuz
10:01 Reply: problem report: incorrect join behavior artifact: 0aec364616 user: mabrand
09:14 Post: how can i identify the data is just inserted into the database or updated the existed item when i use upsert-clause artifact: d085f64f37 user: xliangy
07:36 Reply: Compile error when symbols SQLITE_OMIT_SHARED_CACHE and SQLITE_USER_AUTHENTICATION=1 are both defined artifact: 450632c85d user: aloys
04:22 Reply: How can I calculate trip duration? artifact: 88a9e1d4eb user: ThanksRyan
01:02 Post: FOR IN-OPERATOR optimization doesn't occur through view artifact: 600f887776 user: anacrolix

3 Years Ago (more context)

2020-07-23
23:04 Reply: Issue importing csv file to db artifact: 4a1652d4ac user: LarryBrasfield
22:41 Reply: Multiple read and write calls of web service to access SQLite artifact: c27b7b59ed user: wyoung
22:25 Post: Multiple read and write calls of web service to access SQLite artifact: 5c8714f91f user: abigalexinli
21:41 Edit reply: Finding database file artifact: 7a74c547a3 user: kmedcalf
21:40 Reply: Finding database file artifact: 0dbc91ed9d user: kmedcalf
20:59 Reply: sessionfuzz fails on some architectures (ARM, PPC, SPARC) artifact: c3e9c0edfa user: drh
20:49 Post: Memory Leak in pathsearch function artifact: 69afedbc65 user: kleber
20:46 Post: Finding database file artifact: 3c431200e6 user: muthca
20:35 Reply: Issue importing csv file to db artifact: fa7ee99653 user: LarryBrasfield
20:09 Post: Issue importing csv file to db artifact: 1b44eaf19e user: AxioUK
19:49 Reply: Possible bug in .read when a directory is specified? artifact: 01d12ae640 user: TripeHound
17:00 Reply: alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL artifact: 6886a6710a user: dvdraymond
15:40 Reply: alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL artifact: 80191b6771 user: juslintek
15:38 Reply: alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL artifact: 66c59bd701 user: juslintek
15:35 Reply: alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL artifact: 1a287c1add user: dvdraymond
15:26 Delete reply: GCC-7 and later miscompile SQLite artifact: b53c75ced0 user: Chanda
15:25 Delete reply: GCC-7 and later miscompile SQLite artifact: 7078883131 user: Chanda
15:22 Reply: GCC-7 and later miscompile SQLite artifact: 29257ce1e5 user: LarryBrasfield
15:17 Reply: column check constraint typeof(col) = 'integer' fails if col has declared type text artifact: 1ab2074a93 user: anonymous
15:10 Reply: alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL artifact: 959076a468 user: cuz
14:55 Edit: alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL artifact: a714b69e99 user: juslintek
14:51 Reply: alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL artifact: fd69e1b4de user: juslintek
14:39 Reply: alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL artifact: 62416c35b0 user: stephan
14:31 Post: alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL artifact: 17ebad32a5 user: juslintek
14:26 Edit reply: GCC-7 and later miscompile SQLite artifact: fa66580299 user: LarryBrasfield
13:57 Reply: facing issue from sqlite3_step() artifact: 1277f59acf user: JLHainaut
13:46 Edit reply: GCC-7 and later miscompile SQLite artifact: 18b16a3120 user: Chanda
13:14 Edit reply: GCC-7 and later miscompile SQLite artifact: ac4d555709 user: Chanda
12:14 Reply: GCC-7 and later miscompile SQLite artifact: a259e3f35b user: Chanda
11:49 Reply: column check constraint typeof(col) = 'integer' fails if col has declared type text artifact: 420403c34d user: dvdraymond
10:50 Post: column check constraint typeof(col) = 'integer' fails if col has declared type text artifact: df68fc4cc9 user: anonymous
05:48 Reply: Crash while sqlite3_prepare_v2 with signal SIGFPE in SQLite version 3.31.01 artifact: 19a106df2e user: stephan
05:27 Reply: Crash while sqlite3_prepare_v2 with signal SIGFPE in SQLite version 3.31.01 artifact: b251e90e89 user: RomioGeek
02:08 Reply: Password-protected databases no longer work with 1.113, no rollback possible artifact: a8c99c68e1 user: nandostyle
02:05 Reply: Password-protected databases no longer work with 1.113, no rollback possible artifact: b2d26ab3da user: nandostyle