Open Source

My open-source software projects are available on github.com/Florens-Tselai.

PostgreSQL Contributions

• Add tsmatch JSONPath operator for granular Full Text Search WIP discussion
• Add SQL/JSON ON MISMATCH clause to JSON_{VALUE,QUERY,TABLE} WIP discussion
• Add psql PROMPT variable for search_path. commit discussion
• encode/decode support for base64url. commit discussion
• pg_dsm_registry_allocations system view. commit discussion
• Allow json{b}_strip_nulls to remove null array elements commit discussion
• Chained text processing methods in jsonpath. WIP discussion

PostgreSQL Extensions & Tools

• spat: Redis-like In-Memory DB Embedded in Postgres
• pgvenv: Install PostgreSQL with pip
• pgxicor: XI (ξ) Correlation Coefficient in Postgres
• pgllm: pgllm: Use LLMs in Postgres
• pgPDF: pgPDF: Query PDFs from Postgres
• jsonb_apply: Postgres JSON with a functional twist
• pgJQ: A Postgres extension that brings jq to Postgres and SQL
• vasco: MINE-statistics extension for Postgres. Correlation discovery made easy.
• cookiecutter-postgres-extension: A cookiecutter template for a Postgres extension

SQLite Extensions

• tsellm: tsellm: Use LLMs in SQLite and DuckDB
• liteJQ: jq extension for SQLite.
• WarcDB: A tool that serves crawl data as SQLite databases.

diofanti.org

If you’re a Greek journalist, politician, or concerned citizen, you may have come across diofanti.org, a free and public tool I’ve created that tracks government spending in Greece. Here’s a demo video showcasing it.