as my solution would be easy: time().
This isn’t the first painful migration of timestamps that I’ve had to deal with. And I’m starting to ask myself why we even need abstractions like Instant and datetime when everything could be stored as a time(). It can be converted on the fly to whatever the user wants to see, but all the logic and all the comparisons should probably *always* be between UNIX timestamps.
Fabio Manganiello /
npub1s9…jdnmu
2024-05-31 22:23:23
in reply to nevent1q…y84y
Author Public Key
npub1s9uc08n58mxqk5umvapqulwzng0sja635q86r36d8n4rr9r9ygaskjdnmuPublished at
2024-05-31 22:23:23Event JSON
{
"id": "4a7cbeacdd8a3ad605cd0048e0feaa16d58029b63d6458f0968b280fe1376d9e",
"pubkey": "8179879e743ecc0b539b67420e7dc29a1f097751a00fa1c74d3cea319465223b",
"created_at": 1717194203,
"kind": 1,
"tags": [
[
"p",
"8179879e743ecc0b539b67420e7dc29a1f097751a00fa1c74d3cea319465223b"
],
[
"p",
"6ff6a38d7fe6161f1043d9e7c3212960e2282f52ae22114b2fb21a6da7a73689"
],
[
"e",
"3e427031fc05a1958892353eebf72e5b8f1d7ff8bf0b37b95ea37eee0dbac134",
"",
"reply"
],
[
"p",
"b529c9ccae32c94b6cdae970f047e39a5b5efdb120619fbc58bec87c1ca91fcb"
],
[
"p",
"371820b7120114ecf6d3cc048f32ead77dd6e3080d9372adfd1c9bca1eac68ff"
],
[
"e",
"f5d92ec181f5443b0fd740e507b1dbf76806aef23b36583e4c0ef8d55cb0047b",
"",
"root"
],
[
"proxy",
"https://manganiello.social/objects/5cc55d07-46f3-432b-9285-d5e490748245",
"activitypub"
],
[
"L",
"pink.momostr"
],
[
"l",
"pink.momostr.activitypub:https://manganiello.social/objects/5cc55d07-46f3-432b-9285-d5e490748245",
"pink.momostr"
]
],
"content": "as my solution would be easy: time().\n\nThis isn’t the first painful migration of timestamps that I’ve had to deal with. And I’m starting to ask myself why we even need abstractions like Instant and datetime when everything could be stored as a time(). It can be converted on the fly to whatever the user wants to see, but all the logic and all the comparisons should probably *always* be between UNIX timestamps.",
"sig": "9df13a58a65f728647c85c52dfca737a29e77a5642d5dd9c2fde419318a6480b72679fbe95b3df7cfdcdc42edeefed54240988e1dbf31275fe9a2b266266a844"
}