Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
104 events for the month beginning 2024-01-01 by user spindrift
Following month ↑
2024-01-29
| ||
18:24 | • Reply: drop view if existsx fails if x is the name of a table artifact: 09b5c58a46 user: spindrift | |
2024-01-28
| ||
09:38 | • Edit reply: Start of day in localtime artifact: a883762549 user: spindrift | |
09:14 | • Reply: Start of day in localtime artifact: c74474146d user: spindrift | |
2024-01-27
| ||
18:15 | • Reply: calculating Count per "time period" artifact: 9a87fb918b user: spindrift | |
12:53 | • Reply: calculating Count per "time period" artifact: 10cc32c1df user: spindrift | |
12:01 | • Reply: calculating Count per "time period" artifact: 08fda27522 user: spindrift | |
12:00 | • Edit reply: calculating Count per "time period" artifact: 359f169ceb user: spindrift | |
11:59 | • Reply: calculating Count per "time period" artifact: 1fc3bfdcf2 user: spindrift | |
07:21 | • Edit reply: Bug converting date to ISO date artifact: 7497f2955f user: spindrift | |
2024-01-26
| ||
21:32 | • Reply: Documentation suggestion: In "Determining If An Existing Table Is WITHOUT ROWID", mention "sqlite_schema" artifact: 10de2ef848 user: spindrift | |
17:17 | • Reply: how to improve speed for 30k individual inserts in one table artifact: 9456991860 user: spindrift | |
07:58 | • Edit reply: SQLite: Column naming convention artifact: 9c3b6ba95e user: spindrift | |
07:57 | • Reply: SQLite: Column naming convention artifact: c85938e050 user: spindrift | |
2024-01-25
| ||
19:07 | • Reply: SQLite: Column naming convention artifact: 63b2a05b60 user: spindrift | |
14:31 | • Reply: SQLite: Column naming convention artifact: b59fe6788e user: spindrift | |
2024-01-24
| ||
21:14 | • Edit reply: How to use SQL SUM() on a time field? artifact: 42e4665b2c user: spindrift | |
21:09 | • Reply: How to use SQL SUM() on a time field? artifact: 0a1a7cbbff user: spindrift | |
20:51 | • Edit reply: How to use SQL SUM() on a time field? artifact: 7ca62dc706 user: spindrift | |
20:50 | • Reply: How to use SQL SUM() on a time field? artifact: 014d804823 user: spindrift | |
20:45 | • Edit reply: How to use SQL SUM() on a time field? artifact: 836c55d4e6 user: spindrift | |
20:43 | • Reply: How to use SQL SUM() on a time field? artifact: dfe0464d4a user: spindrift | |
2024-01-23
| ||
20:35 | • Reply: CSV data import by code - solved artifact: c25b1ae517 user: spindrift | |
20:23 | • Edit reply: Foreign Key reference behavior with multiple databases attached (BUG??) V2 artifact: 424f5b9a50 user: spindrift | |
20:21 | • Reply: Foreign Key reference behavior with multiple databases attached (BUG??) V2 artifact: 5fb24d975c user: spindrift | |
14:04 | • Edit reply: CSV data import by code - solved artifact: f6622f92b6 user: spindrift | |
14:03 | • Reply: CSV data import by code - solved artifact: db6a0d407e user: spindrift | |
2024-01-22
| ||
16:55 | • Reply: What happened to 1904? artifact: 2179f08130 user: spindrift | |
16:38 | • Edit reply: What happened to 1904? artifact: 20c28a7fe6 user: spindrift | |
16:35 | • Reply: What happened to 1904? artifact: 72814d8a10 user: spindrift | |
16:07 | • Reply: What happened to 1904? artifact: f4bc959d0b user: spindrift | |
15:35 | • Reply: Bug converting date to ISO date artifact: ec42035f60 user: spindrift | |
15:17 | • Reply: What happened to 1904? artifact: 85f2463dad user: spindrift | |
2024-01-21
| ||
07:50 | • Reply: JSON functions stopped working with blobs in 3.45 artifact: 054ef60bc4 user: spindrift | |
07:08 | • Reply: JSON functions stopped working with blobs in 3.45 artifact: aa2232e3a8 user: spindrift | |
2024-01-19
| ||
21:47 | • Edit reply: Malformed Database upon Index Creation artifact: 659881f863 user: spindrift | |
21:46 | • Reply: Malformed Database upon Index Creation artifact: 209364b55d user: spindrift | |
18:59 | • Reply: Malformed Database upon Index Creation artifact: bfe559fd9c user: spindrift | |
18:44 | • Edit reply: Malformed Database upon Index Creation artifact: 5a52940744 user: spindrift | |
18:43 | • Reply: Malformed Database upon Index Creation artifact: c3fe969806 user: spindrift | |
13:27 | • Reply: Allow altering all database elements (views, indexes, triggers) artifact: 750fdd72b3 user: spindrift | |
2024-01-18
| ||
21:08 | • Reply: Malformed Database upon Index Creation artifact: 9f91bdcbb1 user: spindrift | |
18:31 | • Reply: How do I make a SELECT query using human time stamps? artifact: 63171a645d user: spindrift | |
18:30 | • Reply: high performance mode for sqlite artifact: 0a74f856f5 user: spindrift | |
17:29 | • Edit reply: How do I make a SELECT query using human time stamps? artifact: 70908b1287 user: spindrift | |
17:28 | • Edit reply: How do I make a SELECT query using human time stamps? artifact: 65d53e2b31 user: spindrift | |
17:09 | • Reply: high performance mode for sqlite artifact: 0edfd91cde user: spindrift | |
17:02 | • Reply: high performance mode for sqlite artifact: f18dcb1d7c user: spindrift | |
16:27 | • Reply: How do I make a SELECT query using human time stamps? artifact: 9d6145460f user: spindrift | |
16:17 | • Reply: How do I make a SELECT query using human time stamps? artifact: 5f59d832d0 user: spindrift | |
16:13 | • Reply: How do I make a SELECT query using human time stamps? artifact: b32589db22 user: spindrift | |
14:05 | • Reply: Allow altering all database elements (views, indexes, triggers) artifact: 45a8ee495c user: spindrift | |
06:34 | • Reply: Malformed Database upon Index Creation artifact: 2f154ac7ec user: spindrift | |
2024-01-17
| ||
21:40 | • Reply: Copy two database files locally from master to slave artifact: 33c7b27676 user: spindrift | |
07:47 | • Reply: Copy two database files locally from master to slave artifact: 44a091c3b9 user: spindrift | |
2024-01-16
| ||
19:15 | • Reply: Allow altering all database elements (views, indexes, triggers) artifact: 2b917cf06f user: spindrift | |
16:11 | • Reply: Allow altering all database elements (views, indexes, triggers) artifact: 5b40d3724f user: spindrift | |
2024-01-14
| ||
17:26 | • Reply: wish Please throw informative "attempt to write a readonly database" exception artifact: df3bd19fe7 user: spindrift | |
09:44 | • Edit reply: CLI inserting blank lines between each row artifact: 3a27221abb user: spindrift | |
09:41 | • Reply: CLI inserting blank lines between each row artifact: 3246952bcc user: spindrift | |
09:40 | • Reply: CLI inserting blank lines between each row artifact: 6ec38f0a33 user: spindrift | |
2024-01-13
| ||
13:05 | • Reply: Constraints - multiple eligible values artifact: 5d248cc221 user: spindrift | |
12:20 | • Reply: Constraints - multiple eligible values artifact: 3922eb1362 user: spindrift | |
12:18 | • Reply: Constraints - multiple eligible values artifact: 88a3395292 user: spindrift | |
12:08 | • Reply: How to structure some tables (was: Sqlite noob) artifact: 0aeb7b9d81 user: spindrift | |
2024-01-12
| ||
23:50 | • Reply: Window functions documentation artifact: 030dd03d14 user: spindrift | |
22:08 | • Post: Window functions documentation artifact: 42b5f6458e user: spindrift | |
19:09 | • Reply: db locked error on concurrent write during an open transaction that has already read artifact: 57f357c98d user: spindrift | |
11:18 | • Edit reply: sqlite .dump with CHECKS breaking artifact: 28deba231c user: spindrift | |
11:17 | • Reply: sqlite .dump with CHECKS breaking artifact: 6ea9fffdd8 user: spindrift | |
09:10 | • Edit reply: sqlite .dump with CHECKS breaking artifact: fb36b86699 user: spindrift | |
09:08 | • Reply: sqlite .dump with CHECKS breaking artifact: 4d7a8ce51a user: spindrift | |
08:25 | • Reply: Compute the last day of quarter artifact: 36e0e99adf user: spindrift | |
08:01 | • Edit reply: Compute the last day of quarter artifact: 8dbc6b6cdb user: spindrift | |
07:59 | • Edit reply: Compute the last day of quarter artifact: ad0e47b3ea user: spindrift | |
07:16 | • Reply: Lock database file artifact: f609780822 user: spindrift | |
07:02 | • Reply: Compute the last day of quarter artifact: 60b82c567c user: spindrift | |
06:59 | • Reply: Compute the last day of quarter artifact: 688afe5680 user: spindrift | |
06:46 | • Reply: how to extend a single result sqlite query into a list artifact: c787bc16d4 user: spindrift | |
2024-01-11
| ||
23:35 | • Reply: how to extend a single result sqlite query into a list artifact: e3990fb9db user: spindrift | |
22:17 | • Reply: sqlite .dump with CHECKS breaking artifact: 1b7b6bd58b user: spindrift | |
2024-01-10
| ||
16:24 | • Reply: Lock database file artifact: be09ea5772 user: spindrift | |
2024-01-09
| ||
20:17 | • Reply: Bug / typo in documentation: compile.html artifact: 057694ed7f user: spindrift | |
2024-01-08
| ||
10:48 | • Reply: Prepared statemnts do not convert "True" to 1 and "False" to 0 artifact: d36de0ed1b user: spindrift | |
10:24 | • Reply: Prepared statemnts do not convert "True" to 1 and "False" to 0 artifact: 6abd196605 user: spindrift | |
10:10 | • Edit reply: Prepared statemnts do not convert "True" to 1 and "False" to 0 artifact: b3028f2ab7 user: spindrift | |
10:08 | • Edit reply: Prepared statemnts do not convert "True" to 1 and "False" to 0 artifact: b231e8f699 user: spindrift | |
10:06 | • Edit reply: Prepared statemnts do not convert "True" to 1 and "False" to 0 artifact: def5bb4f11 user: spindrift | |
10:04 | • Reply: Prepared statemnts do not convert "True" to 1 and "False" to 0 artifact: 445f9eeaf6 user: spindrift | |
10:01 | • Edit reply: Prepared statemnts do not convert "True" to 1 and "False" to 0 artifact: 3e0087786e user: spindrift | |
09:59 | • Edit reply: Prepared statemnts do not convert "True" to 1 and "False" to 0 artifact: 7a8a244d67 user: spindrift | |
09:54 | • Reply: Prepared statemnts do not convert "True" to 1 and "False" to 0 artifact: 76aadd5e07 user: spindrift | |
2024-01-07
| ||
17:12 | • Reply: Flat files vs SQLite artifact: 3d7be1ad3d user: spindrift | |
12:40 | • Reply: DATETIME devide by Float artifact: 1719f07503 user: spindrift | |
09:03 | • Reply: DATETIME devide by Float artifact: 70d04fb52e user: spindrift | |
2024-01-04
| ||
19:50 | • Reply: Doc clarification on journal_mode = WAL and SQLITE_BUSY errors artifact: c2f4bf2378 user: spindrift | |
17:23 | • Reply: Are the functions from the SQLite library thread-safe? artifact: b0c980c7db user: spindrift | |
07:02 | • Reply: Lock database file artifact: 0088de19a8 user: spindrift | |
2024-01-03
| ||
22:54 | • Reply: Can I get the next auto increment value, and have the database hold that position for me? artifact: 1f2a4ac427 user: spindrift | |
21:29 | • Reply: Can I get the next auto increment value, and have the database hold that position for me? artifact: 83b5bbe120 user: spindrift | |
18:50 | • Reply: Lock database file artifact: 8ed075ae0c user: spindrift | |
18:46 | • Reply: Clean database file artifact: 3410bf2180 user: spindrift | |
11:49 | • Reply: Lock database file artifact: 786dd8219c user: spindrift | |
11:45 | • Reply: Clean database file artifact: e90c45241b user: spindrift | |
11:43 | • Reply: Clean database file artifact: f500e7d037 user: spindrift | |