SQLite Forum

Timeline
Login

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

111 events by user kmedcalf occurring around 2021-10-28 06:09:22.

2021-12-07
04:07 Reply: Windows Build default compile options? artifact: ba57ce897a user: kmedcalf
2021-12-06
02:04 Reply: SQLite Testing artifact: 70026e7a73 user: kmedcalf
2021-12-05
02:17 Edit reply: Error: stepping, unable to open database file (14) artifact: 4238f24b08 user: kmedcalf
02:15 Reply: Error: stepping, unable to open database file (14) artifact: f8ef1c9342 user: kmedcalf
02:10 Reply: Proposed new date/time function to return a unix timestamp artifact: 741263fb7b user: kmedcalf
2021-12-03
20:43 Reply: SQLite Testing artifact: f70416f7f3 user: kmedcalf
2021-12-02
18:27 Reply: Will the database file be corrupted if using MEMORY journal mode ? artifact: 7e763a5bd4 user: kmedcalf
2021-11-30
21:55 Reply: Proposed new date/time function to return a unix timestamp artifact: 8e66227e40 user: kmedcalf
2021-11-29
17:20 Edit reply: Proposed new date/time function to return a unix timestamp artifact: 73fc7a8fa7 user: kmedcalf
17:19 Reply: Proposed new date/time function to return a unix timestamp artifact: bbdefae9c7 user: kmedcalf
2021-11-26
21:35 Reply: sqlite CLI: .timer - should be whole transaction? artifact: 626174198b user: kmedcalf
20:37 Reply: sqlite CLI: .timer - should be whole transaction? artifact: c40c38258d user: kmedcalf
20:32 Reply: group_concat - ORDER BY parameter please. artifact: e26bfd68e4 user: kmedcalf
20:25 Reply: group_concat - ORDER BY parameter please. artifact: 228bb96e12 user: kmedcalf
2021-11-25
17:58 Reply: Faster way to insert into WITHOUT ROWID table? artifact: c0af76e5f5 user: kmedcalf
17:50 Reply: How to rerank one row in a big set of rows? artifact: c4943eab84 user: kmedcalf
17:48 Reply: How to rerank one row in a big set of rows? artifact: 98ddcbd5a8 user: kmedcalf
2021-11-24
22:37 Reply: Feature Request: ATTACH DB readonly? artifact: c35e9d87d5 user: kmedcalf
21:54 Reply: Feature Request: ATTACH DB readonly? artifact: 5208775b10 user: kmedcalf
2021-11-22
20:43 Reply: Proposed slightly-incompatible change to date-time functions artifact: 9a491235f9 user: kmedcalf
20:30 Edit reply: Proposed slightly-incompatible change to date-time functions artifact: 9183c02f7f user: kmedcalf
2021-11-21
21:50 Reply: big performance hit when querying 2 values in a single query instead of two artifact: 55ff70e928 user: kmedcalf
20:54 Reply: big performance hit when querying 2 values in a single query instead of two artifact: cb5d1e75cf user: kmedcalf
19:17 Reply: Proposed slightly-incompatible change to date-time functions artifact: 05068ae52c user: kmedcalf
18:25 Reply: Proposed slightly-incompatible change to date-time functions artifact: 382aadc198 user: kmedcalf
18:10 Reply: Proposed slightly-incompatible change to date-time functions artifact: bf24576a95 user: kmedcalf
03:17 Reply: IS NULL optimization on NOT NULL constraints breaks on corrupted databases artifact: 2194c356e2 user: kmedcalf
02:42 Reply: Proposed slightly-incompatible change to date-time functions artifact: 62db41fcfc user: kmedcalf
2021-11-19
21:56 Reply: IS NULL optimization on NOT NULL constraints breaks on corrupted databases artifact: 677e52a522 user: kmedcalf
2021-11-17
23:25 Reply: sqlite3.dll is not returning control to my program artifact: 0be17c459c user: kmedcalf
19:41 Reply: SQLite + TCL on-line conference starts in less than 2 days artifact: b2ababc565 user: kmedcalf
19:32 Reply: SQLite + TCL on-line conference starts in less than 2 days artifact: 5e670438a9 user: kmedcalf
19:03 Reply: LockingMode Exclusive for a shared readonly database artifact: feeaf539c8 user: kmedcalf
18:44 Reply: User Define Aggregate Functions with multiple columns and scaler value artifact: f46ded7529 user: kmedcalf
18:12 Reply: Hot backup database in WAL mode by coping artifact: 1307e36986 user: kmedcalf
02:07 Reply: Hot backup database in WAL mode by coping artifact: 4e7930ba21 user: kmedcalf
2021-11-16
23:29 Reply: Hot backup database in WAL mode by coping artifact: 623a68fb98 user: kmedcalf
23:21 Reply: Hot backup database in WAL mode by coping artifact: a27f866abd user: kmedcalf
23:12 Reply: Hot backup database in WAL mode by coping artifact: 173897e539 user: kmedcalf
20:01 Reply: Hot backup database in WAL mode by coping artifact: ca61d80c84 user: kmedcalf
17:27 Reply: Tcl interface : pb with "rollback_hook" method artifact: 8ee9d60f86 user: kmedcalf
2021-11-09
13:05 Reply: ExecuteNonQuery returns wrong number of affected elements artifact: 1461fc6ec4 user: kmedcalf
2021-11-07
20:57 Reply: Delete duplicate rows with an extra character artifact: 9781bdd3cb user: kmedcalf
20:54 Reply: Delete duplicate rows with an extra character artifact: 0cc73c5ec6 user: kmedcalf
19:05 Reply: Delete duplicate rows with an extra character artifact: 122885c581 user: kmedcalf
19:00 Reply: Delete duplicate rows with an extra character artifact: 749c1de319 user: kmedcalf
2021-11-04
11:33 Reply: Is the order conserved in a table from a VALUES clause? artifact: 57bb6764ca user: kmedcalf
2021-11-03
18:38 Reply: Get SQLITE_READONLY when using UPDATE command artifact: fb695bf2bb user: kmedcalf
18:22 Reply: Get SQLITE_READONLY when using UPDATE command artifact: ba973d06af user: kmedcalf
18:12 Delete reply: Get SQLITE_READONLY when using UPDATE command artifact: e2f211565e user: kmedcalf
18:02 Reply: Get SQLITE_READONLY when using UPDATE command artifact: 2d2d7cd87e user: kmedcalf
17:53 Reply: Get SQLITE_READONLY when using UPDATE command artifact: cfd173fc16 user: kmedcalf
2021-11-02
22:17 Reply: Get SQLITE_READONLY when using UPDATE command artifact: 0ffe91a011 user: kmedcalf
20:35 Reply: sqlite3_threadsafe() return value artifact: 3450eea435 user: kmedcalf
2021-11-01
23:24 Reply: Unable to open the connection artifact: 2da978aa43 user: kmedcalf
2021-10-28
06:09 Reply: Database on android SD CARD artifact: 07b7d0a660 user: kmedcalf
06:03 Reply: database creation getting hung up on a NFS mount path artifact: 2fb76e5907 user: kmedcalf
06:00 Reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: 3a66ea2c0a user: kmedcalf
2021-10-26
04:23 Reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: 1bf33f0ef4 user: kmedcalf
00:45 Edit reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: a7f2f09ebf user: kmedcalf
00:43 Edit reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: cb728a42e1 user: kmedcalf
00:38 Reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: f162d6f95b user: kmedcalf
2021-10-25
23:06 Reply: SOLVED Getting SQLITE_LOCKED where SQLITE_BUSY is expected artifact: c33881c335 user: kmedcalf
2021-10-22
00:14 Edit reply: SELECT STATEMENT FOR OGR2OGR IN GIS artifact: 7f1cf4791a user: kmedcalf
00:08 Edit reply: SELECT STATEMENT FOR OGR2OGR IN GIS artifact: c198f66f99 user: kmedcalf
00:07 Reply: SELECT STATEMENT FOR OGR2OGR IN GIS artifact: d857d0d3cc user: kmedcalf
2021-10-21
23:32 Reply: SELECT STATEMENT FOR OGR2OGR IN GIS artifact: 8b1051f010 user: kmedcalf
02:38 Edit reply: I need a little help with UPDATE? artifact: 35117e44c3 user: kmedcalf
02:32 Reply: I need a little help with UPDATE? artifact: de7f14b20f user: kmedcalf
2021-10-18
01:32 Reply: Column names and aliases in expressions artifact: 5ed7b20e02 user: kmedcalf
00:14 Edit reply: Column names and aliases in expressions artifact: 6b0a817262 user: kmedcalf
00:12 Reply: Column names and aliases in expressions artifact: 9cb5b81d6b user: kmedcalf
00:02 Reply: Column names and aliases in expressions artifact: 43b8740461 user: kmedcalf
2021-10-16
09:10 Reply: Temp database artifact: 74f3e90063 user: kmedcalf
03:16 Reply: Temp database artifact: 9cdef47899 user: kmedcalf
03:04 Reply: Temp database artifact: dd390b9eb7 user: kmedcalf
02:41 Reply: Temp database artifact: dcdb9d6a21 user: kmedcalf
2021-10-12
03:38 Reply: Compiling sqlite system on Ubuntu artifact: c0c4885b24 user: kmedcalf
01:28 Reply: x86_64/amd64 sqlite3 binaries artifact: fc6c19f0b0 user: kmedcalf
2021-10-11
10:13 Reply: Question about the WAL checkpoint artifact: c8aa908b1a user: kmedcalf
06:11 Reply: Question about the WAL checkpoint artifact: 840085999a user: kmedcalf
2021-10-10
04:31 Reply: Understanding memory allocation behavior of SQLite artifact: 27f435d986 user: kmedcalf
04:02 Reply: Understanding memory allocation behavior of SQLite artifact: 7663c481a9 user: kmedcalf
03:58 Reply: Understanding memory allocation behavior of SQLite artifact: 380c7b4e09 user: kmedcalf
03:46 Reply: Understanding memory allocation behavior of SQLite artifact: 4145a5b3aa user: kmedcalf
03:36 Reply: Understanding memory allocation behavior of SQLite artifact: 191a960f3f user: kmedcalf
2021-10-09
22:55 Edit reply: Understanding memory allocation behavior of SQLite artifact: 68f0bb3574 user: kmedcalf
22:53 Reply: Understanding memory allocation behavior of SQLite artifact: a713acf701 user: kmedcalf
22:36 Reply: Understanding memory allocation behavior of SQLite artifact: 6c19417c4c user: kmedcalf
05:39 Reply: Updating in-process connections on write artifact: 2098136c48 user: kmedcalf
05:32 Edit reply: Updating in-process connections on write artifact: d4840bf9e8 user: kmedcalf
05:30 Reply: Updating in-process connections on write artifact: bf7e0d8f1d user: kmedcalf
03:38 Reply: Updating in-process connections on write artifact: 28ff21d6ac user: kmedcalf
2021-10-05
21:33 Edit reply: Insert within CTE artifact: 98fb8943a2 user: kmedcalf
21:29 Reply: Insert within CTE artifact: 9a1011513e user: kmedcalf
2021-10-02
21:35 Reply: How to read Images from sqlite3 and show via opencv, PIL or Matplot lib ? artifact: c4cb567022 user: kmedcalf
2021-09-29
01:16 Reply: User -efined functions in the CLI? artifact: 17b16efcf2 user: kmedcalf
01:04 Reply: Reset database artifact: a6ae99e7e8 user: kmedcalf
2021-09-28
19:56 Reply: Can I detect if the disk supports WAL mode? artifact: 292a68c5e4 user: kmedcalf
2021-09-23
22:06 Reply: sqlite3_exec artifact: bdf03c6b29 user: kmedcalf
21:59 Reply: cannot start a transaction within a transaction using sqlite shell artifact: c6bd81ce51 user: kmedcalf
2021-09-22
20:46 Reply: cannot start a transaction within a transaction using sqlite shell artifact: 8f7faacc3d user: kmedcalf
18:34 Reply: cannot start a transaction within a transaction using sqlite shell artifact: dbb5e7c5d7 user: kmedcalf
2021-09-21
19:36 Edit reply: How to find out whether a table is STRICT? artifact: bc3f2aa846 user: kmedcalf
19:35 Edit reply: How to find out whether a table is STRICT? artifact: 09995f663d user: kmedcalf
19:34 Reply: How to find out whether a table is STRICT? artifact: 306b1c9009 user: kmedcalf
19:12 Reply: create taable with syntax error works ? artifact: ed960841e2 user: kmedcalf
2021-09-20
21:06 Reply: How to find out whether a table is STRICT? artifact: 755549daff user: kmedcalf
21:02 Reply: How to find out whether a table is STRICT? artifact: 501b42cc24 user: kmedcalf
20:52 Reply: adding record if it doesn't already exist artifact: 2cca664331 user: kmedcalf
08:52 Reply: adding record if it doesn't already exist artifact: 8e1549f8c1 user: kmedcalf