#dev 2022-01-18

2022-01-18 UTC
typ1cal_c0ffxe3, tetov-irc, frittro, rommudoh[m], diegov and justJustache joined the channel
#
jacky
heh implementing paging via Micropub is a bit tricker than I thought
#
jacky
doing it via SQL is oddly confusing
#
aaronpk
i assume you mean microsub
#
aaronpk
i used random strings in the examples, but the trick is you can use whatever you want, including for example, the integer primary key
#
aaronpk
or if you always sort everything by date, you can use a timestamp
solo joined the channel
#
jacky
oh no, I meant micropub lol
typ1cal_c0ffxe3 and darkkirb joined the channel
#
jacky
and support the `after` + `before` fields
#
aaronpk
same idea tho since it references the microsub spec paging :)
#
jacky
true! lol
#
jacky
probably overkill
frittro_ joined the channel
#
aaronpk
skimming thru that it looks like exactly the right thing to be reading :)
#
jacky
perfect
typ1cal_c0ffxe3 joined the channel
#
jacky
hm okay after reading this more, I think this works for me
#
jacky
leaning on `published_at` might be tricky since I can make that empty/null
#
jacky
but using something like `created_at` could be tricky (I plan to backfeed a lot of stuff from my archives)
#
jacky
I _could_ set the `created_at` to be the date of publishing from entries in my archives
#
GWG
I had similar paging trouble and ended up just doing offset for Micropub until I figured it out.
#
jacky
how did you figure it out?
#
jacky
or was it mainly trial and error for a bit?
#
GWG
I didn't yet
#
GWG
I just implemented offset and figured I'd come back to it later
#
jacky
ahh okay
KartikPrabhu joined the channel
#
GWG
I have this issue that I have the WordPress paging system to deal with, or not.
#
jacky
yeah so leaning on `published_at` breaks the potential cursor based approach I have
#
jacky
like I wouldn't be able to pull out things like drafts
#
jacky
but it doesn't necessarily have to
#
jacky
tries to think on this more
#
jacky
hm I could switch up the cursor for non-published posts to be based on their IDs
#
jacky
only other unique thing there I have
#
jacky
really avoiding adding a `created_at` column
#
[tantek]
what's wrong with keeping track of dt-created?
#
[tantek]
it might be one of the few sources of an actual unique id for active posts
#
jacky
chronologically, sure
#
jacky
but I haven't had an explicit need to publish it (nor can I think of a consuming case - maybe for an archive?)
#
jacky
I _techincally_ have it via the creation dates of the files I write to disk but those aren't indexed (obvs)
#
aaronpk
the micropub client-to-server communication is all private between the user and their own server, so it's ok to use data that isn't published
typ1cal_c0ffxe3 joined the channel
#
jacky
I think I can swap to created_at when post_status == draft and use it otherwise
jacky and gRegor joined the channel
#
aaronpk
This is a good bit of insight "Problem is, I think users tend to think “globally.” They expect all activity within a space or context to be visible to them. If a search for some user can return nothing because the subject is outside your local social graph, then your technology is less useful than other search models. This is why we tend to pool around well-maintained global indexes to give reliable
#
aaronpk
results, but then you have centralized authority emerging." via https://paulfrazee.medium.com/smart-contracts-without-blockchains-fc54603df754
#
jacky
oh I've been wanting to check out that video
#
jacky
the one re: Vitra
angelo joined the channel
#
jacky
I really wish the hypercore folks cared a bit more about language support
#
jacky
if they had bindings/implementations in things like Python or even in C (lol) and binded to other languages, it'd be easier to tinker on devices
ben_thatmustbeme and angelo joined the channel
#
[tantek]
awww still on Medium 😕
#
[tantek]
aaronpk, that email is false with one MASSIVE area: messaging
#
[tantek]
hah typo, that *insight* is false
#
[tantek]
"Problem is, I think users tend to think “globally.” They expect all activity within a space or context to be visible to them." <-- um no absolutely not. no one expects all activity within email to be visible to them, only emails sent to/from them. similarly with txt messages. DMs. etc.
#
[tantek]
"we tend to pool around well-maintained global indexes" <-- really? so what global index of email addresses are we pooled around? (hint: none)
KartikPrabhu1 joined the channel
#
[tantek]
still felt like a bit of solutioneering
#
Ruxton
we tend to pool around indexes.. even poorly maintained localized ones :P
#
Ruxton
mailing list = e-mails index group
#
Ruxton
newsgroups
#
Ruxton
forums
#
Ruxton
community groups (offline)
#
capjamesg[d]
GWG jacky I have had issues with paging in Microsub too. I still have to fix my paging implementation. I can see two pages but that's it.