This Day In History For 2024-04-11
1 Year Ago (more context)
2023-04-11
| ||
23:37 | • Post: Any reason "PRAGMA schema_version;" might return "attempt to write a readonly database" artifact: 793a2ed75b user: simonw | |
23:32 | • Reply: How to store negative zero artifact: e9a9961c43 user: anonymous | |
23:17 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: b478c10072 user: simonw | |
22:46 | • Post: .shell deficiency artifact: 4a149d4dff user: anonymous | |
22:34 | • Post: How to store negative zero artifact: c5be1dbc71 user: mserdarsanli | |
22:24 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: e666e5ef88 user: larrybr | |
22:15 | • Reply: Possible to turn off "defensive" mode using a SQL query? artifact: 3837aaafc7 user: numist | |
22:05 | • Edit reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: fcd2b3eab7 user: simonw | |
22:05 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: b91d165dc7 user: simonw | |
21:39 | • Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: b1d3734b49 user: AAsk1902 | |
21:37 | • Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: ed561dc0c9 user: AAsk1902 | |
21:24 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 5c33cd1c1b user: larrybr | |
21:16 | • Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 3aefa3c7b7 user: AAsk1902 | |
21:15 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 7c3e0ba7b4 user: ldo289 | |
21:10 | • Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 312b3198ea user: AAsk1902 | |
21:08 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: 56742336c8 user: ldo289 | |
21:02 | • Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: ea1c18d40e user: AAsk1902 | |
21:01 | • Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 259f2e7291 user: AAsk1902 | |
20:59 | • Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 8543a9405a user: AAsk1902 | |
20:57 | • Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 6ae5572ca9 user: AAsk1902 | |
20:28 | • Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 51b4d5d443 user: AAsk1902 | |
20:21 | • Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 01c273e07c user: CompuRoot | |
19:55 | • Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: bc0b9c1265 user: kmedcalf | |
19:53 | • Reply: How can a window function replace this subquery to form a grouping? artifact: 0edc30d3ad user: dvdraymond | |
19:53 | • Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 00bdc2e184 user: AAsk1902 | |
19:52 | • Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 49c55be741 user: AAsk1902 | |
19:37 | • Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: dd81b9832b user: larrybr | |
19:23 | • Post: SQLITE_OMIT_WINDOWFUNC artifact: ae32bb11fe user: ChrisNardone | |
19:20 | • Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: e9ca06299f user: AAsk1902 | |
19:11 | • Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: f706fa0e35 user: CompuRoot | |
19:08 | • Reply: How can a window function replace this subquery to form a grouping? artifact: 47f819441e user: kmedcalf | |
19:02 | • Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 88c01a2e18 user: larrybr | |
18:37 | • Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 54634120a7 user: AAsk1902 | |
18:33 | • Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: e73ba0efdc user: AAsk1902 | |
18:30 | • Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: a0f72d99c3 user: AAsk1902 | |
18:08 | • Reply: How can a window function replace this subquery to form a grouping? artifact: cad523761e user: dvdraymond | |
18:00 | • Reply: How can a window function replace this subquery to form a grouping? artifact: a8b3d19700 user: 1codedebugger | |
17:28 | • Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: e6d4341491 user: drh | |
17:21 | • Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: e5b216436a user: larrybr | |
17:17 | • Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: 9ccd6a498d user: macsql20 | |
16:10 | • Edit: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 562ba5e5d6 user: AAsk1902 | |
16:06 | • Edit: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 6cd9a41a09 user: AAsk1902 | |
16:03 | • Post: £ POUND SIGN (V3.41.2) - U+00A3 artifact: b5632b0a36 user: AAsk1902 | |
15:01 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: afeba9f010 user: kmedcalf | |
14:57 | • Edit: Assertion failure in agginfoPersistExprCb function (2) artifact: aeb3e11c08 user: songliu | |
14:43 | • Post: Assertion failure in agginfoPersistExprCb function (2) artifact: 6c5678e3da user: songliu | |
14:32 | • Reply: Assertion failure in sqlite3VdbeExec function artifact: 49709d5d3e user: songliu | |
14:15 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: c858a0de0c user: simonw | |
14:14 | • Reply: Possible to turn off "defensive" mode using a SQL query? artifact: a621d9baf3 user: simonw | |
14:04 | • Reply: There was no error when inserting data, but the data was not written in artifact: fa7dd12482 user: chrisjlocke1 | |
14:02 | • Edit reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 610187fd8c user: kmedcalf | |
13:46 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 0461e2c5d9 user: kmedcalf | |
13:36 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 34c78c1a5e user: kmedcalf | |
13:29 | • Reply: simple query works in sqlite3 cmsdline, fails in trivial c app artifact: d711590fef user: larrybr | |
12:58 | • Reply: There was no error when inserting data, but the data was not written in artifact: 812d0e4e0d user: larrybr | |
11:52 | • Reply: Specify hash type on downloads page artifact: f45182365d user: hglaeser | |
11:08 | • Reply: Possible to turn off "defensive" mode using a SQL query? artifact: 8a3ac5481a user: drh | |
10:49 | • Reply: How can a window function replace this subquery to form a grouping? artifact: 873540f1f3 user: dan | |
10:22 | • Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: 5e4c6bb455 user: drh | |
10:00 | • Reply: ORDER BY is forcing a wrong index to be used, slowing the query artifact: d0bb718542 user: gunter_hick | |
09:30 | • Reply: VACCUM fails with "table locked" after upgrading from 3.40.1 to 3.41.2 artifact: f25dafff42 user: macsql20 | |
07:48 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: c41bd6829c user: stephancb | |
07:47 | • Reply: There was no error when inserting data, but the data was not written in artifact: 19630f735f user: yzs_qaml | |
07:14 | • Reply: There was no error when inserting data, but the data was not written in artifact: 33c406c033 user: yzs_qaml | |
06:49 | • Edit reply: There was no error when inserting data, but the data was not written in artifact: fa7a36fb05 user: chrisjlocke1 | |
06:46 | • Reply: There was no error when inserting data, but the data was not written in artifact: e3d13ebf63 user: chrisjlocke1 | |
06:12 | • Reply: Accessing schema table for attached db artifact: eb9fef59c3 user: curmudgeon | |
03:21 | • Reply: Possible to turn off "defensive" mode using a SQL query? artifact: d9654c239e user: anonymous | |
02:55 | • Edit reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: bac984946a user: simonw | |
02:45 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: fc9d80cd2a user: simonw | |
02:40 | • Edit: Possible to turn off "defensive" mode using a SQL query? artifact: 29393af809 user: simonw | |
02:39 | • Post: Possible to turn off "defensive" mode using a SQL query? artifact: 91f2fe5049 user: simonw | |
02:36 | • Post: There was no error when inserting data, but the data was not written in artifact: 64258b2dbf user: yzs_qaml | |
02:35 | • Reply: Dot Commands artifact: 8c3282fe53 user: ldo289 | |
02:29 | • Reply: Say how to get length(x) in bytes, not just characters, for strings artifact: 1667a5eb15 user: ldo289 | |
02:17 | • Reply: How can a window function replace this subquery to form a grouping? artifact: d3bbd8c531 user: ldo289 | |
2 Years Ago (more context)
2022-04-11
| ||
23:50 | • Reply: RFE: API for column expression affinity (like CREATE TABLE AS SELECT) artifact: d22b751742 user: bjoern | |
23:05 | • Reply: Need Help Constructing a Query artifact: cabb259f73 user: cuz | |
22:53 | • Reply: Need Help Constructing a Query artifact: f5f1e5b245 user: midijohnny | |
22:41 | • Reply: RFE: API for column expression affinity (like CREATE TABLE AS SELECT) artifact: df51d181bc user: larrybr | |
22:41 | • Reply: Need Help Constructing a Query artifact: f05da3577e user: anonymous | |
22:40 | • Reply: RFE: API for column expression affinity (like CREATE TABLE AS SELECT) artifact: 347d0812f4 user: larrybr | |
22:37 | • Edit reply: Need Help Constructing a Query artifact: 06f5e9b85a user: cuz | |
22:35 | • Reply: Need Help Constructing a Query artifact: c331c89640 user: cuz | |
22:18 | • Reply: Need Help Constructing a Query artifact: 776457fd4f user: cuz | |
22:14 | • Reply: Need Help Constructing a Query artifact: 38e01623fc user: anonymous | |
21:46 | • Reply: Need Help Constructing a Query artifact: 3a71d07c66 user: GSnyder | |
21:07 | • Edit: Need Help Constructing a Query artifact: 4c11f0e8d5 user: Tomel51 | |
21:04 | • Reply: How do I determine if a table is STRICT, programatially? artifact: f6525f8fb7 user: bjoern | |
20:50 | • Post: How do I determine if a table is STRICT, programatially? artifact: 1ac901d656 user: anonymous | |
20:47 | • Reply: Learning SQLite Virtual tables artifact: 0c85d770b3 user: anonymous | |
20:46 | • Reply: RFE: API for column expression affinity (like CREATE TABLE AS SELECT) artifact: c17330a848 user: bjoern | |
20:42 | • Post: Need Help Constructing a Query artifact: 13708ff8f0 user: Tomel51 | |
20:34 | • Reply: Learning SQLite Virtual tables artifact: f2d1873f43 user: larrybr | |
20:18 | • Post: Learning SQLite Virtual tables artifact: 28348b307d user: anonymous | |
19:54 | • Reply: RFE: API for column expression affinity (like CREATE TABLE AS SELECT) artifact: 5eb54acf09 user: larrybr | |
19:32 | • Post: RFE: API for column expression affinity (like CREATE TABLE AS SELECT) artifact: 75afbfbf39 user: bjoern | |
16:04 | • Reply: Multi-threaded C# test for SQLite fails with 'database table is locked' artifact: 387c94a35b user: cmgain | |
15:43 | • Reply: Is it possible to create a STRICT table WITHOUT ROWID? artifact: 7ab7c94bef user: anonymous | |
15:07 | • Reply: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). artifact: 44339f2e54 user: ddevienne | |
14:27 | • Reply: Is it possible to create a STRICT table WITHOUT ROWID? artifact: 73e2cd967a user: ddevienne | |
14:02 | • Reply: Trigger not working (semaphore use case) artifact: 3222ea952a user: stephan | |
13:42 | • Reply: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). artifact: b0fb9c4f34 user: stephan | |
13:10 | • Reply: Is it possible to create a STRICT table WITHOUT ROWID? artifact: 10d3ef0777 user: anonymous | |
12:01 | • Edit reply: Trigger not working (semaphore use case) artifact: 447a016488 user: ddevienne | |
11:57 | • Reply: Trigger not working (semaphore use case) artifact: fcee6c0194 user: ddevienne | |
11:13 | • Reply: misuse of window function row_number() artifact: cfc483cfc1 user: anonymous | |
11:08 | • Reply: misuse of window function row_number() artifact: e7a2cff34d user: midijohnny | |
10:54 | • Reply: misuse of window function row_number() artifact: e5bd6b6deb user: midijohnny | |
10:29 | • Post: Is it possible to create a STRICT table WITHOUT ROWID? artifact: 9d567aadf0 user: anonymous | |
10:09 | • Reply: CSV files with multibyte character headers cannot be imported using the ".import" command (CLI). artifact: 6dcced6be2 user: ddevienne | |
07:49 | • Post: misuse of window function row_number() artifact: 82c213ab3a user: anonymous | |
06:59 | • Reply: ROWID like column with SELECT statement artifact: 7086fdbcdd user: anonymous | |
02:00 | • Edit reply: Insert into doesn't work ( it crashes ) artifact: 5a909a11e1 user: sqlitening | |
02:00 | • Edit reply: Insert into doesn't work ( it crashes ) artifact: 034e93bfa5 user: sqlitening | |
01:59 | • Edit reply: Insert into doesn't work ( it crashes ) artifact: 0e94e6e39d user: sqlitening | |
01:56 | • Edit reply: Insert into doesn't work ( it crashes ) artifact: a9db4f9265 user: sqlitening | |
01:54 | • Reply: Insert into doesn't work ( it crashes ) artifact: a9277171a5 user: sqlitening | |
01:51 | • Reply: Using SQLite in AWS EBS artifact: 2a1f6fc4fc user: vijayst | |
01:31 | • Edit reply: ROWID like column with SELECT statement artifact: 5f9b8a95ac user: sqlitening | |
01:29 | • Edit reply: ROWID like column with SELECT statement artifact: b4af42fb5a user: sqlitening | |
01:29 | • Edit reply: ROWID like column with SELECT statement artifact: 6f78ba396f user: sqlitening | |
01:28 | • Edit reply: ROWID like column with SELECT statement artifact: a16ac7968f user: sqlitening | |
01:23 | • Edit reply: ROWID like column with SELECT statement artifact: 95a3f53f05 user: sqlitening | |
01:19 | • Edit reply: ROWID like column with SELECT statement artifact: 71f584d1ae user: sqlitening | |
01:16 | • Reply: ROWID like column with SELECT statement artifact: fe02415bab user: sqlitening | |
00:29 | • Reply: Insert into doesn't work ( it crashes ) artifact: 270166ae13 user: kmedcalf | |
00:24 | • Reply: ROWID like column with SELECT statement artifact: 25a807dcb2 user: kmedcalf | |
00:24 | • Post: Bug: schema hidden column of pragma tables always null artifact: ac13bbc21e user: bjoern | |
3 Years Ago (more context)
2021-04-11
| ||
22:51 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: abcad64131 user: anonymous | |
22:37 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 79c46c7271 user: kmedcalf | |
22:16 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: cd00613c26 user: kmedcalf | |
22:02 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 239becbbdc user: larrybr | |
21:57 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 538711653d user: Clothears | |
21:48 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 1bada19fe8 user: RichardDamon | |
21:03 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 9ce65e441c user: larrybr | |
20:46 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 15f5276317 user: anonymous | |
20:14 | • Post: Creating Virtual Table with EF context.Database.EnsureCreated() artifact: 1ac9d64bc5 user: NiklasRieger | |
20:12 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: e1fcbcca30 user: ThanksRyan | |
20:12 | • Reply: meaning of "GROUP BY CONSTANT" artifact: 9f00be5bf3 user: larrybr | |
20:01 | • Edit reply: How to get the last row_id in a table without inserting anything artifact: 37b33c0d4e user: kmedcalf | |
20:00 | • Reply: How to get the last row_id in a table without inserting anything artifact: 9e764cef2a user: kmedcalf | |
19:54 | • Reply: How to get the last row_id in a table without inserting anything artifact: 7199bb666c user: kmedcalf | |
18:51 | • Reply: How to get the last row_id in a table without inserting anything artifact: ebd065b0c5 user: anonymous | |
17:13 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 09933653c6 user: slavin | |
17:09 | • Reply: Finding database file artifact: 68e9c599ec user: slavin | |
16:59 | • Reply: How to get the last row_id in a table without inserting anything artifact: aa0b66e19f user: little-brother | |
16:43 | • Post: How to get the last row_id in a table without inserting anything artifact: 375569937c user: anonymous | |
15:05 | • Reply: deploying 1_000_000 sqlitedb on AWS? artifact: e529ede831 user: simonw | |
14:37 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 66e67959c0 user: iio7iio7 | |
14:24 | • Reply: meaning of "GROUP BY CONSTANT" artifact: 7aac6ee533 user: lcarlp | |
14:16 | • Post: XML extension artifact: 1c0294834b user: little-brother | |
12:28 | • Reply: You don't know what people are using your database for artifact: 3d98e18edb user: anonymous | |
12:22 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 4336367abb user: Clothears | |
12:13 | • Reply: meaning of "GROUP BY CONSTANT" artifact: 7a1a267a89 user: gunter_hick | |
11:58 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 42dc1488c4 user: iio7iio7 | |
11:50 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: e1903d54f1 user: iio7iio7 | |
10:36 | • Post: You don't know what people are using your database for artifact: 723c627a45 user: slavin | |
10:25 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: d5c79c3fc9 user: slavin | |
10:17 | • Reply: books / papers on "one sqlite per user" design ? artifact: 4acdf8d767 user: slavin | |
00:40 | • Reply: books / papers on "one sqlite per user" design ? artifact: e606ad4f14 user: jkreibich | |
4 Years Ago (more context)
2020-04-11
| ||
23:57 | • Reply: length function for BLOB out of sync with documentation artifact: 47716075a9 user: WHS | |
22:32 | • Reply: 3.31.1: docs as PDF? artifact: 333cfab060 user: anonymous | |
22:31 | • Reply: 3.31.1: docs as PDF? artifact: 9fe824d3b4 user: anonymous | |
22:17 | • Reply: 3.31.1: docs as PDF? artifact: 7160098d60 user: gisbert | |
20:55 | • Reply: Application ID for TeXnicard artifact: 4f7a54e80d user: anonymous | |
17:42 | • Post: typo in rescode.html artifact: f7e81d213c user: anonymous | |
17:24 | • Edit reply: length function for BLOB out of sync with documentation artifact: 4255ad6f19 user: kmedcalf | |
17:22 | • Reply: length function for BLOB out of sync with documentation artifact: 81268b3063 user: kmedcalf | |
16:57 | • Reply: length function for BLOB out of sync with documentation artifact: d4848a51e6 user: WHS | |
16:39 | • Reply: Disk I/O error on cifs volume artifact: 702a8c9c99 user: LarryBrasfield | |
15:40 | • Edit reply: length function for BLOB out of sync with documentation artifact: 454c5052bc user: kmedcalf | |
15:39 | • Edit reply: length function for BLOB out of sync with documentation artifact: a4bec63783 user: kmedcalf | |
15:38 | • Edit reply: length function for BLOB out of sync with documentation artifact: bc5a7275a9 user: kmedcalf | |
15:24 | • Reply: length function for BLOB out of sync with documentation artifact: e4cfa46a59 user: kmedcalf | |
15:02 | • Reply: Disk I/O error on cifs volume artifact: 7d4afa9a8c user: anonymous | |
14:38 | • Reply: Unexplained difference in behavior between 3.19.3 and 3.31.1 artifact: c95e91e212 user: anonymous | |
12:31 | • Reply: length function for BLOB out of sync with documentation artifact: d563f1eaae user: stephan | |
12:20 | • Reply: Return boolean if item EXISTS in database artifact: cc1d07dec6 user: anonymous | |
12:20 | • Post: length function for BLOB out of sync with documentation artifact: db7a31beee user: troyski | |
08:18 | • Edit reply: Unexplained difference in behavior between 3.19.3 and 3.31.1 artifact: 6410d416a0 user: kmedcalf | |
08:14 | • Edit reply: Unexplained difference in behavior between 3.19.3 and 3.31.1 artifact: 09f8f525a9 user: kmedcalf | |
08:11 | • Reply: Unexplained difference in behavior between 3.19.3 and 3.31.1 artifact: 507c6fb321 user: anonymous | |
08:08 | • Reply: Unexplained difference in behavior between 3.19.3 and 3.31.1 artifact: 4d66f9c278 user: kmedcalf | |
07:47 | • Reply: Disk I/O error on cifs volume artifact: 2e04a610ca user: kmedcalf | |
05:36 | • Reply: Disk I/O error on cifs volume artifact: 636e48719e user: anonymous | |
04:58 | • Post: Unexplained difference in behavior between 3.19.3 and 3.31.1 artifact: d55a0087f5 user: anonymous | |
02:48 | • Reply: Disk I/O error on cifs volume artifact: 33f1a3a91d user: LarryBrasfield | |