SQLite Forum

Timeline
Login

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

39 forum posts by user itandetnik

2024-01-25
23:40 Reply: Ambiguous tables priority (artifact: 96dd4bd912 user: itandetnik)
2023-06-17
18:01 Reply: How do SQLite triggers work? (artifact: c655878ed7 user: itandetnik)
2023-05-18
23:05 Reply: How to combine indiviual queries (artifact: 8123c81d32 user: itandetnik)
2023-02-25
21:45 Reply: unique constraint only if flag is set (artifact: a54e6eb076 user: itandetnik)
2023-02-21
15:31 Reply: strftime + LIKE? (artifact: 55c1f7e787 user: itandetnik)
05:06 Reply: strftime + LIKE? (artifact: 6e18046e7a user: itandetnik)
2023-02-20
23:05 Reply: strftime + LIKE? (artifact: a9ff3f7133 user: itandetnik)
2022-12-26
18:32 Edit reply: unable to format date (artifact: 018d915172 user: itandetnik)
18:32 Reply: unable to format date (artifact: e1c9c48efa user: itandetnik)
2022-10-11
03:14 Reply: Hangs in SQLite 3.39.4 (artifact: 4da4f27daf user: itandetnik)
2022-10-05
04:30 Reply: Does the design of deferred transactions lead to deadlocks? (artifact: 458d514af1 user: itandetnik)
2022-09-03
13:16 Reply: To obtain a sqlite3_blob object from a stmt? (artifact: 7fd8dd21a7 user: itandetnik)
2022-05-16
15:15 Reply: Single-pass update on table possible? (artifact: 393c7cf3d8 user: itandetnik)
2022-01-09
22:32 Reply: An index is not used to optimize GROUP BY query (artifact: 0f41f61190 user: itandetnik)
20:49 Reply: An index is not used to optimize GROUP BY query (artifact: 4bc17ba359 user: itandetnik)
2021-12-28
01:01 Reply: select distinct in table and modify column (artifact: 6858e029e4 user: itandetnik)
2021-12-18
04:43 Reply: getting list of columns (artifact: c81deeca0e user: itandetnik)
2021-11-25
21:36 Reply: Sqlite high IO load makes usage impossable (artifact: 5caf085f47 user: itandetnik)
2021-08-29
15:29 Reply: A thought on LIKE/GLOB optimization (artifact: e11e99b33c user: itandetnik)
2021-08-08
03:48 Reply: Not understanding a subquery - Some guidance? (artifact: 960c09bf7d user: itandetnik)
2021-07-04
13:43 Reply: Filter one column for multiple values (artifact: 109dad1e89 user: itandetnik)
2021-05-25
14:41 Reply: How can I merge results from two SELECTs? (artifact: dc96548834 user: itandetnik)
13:21 Reply: Find the relation in a sql query (artifact: 0dfe4a09aa user: itandetnik)
2021-05-01
11:32 Reply: classic save possibility (artifact: 15e4b25670 user: itandetnik)
2021-04-30
21:32 Reply: classic save possibility (artifact: db1ef0affc user: itandetnik)
2021-04-07
23:03 Reply: Error with upsert and trigger WHEN clause? (artifact: 94848734b0 user: itandetnik)
2021-04-03
21:06 Reply: In C API, do prepared statements of simple inserts execute repeatedly even if not reset? (artifact: 4b0f6e0ca4 user: itandetnik)
2021-03-03
15:06 Delete reply: RSS feed not working (artifact: 138bc075e9 user: itandetnik)
2021-02-28
16:01 Reply: RSS feed not working (artifact: 2a7c384fb7 user: itandetnik)
2021-01-18
17:11 Reply: How to decode an sqlite 3 file that has Russian text? (artifact: 8ca02270ad user: itandetnik)
2020-07-16
03:46 Reply: facing issue from sqlite3_step() (artifact: 7fc3597e03 user: itandetnik)
2020-07-06
15:55 Reply: Error: near line 3: parser stack overflow (artifact: a28e5fdf8e user: itandetnik)
15:20 Reply: Error: near line 3: parser stack overflow (artifact: 979bf4946a user: itandetnik)
2020-06-30
14:17 Reply: Sum precision ? (artifact: 0bc30912c4 user: itandetnik)
2020-06-08
13:31 Reply: Min/max and index usage? (artifact: 5be1567a24 user: itandetnik)
2020-05-22
13:40 Reply: Querying first of each month (artifact: d11ad15a07 user: itandetnik)
2020-04-19
22:02 Reply: how to refuse write empty value (artifact: 978c236b3a user: itandetnik)
2020-04-12
14:03 Reply: pivot requery SQLITE (artifact: 3aa28fed01 user: itandetnik)
2020-04-05
15:52 Reply: 'no query solution' error (artifact: 97a682138e user: itandetnik)