SQLite Forum

Timeline
Login

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

44 events by user dvdraymond occurring around 2020-06-05 12:19:44.

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