SQLite Forum

Timeline
Login

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

50 events by user 6kEs4Majrd occurring around 2021-08-10 05:36:57.

2022-03-29
01:44 Post: How to trim suffix from a text column? artifact: e4bf65bbef user: 6kEs4Majrd
2022-03-02
01:02 Post: Is inserting multiple rows with one command better than inserting them each with one command? artifact: 1c69a31258 user: 6kEs4Majrd
2022-03-01
19:55 Reply: Does index slow down insertion artifact: 5ab097a124 user: 6kEs4Majrd
18:05 Post: Does index slow down insertion artifact: 1ad8529074 user: 6kEs4Majrd
14:34 Reply: How to determine the best index to create given a query? artifact: 64a117a309 user: 6kEs4Majrd
14:33 Reply: How to determine the best index to create given a query? artifact: 3996d1f18d user: 6kEs4Majrd
05:43 Reply: efficient ways to select unique from a column in a multi-colume primary key artifact: 05efb19c76 user: 6kEs4Majrd
03:47 Reply: Does the order of the column names in create index matter? artifact: 1d472cafbd user: 6kEs4Majrd
03:42 Edit: How to determine the best index to create given a query? artifact: 7dbda848a3 user: 6kEs4Majrd
03:40 Post: How to determine the best index to create given a query? artifact: df826c33d9 user: 6kEs4Majrd
03:23 Edit: Does the order of the column names in create index matter? artifact: d59640b369 user: 6kEs4Majrd
03:23 Post: Does the order of the column names in create index matter? artifact: 875d98545e user: 6kEs4Majrd
02:19 Reply: efficient ways to select unique from a column in a multi-colume primary key artifact: 093a008260 user: 6kEs4Majrd
01:28 Post: efficient ways to select unique from a column in a multi-colume primary key artifact: 0b449f265d user: 6kEs4Majrd
2022-02-27
16:18 Post: Is there a way to select a colume from `PRAGMA table_info(mytab)`? artifact: 7c3047e24a user: 6kEs4Majrd
2021-08-10
05:36 Reply: sqlar: is it reliable to use length(sqlar.blob)==sqlar.sz determine whether the data is compressed artifact: 2fb4208659 user: 6kEs4Majrd
03:23 Reply: sqlar: is it reliable to use length(sqlar.blob)==sqlar.sz determine whether the data is compressed artifact: 7031690be3 user: 6kEs4Majrd
2021-08-09
11:33 Reply: sqlar: is it reliable to use length(sqlar.blob)==sqlar.sz determine whether the data is compressed artifact: 3913b9fd2d user: 6kEs4Majrd
04:02 Post: sqlar: is it reliable to use length(sqlar.blob)==sqlar.sz determine whether the data is compressed artifact: c17712ff09 user: 6kEs4Majrd
2021-07-10
23:08 Post: LOAD_EXTENSION: Error: error during initialization: artifact: 9a268f74e5 user: 6kEs4Majrd
2021-07-09
16:16 Post: allowing reading by another process while inserting many entries? artifact: c469006faf user: 6kEs4Majrd
2021-06-15
21:55 Reply: Extract files from sqlar with a directory prepended artifact: ace24d41dc user: 6kEs4Majrd
2021-06-14
20:33 Reply: Extract files from sqlar with a directory prepended artifact: 2606d60a0b user: 6kEs4Majrd
16:04 Reply: Extract files from sqlar with a directory prepended artifact: c73b91b3c2 user: 6kEs4Majrd
2021-06-13
16:01 Reply: Extract files from sqlar with a directory prepended artifact: 93cb0840b7 user: 6kEs4Majrd
13:01 Reply: Extract files from sqlar with a directory prepended artifact: 7be4875762 user: 6kEs4Majrd
2021-06-12
23:49 Post: Extract files from sqlar with a directory prepended artifact: 4f099a2dda user: 6kEs4Majrd
2021-04-03
17:05 Post: How to dump a table to a TSV file but escape characters properly artifact: f68281a41d user: 6kEs4Majrd
05:08 Post: About virutal table and FTS4 artifact: 43cac36b7e user: 6kEs4Majrd
2021-03-14
14:53 Post: How to insert control characters? artifact: 1266dd6092 user: 6kEs4Majrd
2020-09-21
22:44 Post: How does sparse files used by sqlite3? artifact: be1129fd4c user: 6kEs4Majrd
2020-08-16
04:22 Reply: How is a table with only primary key stored on disk? artifact: 61866bcb9e user: 6kEs4Majrd
01:19 Reply: How is a table with only primary key stored on disk? artifact: bcd1547601 user: 6kEs4Majrd
2020-08-15
22:30 Post: How is a table with only primary key stored on disk? artifact: d70df22a8b user: 6kEs4Majrd
2020-07-09
16:26 Reply: Can -wal -shm files be deleted if -wal file is empty? artifact: 989cec670e user: 6kEs4Majrd
16:24 Reply: Can -wal -shm files be deleted if -wal file is empty? artifact: 820fe498df user: 6kEs4Majrd
14:22 Reply: Can -wal -shm files be deleted if -wal file is empty? artifact: accb68153b user: 6kEs4Majrd
14:18 Reply: Can -wal -shm files be deleted if -wal file is empty? artifact: e60607d062 user: 6kEs4Majrd
13:15 Reply: Can -wal -shm files be deleted if -wal file is empty? artifact: 23a91c3f2f user: 6kEs4Majrd
13:07 Reply: Can -wal -shm files be deleted if -wal file is empty? artifact: 71de48e3fe user: 6kEs4Majrd
2020-07-08
15:35 Post: Can -wal -shm files be deleted if -wal file is empty? artifact: 2a8c51e0b8 user: 6kEs4Majrd
2020-06-21
22:42 Reply: What reading wal can result in `BusyError: database is locked`? artifact: ca4409f86d user: 6kEs4Majrd
08:36 Post: What reading wal can result in `BusyError: database is locked`? artifact: 8b05f1adf7 user: 6kEs4Majrd
2020-06-20
21:57 Post: C API for holding shm file in cache memory on Mac OS X and Linux? artifact: 772444b72b user: 6kEs4Majrd
2020-06-14
15:32 Reply: How db access is handled by sqlite3? artifact: eb659095e7 user: 6kEs4Majrd
2020-06-13
21:48 Post: How db access is handled by sqlite3? artifact: a93fe6b498 user: 6kEs4Majrd
2020-06-05
14:43 Reply: How to not to overwrite a row if the key exists? artifact: eae18c1b63 user: 6kEs4Majrd
14:00 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 69e3bb00bd user: 6kEs4Majrd
13:56 Reply: How to circumvent "apsw.BusyError: BusyError: database is locked"? artifact: 01fb49df7f user: 6kEs4Majrd
13:03 Reply: How to not to overwrite a row if the key exists? artifact: a0693a9e8a user: 6kEs4Majrd