SQLite Forum

Timeline
Login

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

50 most recent forum posts by user lexfiend

2022-05-18
04:52 Reply: Is this query correctly formulated and giving right output? (artifact: 0b441af0c4 user: lexfiend)
2022-05-17
14:13 Reply: Null value returned by TOTAL (artifact: 719194a32c user: lexfiend)
2022-05-15
09:53 Reply: Null value returned by TOTAL (artifact: 4611e75ccb user: lexfiend)
09:39 Reply: Null value returned by TOTAL (artifact: 5e1c3e295d user: lexfiend)
2022-03-31
08:58 Reply: Text with numbers: how to get natural sort order (artifact: a63497a25f user: lexfiend)
2022-03-17
15:46 Reply: Dump and insert instead of vacuum (artifact: bf66d4e3b7 user: lexfiend)
2022-01-13
13:19 Edit reply: SQLite3 shell doing math operation on parameter substitution (artifact: 1c91ee52d8 user: lexfiend)
13:18 Reply: SQLite3 shell doing math operation on parameter substitution (artifact: f9dd307b91 user: lexfiend)
2021-12-01
04:58 Reply: Compile for Apple Silicon (artifact: 34aa909516 user: lexfiend)
2021-11-25
12:31 Reply: How to rerank one row in a big set of rows? (artifact: 704fd587bd user: lexfiend)
2021-11-14
09:06 Reply: A newbie's question about database structure design (artifact: 0ad0af6a51 user: lexfiend)
2021-08-13
06:00 Reply: LEFT AND RIGHT OUTER JOINS problem (artifact: 54e08d727e user: lexfiend)
2021-07-31
02:10 Reply: Round function returning -0.0 (artifact: 21d92f32ba user: lexfiend)
02:08 Reply: Round function returning -0.0 (artifact: 5bcd98f4d7 user: lexfiend)
01:59 Reply: Round function returning -0.0 (artifact: b1d6b7b179 user: lexfiend)
2021-07-30
15:10 Reply: Round function returning -0.0 (artifact: 91dc2197b9 user: lexfiend)
05:34 Reply: Round function returning -0.0 (artifact: 2fa5fa85c0 user: lexfiend)
05:31 Reply: Can SQLITE_INTERNAL be a transient error ? (artifact: 224c846428 user: lexfiend)
2021-07-21
11:25 Reply: Calculating duration in ISO8601 timestamp (artifact: 551dd42140 user: lexfiend)
2021-06-30
05:29 Reply: php sqlite3_create_window_function (artifact: b6077e33be user: lexfiend)
2021-06-29
01:52 Reply: php sqlite3_create_window_function (artifact: e39494b878 user: lexfiend)
2021-06-19
08:23 Post: PoC CLI `-param` option (artifact: b01049dca8 user: lexfiend)
2021-06-17
04:42 Edit reply: Extract files from sqlar with a directory prepended (artifact: 47d8ae0d9c user: lexfiend)
04:40 Reply: Extract files from sqlar with a directory prepended (artifact: 060af37a97 user: lexfiend)
2021-06-16
16:10 Reply: Extract files from sqlar with a directory prepended (artifact: 3d8098ef3d user: lexfiend)
03:03 Reply: Extract files from sqlar with a directory prepended (artifact: 6c62ed45ba user: lexfiend)
2021-06-15
02:40 Reply: Extract files from sqlar with a directory prepended (artifact: ee2c06e599 user: lexfiend)
2021-06-14
16:44 Reply: Extract files from sqlar with a directory prepended (artifact: bbec44fa25 user: lexfiend)
03:40 Post: Bug: incorrect filter expression in arExtractCommand() (artifact: 6e9aa98e62 user: lexfiend)
03:22 Edit reply: Extract files from sqlar with a directory prepended (artifact: e213cc4c03 user: lexfiend)
03:17 Reply: Extract files from sqlar with a directory prepended (artifact: f71d541d71 user: lexfiend)
2021-06-13
15:42 Reply: INSERT with RETURNING causes duplicate rows (artifact: 78c4bc6148 user: lexfiend)
14:49 Reply: Extract files from sqlar with a directory prepended (artifact: d034f7b1f3 user: lexfiend)
07:39 Post: Bug: Incorrect archive support URL in help text (artifact: 58cc3a68f6 user: lexfiend)
07:35 Reply: Extract files from sqlar with a directory prepended (artifact: ad0f5049b9 user: lexfiend)
2021-03-20
02:54 Post: FTS build docs inconsistency (artifact: 3b423b4adc user: lexfiend)
2021-02-03
08:10 Reply: SQLite3 Array? (artifact: 0146dd5489 user: lexfiend)
2020-12-07
15:37 Reply: sqlite3_prepare() (artifact: 644894f652 user: lexfiend)
15:27 Reply: sqlite3_prepare() (artifact: d906af29cd user: lexfiend)
10:19 Edit reply: libreadline problem with Ubuntu 20.04 (artifact: f1715cb41d user: lexfiend)
09:50 Reply: libreadline problem with Ubuntu 20.04 (artifact: de28ca127f user: lexfiend)
2020-10-29
02:14 Reply: Is `JSON` a valid `create table` type? (artifact: f4afdb0a81 user: lexfiend)
2020-10-08
06:21 Reply: Performance Issue: How can I increase a performance? (artifact: 5580b3c884 user: lexfiend)
2020-09-14
12:57 Reply: Placeholder for table name when inserting data? (artifact: aef5f69a51 user: lexfiend)
2020-08-23
11:09 Reply: Kind request: Please make SHA3/? part of built-in functions (artifact: 3565adead4 user: lexfiend)
10:59 Reply: Weird warning on the Xcode/OSX (artifact: ec318a353d user: lexfiend)
2020-08-13
12:21 Reply: Can you export multiple tables into ONE excel file on ONE tab? (artifact: 324188d06f user: lexfiend)
2020-08-12
04:23 Reply: How can I split a name column into first and last names? (artifact: 9ef4f7718e user: lexfiend)
2020-08-07
07:10 Reply: Need help building a custom amalgamation (artifact: 322f1ca6f7 user: lexfiend)
2020-07-10
02:06 Reply: .selecttrace unknown and strange errors (artifact: cc0ddb4d86 user: lexfiend)