Dates at which people first used EEPROM (File Uploads)
#18945

So for dumb reasons, EEPROM used to store its own copy of a user and in the next update I'm getting rid of this behaviour, but the table that kept track of this also recorded when the user was added for some reason. So, in somewhat of a commemoration of EEPROM being almost Five years old, here is that list, ordered by creation date, before I nuke it. I think the timestamps are in my timezone (UTC+1) but I'm not sure because I can't be bothered to check. :D

user_id username user_created
1 flash 2020-02-14 01:57:59
32 szy 2020-02-16 23:17:46
2 nook 2020-02-17 00:00:30
115 osk 2020-02-17 00:01:24
12 thugginator 2020-02-17 00:15:02
72 Sora 2020-02-17 01:55:49
136 funtime 2020-02-17 01:59:27
9 random 2020-02-17 02:00:00
3 reemo 2020-02-17 02:22:07
145 gebruikersnaam 2020-02-17 13:28:39
101 Arysil 2020-02-17 17:55:12
100 Sword 2020-02-17 20:35:41
142 ReggaeKojima 2020-02-17 21:16:52
45 yurrieissmart 2020-02-17 22:02:44
13 SydKnee 2020-02-19 00:11:26
141 Matthew 2020-02-19 15:24:49
10 game_beetle 2020-02-21 04:11:30
91 scawful 2020-02-21 19:55:56
16 louisoft01 2020-03-03 20:06:37
82 zoren 2020-03-04 01:50:06
25 low 2020-03-08 16:48:00
34 wamwoowam 2020-03-12 17:23:53
152 purplesockk 2020-03-25 20:41:33
158 blue 2020-04-01 21:45:06
4 gaythugmemes 2020-04-01 23:51:38
5 win 2020-04-07 19:12:10
161 alcazar 2020-04-13 02:20:54
92 limewire 2020-04-15 03:41:13
47 Flashwave 2020-04-15 19:06:37
163 Monkena 2020-05-03 19:33:46
164 Pecfex 2020-05-21 09:15:29
21 Koishi 2020-05-27 23:35:05
157 goeo_ 2020-06-09 16:54:27
126 aeulis 2020-06-11 21:12:48
38 JonQuan 2020-06-30 17:06:17
70 noob 2020-07-06 23:58:30
20 Djjuul 2020-07-17 21:32:40
170 suya 2020-08-05 01:24:33
40 Trigex 2020-09-09 08:34:24
175 Bloops 2020-09-22 15:22:17
174 nemko 2020-09-27 04:46:15
14 FlappyzorWorldwideOnline2014through2015...2024through2025 2020-10-02 15:28:04
180 setty 2020-10-19 15:37:30
181 saikuru0 2020-10-19 20:03:08
183 mewea 2020-11-01 16:56:49
8 Gatysh 2020-11-12 05:29:27
184 terribleterrio 2020-11-15 00:17:15
73 rjoken 2020-12-10 02:36:52
188 Shino6u 2020-12-10 02:59:31
189 snugz 2020-12-27 01:43:55
190 Hyporelix 2020-12-31 17:10:05
185 Deleted User 2021-01-09 03:16:10
193 sab 2021-01-19 09:53:25
194 paste 2021-01-22 10:06:29
204 heavycube4u 2021-03-15 21:10:20
173 Phi 2021-03-24 05:17:16
210 Deleted User 2021-05-12 20:05:13
208 Sangui 2021-05-15 20:40:35
79 Chimpstar2070 2021-05-30 07:33:27
215 txmx0000 2021-05-30 07:55:38
148 lester 2021-06-11 19:10:15
218 Bananas 2021-06-28 23:47:07
214 Dimentio 2021-08-19 02:44:47
167 Iktopsui 2021-09-29 17:24:06
88 walllable 2021-11-03 11:01:24
225 catptr 2021-12-10 04:52:41
227 0x64__ 2022-01-22 20:55:48
48 RuMoR 2022-02-12 18:24:55
135 RedDash16 2022-03-02 23:04:19
238 Kou 2022-05-22 21:43:25
236 Neeko 2022-05-30 18:59:10
235 ananinunenon 2022-06-19 13:59:15
52 Kamil 2022-07-23 03:44:05
240 cyn 2022-07-27 17:57:53
241 Melan 2022-07-30 13:35:52
138 Rizaki 2022-08-08 18:18:56
237 Killet 2022-09-13 11:14:00
252 whim 2023-01-30 23:24:16
11 Satori 2023-02-02 19:36:06
247 Niramou 2023-03-10 20:09:25
248 kp 2023-03-23 06:45:55
249 Alexithymia 2023-03-23 23:56:27
250 Period000 2023-03-23 23:59:35
251 defenceder 2023-03-24 00:00:12
151 TheCanadianToast 2023-04-01 20:48:12
253 2023-04-26 22:44:45
97 SnailMush 2023-04-28 22:29:00
254 slugmush 2023-04-28 23:10:38
27 dead385 2023-05-05 17:48:43
37 name 2023-05-21 19:30:31
85 renatus_lupus 2023-05-21 19:32:28
198 GalacticLightN 2023-05-21 19:35:50
207 zenhead 2023-05-21 19:36:43
89 HTFCirno2000 2023-05-21 19:41:54
144 Insane_Crystal 2023-05-21 19:44:53
146 AnimeGuy 2023-05-21 19:47:11
18 Kotori 2023-05-21 19:52:10
93 s8wc3 2023-05-21 19:58:24
102 Deleted User 2023-05-21 20:02:48
15 bribob4 2023-05-21 20:03:38
94 Mal 2023-05-21 20:05:20
22 TuxCrafting 2023-05-21 20:34:50
67 Emily 2023-05-21 20:39:03
55 Rebecca 2023-05-21 20:46:01
49 clayton 2023-05-21 21:31:25
123 rafuwu 2023-05-21 21:35:15
19 scriminamp 2023-05-21 23:08:21
255 Ambar 2023-06-11 20:31:25
256 rew 2023-06-24 01:16:32
257 pink9320 2023-06-24 17:22:04
258 alanac 2023-07-16 13:30:55
233 odpay 2023-07-23 02:39:51
259 snoozin 2023-08-18 22:31:05
46 nathat 2023-08-24 14:04:37
260 Alicyka 2023-08-25 01:13:14
261 flowerpetal 2023-09-11 05:57:04
262 Niiso 2023-09-11 21:02:17
264 skellygore 2023-09-26 20:12:56
265 Majoorhenk 2023-10-10 11:48:25
58 IANSYT 2023-10-12 07:07:17
267 chaoskaiser72 2023-11-05 01:47:55
268 snowdrift 2023-11-05 02:37:21
186 Parsee 2023-11-27 19:29:42
134 termer 2024-01-25 07:35:24
182 gripison 2024-03-22 17:56:02
275 G2_Games 2024-05-25 03:48:09
54 Dilene 2024-05-28 18:51:57
270 philly 2024-09-13 08:36:25
281 pelly 2024-10-10 15:32:06
282 solstice 2024-10-29 22:18:55
284 lachrymal 2024-11-17 21:17:49
285 lul 2024-11-30 19:06:18
286 aves 2024-12-01 06:04:48
287 deek 2024-12-01 06:04:51
283 Adel 2024-12-06 00:48:54
239 Cirno 2024-12-14 03:00:46
288 knaifu 2024-12-24 17:42:19

If you're curious about the gap between szy and I, EEPROM was originally an experiment to see if having a public uploader was viable, fully expecting it to end up being a failure and requiring too much space, so I just kind of hacked it together on the production server and pieced the database together like that. I'm still a bit surprised its managing as well as it does in terms of space to be honest.

Also the records for 2023-05-21 are technically A Lie, on that date I did a mass reupload of hotlinked files to EEPROM on the forum. That also explains why people who haven't used the site in a long time show up there.

For obvious reasons this will be the one and only time I'm posting such a thing because from now on this data won't be recorded anymore and the existing data will be nuked, but as is slightly visible towards the end, it'll just end up being whoever registered last.

Thank you for consuming space on my servers :)

Also a sidenote, this is probably the first time I've used a cross-database join query;

SELECT epu.user_id, mmu.username, epu.user_created
FROM eeprom.prm_users AS epu
LEFT JOIN misuzu.msz_users AS mmu
ON mmu.user_id = epu.user_id
ORDER BY epu.user_created ASC
https://sig.flash.moe/signature.png