Top all-time · #10380
Florents Tselai
Personal blog · tselai.com · on HN as fforfloprogrammingdataai
Florents Tselai's personal blog at tselai.com covers programming, data and ai. Since 2017, 7 different Hacker News readers have linked it 29 times, most often “(All) Databases Are Just Files. Postgres Too”. It is still writing: the last post was on 2026-07-14, and you can follow it by feed.
Most-linked posts?
- (All) Databases Are Just Files. Postgres Too3 people · 3 mentions · first linked 2025-04-16
- LLMs: The Missing Compiler for Unix Tools2 people · 2 mentions · first linked 2025-06-02
- Introducing Pandas-Sets: Set-Oriented Operations in Pandas2 people · 2 mentions · first linked 2018-12-26
What Hacker News says?
Nice work. A few months back, I experimented with having a DSL like PRQL in Postgres, but back then, I found the language a bit cumbersome; however, it was great as an idea. IMHO, the best "data transformation" language is jq and awk is second. PRQL and EdgeQL (EdgeDB) are the most interesting ones to watch how they evolve, though. I've also written a PG extension to make jq available in Postgres [0] I believe Postg…
Comment linking /pgjq-dsl-database.html
on “Show HN: PRQL in PostgreSQL”Submitted Modern Data Practice and the SQL Tradition as a story · 286 points
HN discussionYes, that's extremely important. I've had great success, but replacing Airflow, Luigi, and friends with a cron-ed Makefile target refreshing some database tables (usually Materialized views). I've then used this tool to visualize the execution graph. https://github.com/lindenb/makefile2graph The result looks like this: https://tselai.com/data/graph.png The convenient thing is that each node in the execution graph is…
Comment linking /data/graph.png
on “Data Science at the Command Line, 2nd Edition (2021)”Submitted My Favorite PostgreSQL 18 Feature: Virtual Generated Columns as a story · 54 points
HN discussionFor those interested I read many of these in 2016 and I've put some comments on my retrospective post https://tselai.com/the-books-i-read-and-the-world-i-lived-in...
Comment linking /the-books-i-read-and-the-world-i-lived-in-2016.html
on “Military Reading List”Submitted Llamafile for Meltemi: The First LLM for Greek as a story · 48 points
HN discussionInteresting: I posted this a few days back, and certainly not "10 hours ago". Who was kind enough to re-surface this? Thanks :) Some clarifications on a few comments I see downstream: The motivating example was to easily support Full-Text Search (FTS) on PDFs with SQL only (see blog post https://tselai.com/full-text-search-pdf-postgres ). You can treat `pdf` as an alias for `text` and do everything possible. On the…
Comment linking /full-text-search-pdf-postgres
on “PgPDF: Pdf Type and Functions for Postgres”Submitted Machine Learning – Based Personality Analysis of a Failed Finance Minister as a story · 8 points
HN discussionThe first iteration of this was actually FTS only https://tselai.com/full-text-search-pdf-postgres In the second pass I made `pdf` a type.
Comment linking /full-text-search-pdf-postgres
on “PgPDF: Pdf Type and Functions for Postgres”Submitted System View for Inspecting DSM Registry Allocations in PostgreSQL as a story · 6 points
HN discussionSubmitted (All) Databases Are Just Files. Postgres Too as a story · 6 points
HN discussionSubmitted All Databases Are Just Files as a story · 6 points
HN discussionSubmitted (All) Databases Are Just Files. Postgres Too as a story · 5 points
HN discussionSubmitted Introducing Pandas-Sets: Set-Oriented Operations in Pandas as a story · 5 points
HN discussionSubmitted Support for base64url encoding and decoding in PostgreSQL 19 as a story · 3 points
HN discussionSubmitted LLMs: The Missing Compiler for Unix Tools as a story · 3 points
HN discussionSubmitted LLM Frameworks are Like ORMs in the 80s as a story · 3 points
HN discussionSubmitted Setup.py and Makefile: A just good enough build tool as a story · 3 points
HN discussionSubmitted Introducing Pandas-Sets: Set-Oriented Operations in Pandas as a story · 3 points
HN discussionSubmitted Analyzing 1000+ Greek Wines with Python as a story · 3 points
HN discussionSubmitted AI Breaks the Monopoly of Elegant Software as a story · 2 points
HN discussionSubmitted liteJq: Bringing Jq to SQLite for More Powerful Analytics as a story · 2 points
HN discussionSubmitted Native Full-Text Search in PostgreSQL JSONPath: Proposing Tsmatch as a story · 1 points
HN discussionSubmitted LLMs: The Missing Compiler for Unix Tools as a story · 1 points
HN discussionSubmitted Removing nulls from JSON arrays – coming in PostgreSQL 18 as a story · 1 points
HN discussionSubmitted Full Text Search on PDFs with Postgres as a story · 1 points
HN discussionSubmitted We Need More DSLs in the Database as a story · 1 points
HN discussionSubmitted Collecting, Exploring and Predicting Popular Items on Pocket as a story · 1 points
HN discussionSubmitted The Books I Read and the World I Lived in 2016 as a story · 1 points
HN discussion
