This Day In History For 2024-04-10
1 Year Ago (more context)
2023-04-10
| ||
23:35 | • Reply: Specify hash type on downloads page artifact: 85bfce63e8 user: larrybr | |
23:18 | • Edit reply: (Deleted) artifact: 3e5633a75b user: mkorobkom | |
23:18 | • Edit reply: (Deleted) artifact: 0af4b72729 user: mkorobkom | |
23:17 | • Reply: (Deleted) artifact: f0825d06d4 user: mkorobkom | |
23:03 | • Reply: Planner chooses slow index scan over fast nested search artifact: 0c679a45f6 user: lexi_lambda | |
23:01 | • Reply: (Deleted) artifact: a0ff11f99f user: larrybr | |
22:47 | • Reply: Planner chooses slow index scan over fast nested search artifact: a395e45123 user: drh | |
22:40 | • Reply: Planner chooses slow index scan over fast nested search artifact: 75a41cf096 user: drh | |
22:17 | • Reply: Planner chooses slow index scan over fast nested search artifact: 6919a34396 user: lexi_lambda | |
21:41 | • Edit: (Deleted) artifact: ccfab145b3 user: mkorobkom | |
21:40 | • Edit: (Deleted) artifact: ce126f9055 user: mkorobkom | |
21:21 | • Edit: (Deleted) artifact: dc021508f9 user: mkorobkom | |
21:13 | • Edit: (Deleted) artifact: 4af817705d user: mkorobkom | |
21:03 | • Edit: (Deleted) artifact: a314a4e764 user: mkorobkom | |
21:01 | • Edit: (Deleted) artifact: fa801936cc user: mkorobkom | |
21:00 | • Post: (Deleted) artifact: 527adf72fe user: mkorobkom | |
20:32 | • Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 9ba899f339 user: punkish | |
20:27 | • Post: comparing rtree and geopoly for the same geographies artifact: 34edb829b7 user: punkish | |
19:36 | • Reply: Accessing schema table for attached db artifact: 7562d9a5fc user: curmudgeon | |
19:33 | • Reply: Specify hash type on downloads page artifact: 17977f5076 user: hglaeser | |
19:06 | • Reply: Specify hash type on downloads page artifact: 5043924b06 user: larrybr | |
18:53 | • Reply: Accessing schema table for attached db artifact: 5cc179d7f7 user: anonymous | |
18:50 | • Edit: LSM1 - Bug in lsmFsReadSyncedId() artifact: f45200170b user: Martijn37 | |
18:49 | • Reply: Assertion failure in sqlite3VdbeExec function artifact: 4d62fac9fa user: drh | |
18:43 | • Edit: LSM1 - Bug in lsmFsReadSyncedId() artifact: 7afbdeeebe user: Martijn37 | |
18:42 | • Edit: LSM1 - Bug in lsmFsReadSyncedId() artifact: 8339d10a4b user: Martijn37 | |
18:41 | • Reply: Specify hash type on downloads page artifact: a75bbf7a74 user: hglaeser | |
18:39 | • Reply: Accessing schema table for attached db artifact: 9dbbe158ec user: curmudgeon | |
18:38 | • Edit: LSM1 - Bug in lsmFsReadSyncedId() artifact: b6af43a7b8 user: Martijn37 | |
18:37 | • Edit: LSM1 - Bug in lsmFsReadSyncedId() artifact: ae551713d8 user: Martijn37 | |
18:34 | • Edit: LSM1 - Bug in lsmFsReadSyncedId() artifact: ee56cc2105 user: Martijn37 | |
18:33 | • Post: LSM1 - Bug in lsmFsReadSyncedId() artifact: 909c3694c3 user: Martijn37 | |
18:07 | • Reply: random() in a subquery produces a column with an inconsistent value artifact: f2497d5002 user: bjoern | |
17:26 | • Reply: Accessing schema table for attached db artifact: cfdc9662e8 user: kmedcalf | |
17:17 | • Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 551c917c76 user: dvdraymond | |
16:47 | • Edit reply: Accessing schema table for attached db artifact: 0b9ada9295 user: curmudgeon | |
16:39 | • Reply: Accessing schema table for attached db artifact: b5b984971c user: curmudgeon | |
16:26 | • Reply: Planner chooses slow index scan over fast nested search artifact: 02d1f85143 user: lexi_lambda | |
16:14 | • Reply: random() in a subquery produces a column with an inconsistent value artifact: 2e174445e9 user: lexi_lambda | |
15:41 | • Reply: datetime in sqlite artifact: 1766fbb960 user: gerardnico | |
15:39 | • Reply: Accessing schema table for attached db artifact: 70ffe95449 user: kmedcalf | |
15:26 | • Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: b7a85cd98d user: punkish | |
15:01 | • Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: 51cd778173 user: dvdraymond | |
14:56 | • Post: Assertion failure in sqlite3VdbeExec function artifact: 0b53708c95 user: songliu | |
14:36 | • Reply: Accessing schema table for attached db artifact: 5e6acfd3dd user: curmudgeon | |
13:53 | • Reply: datetime in sqlite artifact: 1b88a6f7d3 user: hanche | |
13:10 | • Reply: Accessing schema table for attached db artifact: 8f030e3055 user: anonymous | |
12:45 | • Reply: Accessing schema table for attached db artifact: 7e0669c01d user: slavin | |
12:20 | • Edit reply: datetime in sqlite artifact: 8c3267c6fa user: chrisjlocke1 | |
12:19 | • Edit reply: datetime in sqlite artifact: f8915b7f3e user: chrisjlocke1 | |
12:18 | • Reply: datetime in sqlite artifact: 9cb664143a user: chrisjlocke1 | |
11:36 | • Reply: Planner chooses slow index scan over fast nested search artifact: 9f662e9489 user: drh | |
11:29 | • Reply: Accessing schema table for attached db artifact: 185e8c34d6 user: curmudgeon | |
10:56 | • Reply: Accessing schema table for attached db artifact: c8ef4fade0 user: drh | |
10:49 | • Reply: random() in a subquery produces a column with an inconsistent value artifact: adcaf02266 user: drh | |
10:46 | • Post: Accessing schema table for attached db artifact: f62987f524 user: curmudgeon | |
10:18 | • Edit reply: ANN Database Designer artifact: fd7b19c138 user: chrisjlocke1 | |
10:15 | • Edit reply: ANN Database Designer artifact: aba883e8e5 user: chrisjlocke1 | |
10:14 | • Reply: ANN Database Designer artifact: 90cdaffac1 user: chrisjlocke1 | |
10:11 | • Reply: datetime in sqlite artifact: 17e992d6a5 user: chrisjlocke1 | |
09:24 | • Edit reply: ANN Database Designer artifact: 1e1569f66f user: AAsk1902 | |
09:22 | • Reply: datetime in sqlite artifact: 9602ca2b1e user: anonymous | |
09:20 | • Reply: datetime in sqlite artifact: 71fd5b271f user: anonymous | |
09:19 | • Reply: ANN Database Designer artifact: b2cf25395b user: AAsk1902 | |
07:35 | • Reply: ANN Database Designer artifact: 2bc735eaa7 user: chrisjlocke1 | |
07:32 | • Edit reply: datetime in sqlite artifact: 82347920f4 user: chrisjlocke1 | |
07:30 | • Reply: datetime in sqlite artifact: 8f6c79d8bd user: chrisjlocke1 | |
07:21 | • Reply: datetime in sqlite artifact: 6fffe09a58 user: punkish | |
07:12 | • Reply: How to get the local timezone offset and name? artifact: f9a5a531a7 user: AAsk1902 | |
06:58 | • Post: datetime in sqlite artifact: 06ae80493a user: anonymous | |
06:57 | • Reply: ANN Database Designer artifact: d083832a14 user: AAsk1902 | |
06:42 | • Reply: How to get the local timezone offset and name? artifact: df1bf7ae83 user: lexfiend | |
04:24 | • Edit reply: Planner chooses slow index scan over fast nested search artifact: d3f3a93802 user: lexi_lambda | |
04:23 | • Edit: Planner chooses slow index scan over fast nested search artifact: 8f30167dc0 user: lexi_lambda | |
04:21 | • Reply: Planner chooses slow index scan over fast nested search artifact: fd0b81f48e user: lexi_lambda | |
03:22 | • Post: Planner chooses slow index scan over fast nested search artifact: 90fa000fbf user: lexi_lambda | |
02:35 | • Reply: ANN Database Designer artifact: 73a91cec1a user: Emily-Elizabeth | |
01:03 | • Post: random() in a subquery produces a column with an inconsistent value artifact: 208afc7a5a user: lexi_lambda | |
2 Years Ago (more context)
2022-04-10
| ||
22:59 | • Post: Insert into doesn't work ( it crashes ) artifact: 3822142cd2 user: anonymous | |
22:51 | • Post: ROWID like column with SELECT statement artifact: 465ab46bb9 user: anonymous | |
18:55 | • Reply: Trigger not working (semaphore use case) artifact: d426b351f8 user: larrybr | |
18:15 | • Reply: Trigger not working (semaphore use case) artifact: f3e50c47e2 user: anonymous | |
18:11 | • Reply: SQLite3 Auto Named Columns artifact: 7a1f541b5e user: anonymous | |
17:51 | • Reply: SQLite3 Auto Named Columns artifact: dd00e6c9bd user: larrybr | |
17:47 | • Reply: Trigger not working (semaphore use case) artifact: 30fcd0f858 user: kmedcalf | |
17:42 | • Reply: Using SQLite in AWS EBS artifact: d290e75281 user: kmedcalf | |
17:34 | • Reply: SQLite3 Auto Named Columns artifact: 31fdcfd907 user: anonymous | |
17:31 | • Reply: Trigger not working (semaphore use case) artifact: d03c19202c user: anonymous | |
17:16 | • Reply: Selected RowId Not Returned after .input artifact: 28d7e14aa6 user: AthanBit | |
16:36 | • Edit reply: Using SQLite in AWS EBS artifact: 80b58b0511 user: vijayst | |
16:09 | • Reply: Using SQLite in AWS EBS artifact: e0f0d82179 user: vijayst | |
15:40 | • Edit reply: caching SQLite database. artifact: eaacc4e6e9 user: larrybr | |
15:28 | • Reply: Using SQLite in AWS EBS artifact: 8eb58b7a86 user: RandomCoder | |
15:10 | • Reply: caching SQLite database. artifact: c40d3b1553 user: larrybr | |
14:59 | • Reply: SQLite3 Auto Named Columns artifact: 3bd767650c user: larrybr | |
13:58 | • Reply: caching SQLite database. artifact: f38d367530 user: slavin | |
13:22 | • Reply: Using SQLite in AWS EBS artifact: 248a387085 user: anonymous | |
12:55 | • Reply: SQLite3 Auto Named Columns artifact: 692d608ab6 user: anonymous | |
12:23 | • Edit reply: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). artifact: 0e0dbf28ed user: midijohnny | |
12:22 | • Reply: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). artifact: cdd74db86b user: midijohnny | |
12:20 | • Post: Using SQLite in AWS EBS artifact: b7b3dcea0f user: vijayst | |
12:09 | • Reply: SQLite3 Auto Named Columns artifact: 3d1bfc25b9 user: larrybr | |
12:01 | • Reply: Trigger not working (semaphore use case) artifact: 1616725376 user: dkfellows | |
11:32 | • Reply: SQLite3 Auto Named Columns artifact: d205faf065 user: slavin | |
09:54 | • Reply: SQLite3 Auto Named Columns artifact: 415bf2d513 user: anonymous | |
09:32 | • Reply: SQLite3 Auto Named Columns artifact: 856741578a user: larrybr | |
09:01 | • Post: SQLite3 Auto Named Columns artifact: 4d1188e06f user: anonymous | |
08:54 | • Reply: Trigger not working (semaphore use case) artifact: 3ae3be9a2e user: cuz | |
05:45 | • Reply: Trigger not working (semaphore use case) artifact: d2c9866d12 user: anonymous | |
02:29 | • Post: Trigger not working (semaphore use case) artifact: fba54d970b user: anonymous | |
01:06 | • Reply: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). artifact: 474bd65626 user: anonymous | |
3 Years Ago (more context)
2021-04-10
| ||
23:13 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 6ed6824176 user: ThanksRyan | |
21:25 | • Post: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 7b7ea1373c user: iio7iio7 | |
20:25 | • Reply: meaning of "GROUP BY CONSTANT" artifact: 90a5774115 user: kmedcalf | |
20:16 | • Edit reply: order of INSERT affects the output artifact: 25aa4c922b user: drh | |
20:08 | • Reply: order of INSERT affects the output artifact: af82695760 user: drh | |
18:46 | • Post: order of INSERT affects the output artifact: 98ac2801cf user: krking | |
17:42 | • Reply: Finding database file artifact: 8de4892255 user: TuaPN2020 | |
15:31 | • Edit reply: index misuse? artifact: e5b6baf50d user: wulian | |
15:03 | • Reply: useless constant term lead to incorrect output artifact: 40caded740 user: dan | |
14:49 | • Reply: useless constant term lead to incorrect output artifact: 1c4f2fdcc4 user: krking | |
14:23 | • Reply: meaning of "GROUP BY CONSTANT" artifact: 3696c0156e user: lcarlp | |
14:17 | • Reply: useless constant term lead to incorrect output artifact: fd8db57c82 user: krking | |
14:11 | • Reply: useless constant term lead to incorrect output artifact: 173c42f489 user: TripeHound | |
14:07 | • Reply: useless constant term lead to incorrect output artifact: 6ea94d0c6f user: anonymous | |
13:34 | • Post: useless constant term lead to incorrect output artifact: c09b6a1424 user: krking | |
12:10 | • Reply: Question .open chinook.db artifact: 5b6df1e3e1 user: slavin | |
06:08 | • Reply: meaning of "GROUP BY CONSTANT" artifact: 1d5a510c07 user: krking | |
06:00 | • Edit reply: meaning of "GROUP BY CONSTANT" artifact: 87ab254741 user: krking | |
05:42 | • Reply: meaning of "GROUP BY CONSTANT" artifact: 1979a3cfb1 user: kmedcalf | |
04:26 | • Reply: meaning of "GROUP BY CONSTANT" artifact: dd67ecfe8a user: krking | |
03:12 | • Reply: StrCaseEq in sqlite3? artifact: 0306c2295e user: anonymous | |
02:37 | • Post: StrCaseEq in sqlite3? artifact: 937a16f4fe user: anonymous | |
01:30 | • Reply: group_concat with distinct and custom seperator artifact: 221c2926f5 user: kmedcalf | |
01:16 | • Reply: meaning of "GROUP BY CONSTANT" artifact: f8460474c4 user: kmedcalf | |
4 Years Ago (more context)
2020-04-10
| ||
23:30 | • Reply: Disk I/O error on cifs volume artifact: 4dcaae4768 user: anonymous | |
21:24 | • Reply: Disk I/O error on cifs volume artifact: 2cb9bebf7f user: kmedcalf | |
20:47 | • Reply: Disk I/O error on cifs volume artifact: db8c23180f user: anonymous | |
19:22 | • Reply: Disk I/O error on cifs volume artifact: ff7ad9abfb user: kmedcalf | |
18:49 | • Reply: Return boolean if item EXISTS in database artifact: ea2faf7b47 user: kmedcalf | |
16:55 | • Post: https://sqlite.org/draft/support.html still points to the old email list artifact: 9650fcbb1d user: jicman | |
16:49 | • Reply: Return boolean if item EXISTS in database artifact: c1f27848a2 user: dvdraymond | |
15:53 | • Reply: Return boolean if item EXISTS in database artifact: adc61d7a8c user: jimmorris33215 | |
14:37 | • Edit reply: sql column in sqlite_master artifact: 814768598d user: curmudgeon | |
14:36 | • Edit reply: sql column in sqlite_master artifact: 57c8e404b3 user: curmudgeon | |
14:18 | • Reply: Return boolean if item EXISTS in database artifact: d3467179d0 user: PongoZ | |
13:57 | • Reply: Disk I/O error on cifs volume artifact: 2aaad1d34a user: anonymous | |
13:31 | • Reply: sql column in sqlite_master artifact: 0208c2ba72 user: curmudgeon | |
13:07 | • Reply: Return boolean if item EXISTS in database artifact: fddd44cf7a user: Clothears | |
12:55 | • Edit reply: Return boolean if item EXISTS in database artifact: 2aef1cd538 user: cuz | |
12:53 | • Reply: Return boolean if item EXISTS in database artifact: e930ad2ce5 user: dvdraymond | |
12:49 | • Reply: Return boolean if item EXISTS in database artifact: ecb0e88818 user: cuz | |
12:43 | • Reply: sql column in sqlite_master artifact: 275dd764d1 user: dvdraymond | |
12:37 | • Reply: Return boolean if item EXISTS in database artifact: 7dad2694e8 user: stephan | |
12:24 | • Reply: Return boolean if item EXISTS in database artifact: c2f93e98b3 user: PongoZ | |
11:29 | • Reply: Return boolean if item EXISTS in database artifact: beec17fb5c user: PongoZ | |
11:20 | • Reply: Return boolean if item EXISTS in database artifact: 2025a68fe0 user: Clothears | |
11:15 | • Reply: Return boolean if item EXISTS in database artifact: 127f27b773 user: dfgriggs | |
11:13 | • Post: sql column in sqlite_master artifact: cc8f8564fe user: curmudgeon | |
10:50 | • Reply: Return boolean if item EXISTS in database artifact: 36fec81d4d user: PongoZ | |
09:28 | • Reply: Return boolean if item EXISTS in database artifact: 7ec9cbecc1 user: gunter_hick | |
08:55 | • Reply: Disk I/O error on cifs volume artifact: f892f21fad user: wyoung | |
00:59 | • Post: Disk I/O error on cifs volume artifact: 2163815f66 user: anonymous | |