SQLite Forum

Timeline
Login

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
Previous month ↓