SQLite User Forum

Today In History
Login

This Day In History For 2024-04-24

1 Year Ago (more context)

2023-04-24
23:31 Reply: Should SQLite support JSON5? artifact: 30a74019d1 user: alexgarciaxyz
22:43 Reply: Improve initial insert performance of rtree index artifact: 3b82a6dcdc user: theroggy
22:42 Reply: Should SQLite support JSON5? artifact: afcdc9d5e2 user: numist
21:19 Edit reply: Improve initial insert performance of rtree index artifact: f958f33fe7 user: theroggy
21:19 Edit reply: Improve initial insert performance of rtree index artifact: 7d446a0a01 user: theroggy
21:17 Reply: Improve initial insert performance of rtree index artifact: 4be63a72b0 user: theroggy
20:47 Reply: Improve initial insert performance of rtree index artifact: 8e90f691f1 user: theroggy
20:44 Reply: Determine schema of a query table artifact: abee2a3338 user: kmedcalf
20:30 Reply: Should SQLite support JSON5? artifact: 3c88d66779 user: RandomCoder
19:42 Reply: Improve initial insert performance of rtree index artifact: 58b4933575 user: drh
19:00 Reply: Should SQLite support JSON5? artifact: b10fed9675 user: alexgarciaxyz
18:36 Reply: IDbCommand::ExecuteReader executing multiple statements in the .NET wrapper allowing an SQL injection attack artifact: cebbe4cdbd user: chrisjlocke1
18:11 Reply: Should SQLite support JSON5? artifact: fc405a888e user: ddevienne
18:08 Reply: IDbCommand::ExecuteReader executing multiple statements in the .NET wrapper allowing an SQL injection attack artifact: f4e3b086d6 user: AAsk1902
18:04 Reply: Re-Direct SQLite temp files to another directory artifact: c7b5a6374a user: jbart1112
17:51 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: f2280321c9 user: alexgarciaxyz
17:43 Post: Should SQLite support JSON5? artifact: d16d4e7154 user: drh
16:58 Edit reply: Determine schema of a query table artifact: 1dbbfbfd9e user: kmedcalf
16:56 Reply: Determine schema of a query table artifact: afae55c5da user: kmedcalf
16:44 Reply: Feature Request: FETCH FIRST n ROW(s) ONLY artifact: 2f172f1bac user: ralfbertling
16:35 Edit reply: Feature Request: FETCH FIRST n ROW(s) ONLY artifact: 4ce6b39f86 user: ralfbertling
16:35 Reply: Feature Request: FETCH FIRST n ROW(s) ONLY artifact: 6cc4cefd54 user: holgerj
16:33 Edit reply: Determine schema of a query table artifact: b140a81eb4 user: kmedcalf
16:32 Reply: Determine schema of a query table artifact: 99e378b483 user: kmedcalf
16:31 Reply: Determine schema of a query table artifact: 45071af03f user: kmedcalf
16:28 Reply: Feature Request: FETCH FIRST n ROW(s) ONLY artifact: 5a1d55fd84 user: ralfbertling
16:25 Edit: Feature Request: FETCH FIRST n ROW(s) ONLY artifact: 1d79abdc31 user: ralfbertling
16:23 Reply: Re-Direct SQLite temp files to another directory artifact: 572adeb850 user: slavin
15:59 Reply: Improve initial insert performance of rtree index artifact: b0ce89838e user: drh
15:26 Edit: Improve initial insert performance of rtree index artifact: 6b8bca17bb user: theroggy
15:22 Post: Improve initial insert performance of rtree index artifact: af937a36b3 user: theroggy
14:49 Reply: IDbCommand::ExecuteReader executing multiple statements in the .NET wrapper allowing an SQL injection attack artifact: d360e8f769 user: dkfellows
14:41 Reply: Re-Direct SQLite temp files to another directory artifact: 2cd095bf9b user: jbart1112
13:09 Reply: IDbCommand::ExecuteReader executing multiple statements in the .NET wrapper allowing an SQL injection attack artifact: 07227e9bb1 user: larrybr
12:44 Reply: Feature Request: FETCH FIRST n ROW(s) ONLY artifact: e27c5b8634 user: larrybr
10:24 Reply: IDbCommand::ExecuteReader executing multiple statements in the .NET wrapper allowing an SQL injection attack artifact: 6e83cfe72b user: abdekker
09:19 Post: Determine schema of a query table artifact: 9ce64b7823 user: curmudgeon
08:50 Reply: Re-Direct SQLite temp files to another directory artifact: 7193355b4d user: dkfellows
08:33 Reply: Single-thread Mode artifact: fc5851d875 user: dkfellows
08:07 Post: Feature Request: FETCH FIRST n ROW(s) ONLY artifact: b415dd7016 user: ralfbertling
02:24 Post: (Deleted) artifact: dd99a3a230 user: zwd_125
00:36 Reply: IDbCommand::ExecuteReader executing multiple statements in the .NET wrapper allowing an SQL injection attack artifact: da0cbefdc6 user: mistachkin

2 Years Ago (more context)

2022-04-24
23:31 Reply: GUI with drill-down? artifact: 33ccb8be9b user: anonymous
21:41 Reply: Sqlite for Web App artifact: bf77e68e55 user: cuz
19:54 Reply: Sqlite for Web App artifact: 2e9e9bd286 user: slavin
19:03 Reply: sqlite building with custom zlib version (1.2.12) on FreeBSD artifact: e699e7fbc7 user: kmedcalf
17:43 Reply: sqlite-gui application artifact: a83294baab user: UserMBL
17:43 Reply: GUI with drill-down? artifact: 9c93873484 user: UserMBL
17:35 Edit reply: sqlite building with custom zlib version (1.2.12) on FreeBSD artifact: f163b7aa8a user: raghupcr
17:34 Reply: sqlite building with custom zlib version (1.2.12) on FreeBSD artifact: d7658391f5 user: raghupcr
15:48 Reply: sqlite building with custom zlib version (1.2.12) on FreeBSD artifact: a84b7e97e7 user: kmedcalf
15:00 Reply: select max not working artifact: 98fd548cf6 user: anonymous
14:58 Reply: select max not working artifact: 13a379975a user: stephan
14:24 Post: select max not working artifact: 6783854923 user: anonymous
12:03 Edit reply: SQL get group by where count is >= 0 artifact: e7655f623b user: midijohnny
12:01 Edit reply: SQL get group by where count is >= 0 artifact: c84e9bebfa user: midijohnny
11:58 Reply: SQL get group by where count is >= 0 artifact: 54594485dc user: midijohnny
11:57 Reply: SQL get group by where count is >= 0 artifact: 50cd6599fd user: jdennis
11:46 Reply: SQL get group by where count is >= 0 artifact: d8c05a9a05 user: midijohnny
11:36 Post: SQL get group by where count is >= 0 artifact: dabb25932b user: bob202
10:58 Reply: Feature request: Stored Procedures artifact: 879e7dd3c3 user: anonymous
10:36 Reply: GUI with drill-down? artifact: a6067f6327 user: UserMBL
08:40 Post: Sqlite for Web App artifact: df82daf76b user: 19662004
05:47 Reply: sqlite building with custom zlib version (1.2.12) on FreeBSD artifact: bf10133448 user: raghupcr
05:47 Edit reply: Feature request: Stored Procedures artifact: 27d0974d8a user: Yairlenga
05:46 Reply: Feature request: Stored Procedures artifact: b0f969b42d user: Yairlenga
05:06 Reply: sqlite building with custom zlib version (1.2.12) on FreeBSD artifact: cb800bcaf8 user: raghupcr
05:00 Reply: Hex String to Integer Function? artifact: 6255de16e0 user: kmedcalf
02:09 Edit reply: GUI with drill-down? artifact: 1228f01881 user: little-brother
01:59 Reply: GUI with drill-down? artifact: c61ea78192 user: little-brother

3 Years Ago (more context)

2021-04-24
23:29 Reply: Sending output to a pipe artifact: d30627f5c3 user: larrybr
22:09 Reply: Sending output to a pipe artifact: 801ee0be99 user: kmedcalf
22:05 Reply: Sending output to a pipe artifact: 291370e6f6 user: knu
21:59 Reply: PROBLEM WITH TRANSACTION artifact: 87e58b3e1f user: kmedcalf
21:55 Reply: Different results in SELECT DISTINCT artifact: 6d8903632c user: kmedcalf
20:13 Reply: Sending output to a pipe artifact: a8ea57bf20 user: ThanksRyan
18:17 Edit: Solved OPEN, ATTACH, CREATE VIEW, SELECT - possible? artifact: 5917b81ad8 user: MichaelS
18:16 Reply: Solved OPEN, ATTACH, CREATE VIEW, SELECT - possible? artifact: 99e0b18cc8 user: MichaelS
18:03 Reply: Solved OPEN, ATTACH, CREATE VIEW, SELECT - possible? artifact: 1f5e9ad2bd user: anonymous
17:56 Reply: Solved OPEN, ATTACH, CREATE VIEW, SELECT - possible? artifact: 4c92c5dead user: vman59
16:28 Reply: How to convert to CTE artifact: 0ee037e6da user: anonymous
16:06 Reply: How to convert to CTE artifact: 31fcbbe0e4 user: anonymous
16:05 Reply: How to convert to CTE artifact: be71b60721 user: larrybr
16:04 Reply: Getting error when pipe sql into sqlite3 utility artifact: eeaa25a776 user: anonymous
16:02 Edit reply: Solved OPEN, ATTACH, CREATE VIEW, SELECT - possible? artifact: f9e40ac664 user: larrybr
16:01 Reply: Solved OPEN, ATTACH, CREATE VIEW, SELECT - possible? artifact: 29f7aa392f user: larrybr
15:50 Reply: How to convert to CTE artifact: c3a85c617b user: anonymous
15:46 Post: Solved OPEN, ATTACH, CREATE VIEW, SELECT - possible? artifact: 2a99c377a8 user: MichaelS
14:49 Reply: Sending output to a pipe artifact: d779782557 user: hanche
14:41 Reply: Getting error when pipe sql into sqlite3 utility artifact: 86ade9713d user: larrybr
14:37 Reply: PROBLEM WITH TRANSACTION artifact: a2223f128f user: cuz
13:57 Reply: How to convert to CTE artifact: c2ef3c0e48 user: cuz
13:48 Reply: Getting error when pipe sql into sqlite3 utility artifact: b5a93aeb49 user: drh
13:43 Edit reply: How to convert to CTE artifact: 564b2b680d user: cuz
13:42 Reply: Getting error when pipe sql into sqlite3 utility artifact: 939d45fd1d user: anonymous
13:38 Reply: How to convert to CTE artifact: 1d1b3e8351 user: cuz
13:37 Reply: Sending output to a pipe artifact: e9c78978f7 user: larrybr
12:56 Post: Sending output to a pipe artifact: 9b3b29110c user: hanche
12:29 Edit reply: Getting error when pipe sql into sqlite3 utility artifact: 6f1d22e8de user: larrybr
12:28 Reply: Getting error when pipe sql into sqlite3 utility artifact: e21294bdfa user: larrybr
12:26 Reply: Different results in SELECT DISTINCT artifact: b0aace9a65 user: cuz
12:02 Reply: PROBLEM WITH TRANSACTION artifact: c9f81f2eb9 user: anonymous
10:58 Reply: Different results in SELECT DISTINCT artifact: 5ca5ad9aa9 user: drh
10:01 Reply: How to convert to CTE artifact: 03bd260b24 user: anonymous
09:59 Post: Getting error when pipe sql into sqlite3 utility artifact: ed8f696a20 user: anonymous
09:29 Post: Different results in SELECT DISTINCT artifact: 86b9a9c51c user: JsToCode
06:41 Reply: How to convert to CTE artifact: 5dc12daa39 user: kmedcalf
05:15 Reply: How to convert to CTE artifact: 0d9d3a0ab8 user: anonymous
04:53 Reply: How to convert to CTE artifact: 2266974831 user: anonymous

4 Years Ago (more context)

2020-04-24
22:59 Edit reply: Incremental Blob I/O and virtual tables artifact: b3e060d919 user: ddevienne
22:58 Reply: Incremental Blob I/O and virtual tables artifact: e7a01d6f5a user: ddevienne
22:14 Edit reply: Sqlite3 is multi-core multi-OS system artifact: be527149a3 user: kmedcalf
22:12 Reply: Sqlite3 is multi-core multi-OS system artifact: 2a0ec086e8 user: kmedcalf
22:02 Reply: Integer becomes blob artifact: 70861c223e user: kmedcalf
21:54 Reply: SQLite search with text vs numeric field artifact: c48ce2ef22 user: kmedcalf
21:40 Reply: infinite loop in the generated opcode caused by the inappropriate handling of crafted statement artifact: 8d45eb7bcb user: kmedcalf
20:57 Reply: Sqlite3 is multi-core multi-OS system artifact: 62df5081ea user: wyoung
20:45 Reply: Sqlite3 is multi-core multi-OS system artifact: a28304af4a user: wyoung
20:42 Reply: Sqlite3 is multi-core multi-OS system artifact: 77bf771b45 user: wyoung
20:01 Reply: Integer becomes blob artifact: 5125596e52 user: knu
19:19 Post: Update Table Columns in SQLite in CoreData for iOS artifact: 21f757f9ee user: t_bard
18:27 Edit reply: Integer becomes blob artifact: 4269b84785 user: extreme4all
18:25 Edit reply: Integer becomes blob artifact: 4586740fa4 user: extreme4all
18:25 Reply: SQL compliance on Wikipedia artifact: f850d1e374 user: Clothears
18:25 Edit reply: Integer becomes blob artifact: 63b09da155 user: extreme4all
18:23 Reply: Integer becomes blob artifact: 6f3088a80d user: extreme4all
18:23 Edit reply: Integer becomes blob artifact: 71355e17c8 user: extreme4all
18:13 Reply: Integer becomes blob artifact: 3311208886 user: extreme4all
17:55 Reply: SQL compliance on Wikipedia artifact: 8d9820afd2 user: tonyp
17:34 Reply: Incremental Blob I/O and virtual tables artifact: 62526ca7ff user: anonymous
16:55 Reply: SQL compliance on Wikipedia artifact: 231460ff1d user: drh
16:29 Reply: SQL compliance on Wikipedia artifact: 4f76344542 user: anonymous
15:41 Post: Simple query leading to a surprisingly poor performing query plan, due to redundant work artifact: 9b6950f697 user: merijn
15:15 Reply: a probable bug in .output handler artifact: d9566dd929 user: LarryBrasfield
14:44 Reply: (Deleted) artifact: 4fda6cd73b user: skywalk
14:24 Reply: Select Query will not work in PHP program artifact: 71f5df00cb user: knu
13:19 Reply: a probable bug in .output handler artifact: 95759d2362 user: drh
13:15 Edit reply: SQL compliance on Wikipedia artifact: 8b683c2a2b user: drh
12:45 Edit: (Deleted) artifact: 29a4ebc80e user: shawnw
12:45 Reply: (Deleted) artifact: ea211ffb0a user: shawnw
12:43 Reply: SQL compliance on Wikipedia artifact: fc76c72fa7 user: drh
11:52 Edit: infinite loop in the exec_prepared_stmt function artifact: 34022c0430 user: drh
11:25 Post: SQLite search with text vs numeric field artifact: 7267eab00c user: surabhi.nitsurat
11:22 Post: Sqlite3 is multi-core multi-OS system artifact: 3ba3ad5161 user: anonymous
11:01 Edit reply: infinite loop in the exec_prepared_stmt function artifact: 0659b4dc04 user: dan
11:00 Edit reply: infinite loop in the exec_prepared_stmt function artifact: cdb5639e47 user: dan
11:00 Reply: infinite loop in the exec_prepared_stmt function artifact: 6dcede2025 user: dan
09:54 Reply: SQL compliance on Wikipedia artifact: b9db3df673 user: younique
09:34 Post: Incremental Blob I/O and virtual tables artifact: a854afaab7 user: ddevienne
09:24 Reply: SQL compliance on Wikipedia artifact: 78c027fde4 user: anonymous
09:15 Reply: SQL compliance on Wikipedia artifact: ca1690bf61 user: anonymous
09:11 Reply: SQL compliance on Wikipedia artifact: e367ce7788 user: anonymous
06:46 Reply: How do create the neat flow diagrams for SQLite? artifact: 49027f581d user: doug9forester
06:28 Post: infinite loop in the generated opcode caused by the inappropriate handling of crafted statement artifact: 10b26cf9b5 user: izhuer
06:13 Post: infinite loop in the exec_prepared_stmt function artifact: 5c580535ed user: izhuer
04:17 Reply: (Deleted) artifact: aa421a70a0 user: drh
03:38 Reply: a probable bug in .output handler artifact: b6caa44aea user: LarryBrasfield
02:13 Post: (Deleted) artifact: f7d817ccef user: shawnw