Notices by Softwarewolf (faoluin@chitter.xyz)

@volpeon When I went to Iceland with family we started getting ads in Icelandic. Which none of us understand.

@solidsanek Does the engine purr?

@lanodan @volpeon @a1ba Void black looks brown under certain light anyway! At least, mine does :3

@lanodan @volpeon @a1ba Rye loaf

@volpeon SAP: Source of All Pain

@volpeon I recently-ish ran into a fun problem with one component of SAP while doing some database development. They were using SAP to push some data down into a certain table. We had a foreign key constraint set up to use this table - because, you know, relational database. But we had to delete it because apparently what SAP does is just drop and recreate the table with the data every 24 hours - which means the table can't update if there's a foreign key constraint that's using it.

So, no relationships in your relational database, because SAP says fuck you.

@ColinTheMathmo @fribbledom Just talked about this same exact thing with my coworker, lol.

Re-reading this article from Molly White and it just hits in all the right spots.

https://www.citationneeded.news/we-can-have-a-different-web/

If my brain isn't empty after work I'll think about more commentary I can add.

uBlock Origin filter list for sites that contain AI-generated content for uBlock Origin. Useful for scrubbing AI-generated bullshit from Google, DDG, and Bing image search pages.

https://github.com/laylavish/uBlockOrigin-HUGE-AI-Blocklist/tree/main

Hey

You're cute

@lanodan @luna It's not data loss, it's surprise GDPR compliance.

@feld I considered PDNS, but stuck with BIND because I guess I'm a masochist. |3 Might keep PDNS in the back of my mind for when I get fed up with BIND though.

@feld BIND apparently does not. :/

Since I'm off this week, today's project is to figure out my proxy server. I've already set it up to some degree, but I need to finish it out. Goal is to get it set up and finished by Wednesday, though I doubt it'll take that long. :blobfoxbongo:

Oh, I guess I should get my DNS servers set up too. I forgot about that. >.>

So after getting my proxy going, I now have kind of a weird setup where my web server and turn server are hosted on the same backend, but the turn server isn't using the proxy. Like so:

NAT (443) => Proxy => Backend server => Web service
NAT (coturn port) => Backend server => Turn service

And for some reason it doesn't work. But if I revert to the previous configuration without the proxy, it works.

Coturn, more like Noturn. :blobfoxsad:

Anyway, I haven't run or eaten lunch yet so Imma go do that.

Afterwords I'll try putting the turnserver on its own backend and see what that does.

...I lied. I haven't eaten or run yet. But I know what's going on. In short, it's a DNS issue, because of course it is.

So I could still move the turnserver to its own backend, or I could try proxying the turnserver and see if that fixes it.

But I have to do other things first.

Turns out I didn't have to do either. I can bypass the reverse proxy by using a separate subdomain. Not sure if I'd prefer it to go through the proxy... maybe it should. But for now, it works and I'm happy enough with it.

Time to go run, and then I'll try tackling DNS. Whee~

Ah right... because my IP is dynamic, I will need a way to dynamically update my DNS servers with that IP at regular intervals.

Just not sure what the best approach for this is, nothing really stands out to me that is self-hostable.