#dev 2026-08-26
2026-08-26 UTC
jeremycherfas, klez, grufwub, [Sophia], lanodan, athenaeryma, srushe, [tantek], Maxpm, sandra, hughrawlinson, GWG, chimo, rMdes-bnc, Saige_Leah_, rMdes, lavandula_, lavandula, pauls, aczietlow[d], thegr8whoopdini[, magnumOopsies[d], [0x3b0b], srazkvt, dustinm` and [Trevor_Morris] joined the channel
# 
[Trevor_Morris] tdrayson I have been working on this sleep integration. Turns out my Auto Export health sync *was* still sending the data to my API endpoint, so I have lots of JSON files. However, I send the "summary" information, which doesn't include all the breakdowns for sleep 😞 I have manually export one to test locally and I've got this. The non-summary JSON files are 17mb each, so I need to check what data I actually need. And then I need t
# [Trevor_Morris] back date it all!
sivoais, lavandula, JadedBlueEyes1 and lavandula_ joined the channel
# tdrayson That looks awesome! One thing I did that I think helped bring down the total non-summary data was only including one source
# tdrayson Then basically stripped out all of the other stuff
# IWDiscord <tdrayson>
# IWDiscord <tdrayson>
# tdrayson What I found was because I have an Apple Watch and order a ring and my phone tracks sleep as a fallback. When I was sending the data, it was actually sending all three sources. So I just have a priority to select ours if it exists and then falls back to the Apple Watch.
# IWDiscord <tdrayson>
# tdrayson So maybe check if you’ve got duplicate entries from multiple sources
# tdrayson Meant to be Oura ring*
lavandula_ joined the channel
# [Trevor_Morris] Ah, I'll give at a go. I'll tweak a manual export first, so I can pull it in locally. I only have certain data being sent over to my API, but I imagine the file-size will balloon if I remove the "summary" flag, which I need to do for the sleep data. It falls back to a single bar chart if the detail isn't there, which could be an option.
# tdrayson Yeah; I had a couple older entries that only had summary data because of how long ago they were.
# [Trevor_Morris] My current move/exercise/stand database table has space for the detailed information, eg per hour, like they show on the phone. But none of that data is populated. So it's another thing I need to make sure this new import can injest.
# tdrayson If you figure that out let me know
# [Trevor_Morris] This is my "timeline" (with only sleep selected). Which is the basic bar.
# [Trevor_Morris] Need another word for "analysis" next to the date, I don't like it repeating!
# tdrayson Breakdown?
# tdrayson Summary?
# tdrayson Where is your timeline page?
# [Trevor_Morris] Summary 👍
# [Trevor_Morris] `/timeline`
# [Trevor_Morris] It is linked in the "blurb" in the main text on the homepage.
# tdrayson Is sleep linked in the filter list? I don’t see it
lavandula joined the channel
# tdrayson I like the changelog idea
# [Trevor_Morris] Not yet. Screenshots are from my local development area.
[artlung] joined the channel
[artlung] joined the channel
# tdrayson [Trevor_Morris] Something I've been trying to wrap my head around recently is how I deal with all-day events in a timeline view. For my food tracking, I've just ended up putting it at 23:59 p.m. at the end of the day, but it feels wrong to put it there. I don't really have a better idea of when it should be stored for all-day events.
# IWDiscord <tdrayson>
# tdrayson Same for the vitals, which are kind of like your fitness rings that you've got, which I plan to add. Again, I'm not sure where they should go because they would technically be the exact same time: 23:59.
# [Trevor_Morris] HA. I have exactly the same issue!
# [Trevor_Morris] I don't store the time when I watch a movie, only the date. But they're *usually* in the evening. Same for "day" things, like fitness and now the new sleep data.
lavandula joined the channel
# tdrayson So your timeline view is just ordered by when it was inserted into the database ?
# [Trevor_Morris] For the new sleep data I have `DB::raw("DATE_ADD(
{$created}, INTERVAL '23:01' HOUR_MINUTE) as created_at")` to move it above fitness which is `DB::raw("DATE_ADD({$created}, INTERVAL 23 HOUR) as created_at")` - not much happens after 11pm in my world! Moves are +21 hour, so they're always nearly last.# [Trevor_Morris] I *might* watch a movie, then go for an activity… but they won't appear in *that* order.
vidak joined the channel
# tdrayson I've been banging my head on these stupid time zone issues. When I travel to a new country, all of the future entries have to be keyed on the correct timeonze. Since I store the local wall clock time and a UTC column, it technically still orders in the timeline correctly. I don't get 9:00 AM rendering from New York after 1:00 PM in the U.K.
# [Trevor_Morris] Don't tell anybody!
# tdrayson timezones have to be up there as one of the most painful things to deal with for a developer
lavandula and chenghiz_ joined the channel
# [Trevor_Morris] Yup.
# [Trevor_Morris] I've found some strange listened data, when I was up during the cross-over. Some of my data is in UTC and other GMT, so that's a pain! lol
srazkvt, doesnm, lavandula, barnaby, rrix, hisacro, pfych, ax562 and thatoddshade joined the channel
# 
[artlung] Back in 2018 I wrote up getting alerted to new user creation by WordFence. https://artlung.com/blog/2018/02/22/suspicious-activity-an-admin-user-with-the-username-backup-was-created-outside-of-wordpress/
Ace, wturrell, lockywolf, rMdes, fluffy, dabeglavins, karjala, IWDiscord and morganwebdev joined the channel
# 
[tantek] the countdown clock on https://openai.com/webmcp-challenge/ is giving "Three Body Problem" vibes — especially the warping effect when you move your cursor over it. possible FrESH exploration (just the clock component, not the whole page or context obv)
Kolev, ggarcia24, rMdes, thatoddshade, ax562, kensanata and owls joined the channel