SQLite Forum

Timeline
Login

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

50 most recent forum posts by user ddevienne

2022-08-05
14:26 Reply: Sublte difference between aggregation and unique index? (artifact: ad5783bc50 user: ddevienne)
13:39 Post: Sublte difference between aggregation and unique index? (artifact: 0b51a408c9 user: ddevienne)
2022-08-04
07:45 Reply: "Friendlier SQL with DuckDB" - Maybe some inspiration for SQLite? (artifact: 08e8e1532f user: ddevienne)
2022-07-27
09:59 Reply: Support DBML - Database Markup Language in SQLite (artifact: dfd8496554 user: ddevienne)
2022-07-26
15:40 Reply: Deterministic and consistent .schema of the CLI (artifact: 47894e492b user: ddevienne)
13:14 Reply: Deterministic and consistent .schema of the CLI (artifact: 5d24c88e75 user: ddevienne)
12:59 Reply: Deterministic and consistent .schema of the CLI (artifact: 0f77a83009 user: ddevienne)
11:38 Post: Deterministic and consistent .schema of the CLI (artifact: d7bc0444ce user: ddevienne)
2022-07-25
09:50 Reply: Fiddle not working on iOS? (artifact: f1fcfbdf07 user: ddevienne)
09:39 Reply: Fiddle not working on iOS? (artifact: 23af7cb513 user: ddevienne)
2022-06-28
08:05 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy (artifact: bb8f3db869 user: ddevienne)
2022-06-27
15:36 Reply: WHERE NOT IN query plan optimization (artifact: cd12a52b30 user: ddevienne)
09:54 Post: WHERE NOT IN query plan optimization (artifact: b8aab3d863 user: ddevienne)
07:12 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy (artifact: 18628420b5 user: ddevienne)
2022-06-23
07:12 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy (artifact: acead32a6a user: ddevienne)
07:10 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy (artifact: 77c09c965f user: ddevienne)
2022-06-22
18:35 Edit reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy (artifact: aa9b4229d3 user: ddevienne)
18:24 Reply: R-TREE SQLITE minx, maxx,miny,maxy accuracy (artifact: 7bde1d41d2 user: ddevienne)
2022-06-20
09:51 Reply: Unexpected Expression Result by FULL OUTER JOIN (artifact: 10a616f905 user: ddevienne)
08:12 Reply: Unexpected Expression Result by FULL OUTER JOIN (artifact: 92783873cb user: ddevienne)
2022-06-16
07:45 Reply: Multiple compression methods (artifact: 9e2a69397d user: ddevienne)
2022-06-10
09:14 Post: Enhance pragma table_info for generated columns? (artifact: d16d25595f user: ddevienne)
2022-05-20
15:15 Edit reply: Add split function (artifact: 89e6177724 user: ddevienne)
13:46 Reply: Add split function (artifact: bb5d320ea2 user: ddevienne)
13:31 Reply: Add split function (artifact: 64f7b56155 user: ddevienne)
10:58 Reply: function - condition on a column (artifact: 309d4ae4ff user: ddevienne)
08:55 Reply: function - condition on a column (artifact: ff5cf82702 user: ddevienne)
07:09 Edit reply: Add split function (artifact: e46056c952 user: ddevienne)
07:07 Reply: Add split function (artifact: 1344a714dd user: ddevienne)
2022-05-17
14:53 Reply: Method to temporarily disable Not Null constraint? (artifact: f5f54ac979 user: ddevienne)
06:56 Reply: Method to temporarily disable Not Null constraint? (artifact: 2affd351e0 user: ddevienne)
2022-05-16
19:52 Reply: Single-pass update on table possible? (artifact: 9ec118fe73 user: ddevienne)
15:43 Reply: Single-pass update on table possible? (artifact: e1fec33536 user: ddevienne)
14:52 Post: Single-pass update on table possible? (artifact: 2efc9fde57 user: ddevienne)
2022-05-11
07:40 Reply: compare two databases (artifact: 7c9ac66f2e user: ddevienne)
2022-05-10
10:32 Reply: Indexing failure (artifact: 62aed11fdc user: ddevienne)
10:29 Reply: Indexing failure (artifact: 5b1de33cdf user: ddevienne)
2022-05-04
14:25 Edit reply: (SOLVED) any idea what went wrong on this 4TB db to cause "database or disk is full" ? (artifact: 22c42e1dd2 user: ddevienne)
09:07 Edit reply: 4/17/2022, 5:03:31 PM convert into YYYY-MM-DD HH:MM:SS (artifact: 5c4d3de1e1 user: ddevienne)
08:27 Reply: 4/17/2022, 5:03:31 PM convert into YYYY-MM-DD HH:MM:SS (artifact: 778a4a277e user: ddevienne)
06:57 Reply: (SOLVED) any idea what went wrong on this 4TB db to cause "database or disk is full" ? (artifact: d884db98a2 user: ddevienne)
2022-05-03
12:14 Reply: (SOLVED) any idea what went wrong on this 4TB db to cause "database or disk is full" ? (artifact: a557194a5e user: ddevienne)
2022-05-02
09:00 Reply: Why SQLITE_OMIT_VIRTUALTABLE implies SQLITE_OMIT_ALTERTABLE (artifact: 313ee41782 user: ddevienne)
2022-04-29
11:01 Reply: Trying to come up with a LIKE IN ... (artifact: d786c21672 user: ddevienne)
07:06 Reply: Trying to come up with a LIKE IN ... (artifact: 6cbabb2df9 user: ddevienne)
2022-04-15
09:06 Reply: Foreign Key reference behavior with multiple databases attached (BUG??) (artifact: 244891b41a user: ddevienne)
2022-04-14
10:43 Reply: USING Clause on Full Outer Join Gives Nulls? (artifact: 20ba9748f2 user: ddevienne)
07:22 Reply: USING Clause on Full Outer Join Gives Nulls? (artifact: 355d5c0ee4 user: ddevienne)
2022-04-13
09:14 Reply: SQLite schema based on SQL Server DB schema (artifact: 92529b9b86 user: ddevienne)
08:53 Reply: SQLite schema based on SQL Server DB schema (artifact: 3762762642 user: ddevienne)