Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
144 most recent events by user slavin occurring on or after 2021-03-01 12:37:30.
2021-08-22
| ||
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 | |
19:28 | • Delete reply: Will SQLite support GQL or SQL/PGQ in the future? artifact: f2eaf07826 user: slavin | |
15:30 | • Reply: Changing the checksum VFS artifact: 4f116e6af2 user: slavin | |
15:19 | • Reply: Will SQLite support GQL or SQL/PGQ in the future? artifact: b71b17cd12 user: slavin | |
2021-06-26
| ||
18:48 | • Post: Changing the checksum VFS artifact: 77b909d134 user: slavin | |
2021-06-17
| ||
12:20 | • Edit reply: Unhandled exception on server application artifact: 6905553031 user: slavin | |
12:18 | • Reply: Unhandled exception on server application artifact: 8a6584fff7 user: slavin | |
2021-06-16
| ||
12:07 | • Reply: can we use a for/while loop inside sqlite triggers ? artifact: 1fae271599 user: slavin | |
2021-06-12
| ||
09:38 | • Edit reply: Inconsistent memory stats of sqlite3 with different compilers artifact: 6831c4fbf2 user: slavin | |
09:34 | • Edit reply: Inconsistent memory stats of sqlite3 with different compilers artifact: 319cc731ef user: slavin | |
09:33 | • Edit reply: Inconsistent memory stats of sqlite3 with different compilers artifact: 436854dfbc user: slavin | |
2021-06-11
| ||
14:27 | • Reply: Inconsistent memory stats of sqlite3 with different compilers artifact: d7a50522ed user: slavin | |
2021-06-10
| ||
07:24 | • Reply: different query plan result when executed within transaction artifact: 37365cdc6d user: slavin | |
2021-06-05
| ||
15:36 | • Reply: Anton Dyachenko artifact: 0ea0bd34a0 user: slavin | |
2021-06-04
| ||
11:40 | • Reply: Anton Dyachenko artifact: 12032ed896 user: slavin | |
2021-06-03
| ||
16:06 | • Reply: SQLite DB corrupt while inserting the data in iOS application. artifact: b5062871db user: slavin | |
2021-06-01
| ||
23:35 | • Reply: How to avoid 'row X missing from index' when using a custom collation? artifact: 8a7feefde0 user: slavin | |
2021-05-28
| ||
13:54 | • Reply: SQLite data access for Unity Game Engine artifact: 8930efc08e user: slavin | |
2021-05-22
| ||
12:27 | • Reply: Joining on Hebrew words including vowel points and cantillation marks artifact: 26f86d3089 user: slavin | |
12:09 | • Reply: Confused about sqlite3_step / sqlite_reset / sqlite3_bind_xxx APIs artifact: 44077bb3dd user: slavin | |
2021-05-21
| ||
17:24 | • Reply: Confused about sqlite3_step / sqlite_reset / sqlite3_bind_xxx APIs artifact: a6e56238dc user: slavin | |
2021-05-18
| ||
13:26 | • Reply: memory vs mmap artifact: 5901d83de7 user: slavin | |
2021-05-17
| ||
15:01 | • Reply: sqlite3_open speed opening database artifact: 1cb551dbc6 user: slavin | |
2021-05-15
| ||
13:16 | • Edit reply: sqlite3_open speed opening database artifact: df62986bd0 user: slavin | |
13:15 | • Reply: sqlite3_open speed opening database artifact: 9003bda625 user: slavin | |
04:10 | • Reply: Special characters * and ? are not supported in Database Names on Windows? artifact: 411d818227 user: slavin | |
2021-05-13
| ||
11:24 | • Reply: Some questions on SQLite internals artifact: 792c036fe5 user: slavin | |
2021-05-11
| ||
21:14 | • Edit reply: Place in the code where can understand that the file was created artifact: b83aae5909 user: slavin | |
21:13 | • Reply: Place in the code where can understand that the file was created artifact: 673e623415 user: slavin | |
13:22 | • Edit reply: Fast way to insert rows in SQLite artifact: 1e9d9d282f user: slavin | |
13:21 | • Reply: Fast way to insert rows in SQLite artifact: 25d3490c2a user: slavin | |
2021-05-06
| ||
15:39 | • Reply: Is CSV parsing too liberal? artifact: acb0442a61 user: slavin | |
01:51 | • Edit reply: select * from fcc where unique_system_identifier='4350131'; returns 1000+ records artifact: ff865cf909 user: slavin | |
01:42 | • Edit reply: select * from fcc where unique_system_identifier='4350131'; returns 1000+ records artifact: b21439feb0 user: slavin | |
01:22 | • Reply: select * from fcc where unique_system_identifier='4350131'; returns 1000+ records artifact: 32a3e883a2 user: slavin | |
2021-05-05
| ||
12:53 | • Reply: Is CSV parsing too liberal? artifact: 07fe5e7a69 user: slavin | |
2021-05-03
| ||
12:25 | • Edit reply: Is there a way to mark an index 'explicit' only? artifact: f5975637f8 user: slavin | |
12:22 | • Reply: Is there a way to mark an index 'explicit' only? artifact: 2410f86240 user: slavin | |
2021-05-02
| ||
13:34 | • Reply: "Office Space"... I'm losing all those pennies artifact: beffde97d4 user: slavin | |
13:28 | • Reply: how to collate in a union and noaccent artifact: 9c68ae7b9b user: slavin | |
2021-04-28
| ||
21:42 | • Reply: SQLite database in space? artifact: 1eadc362cc user: slavin | |
2021-04-27
| ||
14:45 | • Reply: Database is locked when "upgrading" from read to write artifact: c9556990e2 user: slavin | |
2021-04-26
| ||
12:59 | • Reply: How to run the sqlite test artifact: 717b47d142 user: slavin | |
2021-04-25
| ||
12:30 | • Reply: Backup via file system backup software artifact: 796a192a95 user: slavin | |
12:24 | • Reply: PROBLEM WITH TRANSACTION artifact: 4bd0e9ca75 user: slavin | |
2021-04-23
| ||
21:26 | • Reply: The NUMERIC data type? artifact: 4f30adf67d user: slavin | |
2021-04-21
| ||
12:26 | • Edit reply: The NUMERIC data type? artifact: 06e0deed61 user: slavin | |
12:22 | • Reply: The NUMERIC data type? artifact: c952a6ff34 user: slavin | |
2021-04-19
| ||
20:12 | • Reply: Universal binary build for Apple Silicon artifact: b4404ff091 user: slavin | |
2021-04-18
| ||
13:26 | • Reply: Cant write from root user into sqlite when sticky bit is set artifact: 39d5037058 user: slavin | |
2021-04-16
| ||
12:51 | • Reply: Cant write from root user into sqlite when sticky bit is set artifact: 9954c081c8 user: slavin | |
12:33 | • Reply: programming sqlite bytecode directly ? artifact: c695cbe47b user: slavin | |
2021-04-14
| ||
12:25 | • Reply: Select of text that matches scientific notation format automatically converted to number artifact: 28e855b0e0 user: slavin | |
2021-04-13
| ||
14:54 | • Reply: Saving Wikipedia to SQLite artifact: a7e765e668 user: slavin | |
14:24 | • Reply: Noob Question artifact: 15918f10bb user: slavin | |
2021-04-11
| ||
17:13 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: 09933653c6 user: slavin | |
17:09 | • Reply: Finding database file artifact: 68e9c599ec user: slavin | |
10:36 | • Post: You don't know what people are using your database for artifact: 723c627a45 user: slavin | |
10:25 | • Reply: What does, if many threads and/or processes need to write the database at the same instant, mean? artifact: d5c79c3fc9 user: slavin | |
10:17 | • Reply: books / papers on "one sqlite per user" design ? artifact: 4acdf8d767 user: slavin | |
2021-04-10
| ||
12:10 | • Reply: Question .open chinook.db artifact: 5b6df1e3e1 user: slavin | |
2021-04-06
| ||
13:37 | • Reply: What indexes help Window Functions artifact: 680fa795d8 user: slavin | |
2021-04-05
| ||
02:58 | • Reply: What indexes help Window Functions artifact: 1bb2cb6115 user: slavin | |
01:27 | • Reply: .import csv and NULL values artifact: d3bad034ce user: slavin | |
01:16 | • Reply: For a given SQL query, mechanisms for figuring out which physical columns would be returned? artifact: 554de1fe75 user: slavin | |
2021-04-04
| ||
15:04 | • Reply: SQLite Plus: all the missing SQLite functions artifact: 8947bce7c3 user: slavin | |
2021-04-03
| ||
23:19 | • Post: SQLite Plus: all the missing SQLite functions artifact: 2574e65458 user: slavin | |
2021-03-28
| ||
12:20 | • Edit reply: Query Contraint with an if clause? artifact: b1141f0f84 user: slavin | |
12:20 | • Edit reply: Query Contraint with an if clause? artifact: 3edf200a8c user: slavin | |
12:19 | • Reply: Query Contraint with an if clause? artifact: d2a1f5e24d user: slavin | |
12:14 | • Reply: Novice question about running UTF-8 on CLI from file. artifact: 5792632b04 user: slavin | |
2021-03-25
| ||
12:59 | • Reply: Generating random test data using SQL artifact: 7e144ab1ee user: slavin | |
2021-03-24
| ||
20:46 | • Post: Generating random test data using SQL artifact: 7a1c18f75c user: slavin | |
2021-03-21
| ||
13:28 | • Reply: "Scope" of SQLITE_DETERMINISTIC? artifact: b656cafd9c user: slavin | |
02:04 | • Reply: "Scope" of SQLITE_DETERMINISTIC? artifact: d7d73b0121 user: slavin | |
2021-03-19
| ||
16:17 | • Reply: error changing data - attempt to write a readonly database artifact: 3fa166476e user: slavin | |
16:14 | • Reply: Cancelling the query artifact: 3b0fed3f6a user: slavin | |
2021-03-11
| ||
14:17 | • Reply: SQLite3 interfacing with MS SQL Server artifact: d7cc5acd0a user: slavin | |
2021-03-10
| ||
13:44 | • Reply: SQLite Version 3.35.0 - Beta 1 artifact: d1339acc9a user: slavin | |
13:35 | • Reply: Verifying schema for application file format artifact: 50b924817c user: slavin | |
13:24 | • Reply: How to corrupt - windows artifact: 56cb31ff3b user: slavin | |
13:08 | • Reply: SQLite3 interfacing with MS SQL Server artifact: 7bd50af571 user: slavin | |
2021-03-03
| ||
22:32 | • Reply: encoding on new DB-File artifact: 270a037ed9 user: slavin | |
16:09 | • Reply: Feature request: Import csv into a table with generated columns artifact: b13df72bdd user: slavin | |
2021-03-01
| ||
12:37 | • Reply: Database UTF-16 support artifact: fee5433f21 user: slavin | |