#dev 2023-01-07

2023-01-07 UTC
Nuve joined the channel
#
aaronpk I am curious about the context for this but it is very much database antipattern https://hachyderm.io/@lkanies/109645309770295704
#
Loqi [preview] [Luke Kanies] Text presented as text should be stored as text. It does not belong in a database.Yes, I’m talking to you, Wordpress.
[iambismark] joined the channel
#
[iambismark] Huh tbh I’m a bit ignorant about database engine internal storage systems… but do they not store text as text? I’m assuming he means “stored as text directly on the file system without an intermediary engine”
#
[iambismark] Is the corollary then “structured data used for metadata and indexing should be stored in tabular form. It does not belong in markdown frontmatter”? :)
#
aaronpk databases do not store things in a format that is easily recognizable as text no
#
[iambismark] What is text? Must it be human readable in raw form to be text? ^_^ /troll
#
[iambismark] But more seriously I’m curious about it as an anti pattern, how much of that is that from some old MySQL engine handling text columns poorly that is now mitigated by say PostgreSQL vs something more inherent to relational data storage.
#
[tantek] Also bc text formats are more resilient. You usually don’t need the code that write them to read them
#
[tantek] Whereas db files change even with different versions of the “same” software
#
CrowderSoup [iambismark] I am not overly familiar with how databases (mysql, pgsql, etc.) actually format data for storage but it's my understanding that it's saved to disk in a non-human-readable format. This is not ideal for text meant to be read by humans.
angelo joined the channel
#
[iambismark] yah i was being slightly cheeky.. i mean, are the ASCII bits stored on disk actually “human readable”? or are you relying on the intermediary tool in order to render them, just in the same way as a database engine would render its particular binary format? anyway, apologies for the fruitless philosophical troll…
[James_Van_Dyne], barnaby, tiim and Nuve joined the channel
#
[tantek] it's not fruitless or purely philosophical. it's about resiliency. when you depend on one specific piece of software to read & write a file, there’s more chance of the file becoming unreadable in the future when the software is abandoned, breaks, or changes what file format it supports (without adequate backward compatibility testing for all previous formats)
#
[tantek] database engines are such "one specific piece of software". at some point when you upgrade your laptop and move the data across, the new database software in the new OS (maybe you went years between upgrades) won't read or may even corrupt the data from your old file
#
[tantek] databases are only good if you don't care about long term data loss. so databases are good for caches, not long term storage / persistency.
#
IWDiscordRelay <b​lindnerd#6539> Excuse me while I pump my fist in the air in triumph... finally figured out why outgoing mail from my server wasn't being delivered. Turns out that I needed to remove the base part of the domain from the Postfix config and restart Postfix and it now works as I expect.
#
barnaby 🎉
#
IWDiscordRelay <b​lindnerd#6539> this was specific to mail going to my own domain, email to other domains always worked under Postfix for me. Sendmail on the other hand needs to be taken to the top of Mt. Rainer and dropped head down over the side... that was not fun to deal with, hence the switch to Postfix.
[pfefferle] joined the channel
#
[tantek] updated my "test in production" copy of auto_link to support @-@ addresses
#
[tantek] and also verified that if I resent webmentions to old posts with @-@ addresses, that Bridgy Fed will push the updated post to any destinations that display it (like replies to posts, or boosts)
#
[tantek] so that cleaned up a few replies to toots in the display under those toots
#
[tantek] what is auto_link
#
Loqi An autolink is a hyperlink that was automatically added to some text to link that text to an obvious or useful destination, like hyperlinking a URL in plaintext to the URL itself, linking hashtags to search results, and @-names to their profile pages https://indieweb.org/auto_link
#
[tantek] going to let that one bake a while in production before committing it to the repo, since auto_link changes can be a bit more impactful
#
[tantek] [snarfed] would it be possible for the stream display at https://fed.brid.gy/user/tantek.com to note when a post or reply is an update? e.g. rather than " replied ", maybe " updated a reply ", similarly " updated a post " — if Bridgy Fed already knows (is able to detect) that it's sending an update that it is
#
[tantek] e.g. those most recent two " replied " are both updates (I fixed my @-@ links!)
#
@jeffbellseattle https://brid.gy/ (twitter.com/_/status/1611715588149350400)
rubenwardy joined the channel
#
jeremycherfas !tell snarfed How do I check the logs to see why a bridgy mention might be failing?
#
Loqi Ok, I'll tell them that when I see them next
#
sknebel jeremycherfas: on your bridgy page the timestamp links to the log
#
sknebel i.e. where it says "XX minutes ago"
#
jeremycherfas I knew it was something like that. Thanks.
#
jeremycherfas As I feared, something (else) is broken @WithKnown
#
jeremycherfas Known is sending a 500 to Bridgy.
#
jeremycherfas Hmm. Telegraph fails too, and says "The webmention endpoint did not return a status URL "
#
jeremycherfas I wish it weren't so, but I am beginning to think that I would be better off with a paid micro.blog than continuing to limp along WithKnown.
mro joined the channel
#
[snarfed] [tantek] sure! probably low priority, but feel free to file an issue
#
Loqi [snarfed]: jeremycherfas left you a message 2 hours, 39 minutes ago: How do I check the logs to see why a bridgy mention might be failing?
#
IWDiscordRelay <c​apjamesg#4492> jeremycherfas I feel the same way too.
#
IWDiscordRelay <c​apjamesg#4492> The lack of emoji support doesn’t make me happy.
#
IWDiscordRelay <c​apjamesg#4492> I have considered making a micro.blog template that fits in with the style of my website.
geoffo and starrwulfe joined the channel
#
starrwulfe I'm reading thru bridgyfed setup, and there's a blurb about changing the handle by using an h-card reference?
#
starrwulfe adding an acct: u-url link inside your h-card with username@yourdomain.com
#
starrwulfe I guess that's a question for [snarfed]
geoffo joined the channel
#
[snarfed] starrwulfe yup that's supported
mro joined the channel
#
starrwulfe Can it "take over" a handle in this manner?
angelo joined the channel
#
[snarfed] take over?
#
[snarfed] it doesn't "change" your existing BF account's username, it's effectively a whole new AP account
#
[snarfed] followers don't transfer, etc
#
starrwulfe right, that's OK. Is there a way to import a follow list?
#
starrwulfe (if not, expect tons of follow mentions LOL)
#
[snarfed] not yet, sorry, feel free to file an issue!
#
starrwulfe Will do-- I can maybe figure out a way to automate a follow-mention-erator on my side too since it's just standard microformats getting translated by BridgyFed IIRC
jonnybarnes joined the channel
#
[snarfed] [tonz] had a related experience: https://www.zylstra.org/blog/2021/12/what-gdpr-ccpa-trolling-attempt-is-this/
#
[snarfed] argh sorry wrong channel
mro, geoffo, angelo, gRegor and [fluffy] joined the channel