SQLite User Forum

Today In History
Login

This Day In History For 2024-04-16

1 Year Ago (more context)

2023-04-16
22:46 Reply: A new option, possibly, for CLI: -utf8 artifact: b722256fc2 user: larrybr
21:05 Reply: A new option, possibly, for CLI: -utf8 artifact: 3e3b4b022c user: florian.balmer
20:28 Reply: case-sensitivity of INDEX artifact: 5b0b9be579 user: SeverKetor
20:24 Post: ai4sqlite3: natural language query assistant artifact: aea3408302 user: dnamlin
20:01 Post: case-sensitivity of INDEX artifact: a9da843f97 user: punkish
19:30 Reply: Insert with multiple foreign keys artifact: 6dab366247 user: larrybr
18:48 Reply: DB(Encoding UTF-16) read by SQLite ver3.40.1,41.2 is locked. artifact: 1a8fc6dbb8 user: larrybr
18:31 Post: DB(Encoding UTF-16) read by SQLite ver3.40.1,41.2 is locked. artifact: bc75a4d20b user: anonymous
18:07 Post: Insert with multiple foreign keys artifact: 8c9ce4f611 user: cangunay
16:21 Edit reply: Import TXT file into SQLite - End of Line character artifact: 8c539c3e60 user: punkish
16:16 Reply: Import TXT file into SQLite - End of Line character artifact: ea86646822 user: punkish
16:13 Reply: Import TXT file into SQLite - End of Line character artifact: 4e69aa5428 user: punkish
15:17 Reply: Import TXT file into SQLite - End of Line character artifact: f2e4e7c060 user: chrisjlocke1
14:38 Reply: Import TXT file into SQLite - End of Line character artifact: 2f0e39fddb user: larrybr
14:20 Reply: Import TXT file into SQLite - End of Line character artifact: 67b440c861 user: punkish
14:10 Reply: Import TXT file into SQLite - End of Line character artifact: e767e338c5 user: punkish
13:52 Reply: Import TXT file into SQLite - End of Line character artifact: c0d6fc74f8 user: larrybr
13:15 Reply: Compilation guides for sqlite_analyzer artifact: 4b5ff6dc3b user: larrybr
13:14 Reply: Import TXT file into SQLite - End of Line character artifact: 1c59bd22b6 user: slavin
10:04 Reply: Double Quoted Literals now treated as identifiers in current trunk, causing errors. artifact: 6567786475 user: anonymous
10:01 Post: Import TXT file into SQLite - End of Line character artifact: 6c07a1f4be user: TimKendal
07:55 Edit reply: Compilation guides for sqlite_analyzer artifact: accce02bfc user: wlhmnrrd
07:49 Reply: Compilation guides for sqlite_analyzer artifact: 8bae7dff8c user: wlhmnrrd
07:47 Reply: Problems with using index to find range artifact: 053c7b4510 user: anonymous
06:17 Reply: SQL logic error from a simple CREATE TRIGGER statement artifact: a2e4fb3e9e user: joeljuca
04:33 Reply: Double Quoted Literals now treated as identifiers in current trunk, causing errors. artifact: f6bc7d9f06 user: KevinYouren
04:08 Reply: Double Quoted Literals now treated as identifiers in current trunk, causing errors. artifact: 7aaee5a524 user: larrybr
04:03 Post: Double Quoted Literals now treated as identifiers in current trunk, causing errors. artifact: 5b8a34ba32 user: KevinYouren
01:50 Reply: do not print info (version, help) at startup artifact: 2e9caa5478 user: davidjmalan
01:48 Reply: Add support for -quiet option? artifact: 92eaa0d2f3 user: davidjmalan
01:45 Reply: Problems with using index to find range artifact: aa6188a04d user: RichardDamon
01:04 Reply: Add support for -quiet option? artifact: eff0d2e01a user: lexfiend
00:47 Reply: Problems with using index to find range artifact: e3433fd763 user: anonymous

2 Years Ago (more context)

2022-04-16
18:30 Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: a890e87a27 user: larrybr
17:36 Reply: fyi LumoSQL/SQLite seminars today artifact: 11be3e7ead user: danshearer
15:22 Reply: Foreign Key reference behavior with multiple databases attached (BUG??) artifact: bf55b5a789 user: dan
12:33 Reply: Need Help Constructing a Query artifact: f7dfd69a28 user: Tomel51
02:55 Reply: Order of Unique constraint has influence of insert speed? artifact: 6e1dc9cf3a user: anonymous
01:29 Reply: Trying to recover lost notes from MacBook by reading sqlite files artifact: 00de2d790f user: slavin

3 Years Ago (more context)

2021-04-16
23:49 Reply: SQL query help for between times and grouping times artifact: 66ff46e8d3 user: rayB
22:24 Post: SQL query help for between times and grouping times artifact: f54891ee82 user: ThanksRyan
21:01 Edit: VACUUM fails on a database with enabled user authentication extension artifact: ee8f177c56 user: aloys
21:00 Post: VACUUM fails on a database with enabled user authentication extension artifact: 939e3c71fd user: aloys
19:54 Reply: group_concat with distinct and custom seperator artifact: 7fc2ef5499 user: Cieric
19:33 Reply: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: bba19a113d user: gonzus
19:14 Edit reply: Reporting vulnerabilities artifact: 6bdea5075e user: kmedcalf
19:12 Reply: Reporting vulnerabilities artifact: 1fe1a2b1c1 user: kmedcalf
17:50 Post: Reporting vulnerabilities artifact: 306a7d3381 user: anonymous
17:19 Reply: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: 361912b666 user: larrybr
17:03 Reply: sqlite3_db_filename after sqlite3_deserialize returns "x" artifact: ab52b68b5e user: gonzus
14:15 Reply: Cant write from root user into sqlite when sticky bit is set artifact: 2633dc7065 user: larrybr
13:41 Reply: Cant write from root user into sqlite when sticky bit is set artifact: 0184e9074a user: 777777
12:51 Reply: Cant write from root user into sqlite when sticky bit is set artifact: 9954c081c8 user: slavin
12:33 Reply: programming sqlite bytecode directly ? artifact: c695cbe47b user: slavin
12:11 Reply: Cant write from root user into sqlite when sticky bit is set artifact: 3286a7a319 user: cuz
10:15 Post: Cant write from root user into sqlite when sticky bit is set artifact: 37dd114976 user: 777777
03:26 Reply: sql error:INSERT INTO tbl_des SELECT v1,v2.. FROM tbl_src on conflict(vehicle_id,begin_time) do nothing artifact: eec6064054 user: yh2216
01:59 Edit reply: Bug In EXPLAIN Syntax Diagram artifact: 82da8fb347 user: larrybr
00:38 Reply: Bug In EXPLAIN Syntax Diagram artifact: d56a4067bf user: larrybr
00:24 Post: Bug In EXPLAIN Syntax Diagram artifact: 4adcfc3d38 user: ldo289

4 Years Ago (more context)

2020-04-16
23:04 Reply: Return boolean if item EXISTS in database artifact: 421b49ec15 user: LarryBrasfield
21:59 Reply: Tcl coroutine, db eval ... script, yield, segmentation fault artifact: c4f6935667 user: andreas-kupries
21:09 Reply: Return boolean if item EXISTS in database artifact: 728ad70656 user: PongoZ
20:58 Reply: Help speeding up a query artifact: 27ff27d078 user: jicman
20:16 Reply: Help speeding up a query artifact: 985e37eee5 user: kmedcalf
19:46 Reply: SQL-Query is always empty artifact: 719102d523 user: kmedcalf
19:43 Reply: Help speeding up a query artifact: adf2a69978 user: jicman
19:27 Reply: SQL-Query is always empty artifact: 3981ef89cf user: anonymous
19:18 Reply: Help speeding up a query artifact: ceb50e6465 user: kmedcalf
18:13 Post: Help speeding up a query artifact: d25a6aee9d user: jicman
18:06 Edit: Crash in sqlite3_open_v2 with SQLITE_HAS_CODEC artifact: 8d5eab48bc user: sentinel101
17:51 Reply: select in order artifact: 342a772816 user: LarryBrasfield
17:28 Edit: Crash in sqlite3_open_v2 with SQLITE_HAS_CODEC artifact: e1221e61d3 user: sentinel101
17:25 Reply: SQL-Query is always empty artifact: e25a7955af user: kmedcalf
17:21 Reply: select in order artifact: 5f5858fa95 user: kmedcalf
17:13 Reply: select in order artifact: b7303e6d72 user: LarryBrasfield
17:05 Edit reply: select in order artifact: 3041e77bc2 user: ddevienne
17:02 Edit reply: select in order artifact: 40f232969d user: ddevienne
17:02 Reply: select in order artifact: cd10ecc9bb user: ddevienne
16:55 Reply: select in order artifact: a59f6ea6d0 user: LarryBrasfield
16:50 Reply: select in order artifact: 9cffa3c458 user: ddevienne
16:43 Reply: select in order artifact: f7790fa8f8 user: doug9forester
16:35 Reply: select in order artifact: b86e0913d0 user: nylink
16:33 Reply: select in order artifact: 4bde8e7b7a user: mark
16:17 Post: Crash in sqlite3_open_v2 with SQLITE_HAS_CODEC artifact: cecab46cfc user: sentinel101
16:09 Reply: SQL-Query is always empty artifact: 1116016d2c user: anonymous
16:05 Reply: select in order artifact: 93216114f2 user: nylink
16:00 Reply: sqlite-tools-win32-x86-3310100.zip won't work roperly artifact: 27ed699c80 user: LarryBrasfield
15:57 Reply: select in order artifact: 7e917f04cd user: kmedcalf
15:37 Reply: select in order artifact: ec556cd44b user: doug9forester
14:25 Reply: SQL-Query is always empty artifact: be9c2636fb user: gunter_hick
14:22 Reply: SQL-Query is always empty artifact: f5889f9920 user: cuz
14:10 Reply: Slow updates, many with exactly 1000ms? artifact: bab55e5a97 user: cuz
14:03 Reply: Slow updates, many with exactly 1000ms? artifact: b83886491c user: kmedcalf
13:52 Reply: SQL-Query is always empty artifact: f7350db5ef user: kmedcalf
13:25 Reply: sqlite-tools-win32-x86-3310100.zip won't work roperly artifact: bc4269e208 user: gunter_hick
12:34 Reply: Slow updates, many with exactly 1000ms? artifact: 021724b9b8 user: Kukulkan
11:57 Delete reply: sqlite-tools-win32-x86-3310100.zip won't work roperly artifact: 7a63830292 user: PrototypeX
11:56 Reply: sqlite-tools-win32-x86-3310100.zip won't work roperly artifact: 1054343e86 user: PrototypeX
11:48 Reply: select in order artifact: 3bf078bc6f user: tonyp
11:39 Reply: Update Crashed my Program artifact: 791f5d3d58 user: anonymous
11:37 Post: SQL-Query is always empty artifact: b635b58f18 user: anonymous
11:08 Reply: Slow updates, many with exactly 1000ms? artifact: 4de5ef7003 user: gunter_hick
11:08 Reply: how to use in-memory with shared cache in mybatis artifact: 4be088e6be user: live_to_learn
10:59 Reply: select in order artifact: 739f2b09ec user: ddevienne
10:56 Reply: File .db always locked using EF6 / WebApi (.Net) artifact: 46f31cdc4f user: gunter_hick
10:52 Post: Slow updates, many with exactly 1000ms? artifact: df04849b10 user: Kukulkan
10:51 Reply: select in order artifact: dbbd78fecb user: ddevienne
10:50 Reply: sqlite-tools-win32-x86-3310100.zip won't work roperly artifact: b3c7d3af5d user: LarryBrasfield
10:45 Reply: sqlite-tools-win32-x86-3310100.zip won't work roperly artifact: a9586fc4fd user: LarryBrasfield
10:43 Reply: sqlite-tools-win32-x86-3310100.zip won't work roperly artifact: 53951ba676 user: gunter_hick
10:37 Reply: how to use in-memory with shared cache in mybatis artifact: 62db6b3455 user: gunter_hick
10:30 Reply: select in order artifact: f1b7e3a869 user: gunter_hick
07:54 Post: sqlite-tools-win32-x86-3310100.zip won't work roperly artifact: 183697d77e user: PrototypeX
07:29 Post: how to use in-memory with shared cache in mybatis artifact: 02f4709ba6 user: live_to_learn
06:10 Reply: can not subscribe artifact: 28abadd7a0 user: luuk
03:40 Post: select in order artifact: 682f2627b3 user: nylink