SQLite Forum

Timeline
Login

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

50 events by user ddevienne occurring around 2021-06-11 08:41:28.

2021-08-24
09:52 Edit: Most performant way to test for having 0, 1 or more rows in a table artifact: e1c0ad6785 user: ddevienne
09:46 Edit: Most performant way to test for having 0, 1 or more rows in a table artifact: b54e02fce9 user: ddevienne
09:30 Post: Most performant way to test for having 0, 1 or more rows in a table artifact: 15c664f67e user: ddevienne
2021-08-03
06:59 Reply: null character sorts greater than 0x7f and less than 0x80 artifact: d96aed8aff user: ddevienne
2021-07-30
13:27 Reply: LEFT JOIN Misunderstanding artifact: 134b052945 user: ddevienne
2021-07-29
08:17 Reply: Virtual RDBMS over SQLite artifact: e2fd4f50bd user: ddevienne
2021-07-20
16:02 Reply: cycle detection in CHECK constraint with recursive CTE artifact: cb6417fdf5 user: ddevienne
14:35 Reply: ROWID in compound SELECT artifact: 79fa2cae2e user: ddevienne
14:32 Edit reply: cycle detection in CHECK constraint with recursive CTE artifact: 04a82fb13f user: ddevienne
14:31 Edit reply: cycle detection in CHECK constraint with recursive CTE artifact: 2a91f2f203 user: ddevienne
14:30 Edit reply: cycle detection in CHECK constraint with recursive CTE artifact: 3d34635057 user: ddevienne
14:28 Reply: cycle detection in CHECK constraint with recursive CTE artifact: 4c3adefb82 user: ddevienne
12:23 Reply: cycle detection in CHECK constraint with recursive CTE artifact: d13515cf30 user: ddevienne
12:02 Reply: cycle detection in CHECK constraint with recursive CTE artifact: ad291bd3ec user: ddevienne
2021-07-19
12:11 Reply: Populating a tree from a flat table of subcategories artifact: c9993bacc6 user: ddevienne
2021-07-08
17:24 Reply: How to detect invalid trigger w/o actually running it? artifact: eea3380888 user: ddevienne
08:40 Post: How to detect invalid trigger w/o actually running it? artifact: 9264574ffd user: ddevienne
2021-07-07
09:29 Edit reply: How ddo I specify options with MSVC artifact: f31f52a8fe user: ddevienne
09:24 Reply: How ddo I specify options with MSVC artifact: 0ae9c9a83e user: ddevienne
2021-07-06
19:02 Reply: shared in memory db: :memory:+shared cache OR memdb VFS? artifact: 6700ab1f9f user: ddevienne
14:48 Reply: shared in memory db: :memory:+shared cache OR memdb VFS? artifact: d33f5d5dd1 user: ddevienne
14:16 Reply: shared in memory db: :memory:+shared cache OR memdb VFS? artifact: 1704cb3c96 user: ddevienne
2021-06-22
11:41 Post: Extend the ZIP vtable artifact: a306810331 user: ddevienne
2021-06-11
08:44 Edit reply: Vritual Tables Performing SQL Queries artifact: 0bd6ca49c1 user: ddevienne
08:41 Reply: Vritual Tables Performing SQL Queries artifact: d0a80b3d68 user: ddevienne
2021-06-08
11:53 Reply: Feature request: Stored Procedures artifact: d22b2c1eab user: ddevienne
2021-06-07
07:57 Reply: Transaction level triggers? artifact: f76641770b user: ddevienne
2021-05-18
11:16 Reply: Bug report: strange error message in cte and window function artifact: 6e54dbeb22 user: ddevienne
2021-05-13
19:09 Reply: sqlite3_stmt_readonly is dependent on the current database artifact: bac557cc17 user: ddevienne
2021-05-11
14:07 Reply: Fast way to insert rows in SQLite artifact: ad4458bd32 user: ddevienne
10:52 Reply: Fast way to insert rows in SQLite artifact: ab320568a4 user: ddevienne
08:48 Edit reply: Fast way to insert rows in SQLite artifact: 568f5fce3e user: ddevienne
08:40 Reply: Fast way to insert rows in SQLite artifact: 27fdb02205 user: ddevienne
2021-04-28
12:56 Reply: Blobs & SQLITE_TRANSIENT clarification artifact: 5bb2d1644a user: ddevienne
08:12 Edit reply: Blobs & SQLITE_TRANSIENT clarification artifact: 8340f64524 user: ddevienne
08:11 Edit reply: Blobs & SQLITE_TRANSIENT clarification artifact: d2be307833 user: ddevienne
08:10 Reply: Blobs & SQLITE_TRANSIENT clarification artifact: c6fe519852 user: ddevienne
2021-04-21
13:52 Reply: The NUMERIC data type? artifact: 437810a956 user: ddevienne
07:20 Edit reply: Why no release announcement in this Forum anymore? artifact: fa3a6af85b user: ddevienne
07:19 Reply: Why no release announcement in this Forum anymore? artifact: db976e5c4d user: ddevienne
2021-04-19
14:22 Reply: How to Record all Transactions artifact: 5ff9d5ce84 user: ddevienne
14:17 Reply: SQLite doesn't use indexes for bitwise clauses? artifact: 77f12f0a1f user: ddevienne
12:53 Reply: SQLite doesn't use indexes for bitwise clauses? artifact: 4fee04fb03 user: ddevienne
08:59 Reply: usage of SHA-1 artifact: 0dd4b73ef9 user: ddevienne
2021-04-15
09:38 Reply: Noob Question artifact: 71fdd2830e user: ddevienne
2021-04-12
08:57 Reply: XML extension artifact: eb86b8d3fa user: ddevienne
2021-04-09
07:18 Delete reply: json_contains Function Idea artifact: 57536f3aeb user: ddevienne
07:17 Reply: json_contains Function Idea artifact: 19e59eee76 user: ddevienne
2021-04-06
08:50 Reply: open db in read only; explicitly store diff as WAL ? artifact: cdec30c813 user: ddevienne
2021-03-23
10:23 Reply: When is SELECT ... FROM with no table-or-subquery valid. artifact: 9cf9de6e84 user: ddevienne