SQLite Forum

Timeline
Login

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

50 events by user dvdraymond occurring around 2020-07-14 13:10:19.

2020-09-08
17:02 Reply: Switching data between two columns (artifact: ee5f103e71 user: dvdraymond)
13:29 Reply: sqlite3 column truncation problem (artifact: d45466627a user: dvdraymond)
12:51 Reply: Unexpected behaviour of the json_valid function and .json mode in CLI (artifact: f0bc6d2b4d user: dvdraymond)
2020-08-31
14:56 Reply: How do I access urls in a sqlite database using timedelta? (artifact: 16fd344482 user: dvdraymond)
2020-08-28
17:37 Reply: Recursive CTE (artifact: d303383d90 user: dvdraymond)
2020-08-27
20:29 Reply: Recursive CTE (artifact: 922f28b6ea user: dvdraymond)
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)