SQLite Forum

Timeline
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

117 events for the month beginning 2021-07-01 by user anonymous

Following month ↑
2021-07-31
16:37 Reply: Round function returning -0.0 artifact: 40d106fae4 user: anonymous
11:48 Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: e9ddd6fbba user: anonymous
11:14 Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: 5844099d7b user: anonymous
2021-07-30
18:36 Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: f5c0464ab1 user: anonymous
17:57 Post: Abbreviation artifact: 83063fd4b5 user: anonymous
17:50 Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: a5be7fc80c user: anonymous
17:35 Reply: Odd CL behaviour artifact: 7c6ca8d1ff user: anonymous
17:33 Post: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: bc1d13cddc user: anonymous
13:40 Reply: AUTOINCREMENT by value artifact: b16e26a6b7 user: anonymous
12:28 Reply: LEFT JOIN Misunderstanding artifact: bd05c5ea6e user: anonymous
07:17 Post: sqlite3_errcode(db_instance) incorrectly returns SQLITE_OK(0) when last error code was SQLITE_READONLY(8) artifact: 3836350f74 user: anonymous
07:15 Reply: Round function returning -0.0 artifact: 4899757b88 user: anonymous
07:14 Post: sqlite3_errcode(db_instance) incorrectly returns SQLITE_OK(0) when last error code was SQLITE_READONLY(8) artifact: 379ddb8296 user: anonymous
06:11 Reply: Which version of SQLite supports VxWorks DKM mode ? artifact: 3e5df61bae user: anonymous
04:06 Post: Round function returning -0.0 artifact: cc8d7dd31b user: anonymous
2021-07-29
21:17 Reply: Error not given when referencing something that doesn't exist artifact: 839504d50b user: anonymous
05:47 Reply: Entries seen in WAL missing when reading DB artifact: a2c41e300d user: anonymous
2021-07-28
19:35 Post: MIN()/MAX() performance thought artifact: 5c37851472 user: anonymous
17:18 Reply: Need 1.0.110.0 x64 Download artifact: 6ebbca5078 user: anonymous
08:17 Post: Which version of SQLite supports VxWorks DKM mode ? artifact: ec2ef89b1c user: anonymous
05:23 Post: Entries seen in WAL missing when reading DB artifact: 4827f7e056 user: anonymous
04:54 Post: Error not given when referencing something that doesn't exist artifact: 12293019e2 user: anonymous
02:54 Post: .NET 5 and sqlite artifact: fa8b6aab1f user: anonymous
2021-07-27
14:55 Post: Need 1.0.110.0 x64 Download artifact: d9352b83ea user: anonymous
2021-07-26
15:39 Reply: how can i identify the data is just inserted into the database or updated the existed item when i use upsert-clause artifact: 5840b4b09d user: anonymous
2021-07-23
21:27 Reply: sqlite3 LIKE clause with parameters for c api artifact: 644c06438c user: anonymous
20:52 Post: sqlite3 LIKE clause with parameters for c api artifact: cf208c4d6a user: anonymous
20:12 Reply: Can SQLite be used with AWS Elastic File System (EFS)? artifact: 339d237d65 user: anonymous
12:44 Reply: Parse failure doing UPDATE FROM artifact: 78fc63e142 user: anonymous
12:30 Post: Parse failure doing UPDATE FROM artifact: 6a4416f903 user: anonymous
2021-07-21
14:50 Reply: Csv or Vsv parsing blob column artifact: 9e96b82fb3 user: anonymous
11:59 Reply: Csv or Vsv parsing blob column artifact: 4c092cc0a9 user: anonymous
10:34 Reply: Wrong version for download artifact: 285687cd2d user: anonymous
09:32 Reply: SELECT optimization for constant expression artifact: 70799fcac8 user: anonymous
08:37 Post: SQLite diff tool doesn't work with CRLF new line characters artifact: 862ebf4146 user: anonymous
06:27 Post: Wrong version for download artifact: 78ccea0eb1 user: anonymous
06:05 Reply: Calculating duration in ISO8601 timestamp artifact: 2df32e81d9 user: anonymous
2021-07-20
23:39 Post: Csv or Vsv parsing blob column artifact: 682ad5f740 user: anonymous
23:20 Reply: Calculating duration in ISO8601 timestamp artifact: c798c74f8d user: anonymous
21:38 Reply: Calculating duration in ISO8601 timestamp artifact: 3579576882 user: anonymous
21:09 Reply: Calculating duration in ISO8601 timestamp artifact: bdf01f49ff user: anonymous
20:45 Post: Calculating duration in ISO8601 timestamp artifact: 4e3a94320d user: anonymous
18:52 Reply: Query Detail Table artifact: 9cf51e6df7 user: anonymous
16:15 Reply: cycle detection in CHECK constraint with recursive CTE artifact: 57f4f90f1d user: anonymous
15:38 Reply: cycle detection in CHECK constraint with recursive CTE artifact: 876ceec83e user: anonymous
15:36 Reply: cycle detection in CHECK constraint with recursive CTE artifact: 8a0a450e53 user: anonymous
10:24 Reply: cycle detection in CHECK constraint with recursive CTE artifact: 938c042b93 user: anonymous
05:16 Reply: document nit chapter 2 section 3 literals artifact: 7816e8ff71 user: anonymous
2021-07-19
17:19 Reply: Programmatically getting information about the 'where' clause artifact: dbd5ef5850 user: anonymous
16:59 Post: Programmatically getting information about the 'where' clause artifact: 88ca56bddf user: anonymous
2021-07-18
17:18 Post: Update records in a table based on selection in another table artifact: 2d4b633dfa user: anonymous
07:05 Post: Does the column order in an insert statement impact the insert speed? artifact: fd254d2db8 user: anonymous
2021-07-17
21:22 Reply: Tips for getting SQLite under Python to perform better with more RAM? artifact: 544c18f8bf user: anonymous
14:46 Reply: cycle detection in CHECK constraint with recursive CTE artifact: c4ef455584 user: anonymous
14:30 Reply: Unable to load DLL 'SQLite.Interop.dll' (0x8007007E) using nuget version 1.0.114.4 of System.Data.Sqlite artifact: e4b46d6e87 user: anonymous
13:07 Reply: cycle detection in CHECK constraint with recursive CTE artifact: f7efbc8d41 user: anonymous
2021-07-16
18:56 Reply: Tips for getting SQLite under Python to perform better with more RAM? artifact: 2c9c5ae773 user: anonymous
18:02 Post: cycle detection in CHECK constraint with recursive CTE artifact: 621a2129b5 user: anonymous
14:14 Post: Documentation typo in Retrieving Statement SQL artifact: 23a98d2b51 user: anonymous
09:12 Reply: Help with a query artifact: 04900a8152 user: anonymous
08:19 Reply: Memory cache artifact: ae9c105798 user: anonymous
03:45 Reply: Should SQLite be able to optimize this query? artifact: 8d1660e7ee user: anonymous
2021-07-15
21:04 Reply: Help with a query artifact: 0b0aea8efc user: anonymous
19:51 Reply: Should SQLite be able to optimize this query? artifact: acac0c5cb7 user: anonymous
18:29 Post: PSTOKEN extension (new version) artifact: 0e2bc16832 user: anonymous
13:46 Reply: FILTER clause with window functions artifact: 8691e0dbab user: anonymous
11:33 Reply: Help with a query artifact: aa167badc2 user: anonymous
2021-07-14
21:51 Reply: Help with a query artifact: 9f0a1f8ea7 user: anonymous
21:04 Reply: Help with a query artifact: 659869ad08 user: anonymous
20:55 Reply: Help with a query artifact: 5dfde50996 user: anonymous
20:38 Reply: Help with a query artifact: a6378c5671 user: anonymous
11:20 Reply: Help with a query artifact: 34517f330e user: anonymous
10:49 Reply: Help with a query artifact: 4c5dcc4259 user: anonymous
10:33 Reply: Help with a query artifact: d7431afaed user: anonymous
09:47 Reply: Help with a query artifact: e2ee3ae697 user: anonymous
09:11 Post: Help with a query artifact: 521815dc1d user: anonymous
02:15 Reply: fortify source artifact: 7e368833dc user: anonymous
01:02 Reply: fortify source artifact: c5cc151a96 user: anonymous
00:37 Reply: fortify source artifact: 367b6b85bb user: anonymous
2021-07-13
19:06 Post: fortify source artifact: df546ea2ef user: anonymous
13:22 Post: My Database is being deleted after each restart of my code. How can I fix it? artifact: 30d62a223b user: anonymous
04:28 Post: "=" character not mentioned in expr syntax definition artifact: 1a4e6b96f9 user: anonymous
04:20 Reply: CHECK and ON CONFLICT artifact: 0f41f9c7a5 user: anonymous
00:13 Post: CHECK and ON CONFLICT artifact: 9a99a1a132 user: anonymous
2021-07-11
23:24 Post: article: SQLite Extraction of Oracle Tables artifact: 399f346e05 user: anonymous
16:24 Reply: LOAD_EXTENSION: Error: error during initialization: artifact: 424253d93b user: anonymous
13:14 Reply: Nonsensical import column separator error artifact: fb0474c876 user: anonymous
12:44 Post: Nonsensical import column separator error artifact: a1844c6ec5 user: anonymous
12:36 Reply: Unstack one column to multiple artifact: be86b27313 user: anonymous
10:50 Reply: Can this SQL be simplified? artifact: 979bb0e9ad user: anonymous
2021-07-10
18:27 Reply: Can this SQL be simplified? artifact: ce14a018bc user: anonymous
2021-07-09
16:26 Reply: usage of SHA-1 artifact: eec8e1bc73 user: anonymous
13:42 Post: not able to update rows artifact: 43b5cc306c user: anonymous
09:30 Reply: Deleted rows not in FreeList artifact: f7925a9ac0 user: anonymous
08:45 Reply: Deleted rows not in FreeList artifact: 7a323d249b user: anonymous
2021-07-08
14:39 Reply: Switching pragma synchronous to upgrade durability artifact: 1046c87e75 user: anonymous
13:14 Reply: Custom / pluggable VDBE behavior? artifact: 60bdfe7ecf user: anonymous
12:45 Post: Custom / pluggable VDBE behavior? artifact: 76f0087704 user: anonymous
12:09 Reply: How to detect invalid trigger w/o actually running it? artifact: 311bc202c5 user: anonymous
12:05 Post: Deleted rows not in FreeList artifact: 2e968c7a49 user: anonymous
11:31 Post: Awesome people artifact: d32a1fda35 user: anonymous
05:52 Reply: php sqlite3_create_window_function artifact: 4f3641d89b user: anonymous
03:47 Reply: How ddo I specify options with MSVC artifact: 2650e63d98 user: anonymous
2021-07-07
23:22 Reply: Support for blocking VFS artifact: 07e7d8a8fe user: anonymous
18:44 Reply: Strange filter condition with notNull artifact: 4747ec0150 user: anonymous
08:45 Post: How ddo I specify options with MSVC artifact: 0fc579946b user: anonymous
01:55 Reply: Query Detail Table artifact: fdf999ca08 user: anonymous
2021-07-06
20:57 Reply: Query Detail Table artifact: e7eb3c69b6 user: anonymous
20:04 Post: Query Detail Table artifact: f78e44ac4c user: anonymous
2021-07-04
15:19 Post: Curious about check-in [5e7e0d4ef8] artifact: 26b4e0055d user: anonymous
2021-07-03
13:02 Reply: cannot create tables in sqlitestudio than other apps can see artifact: d0248a3406 user: anonymous
2021-07-02
06:14 Reply: SQLite.Interop.dll and NetStandard artifact: aede337a8a user: anonymous
06:00 Reply: SQLite.Interop.dll and NetStandard artifact: 642725b617 user: anonymous
04:22 Reply: Incorrect Result From SQLite Query artifact: 524e25a2c2 user: anonymous
2021-07-01
21:35 Post: Clustered vs Non Clustered Indexes in SQLite artifact: ae6836d44e user: anonymous
15:06 Reply: cannot create tables in sqlitestudio than other apps can see artifact: e6d1af88d1 user: anonymous
09:49 Post: SQLite.Interop.dll and NetStandard artifact: 1637001888 user: anonymous
Previous month ↓