SQLite Forum

Timeline
Login

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

50 forum posts by user dvdraymond occurring on or before 2020-09-16 14:53:28.

2020-09-16
14:53 Reply: get changed columns data (previous/ after) on update row and previous data before delete row (artifact: 9ba9a36e19 user: dvdraymond)
13:48 Reply: get changed columns data (previous/ after) on update row and previous data before delete row (artifact: 392c60a256 user: dvdraymond)
13:11 Reply: Error: no such column: x (artifact: 3c31691966 user: dvdraymond)
2020-09-14
15:28 Reply: Connect to sample Database (artifact: c61ee87050 user: dvdraymond)
2020-09-10
18:26 Reply: Exclusive write-only lock? (Allow only one process read-write, and multiple read-only) (artifact: fa3db692ec user: dvdraymond)
15:48 Reply: Using windows function (artifact: 094df10977 user: dvdraymond)
15:30 Reply: Unique every N seconds. How? (artifact: f498a1ad90 user: dvdraymond)
15:18 Reply: Exclusive write-only lock? (Allow only one process read-write, and multiple read-only) (artifact: beac025c0d user: dvdraymond)
12:54 Reply: Unique every N seconds. How? (artifact: 8d830cc438 user: dvdraymond)
2020-09-08
17:52 Reply: Switching data between two columns (artifact: 05a4349567 user: dvdraymond)
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)