SQLite User Forum

Today In History
Login

This Day In History For 2024-03-30

1 Year Ago (more context)

2023-03-30
23:49 Reply: System.Data.SQLite transaction behaviour. artifact: 1a319d8618 user: mistachkin
23:12 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: cfaa9a4ee0 user: knu
22:41 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: 5c40f49477 user: dempson
22:24 Reply: before insert trigger artifact: 59cb085a27 user: knu
21:47 Reply: before insert trigger artifact: eb6b942cff user: dfgriggs
20:34 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: 3ac2059ce5 user: knu
18:47 Reply: unixepoch(): document if it rounds or truncates artifact: 914f658ac2 user: larrybr
18:08 Reply: Correct way of carrying connections over forked processes artifact: 0f7a7b785d user: larrybr
17:55 Edit: System.Data.SQLite transaction behaviour. artifact: 364a5bfadf user: tolgaong
17:51 Reply: before insert trigger artifact: 9730496d99 user: justme
17:39 Reply: Correct way of carrying connections over forked processes artifact: d2ecd6cdcf user: paulclinger
17:38 Reply: before insert trigger artifact: 38c117a6b2 user: dvdraymond
17:30 Reply: Correct way of carrying connections over forked processes artifact: 86f3267e20 user: paulclinger
17:24 Reply: Correct way of carrying connections over forked processes artifact: b5f8e9fe70 user: paulclinger
17:19 Reply: Correct way of carrying connections over forked processes artifact: a4eab4245a user: paulclinger
17:17 Reply: before insert trigger artifact: e88f7361b4 user: dvdraymond
17:04 Reply: why does this query return table names instead of actual tables? artifact: 202cf263de user: sqlitevexee
16:59 Reply: why does this query return table names instead of actual tables? artifact: 86e557ed4d user: dvdraymond
16:47 Reply: before insert trigger artifact: 5ea92e0a6e user: justme
16:44 Reply: before insert trigger artifact: efb0da70af user: justme
16:09 Reply: why does this query return table names instead of actual tables? artifact: 2902565a8b user: sqlitevexee
15:48 Reply: why does this query return table names instead of actual tables? artifact: af7e87c715 user: sqlitevexee
15:35 Reply: before insert trigger artifact: ec17690b4e user: kmedcalf
15:31 Edit reply: why does this query return table names instead of actual tables? artifact: 3778034263 user: chrisjlocke1
15:30 Reply: CROSS JOIN doc bug? artifact: a75e3f1703 user: kmedcalf
15:27 Reply: why does this query return table names instead of actual tables? artifact: 0141f41969 user: chrisjlocke1
14:48 Reply: Dot Commands artifact: ba2600217e user: slavin
14:47 Post: System.Data.SQLite transaction behaviour. artifact: 8d5fd4c1a9 user: tolgaong
14:43 Reply: why does this query return table names instead of actual tables? artifact: fd1d064621 user: sqlitevexee
14:39 Edit reply: why does this query return table names instead of actual tables? artifact: db04bb2253 user: dvdraymond
14:37 Edit reply: before insert trigger artifact: 7ab510ebaf user: lexfiend
14:33 Reply: why does this query return table names instead of actual tables? artifact: 113c3b7122 user: dvdraymond
13:37 Post: why does this query return table names instead of actual tables? artifact: 70e76593bc user: sqlitevexee
13:34 Edit reply: CROSS JOIN doc bug? artifact: 6b2459c296 user: holgerj
13:33 Reply: Error: in prepare, no such column: %03d SQLite version 3.41.2 2023-03-22 11:56:21 artifact: 74c3f2bf52 user: anonymous
13:25 Reply: CROSS JOIN doc bug? artifact: 5439147ddd user: holgerj
12:12 Reply: Correct way of carrying connections over forked processes artifact: ed99424f97 user: UserMBL
11:18 Reply: before insert trigger artifact: 2878946194 user: knu
08:29 Reply: Correct way of carrying connections over forked processes artifact: 65eeb1797d user: ddevienne
08:13 Reply: Invalid pointer returned for SQLITE_SCANSTAT_EXPLAIN text artifact: 1bd889b107 user: ddevienne
07:03 Post: unixepoch(): document if it rounds or truncates artifact: a7c07be63d user: jidanni
05:02 Post: The provider did not return a ProviderManifest instance artifact: eccf1e6f4d user: Elanchezhiyan
04:51 Reply: Correct way of carrying connections over forked processes artifact: cf74c7e5e0 user: sqweek
04:40 Reply: before insert trigger artifact: e4b470150d user: lexfiend
03:56 Post: Request: Pragma to toggle DQS artifact: 4bbae0aaa2 user: anonymous
03:45 Reply: before insert trigger artifact: cff07eefce user: justme
03:22 Reply: before insert trigger artifact: 1bc8862b3c user: justme
03:21 Reply: before insert trigger artifact: 1ae26d2e0a user: justme
02:46 Reply: Correct way of carrying connections over forked processes artifact: 1fa0772820 user: larrybr
02:13 Reply: Column aliases inside FROM artifact: 2f66a37ade user: larrybr
00:53 Post: Correct way of carrying connections over forked processes artifact: 602c40a48d user: paulclinger
00:04 Reply: before insert trigger artifact: eb6b1e8cda user: kmedcalf

2 Years Ago (more context)

2022-03-30
23:57 Reply: some weird date side effects artifact: c0c8f0d97a user: drh
22:40 Post: some weird date side effects artifact: 6e208d89ba user: rbucker
22:04 Reply: Save in memory db to hd artifact: 3dbb09ed7c user: wyoung
21:54 Edit reply: Multi-threaded C# test for SQLite fails with 'database table is locked' artifact: fc9521137f user: kmedcalf
21:54 Reply: Multi-threaded C# test for SQLite fails with 'database table is locked' artifact: 88cec8e48e user: kmedcalf
21:48 Reply: Multi-threaded C# test for SQLite fails with 'database table is locked' artifact: c253672d96 user: kmedcalf
21:44 Post: Save in memory db to hd artifact: fa9f9cd803 user: Woody.033
21:06 Post: Multi-threaded C# test for SQLite fails with 'database table is locked' artifact: f1915598df user: cmgain
18:07 Reply: Mixing AUTOINCREMENT with composite foreign key artifact: a4807886c1 user: anonymous
17:45 Reply: SEE License Implementation won't work in .Net API artifact: 723d67937f user: mistachkin
15:33 Reply: March 30 2022 - your windows binaries doe not create correct hash artifact: f632eefa3b user: wyoung
15:31 Post: March 30 2022 - your windows binaries doe not create correct hash artifact: 7b85bd9c5a user: anonymous
14:28 Reply: Unicode Character in TEXT column artifact: 8aaceffef4 user: larrybr
14:19 Reply: Unicode Character in TEXT column artifact: 0f646cb842 user: larrybr
14:13 Reply: Unicode Character in TEXT column artifact: 7e4bab751c user: anonymous
14:10 Reply: Unicode Character in TEXT column artifact: d868c0e1ca user: anonymous
14:03 Reply: Sharing a SQLite3 Database artifact: 81567f1a44 user: TLGLee
14:01 Reply: Unicode Character in TEXT column artifact: fea1ddc962 user: slavin
13:49 Reply: Unicode Character in TEXT column artifact: 39d4a24536 user: anonymous
13:37 Reply: Unicode Character in TEXT column artifact: 646f703797 user: anonymous
13:35 Reply: Unicode Character in TEXT column artifact: 86878350e9 user: larrybr
13:21 Reply: Unicode Character in TEXT column artifact: 125eaf28e6 user: gunter_hick
12:56 Post: Unicode Character in TEXT column artifact: 871d066d6c user: anonymous
12:32 Reply: Mixing AUTOINCREMENT with composite foreign key artifact: 64813535b7 user: meepuebe
12:26 Reply: Can a SQLite DB be accessed by another Computer? artifact: 6801ae9386 user: Owamreta
11:35 Reply: integrity_check(100) calls progress callback millions of times. artifact: 18017e4817 user: drh
11:19 Reply: integrity_check(100) calls progress callback millions of times. artifact: 1476133f9f user: macsql20
10:38 Reply: CLI handling of unterminated /* comments artifact: d12aa5b889 user: larrybr
09:59 Post: CLI handling of unterminated /* comments artifact: aefd62fcc7 user: mark
08:56 Reply: Incorrect 3.38.2 win64 download artifact: 6ff0671da4 user: anonymous
04:04 Reply: Mixing AUTOINCREMENT with composite foreign key artifact: 03a60be512 user: larrybr
03:49 Reply: Mixing AUTOINCREMENT with composite foreign key artifact: 6dd03da32a user: anonymous
01:29 Post: Mixing AUTOINCREMENT with composite foreign key artifact: 5cfbf4e35a user: meepuebe
01:16 Edit reply: How to trim suffix from a text column? artifact: 5238881020 user: kmedcalf
01:12 Edit reply: How to trim suffix from a text column? artifact: 4842c50d1a user: kmedcalf

3 Years Ago (more context)

2021-03-30
23:48 Reply: What is the point of a lone SELECT statement in an SQLite trigger? artifact: 90773dd940 user: kmedcalf
23:28 Reply: What is the point of a lone SELECT statement in an SQLite trigger? artifact: 7ac2fad4e0 user: dorian
23:08 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 968d5c12a8 user: kmedcalf
22:59 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: be3b67da52 user: kmedcalf
22:30 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 12517fa2be user: drh
22:25 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: df0d14ed6a user: kmedcalf
21:46 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 38d5607478 user: larrybr
19:48 Reply: Automatic change True value to 1 artifact: 70643d03d7 user: kmedcalf
19:41 Reply: Atomically initialize database artifact: 9b1f89b3fd user: TripeHound
18:56 Post: Automatic change True value to 1 artifact: 8c16830921 user: Illu__
18:04 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 417a7e08ff user: anonymous
15:49 Reply: Atomically initialize database artifact: 73791d194d user: RichardDamon
15:03 Post: Atomically initialize database artifact: 6d397b8f9a user: billwade
14:30 Reply: What is the point of a lone SELECT statement in an SQLite trigger? artifact: c0381ab451 user: drh
13:57 Reply: What is the point of a lone SELECT statement in an SQLite trigger? artifact: ee0c1413bb user: anonymous
08:39 Edit: Trouble writing/retrieving a small UTF-8 GIF image. artifact: 3cb5f64306 user: 1codedebugger
08:25 Post: System.Data.SQLite release artifact: 0347aaf7e6 user: mmecing
07:49 Reply: Trouble writing/retrieving a small UTF-8 GIF image. artifact: 04a5c3a9d0 user: gunter_hick
07:34 Post: What is the point of a lone SELECT statement in an SQLite trigger? artifact: 7b673d64f3 user: dorian
07:05 Reply: Trouble writing/retrieving a small UTF-8 GIF image. artifact: 2a1c21dbb7 user: sqweek
07:03 Edit: Trouble writing/retrieving a small UTF-8 GIF image. artifact: 6a7001b651 user: 1codedebugger
06:27 Edit: Trouble writing/retrieving a small UTF-8 GIF image. artifact: 2735a2a31e user: 1codedebugger
06:23 Post: Trouble writing/retrieving a small UTF-8 GIF image. artifact: 6fb14e85dd user: 1codedebugger
06:18 Reply: Can you export multiple tables into ONE excel file on ONE tab? artifact: 5770336cc4 user: romankris
04:44 Edit: (Deleted) artifact: 8f46d9b832 user: 1codedebugger
03:12 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 08c0529cc6 user: kmedcalf
02:02 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 6fa9839334 user: drh
00:54 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 7dbf046041 user: drh
00:12 Reply: Crash when a RETURNING clause refers to a table in UPDATE FROM artifact: 68c88ac201 user: kmedcalf

4 Years Ago (more context)

2020-03-30
22:53 Reply: 3.31.1: create table with multiple primary key columns artifact: e80a323595 user: kmedcalf
22:32 Reply: 3.31.1: create table with multiple primary key columns artifact: 58c7e94cde user: richs
22:02 Reply: 3.31.1: create table with multiple primary key columns artifact: 344d06d75a user: kmedcalf
21:57 Reply: Sqlite in PHP import data from a file artifact: 6103da0ae3 user: slavin
21:53 Reply: 3.31.1: create table with multiple primary key columns artifact: d1f0c41aaa user: richs
21:41 Reply: How can I maintain a list in an arbitrary order? artifact: ffc5812124 user: kmedcalf
21:32 Reply: 3.31.1: create table with multiple primary key columns artifact: 96513fb983 user: doug9forester
21:13 Reply: 3.31.1: create table with multiple primary key columns artifact: bcf2feaf9f user: kmedcalf
21:12 Reply: feature request: Add option to UNIQUE constrain to treat NULLs as distinct artifact: 679f99ce26 user: anonymous
20:54 Reply: How can I maintain a list in an arbitrary order? artifact: d67fd7b460 user: kmedcalf
20:03 Reply: How can I maintain a list in an arbitrary order? artifact: 294711bbde user: cladisch
20:03 Reply: 3.31.1: create table with multiple primary key columns artifact: 1c52d6802e user: richs
19:57 Reply: 3.31.1: create table with multiple primary key columns artifact: cf2979708f user: richs
19:36 Post: How can I maintain a list in an arbitrary order? artifact: 65a52ad3de user: doug9forester
19:25 Edit reply: 3.31.1: create table with multiple primary key columns artifact: e83cea2e22 user: kmedcalf
19:15 Reply: 3.31.1: create table with multiple primary key columns artifact: 01cba6a4b0 user: kmedcalf
19:06 Reply: 3.31.1: create table with multiple primary key columns artifact: fc5fa5181b user: drh
18:30 Reply: 3.31.1: create table with multiple primary key columns artifact: 45f6aece23 user: anonymous
18:27 Post: 3.31.1: create table with multiple primary key columns artifact: e5b49fab2e user: richs
18:22 Reply: Sqlite in PHP import data from a file artifact: dfa6410cb3 user: pizzipie
15:31 Reply: How to display count(*) artifact: 5a5fd8bf01 user: stephan
14:52 Post: How to display count(*) artifact: 39eecc9f0e user: tonyATMS
13:18 Post: Trivial typo in the documentation artifact: 8e6cf07cc8 user: gisbert
13:14 Edit reply: 3.31.1: docs as PDF? artifact: cffc9481fe user: gisbert
13:13 Reply: 3.31.1: docs as PDF? artifact: ddd9e2a310 user: gisbert
12:45 Reply: docs: minor typo artifact: 664f4ac66f user: missinglink
12:25 Reply: progress handler from user functions artifact: 8175620922 user: gunter_hick
12:02 Edit reply: 3.31.1: docs as PDF? artifact: 05a4df13b6 user: KlaasZ4usVanBv
12:00 Delete reply: 3.31.1: docs as PDF? artifact: b228c411cd user: KlaasZ4usVanBv
11:32 Post: Fossil: Cloning under Catalina seems not to work artifact: cd50cdef1b user: KlaasZ4usVanBv
09:33 Reply: progress handler from user functions artifact: a762001840 user: Maxulite
09:26 Reply: Sqlite in PHP import data from a file artifact: 620a422fd7 user: slavin
08:20 Reply: Natural sort order artifact: af474c3883 user: ddevienne
07:45 Reply: 3.31.1: docs as PDF? artifact: a301a09ad6 user: anonymous
06:46 Reply: progress handler from user functions artifact: 7bcf7f7680 user: gunter_hick
06:21 Reply: vtable constructor failed fails in one machine artifact: 869d4dafb9 user: gunter_hick