SQLite Forum

Timeline
Login

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

125 events for the month beginning 2022-08-01 by user anonymous

Following month ↑
2022-08-31
22:36 Post: Announce list for new releases artifact: 8ac448d5fc user: anonymous
19:39 Reply: WAL3 mode - RFC for Concurrent Writes artifact: 2cb33b2b2a user: anonymous
14:58 Reply: Regression: Invalid SQL error in UPDATE when using column from table being updated in left join predicate artifact: 0ed2e37ed8 user: anonymous
2022-08-30
22:39 Reply: pragma_* table-valued function irregularities artifact: 9c6a73aefb user: anonymous
20:47 Post: pragma_* table-valued function irregularities artifact: d43aa47ab9 user: anonymous
2022-08-29
18:14 Reply: How to expose SQL API query endpoint safely? artifact: 034b964fc7 user: anonymous
16:16 Reply: SQLite on Windows for ARM artifact: e7d284cc1d user: anonymous
15:58 Reply: Inclusion of .recover in the SQLite3 API artifact: 455705b748 user: anonymous
14:47 Post: lang_datefunc documentation seems off? artifact: 930158cd96 user: anonymous
09:22 Reply: How to expose SQL API query endpoint safely? artifact: 7467ea0706 user: anonymous
09:11 Reply: How to expose SQL API query endpoint safely? artifact: 135ba38952 user: anonymous
08:55 Reply: JDBC backup api artifact: 935353ea29 user: anonymous
08:35 Reply: JDBC backup api artifact: 8380f1bb71 user: anonymous
06:18 Post: JDBC backup api artifact: a74a4f4a67 user: anonymous
01:58 Post: Inclusion of .recover in the SQLite3 API artifact: 628c06f3e1 user: anonymous
2022-08-27
16:47 Reply: Operational Error artifact: 0c2927a3f6 user: anonymous
01:41 Post: Operational Error artifact: a7dcff6cf1 user: anonymous
2022-08-26
13:18 Reply: Arrays in SQLite artifact: cc7c596e45 user: anonymous
12:46 Reply: How to generate series of month end dates between two dates artifact: e107823a2b user: anonymous
07:44 Post: How to generate series of month end dates between two dates artifact: ea088e6d8e user: anonymous
2022-08-25
22:23 Reply: Regression: Invalid SQL error in UPDATE when using column from table being updated in left join predicate artifact: e9d2d07055 user: anonymous
19:29 Reply: How to Corrrupt an SQLite DB Section 2.2.1 artifact: 5e679d46d8 user: anonymous
18:21 Post: Regression: Invalid SQL error in UPDATE when using column from table being updated in left join predicate artifact: 09862e12c7 user: anonymous
17:47 Reply: SQLite on Windows for ARM artifact: 777ce420ac user: anonymous
13:59 Post: How to Corrrupt an SQLite DB Section 2.2.1 artifact: dbf245f2b7 user: anonymous
13:22 Reply: Arrays in SQLite artifact: a7ebcadcff user: anonymous
2022-08-24
18:53 Reply: SQLite on Windows for ARM artifact: b22e0bbbe9 user: anonymous
12:06 Post: (Deleted) artifact: 655a294d25 user: anonymous
2022-08-23
23:31 Post: win-arm64 support artifact: 643d71a04b user: anonymous
20:53 Reply: Cross process change notification artifact: eaa7108907 user: anonymous
04:59 Reply: Inconsistent .def files in Windows binaries 3.39.2 artifact: 9166828aab user: anonymous
2022-08-22
04:23 Reply: Inconsistent .def files in Windows binaries 3.39.2 artifact: 481581a5cf user: anonymous
02:11 Reply: Assistance in selecting indexes (novice/amateur level) artifact: 7b8f4afa83 user: anonymous
2022-08-20
18:47 Reply: what are the recommended storage limits per sqlite? is it possible to have 200TB in SQLite and still have good performance in artifact: 3ed0ed5091 user: anonymous
18:19 Reply: Assistance in selecting indexes (novice/amateur level) artifact: 508fcc7223 user: anonymous
13:19 Reply: Remove duplicate rows? artifact: ad235e398f user: anonymous
09:16 Post: Partial fts5 index on content artifact: fc2520dfd8 user: anonymous
06:38 Reply: Assistance in selecting indexes (novice/amateur level) artifact: 5e3af2875c user: anonymous
02:16 Post: Assistance in selecting indexes (novice/amateur level) artifact: 08b5d1686b user: anonymous
2022-08-19
18:22 Reply: Will sqlite serialise queries from multiple threads? artifact: 1d734afa81 user: anonymous
13:43 Reply: Will sqlite serialise queries from multiple threads? artifact: 126cfc2d42 user: anonymous
12:39 Reply: Proposed change to allow null values on csv import artifact: 5e14eecb91 user: anonymous
11:14 Post: Will sqlite serialise queries from multiple threads? artifact: afac2fc076 user: anonymous
02:11 Reply: Total ordering of transactions in WAL artifact: 81ba059fcd user: anonymous
2022-08-18
16:30 Reply: Add Comment is Must artifact: 8ced12e9d4 user: anonymous
12:36 Reply: Add Comment is Must artifact: 182842ce15 user: anonymous
12:05 Reply: Query to create a table with blank row inserted between missing RowID's? artifact: b8077563ae user: anonymous
02:18 Reply: Query to create a table with blank row inserted between missing RowID's? artifact: fc5264c77c user: anonymous
02:18 Reply: Query to create a table with blank row inserted between missing RowID's? artifact: d813148e6c user: anonymous
02:17 Reply: Query to create a table with blank row inserted between missing RowID's? artifact: d7cddb02ac user: anonymous
00:32 Post: Query to create a table with blank row inserted between missing RowID's? artifact: fa3d236684 user: anonymous
2022-08-17
19:35 Reply: Delete every record except the first of the month artifact: ef37d95ffa user: anonymous
18:36 Reply: Add Comment is Must artifact: d7be961c5c user: anonymous
13:58 Reply: calculate percentage artifact: 3f4ce5d234 user: anonymous
2022-08-16
23:57 Reply: json_object() runtime error in a TEXT column artifact: 7e1be111f2 user: anonymous
21:58 Reply: (Deleted) artifact: f9b248b570 user: anonymous
21:46 Reply: Special feature in sqlite: definite time triggers artifact: e9d8ed65f3 user: anonymous
21:32 Reply: Special feature in sqlite: definite time triggers artifact: 8a7b09d7e3 user: anonymous
21:23 Post: Special feature in sqlite: definite time triggers artifact: 15b23c9c9c user: anonymous
20:06 Reply: calculate percentage artifact: 512d4671c0 user: anonymous
19:24 Reply: (Deleted) artifact: 3b3ce86fad user: anonymous
19:14 Reply: (Deleted) artifact: 9015c0a72e user: anonymous
16:42 Post: calculate percentage artifact: 1b9a263813 user: anonymous
15:53 Reply: What is the difference between SQLite and Microsoft Access on a technical level? What features is SQLite better or has more f artifact: 713cf942cc user: anonymous
14:01 Reply: Any way to preserve subquery result order in outer query artifact: 27035e6bc0 user: anonymous
05:54 Reply: Temporary database with memory limit artifact: dccf57dec7 user: anonymous
2022-08-15
13:44 Reply: What is the difference between SQLite and Microsoft Access on a technical level? What features is SQLite better or has more f artifact: e4c39175bb user: anonymous
05:09 Post: What is the difference between SQLite and Microsoft Access on a technical level? What features is SQLite better or has more f artifact: c78fcea9b7 user: anonymous
2022-08-14
21:47 Reply: First insert always takes longer artifact: 9e29c812de user: anonymous
17:19 Post: what are the recommended storage limits per sqlite? is it possible to have 200TB in SQLite and still have good performance in artifact: f4c818fdca user: anonymous
02:30 Reply: ODBC official in sqlite, is possible? artifact: 9aa74445c1 user: anonymous
2022-08-13
23:18 Reply: First insert always takes longer artifact: 4799470b7a user: anonymous
15:53 Reply: ODBC official in sqlite, is possible? artifact: 6900d401c7 user: anonymous
12:42 Reply: making Count() … GROUP BY faster artifact: e4a19f8c02 user: anonymous
05:28 Reply: ODBC official in sqlite, is possible? artifact: 5005321c09 user: anonymous
04:31 Reply: Issues in window function documentation artifact: 2f555ae23a user: anonymous
2022-08-12
20:34 Post: ODBC official in sqlite, is possible? artifact: fbc7f52ae1 user: anonymous
19:02 Reply: making Count() … GROUP BY faster artifact: 1454bdb552 user: anonymous
12:00 Reply: Temporary database with memory limit artifact: 0d23ccc88c user: anonymous
09:51 Reply: Temporary database with memory limit artifact: fe7351f74f user: anonymous
06:06 Reply: Temporary database with memory limit artifact: 198882e08a user: anonymous
2022-08-11
21:29 Reply: How to init a database schema with many concurent accessors artifact: 69e11a0735 user: anonymous
18:45 Post: Are there any open source examples of applications using the RBU extension? artifact: e58f9241c7 user: anonymous
17:27 Reply: How to init a database schema with many concurent accessors artifact: 5bf7d2b4ad user: anonymous
11:35 Reply: Temporary database with memory limit artifact: 021b989e7b user: anonymous
08:32 Reply: Temporary database with memory limit artifact: 7121748c53 user: anonymous
07:23 Post: Temporary database with memory limit artifact: dd8852e499 user: anonymous
2022-08-09
20:23 Reply: json_object() runtime error in a TEXT column artifact: 503b1cd9db user: anonymous
19:15 Reply: json_object() runtime error in a TEXT column artifact: 0e65ffe486 user: anonymous
18:09 Reply: json_object() runtime error in a TEXT column artifact: 3838ebd8a9 user: anonymous
07:45 Reply: json_object() runtime error in a TEXT column artifact: 9e9a88a481 user: anonymous
00:31 Reply: Potential typo in equation in window function documentation artifact: 2c075036c3 user: anonymous
00:28 Post: Issues in window function documentation artifact: 52377d35ea user: anonymous
00:02 Reply: Best practice implementing row level authorization? artifact: 350f7bef06 user: anonymous
2022-08-08
22:17 Reply: Database file format changes since 3.35.3? artifact: 367687933f user: anonymous
22:03 Reply: Tutorial - structuring SQL with CTEs and decoupling SQL via JSON - seeking feedback artifact: 632ad85f1e user: anonymous
17:17 Reply: SQLite in Browsers: Nightmare, Dream, Reality? artifact: fe3ed5513c user: anonymous
16:55 Post: SQLite in Browsers: Nightmare, Dream, Reality? artifact: 6e26ff6a98 user: anonymous
04:57 Reply: Basic speedup and transactions artifact: 7921191d44 user: anonymous
2022-08-07
21:55 Reply: Undocumented file control opcodes artifact: 446eaa1064 user: anonymous
19:37 Reply: Best practice implementing row level authorization? artifact: 2e4b58ca45 user: anonymous
00:30 Reply: Request for extension of sqlite3_vfs struct artifact: 66061dbf1d user: anonymous
2022-08-06
21:46 Post: Request for extension of sqlite3_vfs struct artifact: e1705362a0 user: anonymous
2022-08-05
20:00 Reply: Conflicting types when building artifact: 4418460c0e user: anonymous
19:25 Post: Undocumented file control opcodes artifact: ad771247d4 user: anonymous
18:56 Reply: Patches to compile SQLite with non-Unicode artifact: 8f42bc28ec user: anonymous
15:08 Reply: Conflict resolution between upsert and triggers artifact: e8c102dab1 user: anonymous
13:20 Post: Conflict resolution between upsert and triggers artifact: 4a474ff8b0 user: anonymous
06:41 Reply: The hex() value is different from the requested value artifact: 05aeec5d0d user: anonymous
06:33 Reply: The hex() value is different from the requested value artifact: a52076dc9f user: anonymous
05:06 Post: The hex() value is different from the requested value artifact: 511708e3eb user: anonymous
2022-08-04
20:07 Reply: Patches to compile SQLite with non-Unicode artifact: 7da1f90f52 user: anonymous
17:08 Reply: Patches to compile SQLite with non-Unicode artifact: 111334eff9 user: anonymous
16:55 Post: Question about REAL datatype artifact: 75d21b7311 user: anonymous
07:47 Post: "Smart Database" or "Smart SQLite" or "SQLite with Fido" artifact: f724b8cf44 user: anonymous
2022-08-03
22:46 Post: Patches to compile SQLite with non-Unicode artifact: 23c80443ca user: anonymous
2022-08-02
15:40 Reply: Insert into geoply table seg faults artifact: d817598a63 user: anonymous
15:32 Reply: sqlite3.dll compatibility with php artifact: c7dc70a8bc user: anonymous
10:34 Post: sqlite3.dll compatibility with php artifact: dd50a44e00 user: anonymous
2022-08-01
18:14 Reply: Porting Sqlite to freertos artifact: 95f6e77a9b user: anonymous
12:51 Reply: SQLite PRAGMA configurations not causing noticeable performance compared to default PRAGMA configurations artifact: b84c5372f2 user: anonymous
12:13 Post: Insert into geoply table seg faults artifact: a096ab7d96 user: anonymous
07:07 Reply: Foreign keys artifact: a813e634ef user: anonymous
05:34 Reply: Inconsistent .def files in Windows binaries 3.39.2 artifact: 682cca5dc4 user: anonymous
05:31 Post: Attached database qestion artifact: 7d6ed3d1b9 user: anonymous
Previous month ↓