Pavel Stěhule

PostgreSQL Evangelist at PostgreSQL Global Development Group

Benešov, Central Bohemia, Czechia
email-iconphone-icongithub-logolinkedin-logotwitter-logostackoverflow-logofacebook-logo
Join Prog.AI to see contacts
email-iconphone-icongithub-logolinkedin-logotwitter-logostackoverflow-logofacebook-logo
Join Prog.AI to see contacts

Summary

🤩
Rockstar
🎓
Top School
Pavel Stěhule is a PostgreSQL evangelist and systems engineer with 15+ years of hands-on experience authoring extensions, improving core PL/pgSQL, and teaching database development and SQL. As founder of the Czech and Slovak PostgreSQL User Group and a long-time contributor to the PostgreSQL Global Development Group, he blends community leadership with deep implementation expertise. His open-source work includes creating practical tools like pspg — a powerful Unix pager for tabular query results — and contributing Oracle-compatible functions via orafce, demonstrating a focus on interoperability and developer ergonomics. Pavel pairs low-level C and PL/pgSQL hacking with real-world tuning and architecture experience from companies ranging from GoodData to CZ.NIC, making him equally fluent in internals and production requirements. Based in Benešov, Czechia, he also brings formal training in systems engineering and operational research to complex database problem solving.
code15 years of coding experience
job16 years of employment as a software developer
bookMaster of Science (M.S.), systems engineering, operational research, Master of Science (M.S.), systems engineering, operational research at České vysoké učení technické v Praze
languagesEnglish
stackoverflow-logo

Stackoverflow

Stats
43,998reputation
4.3mreached
951answers
2questions
Badges
mysql
top-5%
sql
top-1%
postgresql
top-1%
psql
top-5%
ddl
top-5%
database
top-1%
github-logo-circle

Github Skills (30)

plpgsql10
ncurses10
oracles10
postgresql10
c1110
terminal-application10
c1710
oracle10
dump10
database-design10
sql10
database10
mysql9
unix9
ddl9

Programming languages (10)

JavaShellC++CRustPLpgSQLGoPerl

Github contributions (5)

github-logo-circle
okbob/pspg

Jul 2017 - Jan 2023

Unix pager (with very rich functionality) designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Works well with pgcli too. Can be used as CSV or TSV viewer too. It supports searching, selecting rows, columns, or block and export selected area to clipboard.
Role in this project:
userBack-end Developer
Contributions:135 releases, 1143 commits, 64 PRs in 5 years 7 months
Contributions summary:Pavel implemented and refined features related to the graphical pager, `pspg`, focusing on enhancing its tabular data viewing capabilities. They addressed issues such as incorrect drawing of borders and cursor positioning. The user also contributed to the project by adding and modifying code related to the handling of various features and options.
unixcsvpgclituincurses
orafce/orafce

Aug 2013 - Jan 2023

The "orafce" project implements in Postgres some of the functions from the Oracle database that are missing (or behaving differently).Those functions were verified on Oracle 10g, and the module is useful for production work.
Role in this project:
userBack-end Developer / Database Engineer
Contributions:79 releases, 1 review, 381 commits in 9 years 7 months
Contributions summary:Pavel primarily contributed to the `orafce/orafce` repository, which implements Oracle database functions in PostgreSQL. Their work involved removing unused variables, adding and modifying SQL scripts, and modifying and adding core functions. The user's commits focused on modifying functions, and adding domain and operators. They were also focused on the migration of the codebase.
oracle-to-postgresverifiedoracle-databasepostgresql-extensionsql
Find and Hire Top DevelopersWe’ve analyzed the programming source code of over 60 million software developers on GitHub and scored them by 50,000 skills. Sign-up on Prog,AI to search for software developers.
Request Free Trial
Pavel Stěhule - PostgreSQL Evangelist at PostgreSQL Global Development Group