News for hackers. Stuff that matters.

fforflo

Re:Llama-Scan: Convert PDFs to Text W Local LLMs on Monday August 18, 2025 @08:32AM (#44939858)
If you're interested in this sort of thing with an SQL flavor, you may find the pgpdf PostgreSQL extension useful https://github.com/Florents-Tselai/pgpdf .

It's basically an SQL wrapper around poppler.

Except for the fact that big consultancies who receive most of the government contracts, have zero contribution to the open source ecosystem.
Re:Pope Francis Has Died on Monday April 21, 2025 @08:34AM (#43751251)
Technically yes, but they're used interchangeably nowdays. Plus, the official transcript mentions "Mytilene" so I wanted to follow that. Although I use Lesvos myself.
Re:Pope Francis Has Died on Monday April 21, 2025 @06:02AM (#43750147)
In 2021, during a visit to the Greek island of Mytilene, Pope Francis delivered one of the finest speeches I've ever read:

> 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...

With $GEMINI_MODE=gemini-2.0-flash I also got some decent results for libraries like simonw/llm and pgcli.

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...

It's decent enough. But you'd probably have to use a model like llama2, which may set your GPU on fire.
If you want to use Ollama to run local models, here’s a simple example:

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...

( Read More... | no comments | 2 points | on HN )
It's also exciting that their code to actually reproduce these is also available. https://github.com/wccarleton/mesoneomalta

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...

( Read More... | no comments | on HN )

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...

( Read More... | no comments | 2 points | on HN )
Re:Ask HN: What are you working on? (March 2025) on Monday March 31, 2025 @05:12AM (#43532844)
I'm working on spat https://github.com/Florents-Tselai/spat a Postgres extension.

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.

I tend to agree. The OOP-all-the-things mantra created many problems; lots of books were printed (more than necessary), and lots of evangelists made their name on unnecessary abstractions over abstractions. One might blame Java for that, but it's a chicken-and-egg problem.
Re:Stoop Coffee: A simple idea transformed my neighborhood on Wednesday March 26, 2025 @05:14AM (#43480249)
The "New World" is re-discovering what the Balkans / Southern Europe have been doing for decades.
Makefile with make2graph to visualize DAGs.
Whenever I read something about Boston Dynamics now, I can't help but remember that scene from Silicon Valley (HBO) where Eric kicks BigDog https://www.youtube.com/watch?v=BFnMBW95RZI
PostgreSQL 18 won't have many JSON enhancements - how much better can it get after all? And virtual generated columns will probably be the highlight of the release. But there's always some room for improvement. One long-standing pain point has been simply removing nulls from JSON arrays.

Older »