SQLite User Forum

Today In History
Login

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