SQLite User Forum

Today In History
Login

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