SQLite Forum

Timeline
Login

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

111 events by user slavin occurring around 2021-08-18 01:22:18.

2021-10-24
01:48 Reply: Database on android SD CARD artifact: 4ac3f373f2 user: slavin
2021-10-22
14:07 Reply: Truncated Words bug with fts5vocab artifact: b8a691b233 user: slavin
2021-10-20
12:18 Edit reply: INDEX usage on inequality and IN artifact: 844bbb2ca8 user: slavin
12:17 Reply: INDEX usage on inequality and IN artifact: 567ef6bfa4 user: slavin
2021-10-14
14:33 Edit reply: binary .dump format artifact: 698355ddf8 user: slavin
14:33 Reply: binary .dump format artifact: 7501594306 user: slavin
10:10 Edit reply: binary .dump format artifact: 442587d3b7 user: slavin
10:08 Reply: binary .dump format artifact: 02470db818 user: slavin
2021-10-13
19:18 Reply: inconsistent output: insert on conflict with returning artifact: a339db3dbc user: slavin
12:19 Reply: Data Types artifact: 073be6a27e user: slavin
2021-10-12
21:55 Reply: Data Types artifact: b010aa47f1 user: slavin
2021-10-11
01:52 Reply: Update with table alias artifact: 3872dc98e3 user: slavin
2021-10-10
02:56 Edit reply: Understanding memory allocation behavior of SQLite artifact: d560d3da8f user: slavin
2021-10-09
15:16 Reply: Understanding memory allocation behavior of SQLite artifact: 153bc160cf user: slavin
2021-10-03
13:43 Delete reply: Unexpected output from the SELECT artifact: 3dbd531b91 user: slavin
05:08 Reply: Unexpected output from the SELECT artifact: 7e7078acd4 user: slavin
2021-09-28
21:17 Reply: Reset database artifact: 9d6f9839d7 user: slavin
2021-09-26
13:19 Reply: SIGBUS in sqlite artifact: ebeb240cfe user: slavin
2021-09-25
21:06 Reply: V3.36 artifact: b66e1c3b4a user: slavin
2021-09-24
11:27 Edit reply: Cannot select a value that matches another column name artifact: f4796c6f76 user: slavin
11:24 Reply: Cannot select a value that matches another column name artifact: 5aaeb72c2e user: slavin
2021-09-21
06:00 Reply: get only first record found artifact: aa20b2d8f0 user: slavin
2021-09-20
15:10 Reply: adding record if it doesn't already exist artifact: 14fc4693a5 user: slavin
15:08 Reply: Database anomaly artifact: 07696551da user: slavin
2021-09-16
12:46 Reply: about "strict" mode artifact: 66dc6d95aa user: slavin
2021-09-15
11:42 Reply: Select query returning: no such table error artifact: ca3b8865ac user: slavin
2021-09-14
14:48 Post: DELETE FROM … RETURNING artifact: 9ceaa4a1e0 user: slavin
2021-09-12
14:09 Reply: Android and desktop Java library artifact: 725a45707a user: slavin
2021-09-11
16:39 Reply: Android and desktop Java library artifact: 495997e71e user: slavin
2021-09-10
06:10 Reply: Method to temporarily disable Not Null constraint? artifact: f58551be36 user: slavin
02:15 Edit reply: NEXT VALUE FOR in SQLite artifact: 9d90f945e7 user: slavin
02:15 Reply: NEXT VALUE FOR in SQLite artifact: f1524c8da4 user: slavin
2021-09-09
13:47 Reply: How to insert duplicate rows? artifact: 335930bfb9 user: slavin
13:43 Edit reply: NEXT VALUE FOR in SQLite artifact: a04e556795 user: slavin
13:37 Reply: NEXT VALUE FOR in SQLite artifact: 78b66a3c9b user: slavin
07:59 Reply: How to insert duplicate rows? artifact: f70dc8384e user: slavin
2021-09-08
18:13 Reply: solved disk I/O error on F2FS artifact: 63a651757f user: slavin
18:11 Reply: WAL/SHM files do not get deleted with ReadOnly flag artifact: 3ac8cfca59 user: slavin
12:49 Reply: A crash bug in function isLikeOrGlob() artifact: 39ccb68762 user: slavin
2021-09-07
15:24 Reply: Automatic indexing (idle question) artifact: 1912e63e6b user: slavin
2021-09-06
18:58 Reply: Automatic indexing (idle question) artifact: 594bed7b7c user: slavin
2021-09-05
21:53 Post: Automatic indexing (idle question) artifact: d6677078fd user: slavin
2021-09-04
14:51 Reply: The characters to be escaped in Sqlite3 to prevent Sql Injection artifact: eca1100f5f user: slavin
2021-09-03
13:52 Reply: What happens if I define LONGDOUBLE_TYPE as double? artifact: 506dd87ea5 user: slavin
2021-09-01
12:32 Reply: Finding overlap of boxed coordinates artifact: e9408c7224 user: slavin
2021-08-26
21:01 Reply: Recursively Import 10 GB sized csv file to sqlite fast without blocking reads artifact: ed5f8061f2 user: slavin
2021-08-25
01:36 Reply: Why WAL file (-wal) may disappear? artifact: fef23cf2ff user: slavin
2021-08-23
02:42 Reply: about "strict" mode artifact: 2ef5e46b63 user: slavin
00:37 Reply: Coverting 305GB CSV to sqlite database artifact: 64e5159ff7 user: slavin
2021-08-22
16:26 Post: New Hipp podcast artifact: d768ddc945 user: slavin
15:56 Post: About STRICT tables artifact: ac9d8f7248 user: slavin
06:55 Reply: about "strict" mode artifact: 7456cd275b user: slavin
2021-08-21
13:39 Reply: about "strict" mode artifact: 99472fab32 user: slavin
2021-08-20
13:04 Reply: Trying to "Open Database" Safari History.db file and get Error: "could not open safari database file reason: unable to open.. artifact: fcc0327ba1 user: slavin
2021-08-18
14:50 Reply: random DB locks artifact: cc4f5da458 user: slavin
01:22 Reply: ADO.NET INSERT/UPDATE RETURNING statement question artifact: a05aa153bb user: slavin
2021-08-17
23:37 Reply: random DB locks artifact: a94f483471 user: slavin
12:12 Reply: Is it possible to put the journal file to non-volatile RAM artifact: 74be7f0953 user: slavin
2021-08-15
13:10 Reply: wal checkpointing very slow artifact: 94c40d994a user: slavin
02:32 Reply: pragma integrity_check; Error: disk I/O error artifact: 52886c2567 user: slavin
2021-08-14
21:05 Reply: Converting from sqlite to sqlite3 artifact: 95a8f14560 user: slavin
13:02 Reply: pragma integrity_check; Error: disk I/O error artifact: 229e2b5d93 user: slavin
2021-08-13
13:06 Reply: pragma integrity_check; Error: disk I/O error artifact: aba3e16947 user: slavin
2021-08-12
15:57 Reply: Test ACID properties SQLITE artifact: c09b3b60b6 user: slavin
15:37 Reply: Documentation: list of addons and extras artifact: 9b1f6db6d6 user: slavin
2021-08-11
17:10 Post: Documentation: list of addons and extras artifact: 30bd112cfd user: slavin
2021-08-10
15:15 Reply: SQLite Binary Log support! artifact: a0079eb66b user: slavin
00:32 Reply: SQLite Binary Log support! artifact: e7e18e601d user: slavin
2021-08-09
14:35 Reply: Why WAL file (-wal) may disappear? artifact: eafdda128a user: slavin
2021-08-08
12:41 Reply: Old Nabble SQLite mailing list site down? artifact: 748e339cdb user: slavin
12:33 Reply: Not understanding a subquery - Some guidance? artifact: 13b06bae21 user: slavin
2021-08-07
23:26 Reply: Not understanding a subquery - Some guidance? artifact: 6dcc9cd5fc user: slavin
13:30 Edit reply: Questions about data types and overflow bounds artifact: 91d6da55c1 user: slavin
2021-08-06
15:32 Reply: Questions about data types and overflow bounds artifact: b980380c87 user: slavin
15:30 Reply: Fail to calculate long expression artifact: eec4141a1b user: slavin
2021-08-05
14:12 Reply: Old Nabble SQLite mailing list site down? artifact: 21266fcec9 user: slavin
2021-08-02
17:45 Reply: Fail to calculate long expression artifact: b1fd4562b5 user: slavin
14:54 Reply: Feature Request: Allow REAL to serve as rowid by having the B-Tree interpret its byte signature as a 64bit INTEGER. artifact: fb8f5944bb user: slavin
2021-07-30
12:39 Delete reply: Why data is lost in SQLite database with WAL mode on when connection is not closed properly? artifact: 8de2d93344 user: slavin
12:39 Reply: Why data is lost in SQLite database with WAL mode on when connection is not closed properly? artifact: fb1ef9c78c user: slavin
2021-07-29
13:48 Reply: Why data is lost in SQLite database with WAL mode on when connection is not closed properly? artifact: 29cc624e24 user: slavin
2021-07-28
12:32 Reply: Error not given when referencing something that doesn't exist artifact: c8d3ba13a9 user: slavin
2021-07-25
12:42 Reply: insert into view returning id returns null artifact: 374eb39f6c user: slavin
2021-07-22
15:07 Reply: Csv or Vsv parsing blob column artifact: 582bc0286b user: slavin
2021-07-21
14:34 Reply: Csv or Vsv parsing blob column artifact: dd6d723d7e user: slavin
2021-07-18
13:45 Reply: Does the column order in an insert statement impact the insert speed? artifact: 36728ae68d user: slavin
13:40 Post: Inserting One Billion Rows in SQLite Under A Minute artifact: 8f76af39ca user: slavin
13:10 Reply: Does the column order in an insert statement impact the insert speed? artifact: 8f60f59d30 user: slavin
12:48 Reply: (Deleted) artifact: f8abbfedbf user: slavin
2021-07-14
12:47 Reply: My Database is being deleted after each restart of my code. How can I fix it? artifact: b39f12845f user: slavin
12:43 Reply: How much would you trust a page-level checksum ? artifact: ee790fb3d3 user: slavin
2021-07-12
14:05 Reply: Database corruption: database disk image is malformed artifact: 64594dc46e user: slavin
13:50 Reply: Unstack one column to multiple artifact: 1e5d2f1bcb user: slavin
2021-07-11
15:26 Edit reply: How much would you trust a page-level checksum ? artifact: dcaa5034c1 user: slavin
14:22 Reply: How much would you trust a page-level checksum ? artifact: 7d81b9b5a7 user: slavin
13:54 Reply: Unstack one column to multiple artifact: d98a069d55 user: slavin
2021-07-09
16:56 Post: How much would you trust a page-level checksum ? artifact: 7452037e57 user: slavin
2021-07-08
13:29 Reply: Switching pragma synchronous to upgrade durability artifact: 7a7bf07d8a user: slavin
13:24 Reply: Shortcut to change a non changing update or upsert in a noop artifact: 2f2836a5a3 user: slavin
2021-07-07
12:20 Reply: Shortcut to change a non changing update or upsert in a noop artifact: 3ee1edf823 user: slavin
2021-07-03
14:54 Post: The Untold Story of SQLite artifact: 980587188f user: slavin
14:54 Post: The Untold Story of SQLite artifact: 06a861d93c user: slavin
12:35 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 38bb20d059 user: slavin
2021-07-02
16:33 Reply: cannot create tables in sqlitestudio than other apps can see artifact: f6bc9ed7fa user: slavin
2021-07-01
12:39 Reply: Should we recreate database for these error codes SQLITE_INTERNAL/SQLITE_FORMAT/SQLITE_EMPTY/SQLITE_NOLFS ? artifact: ac3555f248 user: slavin
12:33 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 0be2bca5d6 user: slavin
2021-06-30
14:49 Reply: Is there a 64 bit sqlite3.exe available to avoid out of memory error? artifact: 48ed69cbeb user: slavin
2021-06-29
14:11 Reply: Which performance test tool should choose ? artifact: 48415b5adf user: slavin
2021-06-28
12:25 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 26daf8f9e0 user: slavin
01:46 Reply: cannot create tables in sqlitestudio than other apps can see artifact: 2e5f493b7f user: slavin
2021-06-27
19:29 Reply: Will SQLite support GQL or SQL/PGQ in the future? artifact: 4b03ff6718 user: slavin