ohai.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A cozy, fast and secure Mastodon server where everyone is welcome. Run by the folks at ohai.is.

Administered by:

Server stats:

1.8K
active users

#database

35 posts29 participants2 posts today

#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 publiclyBy JayeLTee

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

What is RAG and Why Should You Care? 🤔

Curious about transforming your database into a knowledge engine that understands plain language queries?
PostgreSQL + Retrieval-Augmented Generation connects your data directly to LLMs, enabling natural language search without complex syntax.

Free "What is RAG" chapter: link.illustris.org/whatisrag
#PostgreSQL #RAG #LLMs #Database #AISearch

link.illustris.orgHow to access Postgres meta-commands | LinkedIn Learning, formerly Lynda.comAfter watching this video, you can list Postgres meta-commands and their details. When a person knows how to list and obtain details of each meta-command, they are able to explore Postgres databases easily.