SQLite User Forum

Today In History
Login

This Day In History For 2024-04-12

1 Year Ago (more context)

2023-04-12
23:17 Post: Assertion failure in sqlite3VdbeExec function (2) artifact: 0d48347967 user: songliu
20:18 Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 65a3e75ff6 user: larrybr
19:59 Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 52d7e7d226 user: AAsk1902
19:58 Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 8004cd4a5d user: AAsk1902
19:06 Reply: ANN Database Designer artifact: 3801dd8dfd user: anonymous
18:49 Post: A new option, possibly, for CLI: -utf8 artifact: 040f4bef6c user: larrybr
15:57 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 6c978de60a user: alexgarciaxyz
15:18 Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 608911668b user: kmedcalf
14:39 Reply: Any reason "PRAGMA schema_version;" might return "attempt to write a readonly database" artifact: 43f9b849f4 user: drh
14:22 Reply: Any reason "PRAGMA schema_version;" might return "attempt to write a readonly database" artifact: e7305c69d5 user: mgrmgr
14:02 Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds artifact: 2601a49760 user: mgrmgr
13:11 Reply: End-of-life for System.Data.SQLite 1.0.96.0 artifact: 1237758626 user: chrisjlocke1
11:31 Post: End-of-life for System.Data.SQLite 1.0.96.0 artifact: 85bcf591a1 user: anonymous
08:48 Post: Querying deferrability of foreign key constraint artifact: d187073dc9 user: pepijnve
08:16 Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: c902abcee7 user: AAsk1902
08:15 Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 2915b9e30b user: AAsk1902
08:14 Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: fc59b0709f user: AAsk1902
08:06 Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: b1f0f382c4 user: AAsk1902
07:52 Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 875e098870 user: Clothears
07:18 Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: d5c95e0d62 user: AAsk1902
07:08 Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 020f1b43b7 user: AAsk1902
07:02 Edit reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 57236e0454 user: AAsk1902
06:56 Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: ed685130c5 user: AAsk1902
06:44 Reply: about SQLite Shared-Cache Mode artifact: 5a20a27568 user: els278935
06:26 Post: Minor error from current trunk artifact: 2022c55c4d user: anonymous
06:26 Reply: about SQLite Shared-Cache Mode artifact: 02046fffb9 user: gunter_hick
05:54 Reply: £ POUND SIGN (V3.41.2) - U+00A3 artifact: 053b6c0060 user: gunter_hick
03:56 Post: about SQLite Shared-Cache Mode artifact: a447ddba37 user: els278935
02:11 Reply: There was no error when inserting data, but the data was not written in artifact: c118ab7f21 user: yzs_qaml
01:56 Edit reply: Any reason "PRAGMA schema_version;" might return "attempt to write a readonly database" artifact: 2e0136b727 user: simonw
01:56 Reply: Any reason "PRAGMA schema_version;" might return "attempt to write a readonly database" artifact: 59b4475b76 user: simonw
01:56 Reply: There was no error when inserting data, but the data was not written in artifact: 89b11fcac2 user: yzs_qaml

2 Years Ago (more context)

2022-04-12
23:29 Post: Calculated value using two foreign table values? artifact: 9c4073a3ff user: pmeloy
21:39 Reply: Incorrect query result in sqlite 3.38.2 artifact: cce1fb44cb user: slavin
15:55 Reply: Incorrect query result in sqlite 3.38.2 artifact: 3d99b81573 user: d3x0r
15:33 Edit: (Deleted) artifact: aa2e7b6fee user: tiep.vu
15:33 Edit: (Deleted) artifact: 261275c377 user: tiep.vu
15:32 Post: Incorrect query result in sqlite 3.38.2 artifact: 1829954aa6 user: tiep.vu
15:31 Post: (Deleted) artifact: 9045c83ba8 user: tiep.vu
15:08 Reply: Need Help Constructing a Query artifact: a7da16d8c1 user: cuz
13:38 Reply: integrity_check(100) calls progress callback millions of times. artifact: c714d07ef0 user: anonymous
12:54 Reply: RFE: API for column expression affinity (like CREATE TABLE AS SELECT) artifact: 5a7b04d17b user: drh
12:21 Reply: Need Help Constructing a Query artifact: 4a66328b0e user: Tomel51
12:20 Reply: Need Help Constructing a Query artifact: 99afd10785 user: Tomel51
11:11 Reply: integrity_check(100) calls progress callback millions of times. artifact: 63835a8f90 user: macsql20
06:50 Reply: Need Help Constructing a Query artifact: 0b7a12e4d9 user: anonymous
00:54 Reply: RFE: API for column expression affinity (like CREATE TABLE AS SELECT) artifact: 9044887928 user: larrybr
00:30 Reply: RFE: API for column expression affinity (like CREATE TABLE AS SELECT) artifact: 887edc3d0d user: RandomCoder

3 Years Ago (more context)

2021-04-12
23:44 Reply: Pragma compile_options does not show some options artifact: 2ad8a120ce user: larrybr
23:01 Reply: XML extension artifact: d7291ee380 user: anonymous
23:00 Reply: Noob Question artifact: b74338aebd user: anonymous
22:47 Post: Pragma compile_options does not show some options artifact: b2b813a409 user: anonymous
22:35 Reply: XML extension artifact: ad789be742 user: little-brother
22:13 Edit reply: Noob Question artifact: f785b35e32 user: little-brother
22:08 Reply: Noob Question artifact: 9bfcc6cd83 user: little-brother
22:05 Reply: Noob Question artifact: 74d75e4e65 user: anonymous
19:17 Reply: Noob Question artifact: c3442a7fe9 user: anonymous
19:00 Reply: Noob Question artifact: 4d8a207153 user: anonymous
18:44 Post: Noob Question artifact: ad8b9c405d user: anonymous
14:21 Reply: SQLite3 extensions: extension-functions.c in Windows doesn't load artifact: 9d6a148f56 user: anonymous
14:18 Reply: Only Column Names read from table artifact: 6fd4924c40 user: knu
14:07 Reply: Only Column Names read from table artifact: 9add3c3898 user: jicman
14:04 Post: NULL pointer access in sqlite3MemdbInit artifact: 460d8c3ceb user: kjarvel
13:23 Post: Only Column Names read from table artifact: e0c41837ae user: yuvraj.jambhle
13:10 Post: Getting Minimum, Maximum and Current Weight artifact: da1e7eea39 user: CecilWesterhof
12:36 Reply: SQLite3 extensions: extension-functions.c in Windows doesn't load artifact: eb50b6294c user: anonymous
12:28 Reply: find in b+-tree node artifact: 65ffbad0c8 user: billwade
11:34 Reply: How to get the last row_id in a table without inserting anything artifact: a1cfd66c76 user: drh
11:31 Reply: find in b+-tree node artifact: b303800549 user: drh
11:26 Reply: UNION Sorts on First Field artifact: 3b5f4b47a7 user: drh
11:13 Reply: SQLite3 extensions: extension-functions.c in Windows doesn't load artifact: 97c23b4cef user: gunter_hick
10:57 Reply: Regression: Mixing AND with OR results in no rows returned artifact: 7e9f0bdcca user: dan
10:52 Reply: Regression: Mixing AND with OR results in no rows returned artifact: 6fc95636bc user: dan
10:33 Edit reply: UNION Sorts on First Field artifact: 06c02cf9a3 user: gunter_hick
10:32 Reply: UNION Sorts on First Field artifact: 171c6dd697 user: gunter_hick
10:11 Reply: UNION Sorts on First Field artifact: 32bcdc60f0 user: CecilWesterhof
10:09 Post: SQLite3 extensions: extension-functions.c in Windows doesn't load artifact: 1007f28b78 user: anonymous
09:54 Reply: UNION Sorts on First Field artifact: 1e4f183293 user: gunter_hick
09:49 Reply: How to get the last row_id in a table without inserting anything artifact: 631b9a6834 user: anonymous
09:28 Post: UNION Sorts on First Field artifact: 5aa76a510d user: CecilWesterhof
08:57 Reply: XML extension artifact: eb86b8d3fa user: ddevienne
07:31 Reply: sqlite3_bind_() problem I do not understand artifact: 7b1e26a822 user: anonymous
06:51 Edit: Regression: Mixing AND with OR results in no rows returned artifact: 1809391c8f user: odubaj
06:30 Post: Regression: Mixing AND with OR results in no rows returned artifact: a7e70abb78 user: odubaj
05:01 Reply: How to get the last row_id in a table without inserting anything artifact: b47934f44b user: gunter_hick
04:56 Reply: sqlite3_bind_() problem I do not understand artifact: 00528dda4a user: dan
04:23 Reply: You don't know what people are using your database for artifact: 24e7d8a90d user: sqweek
04:02 Post: sqlite3_bind_() problem I do not understand artifact: 7d689d92a5 user: anonymous
03:51 Reply: find in b+-tree node artifact: 16592f4526 user: XiongZaiBingGan
03:28 Reply: find in b+-tree node artifact: 39ad6998d5 user: larrybr
03:23 Post: find in b+-tree node artifact: 05868d7498 user: XiongZaiBingGan
02:05 Post: Tiny comment fix artifact: 2415559747 user: anonymous
01:04 Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 1e5e023aa3 user: larrybr
00:42 Reply: You don't know what people are using your database for artifact: 9b218b3aa0 user: anonymous

4 Years Ago (more context)

2020-04-12
21:46 Reply: 3.31.1: docs as PDF? artifact: eb96b65d3d user: gisbert
21:27 Post: How to use BLOB in C program artifact: d127181b91 user: scottdoctor
18:10 Edit reply: How can I compile the newest percentile.c? artifact: 5ed16629f5 user: kmedcalf
18:07 Edit reply: How can I compile the newest percentile.c? artifact: 24b1e148a8 user: kmedcalf
18:06 Reply: How can I compile the newest percentile.c? artifact: adf0616699 user: kmedcalf
18:03 Reply: Possible transaction issues on handling multiple databases shared by multiple connections artifact: 2d1169e04f user: kmedcalf
17:02 Reply: How can I compile the newest percentile.c? artifact: 703601f60f user: drh
16:47 Post: How can I compile the newest percentile.c? artifact: 0e12a43c37 user: anonymous
16:02 Reply: Possible transaction issues on handling multiple databases shared by multiple connections artifact: 037bd34ae1 user: slavin
14:03 Reply: pivot requery SQLITE artifact: 3aa28fed01 user: itandetnik
12:04 Post: pivot requery SQLITE artifact: 651aac665d user: anonymous
11:28 Post: Possible transaction issues on handling multiple databases shared by multiple connections artifact: e9f57ea252 user: leandro
02:53 Changes to wiki page "about" artifact: 511d595e30 user: drh