Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent forum posts by user stephancb
2024-04-24
| ||
10:25 | • Reply: Array syntax for insert statements? (artifact: d1314ccc68 user: stephancb) | |
2024-04-08
| ||
02:25 | • Reply: WAL on network filesystems (artifact: e90fd84ee8 user: stephancb) | |
2024-03-09
| ||
05:37 | • Reply: Incorrect query result caused by large number comparison (artifact: d22b99a9ad user: stephancb) | |
2024-03-04
| ||
16:26 | • Reply: Index doesn't have expected performance benefit (artifact: 1b244e8a2e user: stephancb) | |
2024-02-15
| ||
03:40 | • Reply: How to omit generated fields of a table in a pragma_table_xinfo() query? (artifact: 184562587f user: stephancb) | |
2024-02-09
| ||
15:15 | • Reply: sqlite3_step return codes (artifact: 5521896168 user: stephancb) | |
2024-01-14
| ||
15:43 | • Reply: Suggestion: octal literals (artifact: cebc2440ab user: stephancb) | |
2024-01-05
| ||
12:23 | • Reply: Are the functions from the SQLite library thread-safe? (artifact: 8d27581d12 user: stephancb) | |
12:09 | • Reply: Are the functions from the SQLite library thread-safe? (artifact: ca8bbb4df1 user: stephancb) | |
01:13 | • Edit reply: Are the functions from the SQLite library thread-safe? (artifact: 210cb2d540 user: stephancb) | |
01:09 | • Reply: Are the functions from the SQLite library thread-safe? (artifact: a2667d8d54 user: stephancb) | |
2023-12-19
| ||
15:23 | • Edit reply: round() doesn't work as expected after 3.42 (artifact: 68ebb8ea66 user: stephancb) | |
15:17 | • Reply: round() doesn't work as expected after 3.42 (artifact: 558faf7406 user: stephancb) | |
12:47 | • Reply: round() doesn't work as expected after 3.42 (artifact: 348d4aa553 user: stephancb) | |
2023-12-15
| ||
10:32 | • Reply: WHERE timeDayData BETWEEN date('now', '-300 day') AND date('now', '-280 day') (artifact: 64cc551209 user: stephancb) | |
09:45 | • Reply: WHERE timeDayData BETWEEN date('now', '-300 day') AND date('now', '-280 day') (artifact: 50710fd137 user: stephancb) | |
2023-12-14
| ||
05:17 | • Reply: WHERE timeDayData BETWEEN date('now', '-300 day') AND date('now', '-280 day') (artifact: 2fbfec304c user: stephancb) | |
2023-10-11
| ||
15:37 | • Reply: Failed to create db on CIFS network mount: Runtime error: database is locked (5) (artifact: 19c86e175a user: stephancb) | |
2023-09-12
| ||
15:31 | • Reply: Suggestion Re Statement Cache (artifact: be2ad0845f user: stephancb) | |
2023-08-25
| ||
08:32 | • Edit reply: I/O error when SQLite file grows large (artifact: 79172c42ae user: stephancb) | |
08:25 | • Edit reply: I/O error when SQLite file grows large (artifact: 596d3729ce user: stephancb) | |
08:24 | • Reply: I/O error when SQLite file grows large (artifact: a4ad7213b3 user: stephancb) | |
2023-05-16
| ||
16:17 | • Edit reply: SELECT query with Float equality (artifact: 568de2a06a user: stephancb) | |
16:16 | • Reply: SELECT query with Float equality (artifact: 9eca784a59 user: stephancb) | |
04:35 | • Reply: SELECT query with Float equality (artifact: a674e086ee user: stephancb) | |
2023-05-02
| ||
08:40 | • Reply: Feature Request: Support for `BIGINT PRIMARY KEY AUTOINCREMENT`? (artifact: 7295e386ad user: stephancb) | |
2023-04-11
| ||
07:48 | • Reply: Feature request: unixepoch_ms() for Unix timestamp in milliseconds (artifact: c41bd6829c user: stephancb) | |
2023-03-10
| ||
15:13 | • Reply: Storing numeric vectors (artifact: e6c959b548 user: stephancb) | |
2023-02-17
| ||
10:24 | • Reply: large single db vs many, smaller attached dbs (or one big db with blobs vs lots of binary files) (artifact: c36f38ffcb user: stephancb) | |
2023-01-31
| ||
20:35 | • Edit reply: julianday('now') returns incorrect date/time (artifact: 0de3b35f1c user: stephancb) | |
20:34 | • Reply: julianday('now') returns incorrect date/time (artifact: 692fb672a6 user: stephancb) | |
2023-01-18
| ||
05:39 | • Reply: What timescale SQLite uses: UT1, UTC, TT? for IETF standartization (artifact: 98a75f73b6 user: stephancb) | |
2023-01-17
| ||
09:55 | • Reply: What timescale SQLite uses: UT1, UTC, TT? for IETF standartization (artifact: bc7f4172cd user: stephancb) | |
07:29 | • Reply: is compilation configure script parsing my variables? (artifact: f5dbf29a76 user: stephancb) | |
05:39 | • Reply: What timescale SQLite uses: UT1, UTC, TT? for IETF standartization (artifact: 29fa7a5ec9 user: stephancb) | |
2023-01-16
| ||
05:39 | • Reply: Sqlite3 as a shared object (.so) (artifact: 60f3491076 user: stephancb) | |
2023-01-11
| ||
16:18 | • Reply: File locking in Vtab? (artifact: 08b83fabcf user: stephancb) | |
11:28 | • Reply: File locking in Vtab? (artifact: 96b3519c9e user: stephancb) | |
11:06 | • Post: File locking in Vtab? (artifact: 5f634f7f42 user: stephancb) | |
2023-01-03
| ||
11:36 | • Reply: Can SQLite filter duplicates? (artifact: aee83ae33b user: stephancb) | |
2023-01-01
| ||
13:02 | • Reply: Bitmap/mask index ? (artifact: 24639df3fd user: stephancb) | |
2022-12-28
| ||
20:30 | • Reply: UTC time between SQLite and Python Arrow have a delta of one hour ! :'( (artifact: 8762fd73d3 user: stephancb) | |
13:22 | • Reply: UTC time between SQLite and Python Arrow have a delta of one hour ! :'( (artifact: 7c0043fcdf user: stephancb) | |
2022-12-27
| ||
13:30 | • Reply: UTC time between SQLite and Python Arrow have a delta of one hour ! :'( (artifact: cd4f7aea35 user: stephancb) | |
2022-12-13
| ||
11:17 | • Reply: decimal precision (artifact: 6040ab8f6a user: stephancb) | |
2022-10-26
| ||
21:25 | • Reply: Local time zone UTC offset in SQLite query (artifact: 86e6019bca user: stephancb) | |
16:06 | • Reply: Local time zone UTC offset in SQLite query (artifact: 0c9886e986 user: stephancb) | |
2022-09-02
| ||
13:24 | • Reply: Clearing out the WAL (artifact: fefd56014e user: stephancb) | |
2022-08-26
| ||
11:49 | • Reply: Arrays in SQLite (artifact: 34533550b6 user: stephancb) | |
2022-08-13
| ||
08:03 | • Edit reply: making Count() … GROUP BY faster (artifact: 4e4c879f90 user: stephancb) | |