Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
127 events for the month beginning 2021-12-01 by user anonymous
Following month ↑
2021-12-31
| ||
18:58 | • Reply: FYI: binary dump artifact: 8d07759abf user: anonymous | |
2021-12-30
| ||
16:17 | • Reply: Left outter join on pragma tables acts as inner join artifact: 477e6ec87e user: anonymous | |
00:41 | • Post: Trivial Typo on Amalgamation Page artifact: f2c5b48dd8 user: anonymous | |
2021-12-29
| ||
20:38 | • Post: Left outter join on pragma tables acts as inner join artifact: e3a40018b5 user: anonymous | |
01:58 | • Reply: try to insert dollar sign and percentage chars artifact: d3d872fd84 user: anonymous | |
01:58 | • Reply: try to insert dollar sign and percentage chars artifact: 25ded3a1de user: anonymous | |
01:40 | • Post: try to insert dollar sign and percentage chars artifact: 21fb5ae39e user: anonymous | |
2021-12-28
| ||
23:15 | • Reply: select distinct in table and modify column artifact: d6d0247441 user: anonymous | |
14:15 | • Reply: How SQLite database can be survived from a power failure during extending the page count ? artifact: 0e5121f8f2 user: anonymous | |
13:24 | • Reply: select distinct in table and modify column artifact: 8ba91f26e1 user: anonymous | |
06:15 | • Reply: How SQLite database can be survived from a power failure during extending the page count ? artifact: eb3afa41b5 user: anonymous | |
05:30 | • Post: How SQLite database can be survived from a power failure during extending the page count ? artifact: 56edd0a899 user: anonymous | |
2021-12-27
| ||
19:49 | • Post: select distinct in table and modify column artifact: 5dc4632a61 user: anonymous | |
2021-12-26
| ||
19:49 | • Reply: table locked when dropping a temp table artifact: 5fbdddccef user: anonymous | |
14:19 | • Reply: Foreign key joins artifact: 9e931d9c40 user: anonymous | |
2021-12-24
| ||
10:48 | • Post: Parser accepts invalid column names artifact: 021a33600b user: anonymous | |
10:13 | • Reply: Selecting certain sub string artifact: 04568acf77 user: anonymous | |
2021-12-23
| ||
10:21 | • Post: Select entries based on date/time plus one before and one after artifact: 3ce0b7659e user: anonymous | |
2021-12-22
| ||
23:04 | • Post: Minor struct layout optimization in date.c artifact: 4f6efbb2a9 user: anonymous | |
2021-12-21
| ||
20:36 | • Reply: UPSERT but know what is inserted and what is updated artifact: 4a70140a85 user: anonymous | |
19:11 | • Reply: Distributed backups from a database of databases artifact: 28e12f2e91 user: anonymous | |
18:48 | • Reply: Distributed backups from a database of databases artifact: bc6a8e786d user: anonymous | |
15:05 | • Post: Distributed backups from a database of databases artifact: 1e96940007 user: anonymous | |
2021-12-20
| ||
06:39 | • Reply: Non-Unicode artifact: 2e1b099b27 user: anonymous | |
2021-12-19
| ||
02:29 | • Reply: \n breaks reading from SQLITE3 artifact: 85dd48a58c user: anonymous | |
01:43 | • Reply: Incremental backup artifact: 217f3b9e64 user: anonymous | |
2021-12-18
| ||
18:18 | • Reply: Non-Unicode artifact: 53428ca44b user: anonymous | |
17:15 | • Reply: getting list of columns artifact: 83b481c7b6 user: anonymous | |
17:13 | • Reply: getting list of columns artifact: a5fa4f4362 user: anonymous | |
17:06 | • Reply: \n breaks reading from SQLITE3 artifact: ce99b0fd39 user: anonymous | |
16:50 | • Reply: \n breaks reading from SQLITE3 artifact: d85708b1b9 user: anonymous | |
16:08 | • Reply: getting list of columns artifact: 2c1e9bc1c3 user: anonymous | |
16:00 | • Reply: Non-Unicode artifact: 22e509efc8 user: anonymous | |
07:54 | • Post: A gotcha with pragma functions artifact: 28d624e772 user: anonymous | |
06:00 | • Post: Non-Unicode artifact: f2f92e88b6 user: anonymous | |
01:44 | • Post: getting list of columns artifact: 4ab760c074 user: anonymous | |
01:11 | • Reply: \n breaks reading from SQLITE3 artifact: fd328ac547 user: anonymous | |
2021-12-17
| ||
22:33 | • Post: \n breaks reading from SQLITE3 artifact: d3f65dcd2b user: anonymous | |
14:10 | • Reply: 3.37 like now case sensitive. artifact: ab42709df0 user: anonymous | |
2021-12-16
| ||
23:17 | • Reply: Trying to "Open Database" Safari History.db file and get Error: "could not open safari database file reason: unable to open.. artifact: 77f07399b2 user: anonymous | |
13:59 | • Reply: Icu extension Windows artifact: 37e177ad13 user: anonymous | |
07:49 | • Reply: Documentation issue (wrong table name) in FAQ, point 7 artifact: 008e5a6198 user: anonymous | |
2021-12-15
| ||
21:59 | • Reply: Documentation issue (wrong table name) in FAQ, point 7 artifact: 4f848f8825 user: anonymous | |
15:19 | • Reply: Error: stepping, unable to open database file (14) artifact: c49518acd0 user: anonymous | |
06:13 | • Post: BLOB Incremental I/O vs direct file system I/O artifact: 35e9b86c42 user: anonymous | |
2021-12-14
| ||
21:43 | • Reply: 3.37 like now case sensitive. artifact: 6870d3dd64 user: anonymous | |
21:14 | • Post: 3.37 like now case sensitive. artifact: 765e3b910e user: anonymous | |
19:35 | • Reply: GopherCon 2021 presentation on litestream artifact: b7800b0e33 user: anonymous | |
19:16 | • Reply: FYI: binary dump artifact: 181313b16f user: anonymous | |
12:00 | • Reply: FYI: binary dump artifact: 10796ae90b user: anonymous | |
11:21 | • Reply: Error: stepping, unable to open database file (14) artifact: f01f96c5bf user: anonymous | |
07:05 | • Post: Lazy table artifact: 89e56ef1a3 user: anonymous | |
02:17 | • Reply: FYI: binary dump artifact: 72591f61aa user: anonymous | |
2021-12-13
| ||
19:30 | • Reply: Error: stepping, unable to open database file (14) artifact: e57bc152f3 user: anonymous | |
18:07 | • Reply: How to merge two or more tables that have the same structure? artifact: f2561906f8 user: anonymous | |
15:28 | • Reply: How to merge two or more tables that have the same structure? artifact: 20f8c250a0 user: anonymous | |
14:42 | • Post: How to merge two or more tables that have the same structure? artifact: 19843c3367 user: anonymous | |
14:21 | • Reply: FYI: binary dump artifact: cf0eb3ce0d user: anonymous | |
13:50 | • Reply: FYI: binary dump artifact: 08718d2de5 user: anonymous | |
13:41 | • Reply: Importing XML artifact: 08c2c6956d user: anonymous | |
13:11 | • Reply: Database file name encoding -- is it really UTF-8? artifact: e794d37d28 user: anonymous | |
12:51 | • Reply: Database file name encoding -- is it really UTF-8? artifact: f754755928 user: anonymous | |
12:49 | • Reply: Database file name encoding -- is it really UTF-8? artifact: 9fce556fc6 user: anonymous | |
11:04 | • Post: Importing XML artifact: c5d94e9182 user: anonymous | |
10:16 | • Post: FYI: binary dump artifact: 61812c70de user: anonymous | |
07:33 | • Reply: Database file name encoding -- is it really UTF-8? artifact: b4db40ef1f user: anonymous | |
02:51 | • Reply: Sqlite3 can happend deadlock? artifact: 13b57d0fb6 user: anonymous | |
02:17 | • Reply: Sqlite3 can happend deadlock? artifact: 6eeb1f1a31 user: anonymous | |
2021-12-12
| ||
22:40 | • Reply: Database file name encoding -- is it really UTF-8? artifact: 98e7de86bc user: anonymous | |
13:48 | • Reply: compiler warning on Version 3.37.0 (2021-11-27). artifact: 148de561c3 user: anonymous | |
10:05 | • Post: Database file name encoding -- is it really UTF-8? artifact: 52ecb18924 user: anonymous | |
2021-12-11
| ||
22:54 | • Reply: SQLite3 select (with table scan) not saturating NVMe throughput artifact: ab9bd24b5c user: anonymous | |
22:46 | • Reply: SQLite3 select (with table scan) not saturating NVMe throughput artifact: 2a39ca3c07 user: anonymous | |
21:53 | • Post: SQLite3 select (with table scan) not saturating NVMe throughput artifact: 453a51a2fc user: anonymous | |
19:50 | • Reply: Build Error: sqlite3.c(206932): error C2061: syntax error: identifier 'sqlite3_session' artifact: 611c83d0db user: anonymous | |
14:32 | • Reply: MAX performance artifact: 31d0c1a07f user: anonymous | |
14:03 | • Reply: MAX performance artifact: c6cd5509c0 user: anonymous | |
12:07 | • Post: MAX performance artifact: c790af6684 user: anonymous | |
10:55 | • Reply: UPSERT but know what is inserted and what is updated artifact: 9f75636e36 user: anonymous | |
07:44 | • Reply: UPSERT but know what is inserted and what is updated artifact: 67aa10d91c user: anonymous | |
2021-12-10
| ||
22:07 | • Post: Adding SQLite to Visual Studio 2022 Toolbox artifact: 7721eaa9b1 user: anonymous | |
18:19 | • Post: UPSERT but know what is inserted and what is updated artifact: e88687aeae user: anonymous | |
07:31 | • Reply: STRICT is keyword? artifact: 5db70e51b6 user: anonymous | |
05:22 | • Post: Sqlite3 can happend deadlock? artifact: c21dfc5a1f user: anonymous | |
05:13 | • Reply: STRICT is keyword? artifact: 58dadd48cb user: anonymous | |
2021-12-09
| ||
22:01 | • Post: STRICT is keyword? artifact: 036c79451f user: anonymous | |
21:37 | • Post: False positive Bloom filter artifact: ac0f2750a1 user: anonymous | |
08:58 | • Post: Compatilility "IF" MySQL artifact: 26f089850c user: anonymous | |
2021-12-08
| ||
19:52 | • Reply: How to use self loaded sqlite in DotNet artifact: 9fa66b7f8e user: anonymous | |
19:28 | • Post: date.c osLocaltime: Potential use of undefined variable artifact: 1d6dadeade user: anonymous | |
10:32 | • Post: SQLite Release 3.38.0 On 2022-03-39 (??) artifact: 40fadfa2a9 user: anonymous | |
05:03 | • Reply: Suggestions for learning SQL(ite) artifact: fb95267cd0 user: anonymous | |
2021-12-07
| ||
08:26 | • Post: SEE release history artifact: e04781b784 user: anonymous | |
00:12 | • Reply: Venting about inconvenient limitations, feel free to ignore artifact: af3172ed66 user: anonymous | |
2021-12-06
| ||
08:49 | • Post: If you set PreLoadSQLite_BaseDirectory it does not search in the Nuget Directories artifact: c058bea21a user: anonymous | |
00:47 | • Post: Venting about inconvenient limitations, feel free to ignore artifact: c712ab0376 user: anonymous | |
2021-12-05
| ||
14:18 | • Post: How to use self loaded sqlite in DotNet artifact: 44b9abc34a user: anonymous | |
13:08 | • Reply: Error: stepping, unable to open database file (14) artifact: 8fb5def89b user: anonymous | |
12:01 | • Reply: How to rerank one row in a big set of rows? artifact: e08e13bf2c user: anonymous | |
11:45 | • Post: confusing text in vfs.html artifact: 141ba58a50 user: anonymous | |
2021-12-04
| ||
23:57 | • Post: Error: stepping, unable to open database file (14) artifact: 7bc7b9836e user: anonymous | |
01:48 | • Reply: How to use SQLITE_CUSTOM_INCLUDE in configure artifact: 5c5c2c67ee user: anonymous | |
2021-12-03
| ||
23:59 | • Post: How to use SQLITE_CUSTOM_INCLUDE in configure artifact: 9f431ed4c1 user: anonymous | |
18:13 | • Post: SQLite Testing artifact: 7337eb8a10 user: anonymous | |
08:17 | • Reply: SQLite_Master data out of nowhere artifact: 92fc97f127 user: anonymous | |
04:05 | • Reply: Linking tables artifact: 9ba68c705e user: anonymous | |
2021-12-02
| ||
19:46 | • Reply: Howto group most similar values artifact: a1256996d6 user: anonymous | |
19:23 | • Reply: Howto group most similar values artifact: 8c32423b2c user: anonymous | |
16:40 | • Reply: Linking tables artifact: 2cc119c1e6 user: anonymous | |
16:30 | • Reply: Linking tables artifact: eba0a5ea99 user: anonymous | |
16:21 | • Reply: Linking tables artifact: fcf71ccc48 user: anonymous | |
16:05 | • Reply: Howto group most similar values artifact: d7ed82a554 user: anonymous | |
15:37 | • Post: Linking tables artifact: d035ea92d3 user: anonymous | |
14:26 | • Post: In perspective of disk usage, is the sizeof 'a' < INT ? artifact: d26860891a user: anonymous | |
13:24 | • Post: SQLite_Master data out of nowhere artifact: 23d91e1b27 user: anonymous | |
08:57 | • Reply: Cursor Keys broken on CLI ? (SQLite version 3.37.0 2021-11-24 21:16:32) artifact: 5c22af1bda user: anonymous | |
07:11 | • Reply: 64-bit precompiled Linux binaries artifact: 9551473c8b user: anonymous | |
2021-12-01
| ||
19:53 | • Reply: sqlite CLI: .timer - should be whole transaction? artifact: 9e13b9c412 user: anonymous | |
19:46 | • Post: Cursor Keys broken on CLI ? (SQLite version 3.37.0 2021-11-24 21:16:32) artifact: a1a47b2f53 user: anonymous | |
17:56 | • Post: RETURNING clause returns value despite constraint violation artifact: 793beaf322 user: anonymous | |
15:47 | • Reply: Will the database file be corrupted if using MEMORY journal mode ? artifact: 923eeb7f5a user: anonymous | |
13:47 | • Reply: Will the database file be corrupted if using MEMORY journal mode ? artifact: 1068189914 user: anonymous | |
13:24 | • Reply: Microsoft Store unsupported API artifact: f0616a7250 user: anonymous | |
08:33 | • Reply: Suggestions for learning SQL(ite) artifact: 772b149e15 user: anonymous | |
05:57 | • Post: Will the database file be corrupted if using MEMORY journal mode ? artifact: 1260a5a75d user: anonymous | |
05:41 | • Post: Suggestions for learning SQL(ite) artifact: e957d418a6 user: anonymous | |
03:18 | • Reply: Microsoft Store unsupported API artifact: 33549488f2 user: anonymous | |