Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
46 events by user dvdraymond occurring around 2020-06-18 11:32:53.
2020-08-27
| ||
12:59 | • Reply: Recursive CTE artifact: b5580ee75c user: dvdraymond | |
2020-08-25
| ||
19:46 | • Reply: CHECK violation during table definition ignored, normal or bug? artifact: e923f4157f user: dvdraymond | |
2020-08-20
| ||
19:15 | • Reply: Defragment a table ? artifact: 26a4ed1643 user: dvdraymond | |
13:21 | • Reply: Defragment a table ? artifact: 3676cbb5a1 user: dvdraymond | |
2020-08-19
| ||
19:05 | • Reply: DELETE FROM database WHERE rowid artifact: 1e6506a7cd user: dvdraymond | |
2020-08-11
| ||
16:04 | • Reply: How can I split a name column into first and last names? artifact: 0281af32e3 user: dvdraymond | |
12:13 | • Reply: Select by column id artifact: f654d697d9 user: dvdraymond | |
2020-08-03
| ||
17:23 | • Reply: Update with group_concat artifact: c16d1b3791 user: dvdraymond | |
2020-07-30
| ||
12:59 | • Reply: SQLITE python 3 issue, please help artifact: 5596076393 user: dvdraymond | |
2020-07-23
| ||
17:00 | • Reply: alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL artifact: 6886a6710a user: dvdraymond | |
15:35 | • Reply: alter table "table" add column "name" varchar not null throws Cannot add a NOT NULL column with default value NULL artifact: 1a287c1add user: dvdraymond | |
11:49 | • Reply: column check constraint typeof(col) = 'integer' fails if col has declared type text artifact: 420403c34d user: dvdraymond | |
2020-07-20
| ||
17:58 | • Reply: Error message that is not an error!!! artifact: 2058db3ef2 user: dvdraymond | |
2020-07-17
| ||
18:37 | • Reply: SELECT using variables artifact: 6848942e8a user: dvdraymond | |
14:07 | • Edit reply: SELECT using variables artifact: 95b98ab38a user: dvdraymond | |
12:33 | • Reply: SELECT using variables artifact: 3991d1eeda user: dvdraymond | |
2020-07-16
| ||
18:46 | • Reply: how to check update statement really modify a record artifact: c10b16a491 user: dvdraymond | |
2020-07-15
| ||
17:47 | • Reply: how to check update statement really modify a record artifact: ced02be52d user: dvdraymond | |
2020-07-14
| ||
13:10 | • Reply: Two space separated fields in SELECT field list artifact: ec55e6a445 user: dvdraymond | |
2020-07-07
| ||
20:21 | • Reply: max page count doesn't return sqlite_full error when reaches the limit of page count artifact: 0da82bdc52 user: dvdraymond | |
2020-07-02
| ||
13:02 | • Reply: max page count doesn't return sqlite_full error when reaches the limit of page count artifact: 6ff250f471 user: dvdraymond | |
2020-06-29
| ||
13:34 | • Reply: Can of worms - Easiest way to build a UI for Sqlite? artifact: 8ae3aca638 user: dvdraymond | |
2020-06-26
| ||
14:22 | • Reply: Problem with Sqlite DELETE documentation artifact: 1c46fabd38 user: dvdraymond | |
2020-06-19
| ||
16:06 | • Reply: Using coalesce in where clause artifact: 1d29be49b4 user: dvdraymond | |
2020-06-18
| ||
11:32 | • Reply: How to speed up this query? artifact: f119aea8c0 user: dvdraymond | |
2020-06-05
| ||
12:47 | • Reply: index question artifact: f7757de15d user: dvdraymond | |
12:19 | • Reply: index question artifact: 5277f1b57e user: dvdraymond | |
2020-06-04
| ||
13:55 | • Reply: Non primary key alias to rowid artifact: d547994810 user: dvdraymond | |
2020-04-29
| ||
12:14 | • Reply: Problem with CTE followed by a delete artifact: e026ecb450 user: dvdraymond | |
2020-04-28
| ||
12:31 | • Reply: how to backup a locked DB artifact: 56e0e8e8fd user: dvdraymond | |
2020-04-27
| ||
17:29 | • Reply: how to backup a locked DB artifact: 53e1ca0c63 user: dvdraymond | |
2020-04-21
| ||
16:22 | • Reply: Country-coding from Lat/Long, using GeoPoly and/or R-Tree artifact: a92e0fef9b user: dvdraymond | |
2020-04-14
| ||
15:02 | • Reply: Speed optimization for big single tabel searches artifact: afd22ce59e user: dvdraymond | |
14:52 | • Reply: Multi-column Foreign Key with one "hard-coded" column value artifact: 8f49dbdfc4 user: dvdraymond | |
2020-04-10
| ||
16:49 | • Reply: Return boolean if item EXISTS in database artifact: c1f27848a2 user: dvdraymond | |
12:53 | • Reply: Return boolean if item EXISTS in database artifact: e930ad2ce5 user: dvdraymond | |
12:43 | • Reply: sql column in sqlite_master artifact: 275dd764d1 user: dvdraymond | |
2020-04-08
| ||
12:51 | • Reply: Select every nth record from table artifact: d7209d7840 user: dvdraymond | |
2020-04-06
| ||
14:52 | • Reply: alter table RENAME COLUMN took 3 hours artifact: ab30590a6c user: dvdraymond | |
12:26 | • Reply: Inserting multiple rows in table artifact: ddd43e6653 user: dvdraymond | |
2020-04-03
| ||
17:24 | • Reply: Best order to vaccum, analyze, create indexes, etc.. ? artifact: 41d907af3b user: dvdraymond | |
2020-03-31
| ||
14:19 | • Reply: UPSERT On Conflict with no target artifact: 7ad06a3628 user: dvdraymond | |
13:11 | • Reply: 3.31.1: create table with multiple primary key columns artifact: 0981a2b896 user: dvdraymond | |
2020-03-25
| ||
18:35 | • Reply: Searches in the forum artifact: bd79f08c34 user: dvdraymond | |
2020-03-18
| ||
14:39 | • Reply: Request for comment: New ANALYZE syntax artifact: f901b6270e user: dvdraymond | |
2020-03-16
| ||
13:14 | • Reply: Forum emails are all going to the SPAM folder artifact: cfbb063a06 user: dvdraymond | |