Zeitpunkt Nutzer Delta Tröts TNR Titel Version maxTL So 11.08.2024 00:00:10 22.221 +2 3.025.397 136,2 Mastodon 4.2.10 500 Sa 10.08.2024 00:00:01 22.219 0 3.023.374 136,1 Mastodon 4.2.10 500 Fr 09.08.2024 00:00:06 22.219 0 3.021.586 136,0 Mastodon 4.2.10 500 Do 08.08.2024 00:00:01 22.219 +1 3.020.153 135,9 Mastodon 4.2.10 500 Mi 07.08.2024 00:00:00 22.218 +3 3.018.114 135,8 Mastodon 4.2.10 500 Di 06.08.2024 00:01:06 22.215 -2 3.015.848 135,8 Mastodon 4.2.10 500 Mo 05.08.2024 00:01:12 22.217 +2 3.013.475 135,6 Mastodon 4.2.10 500 So 04.08.2024 00:00:06 22.215 +1 3.012.355 135,6 Mastodon 4.2.10 500 Sa 03.08.2024 00:00:18 22.214 +1 3.010.437 135,5 Mastodon 4.2.10 500 Fr 02.08.2024 00:00:58 22.213 0 3.008.406 135,4 Mastodon 4.2.10 500
Critical Silence (@CriticalSilence) · 08/2023 · Tröts: 149 · Folger: 33
So 11.08.2024 04:30
I would've never thought, that I refactor my whole sub page for tracking things per day.
After a random kind stranger shared his experienced knowledge with me, pointing out "LAG()", I built a #SQL join to collect first and last entry per "day", e.g. first at 10am, last at 02am. Of course, this escalates a little now.
I wasted so much performance on my #raspberry in the past, just by doing things through #PHP, instead of using the database, which could do it way faster, its really insane.
[Öffentlich] Antw.: 0 Wtrl.: 0 Fav.: 0