ruhr.social ist einer von vielen unabhängigen Mastodon-Servern, mit dem du dich im Fediverse beteiligen kannst.
Eine Mastodon-Gemeinschaft rund um das Ruhrgebiet und die Menschen dort. Diese Instanz wird ehrenamtlich von Enthusiasten moderiert und technisch betreut.

Verwaltet von:

Serverstatistik:

1,5 Tsd.
aktive Profile

#database

11 Beiträge11 Beteiligte0 Beiträge heute

#Biketooter :When planning a #bike #route with #FOSS and #OSM based #routing engines, such as #Brouter / #Bikerouter ,the result analysis frequently shows some #surface percentage as "unknown". I guess that's because the #information is missing in the #OpenstreetMap #database .However, when I upload the same track as #GPX into a #commercial #biking application, such as #Komoot or #Cyclers ,the unknown has disappeared, while they are also based on OSM. How come?

Database for an internal chat with millions of chat messages and over 130,000 files with PII and PHI from the United States exposed publicly for over a month.

Contacted the company responsible for setting up the chat and one of their clients, a Mental Health Clinic, but no one replied back to me and just silently fixed the issue.

jltee.substack.com/p/internal-

The Hub of Stupi.. *misconfigs · Internal chat database for multiple US companies exposed publiclyVon JayeLTee

We've switched to my tool to measure latency and availability of our databases at work. This brand new tool, not yet open source, leverages the power of Prometheus histograms to measure those metrics finely.

I had to use DNS names instead of IP addresses to reach the endpoints, because it was easier to use (label = name).

But, the farthest the infrastructure was, the more degraded the measures were. Everything ran locally so what the hell? The level of degradation was not random, it was equal to the light distance to France.

It was DNS. It's always DNS.

The private zones were not deployed on the local resolvers, so we had a 200ms round trip in Australia, to reach resolvers in France, before actually connecting to the database.

The DNS cache didn't help at all.

#qos#latency#dns

New problem, new library! This time, I made a small utility for Laravel to limit a group of models on the table.

github.com/Laragear/Capstone

I talked about the implementation on my Medium blog, but in a nutshell, it uses a subquery to keep only the records you don't want to delete, like the latest five.

Limit the number of model records by amount or date. - Laragear/Capstone
GitHubGitHub - Laragear/Capstone: Limit the number of model records by amount or date.Limit the number of model records by amount or date. - Laragear/Capstone
#PHP#Programming#Coding