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

Postgres Contributions

  • Allow json{b}_strip_nulls to remove null array elements commit, discussion
  • Add documentation about calling version-1 C functions from C. commit, discussion
  • encode/decode support for base64url. WIP discussion
  • pg_dsm_registry system view. WIP discussion
  • Chained text processing methods in jsonpath. WIP discussion

Postgres Extensions & Tools

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