SQLite Forum

Timeline
Login

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