SQLite Forum

Timeline
Login

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

86 events for the month beginning 2023-05-01 by user kmedcalf

Following month ↑
2023-05-31
17:43 Reply: Column Default value artifact: 01092b65ae user: kmedcalf
17:33 Reply: SQLITE_BUSY & SQLITE_LOCKED artifact: ba9c1d044d user: kmedcalf
17:20 Reply: Forcing read only access artifact: 18f562e2c6 user: kmedcalf
2023-05-30
19:58 Edit reply: Column Default value artifact: 032284286f user: kmedcalf
19:56 Reply: Column Default value artifact: 454a2b10d3 user: kmedcalf
19:24 Reply: Column Default value artifact: 9f675db2eb user: kmedcalf
18:05 Reply: RETURNING _rowid_ on insert to a virtual table != sqlite3_last_insert_rowid() artifact: bf8063892c user: kmedcalf
17:32 Reply: RETURNING _rowid_ on insert to a virtual table != sqlite3_last_insert_rowid() artifact: f763493c2a user: kmedcalf
17:26 Reply: SQLITE_BUSY The database file is locked (database is locked) artifact: 099cb3ca36 user: kmedcalf
15:39 Edit reply: SQLITE_BUSY The database file is locked (database is locked) artifact: 9abc7a5e7b user: kmedcalf
15:38 Reply: SQLITE_BUSY The database file is locked (database is locked) artifact: 5bf34b1c8c user: kmedcalf
2023-05-29
19:48 Reply: Column Default value artifact: f65788ffbc user: kmedcalf
2023-05-28
19:44 Edit reply: Why is DuckDB's window function more than 20 times faster than SQLite? artifact: aa36a16ab0 user: kmedcalf
19:43 Reply: Why is DuckDB's window function more than 20 times faster than SQLite? artifact: 3f75ce896e user: kmedcalf
18:36 Edit reply: Why is DuckDB's window function more than 20 times faster than SQLite? artifact: 73f31aef73 user: kmedcalf
18:33 Reply: Why is DuckDB's window function more than 20 times faster than SQLite? artifact: 5783ebe56c user: kmedcalf
15:55 Reply: Why is DuckDB's window function more than 20 times faster than SQLite? artifact: 08b5ef13de user: kmedcalf
2023-05-27
17:16 Edit reply: Collation order for Norway, Sweden, Denmark artifact: b145586725 user: kmedcalf
17:07 Edit reply: Collation order for Norway, Sweden, Denmark artifact: 89a36039bd user: kmedcalf
16:56 Reply: Collation order for Norway, Sweden, Denmark artifact: 0fc297f393 user: kmedcalf
15:46 Edit reply: Column Default value artifact: 6d58b46f74 user: kmedcalf
15:45 Reply: Column Default value artifact: 1e27092134 user: kmedcalf
2023-05-26
18:45 Reply: Collation order for Norway, Sweden, Denmark artifact: 194fb23a0c user: kmedcalf
15:49 Reply: UPDATE FROM query - Standard SQL equivalent query artifact: 33c5e64838 user: kmedcalf
15:26 Reply: Parse error when a RETURNING clause refers to the alias of the inserted table artifact: 51e37a4c04 user: kmedcalf
2023-05-25
19:42 Reply: Trying to do an UPDATE FROM query artifact: eaee0c83e2 user: kmedcalf
17:06 Edit reply: C# generate_series() problem artifact: 18a64e57c1 user: kmedcalf
17:04 Reply: C# generate_series() problem artifact: 3220da83b4 user: kmedcalf
16:54 Reply: Collation order for Norway, Sweden, Denmark artifact: 73d0e24eca user: kmedcalf
16:51 Reply: Collation order for Norway, Sweden, Denmark artifact: 4c1c919a4f user: kmedcalf
16:39 Reply: Collation order for Norway, Sweden, Denmark artifact: bfa4f6e22a user: kmedcalf
2023-05-24
16:27 Reply: Allow sqlar to work from a view? artifact: 0f751207a0 user: kmedcalf
16:14 Reply: Allow sqlar to work from a view? artifact: e1c47b2f2a user: kmedcalf
14:52 Reply: Allow sqlar to work from a view? artifact: e0e4a5742d user: kmedcalf
13:22 Reply: Performance of REPLACE artifact: f293c02edf user: kmedcalf
13:15 Reply: Allow sqlar to work from a view? artifact: 98c6e761a0 user: kmedcalf
2023-05-23
22:10 Edit reply: Row value index search oddity artifact: 859775726c user: kmedcalf
20:43 Reply: Row value index search oddity artifact: bffa967d1b user: kmedcalf
20:30 Edit reply: Row value index search oddity artifact: 14a0eee7e4 user: kmedcalf
20:03 Reply: Row value index search oddity artifact: 7f6a341d8e user: kmedcalf
18:41 Reply: joined query is slow in spite of using indexes artifact: 1f9b1a2de2 user: kmedcalf
18:21 Reply: joined query is slow in spite of using indexes artifact: 62a192fe88 user: kmedcalf
17:22 Edit reply: joined query is slow in spite of using indexes artifact: c1b8a2fdcb user: kmedcalf
17:09 Reply: Row value index search oddity artifact: fa54e894fe user: kmedcalf
16:42 Reply: SQLite Internal/Compile variables artifact: 0b976702e9 user: kmedcalf
16:32 Reply: making row_numbe() faster artifact: b63d939068 user: kmedcalf
2023-05-22
16:55 Reply: joined query is slow in spite of using indexes artifact: c4fb7ac653 user: kmedcalf
16:07 Reply: joined query is slow in spite of using indexes artifact: 7a97e0c058 user: kmedcalf
15:53 Reply: getting query performance info artifact: 74f86a4409 user: kmedcalf
14:37 Edit reply: .explain on artifact: 3057ecbed7 user: kmedcalf
14:37 Reply: .explain on artifact: 2523e9cf96 user: kmedcalf
2023-05-20
17:54 Reply: Feature request: Allow trailing commas at the end of SELECT column lists artifact: 7b6354c75c user: kmedcalf
2023-05-19
15:33 Reply: Only Column Names read from table artifact: b9d7080a4f user: kmedcalf
2023-05-16
15:01 Reply: json_each seems to be triggering an UPDATE in the authorizer artifact: 311348fd05 user: kmedcalf
2023-05-15
20:51 Reply: .explain on artifact: 2073a51634 user: kmedcalf
14:50 Reply: .explain on artifact: a71fcb6b52 user: kmedcalf
14:24 Reply: .explain on artifact: c6b5e55ff5 user: kmedcalf
13:18 Reply: .explain on artifact: 87a162e000 user: kmedcalf
2023-05-14
19:13 Reply: How does Sqlite shrink_memory work? artifact: a0bf63643f user: kmedcalf
19:05 Reply: fonction texte "Left" artifact: b17abed688 user: kmedcalf
18:51 Reply: Recovery data base artifact: a1051f584c user: kmedcalf
01:03 Reply: How does Sqlite shrink_memory work? artifact: acd405cac6 user: kmedcalf
2023-05-13
17:49 Reply: code = Busy (5), message = System.Data.SQLite.SQLiteException (0x800007AF): database is locked database is locked artifact: bea08c789f user: kmedcalf
03:38 Reply: How does Sqlite shrink_memory work? artifact: cb276da6a8 user: kmedcalf
2023-05-12
16:22 Reply: Binary column: multiple data types and converting integer to blob artifact: 9cb7e91b5b user: kmedcalf
15:56 Reply: SELECT query with Float equality artifact: a99fb41818 user: kmedcalf
15:18 Edit reply: Binary column: multiple data types and converting integer to blob artifact: d8d36d50c2 user: kmedcalf
14:47 Edit reply: Binary column: multiple data types and converting integer to blob artifact: b51f19baba user: kmedcalf
14:44 Reply: Binary column: multiple data types and converting integer to blob artifact: c64a69c97c user: kmedcalf
14:38 Reply: Binary column: multiple data types and converting integer to blob artifact: 9a49fc46c5 user: kmedcalf
13:12 Reply: Bilingual SQLite search tricks artifact: 41bec04bc7 user: kmedcalf
2023-05-09
19:53 Reply: code = Busy (5), message = System.Data.SQLite.SQLiteException (0x800007AF): database is locked database is locked artifact: c8cf7f2c3d user: kmedcalf
19:02 Reply: code = Busy (5), message = System.Data.SQLite.SQLiteException (0x800007AF): database is locked database is locked artifact: 2aa9bef97c user: kmedcalf
18:37 Reply: code = Busy (5), message = System.Data.SQLite.SQLiteException (0x800007AF): database is locked database is locked artifact: 54b8cdc34b user: kmedcalf
16:17 Reply: unable to open database file artifact: 9e06ae1ca1 user: kmedcalf
2023-05-08
17:15 Reply: Format('0x$x',?) Query artifact: 3472efb5d3 user: kmedcalf
15:20 Reply: Locking has a very obvious effect on the asynchronous execution of implicit ,but has a minimal effect on explicit artifact: 29a87e0d8e user: kmedcalf
14:40 Reply: Locking has a very obvious effect on the asynchronous execution of implicit ,but has a minimal effect on explicit artifact: 5e3ad36c7e user: kmedcalf
2023-05-07
16:36 Reply: attempt to write a readonly database after Windows Updates artifact: 4662925c02 user: kmedcalf
16:32 Reply: System.Data.SQLite Help File Unreadable artifact: 1e469fdb8a user: kmedcalf
2023-05-04
14:52 Reply: concat, concat_ws, T-SQL artifact: 8624a1c1b1 user: kmedcalf
2023-05-03
14:42 Reply: DB file is dropped/re-created on next app run artifact: 4821870a7d user: kmedcalf
2023-05-01
17:41 Reply: Is sed faster than SQLite? artifact: b3e4af35b2 user: kmedcalf
15:40 Reply: Is sed faster than SQLite? artifact: 3983374e99 user: kmedcalf
15:31 Reply: Is sed faster than SQLite? artifact: 1eda734eb8 user: kmedcalf
15:21 Reply: Is sed faster than SQLite? artifact: afd7471fc3 user: kmedcalf
Previous month ↓