SQLite Forum

Timeline
Login

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

50 most recent forum posts by user punkish

2022-08-12
13:57 Post: making Count() … GROUP BY faster (artifact: c81e5c1e99 user: punkish)
2022-08-08
15:14 Edit reply: GROUP BY failing to GROUP (artifact: af9baaed77 user: punkish)
12:55 Reply: GROUP BY failing to GROUP (artifact: cc3da68c0d user: punkish)
12:52 Edit reply: GROUP BY failing to GROUP (artifact: d86f942fe0 user: punkish)
12:07 Reply: GROUP BY failing to GROUP (artifact: 03d4884bbd user: punkish)
10:45 Reply: GROUP BY failing to GROUP (artifact: e38bed5d96 user: punkish)
2022-08-07
21:41 Edit: GROUP BY failing to GROUP (artifact: 5c8c5c03b2 user: punkish)
21:34 Post: GROUP BY failing to GROUP (artifact: 6774859468 user: punkish)
2022-02-24
13:43 Reply: two fast queries together make for a very slow query (artifact: b3514c6c80 user: punkish)
2022-02-23
17:02 Post: two fast queries together make for a very slow query (artifact: e71512aa7a user: punkish)
2022-02-20
22:48 Reply: why is an empty field evaluate to greater than an integer? (artifact: 83b1a3f9da user: punkish)
22:37 Reply: why is an empty field evaluate to greater than an integer? (artifact: ddb4478663 user: punkish)
21:46 Post: why is an empty field evaluate to greater than an integer? (artifact: 16ee998043 user: punkish)
2022-01-01
19:07 Reply: select valid lat/lng from columns typed as text (artifact: 9706557aae user: punkish)
2021-12-31
18:43 Reply: select valid lat/lng from columns typed as text (artifact: d59530c897 user: punkish)
18:08 Post: select valid lat/lng from columns typed as text (artifact: 3ab3e7ce80 user: punkish)
2021-12-26
12:12 Edit: emulating UPSERT on VIRTUAL table (artifact: 25e767ebd1 user: punkish)
11:52 Edit: emulating UPSERT on VIRTUAL table (artifact: 641ed45e11 user: punkish)
11:51 Post: emulating UPSERT on VIRTUAL table (artifact: f3f73221cc user: punkish)
2020-09-15
14:29 Reply: another performance question related to `geopoly` (artifact: 25d2c5c5b4 user: punkish)
14:23 Reply: another performance question related to `geopoly` (artifact: dfc84c2126 user: punkish)
09:24 Reply: another performance question related to `geopoly` (artifact: 29afe82b4e user: punkish)
04:20 Post: another performance question related to `geopoly` (artifact: 28ede1c8f3 user: punkish)
2020-08-17
07:22 Edit: geopoly performance (artifact: 3339cc99b2 user: punkish)
07:00 Post: geopoly performance (artifact: 6cde2e98eb user: punkish)
2020-08-10
09:23 Edit: using geopoly to find rows within a buffer around an input point (artifact: f5148ce4dc user: punkish)
2020-08-09
19:00 Reply: using geopoly to find rows within a buffer around an input point (artifact: bcf67358a8 user: punkish)
18:54 Edit: using geopoly to find rows within a buffer around an input point (artifact: ac8c6f04e6 user: punkish)
18:50 Edit: using geopoly to find rows within a buffer around an input point (artifact: 7457a2669c user: punkish)
18:42 Post: using geopoly to find rows within a buffer around an input point (artifact: b0112b818a user: punkish)
2020-03-17
17:54 Reply: Convert datetime string to second since Epoch with millisecond precision (artifact: b5f94212df user: punkish)
2020-03-15
15:01 Reply: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read (artifact: 36aeeedde1 user: punkish)
13:52 Reply: email gateway Confusing authorship on edited posts (artifact: 0bbb38ab42 user: punkish)
13:06 Reply: (email) Lack of paragraph wrapping in text/plain emails makes them hard to read (artifact: a05f706d7f user: punkish)
2020-03-13
20:53 Edit reply: a css to improve readability of this forum (artifact: 3db0700285 user: punkish)
20:39 Reply: a css to improve readability of this forum (artifact: 604dc8433c user: punkish)
15:29 Reply: JOINs with FTS5 virtual tables are very slow (artifact: 509bdbe534 user: punkish)
14:34 Reply: JOINs with FTS5 virtual tables are very slow (artifact: f17e16e14b user: punkish)
14:15 Reply: JOINs with FTS5 virtual tables are very slow (artifact: 9ef4087b98 user: punkish)
14:07 Reply: a css to improve readability of this forum (artifact: 82cf265748 user: punkish)
13:11 Reply: a css to improve readability of this forum (artifact: 6c01d278a7 user: punkish)
13:06 Edit reply: a css to improve readability of this forum (artifact: a5752ba304 user: punkish)
13:04 Reply: a css to improve readability of this forum (artifact: bbbc945880 user: punkish)
13:00 Reply: a css to improve readability of this forum (artifact: 36cb08c001 user: punkish)
12:40 Edit: a css to improve readability of this forum (artifact: 55a14d3904 user: punkish)
12:37 Edit: a css to improve readability of this forum (artifact: e2890b0bcc user: punkish)
12:30 Post: a css to improve readability of this forum (artifact: 04c71a9817 user: punkish)
11:07 Edit: JOINs with FTS5 virtual tables are very slow (artifact: 5f79ba0c13 user: punkish)
10:09 Edit: JOINs with FTS5 virtual tables are very slow (artifact: e2debc62ee user: punkish)
09:53 Post: JOINs with FTS5 virtual tables are very slow (artifact: c99fda4f62 user: punkish)