SQLite Forum

Timeline
Login

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
Previous month ↓