mastodon.top est l'un des nombreux serveurs Mastodon indépendants que vous pouvez utiliser pour participer au fédiverse.
Mastodon.top est une instance francophone stable, régulièrement mise à jour et accessible à tous hébergée par VirtuBox

Statistiques du serveur :

1,4K
comptes actifs

#database

17 messages13 participants1 message aujourd’hui

#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?

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

Mississippi libraries ordered to delete academic research in response to state laws
Lawmaker says the removal of scholarly material from library databases would provoke backlash in a state where minorities have fought for equal access to education.
mississippitoday.org/2025/04/0
#Libraries #Research #Mississippi #Academia #AcademicResearch #ResearchCollections #Database #ScholarlyMaterials #Race #Gender

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

Check out Kothari Nishchay's session "PostgreSQL pgroll – Zero-Downtime, Reversible Schema Migrations" at #PostgreSQLDayBangkok to explore pgroll, a powerful tool for seamless database migrations.

🔗 Click here youtu.be/uB7egck68Js?si=WD2PXV to watch on the FOSSASIA YouTube channel

youtu.be- YouTubeProfitez des vidéos et de la musique que vous aimez, mettez en ligne des contenus originaux, et partagez-les avec vos amis, vos proches et le monde entier.