fforflo
AI Breaks the Monopoly of Elegant Software
Native Full-Text Search in PostgreSQL JSONPath: Proposing Tsmatch
Deloitte to refund the Australian government after using AI in $440k report
Volcanic crisis reveals coupled magma system at Santorini and Kolumbo
Support for base64url encoding and decoding in PostgreSQL 19
My Favorite PostgreSQL 18 Feature: Virtual Generated Columns
Pgconf.eu 2025 Schedule
It's basically an SQL wrapper around poppler.
System View for Inspecting DSM Registry Allocations in PostgreSQL
LLMs: The Missing Compiler for Unix Tools
> This great basin of water, the cradle of so many civilizations, now looks like a mirror of death. Let us not let our sea (mare nostrum) be transformed into a desolate sea of death (mare mortuum). Let us not allow this place of encounter to become a theatre of conflict. Let us not permit this “sea of memories” to be transformed into a “sea of forgetfulness”. Please brothers and sisters, let us stop this shipwreck of civilization!
> We are in the age of walls and barbed wire. To be sure, we can appreciate people’s fears and insecurities, the difficulties and dangers involved, and the general sense of fatigue and frustration, exacerbated by the economic and pandemic crises. Yet problems are not resolved and coexistence improved by building walls higher, but by joining forces to care for others according to the concrete possibilities of each and in respect for the law, always giving primacy to the inalienable value of the life of every human being
Worth reading in full https://www.vatican.va/content/francesco/en/speeches/2021/de...
You can tell that because simonw writes quite heavily-documented code an the logic is pretty straightforward, it helps the model a lot!
https://github.com/Florents-Tselai/Tutorial-Codebase-Knowled...
https://github.com/Florents-Tselai/Tutorial-Codebase-Knowled...
from ollama import chat, ChatResponse
def call_llm(prompt, use_cache: bool = True, model="phi4") -> str: response: ChatResponse = chat( model=model, messages=[{ 'role': 'user', 'content': prompt, }] ) return response.message.content
Show HN: Install Postgres with Pip in Virtualenv
https://github.com/Florents-Tselai/pgvenv
Hi HN,I frequently work with Postgres & Python and toggle between multiple versions of each. In Postgres, I keep a separate installation for each project, but I don't like git submodules and don't want to ship "pg_build.sh" scripts with the source code.So, I built pgvenv as a Python shell package that, when installed, triggers a from-source installation of Postgres and installs it at venv's...
Ask HN: AI Infra Support for a non-profit making government data transparent?
Hi HN,I run diofanti.org, a free, open-data platform that monitors government spending and operations in Greece. We transform raw public data into a tableau-like dashboard, providing citizens, journalists, and policymakers with transparency and actionable insights.For the past five years, a Hetzner-hosted Postgres instance and Metabase have served us well. However, I’ve recently been working on...
Ask HN: What Are Your Experiences with RAG and LLMs in Non-English Languages?
I’ve been working on some projects with Greek-language data and have encountered some interesting challenges with RAG and LLMs. In an English-speaking universe, it's relatively straightforward to have a decent prototype in a short time. But in other languages, it has proven a bit trickier.I’m curious to hear from others working with non-English languages—what challenges have you faced? Some...
spat is a Redis-like in-memory data structure server embedded in Postgres. Data is stored in Postgres shared memory. The data model is key-value. Keys are strings, but values can be strings, lists, sets, or hashes.
It's still alpha, but it works.