devblogy.k47.czkategoriersstwitter @devblogy přidat blog

Pavel Stehule's blog


How to get info about relations between system tables? ∕ 2024-09-07 ∕ Pavel Stehule's blog
More complex log in json format processing ∕ 2024-06-07 ∕ Pavel Stehule's blog
compiled win x64 dll of orafce-4.9.3 and plpgsql_check-2.7.4 for PostgreSQL 15 and 16 ∕ 2024-03-20 ∕ Pavel Stehule's blog
How fast is plpgsql? ∕ 2024-03-05 ∕ Pavel Stehule's blog
using jq for processing PostgreSQL logs in json format ∕ 2024-03-04 ∕ Pavel Stehule's blog
new extension pgmeminfo ∕ 2024-02-08 ∕ Pavel Stehule's blog
2023 resume ∕ 2024-01-03 ∕ Pavel Stehule's blog
Close cursors ∕ 2023-12-06 ∕ Pavel Stehule's blog
compiled dll of plpgsql_check 2.5.4 and Orafce 4.7.0 for PostgreSQL 15 and 16 ∕ 2023-10-13 ∕ Pavel Stehule's blog
prepared dll of orafce 4.0.1 and plpgsql_check 2.2.5 for PostgreSQL 14 and PostgreSQL 15 ∕ 2022-12-02 ∕ Pavel Stehule's blog
pspg 5.6.0 ∕ 2022-11-28 ∕ Pavel Stehule's blog
pspg and nushell ∕ 2022-11-21 ∕ Pavel Stehule's blog
orafce 4.0.0 ∕ 2022-11-02 ∕ Pavel Stehule's blog
pspg 5.5.8 ∕ 2022-10-08 ∕ Pavel Stehule's blog
Orafce 3.21.0 ∕ 2022-04-16 ∕ Pavel Stehule's blog
New releases Orafce and plpgsql_check ∕ 2022-04-06 ∕ Pavel Stehule's blog
2021 Resume ∕ 2021-12-20 ∕ Pavel Stehule's blog
pspg 5.5.0 ∕ 2021-11-02 ∕ Pavel Stehule's blog
Orafce 3.17.0 ∕ 2021-10-31 ∕ Pavel Stehule's blog
pspg 5.4.1 released ∕ 2021-10-13 ∕ Pavel Stehule's blog
Orafce 3.16.2 for Postgres 12, 13 and 14 for Microsoft Windows ∕ 2021-10-12 ∕ Pavel Stehule's blog
plpgsql_check 2.0.4 for Microsoft Windows and Postgres 12, 13 and 14. ∕ 2021-10-11 ∕ Pavel Stehule's blog
pspg 5.4.0 ∕ 2021-10-10 ∕ Pavel Stehule's blog
plpgsql_check 2.0.1 ∕ 2021-09-29 ∕ Pavel Stehule's blog
bugfix release of pspg - 5.3.5 ∕ 2021-09-13 ∕ Pavel Stehule's blog
orafce_mail ∕ 2021-08-21 ∕ Pavel Stehule's blog
pspg 5.2.0 released ∕ 2021-07-26 ∕ Pavel Stehule's blog
pspg 5.1.0 was released, psql \watch command now supports pspg ∕ 2021-07-16 ∕ Pavel Stehule's blog
calculating derivation from pg_stat_database and watch statement ∕ 2021-06-27 ∕ Pavel Stehule's blog
pspg 5.0.0 is released ∕ 2021-05-30 ∕ Pavel Stehule's blog
Article about prepared PostgreSQL 14 ∕ 2021-05-25 ∕ Pavel Stehule's blog
pspg 4.6.1 bugfix release ∕ 2021-04-22 ∕ Pavel Stehule's blog
pspg 4.6.0 released ∕ 2021-04-18 ∕ Pavel Stehule's blog
new release 3.15.0 of Orafce extension ∕ 2021-03-13 ∕ Pavel Stehule's blog
Video about pspg pager usage ∕ 2021-03-05 ∕ Pavel Stehule's blog
pspg 4.3.0 released ∕ 2021-02-26 ∕ Pavel Stehule's blog
dll of Orafce and plpgsql_check extensions for PostgreSQL 13 are available ∕ 2021-01-24 ∕ Pavel Stehule's blog
pspg 4.0.0 released ∕ 2021-01-16 ∕ Pavel Stehule's blog
redirect query result from psql to LibreOffice Calc by using clipboard ∕ 2020-12-23 ∕ Pavel Stehule's blog
Orafce 3.14.0 released ∕ 2020-12-22 ∕ Pavel Stehule's blog
redirect result from psql to libreoffice calc ∕ 2020-11-08 ∕ Pavel Stehule's blog
compiled dll of Orafce are available ∕ 2020-09-23 ∕ Pavel Stehule's blog
new release of pspg - pager for PostgreSQL, MySQL, MonetDB, PrestoSQL, ... ∕ 2020-09-18 ∕ Pavel Stehule's blog
Fedora 33 looks well ∕ 2020-09-13 ∕ Pavel Stehule's blog
Turbo Vision for terminals ∕ 2020-08-20 ∕ Pavel Stehule's blog
New release of plpgsql_check - now with possibility to enable, disable checks, warnings, tracing inside functions ∕ 2020-08-14 ∕ Pavel Stehule's blog
Gnome-terminal with sixel support ∕ 2020-08-11 ∕ Pavel Stehule's blog
plpgsql_check now supports tracing ∕ 2020-08-05 ∕ Pavel Stehule's blog
pspg for monetdb client ∕ 2020-07-21 ∕ Pavel Stehule's blog
small notice - new release of plpgsql_check ∕ 2020-07-02 ∕ Pavel Stehule's blog
mandown - markdown terminal viewer ∕ 2020-06-16 ∕ Pavel Stehule's blog
pspg - two new features ∕ 2020-05-18 ∕ Pavel Stehule's blog
dbms_sql ∕ 2020-05-13 ∕ Pavel Stehule's blog
pgcli integrated support for pspg ∕ 2020-04-24 ∕ Pavel Stehule's blog
split string to table ∕ 2020-04-17 ∕ Pavel Stehule's blog
new pspg - version 3.0.0 with named pipe support ∕ 2020-04-06 ∕ Pavel Stehule's blog
simple monitoring of PostgreSQL incremental statistics ∕ 2020-04-02 ∕ Pavel Stehule's blog
Postgres 13, new family of polymorphic types - anycompatible ∕ 2020-03-31 ∕ Pavel Stehule's blog
pspg 2.7.0 with inotify support ∕ 2020-03-27 ∕ Pavel Stehule's blog
small update of ncurses-st-menu ∕ 2020-03-24 ∕ Pavel Stehule's blog
private, public plpgsql functions ∕ 2020-03-01 ∕ Pavel Stehule's blog
plpgsql_check 1.9 calculates coverage metrics ∕ 2020-02-14 ∕ Pavel Stehule's blog
psql and gnuplot ∕ 2020-02-09 ∕ Pavel Stehule's blog
Moscow PgConf.Russia 2020 ∕ 2020-02-07 ∕ Pavel Stehule's blog
pspg themes - what you use it? ∕ 2019-12-30 ∕ Pavel Stehule's blog
Compilation Orafce on CentOS 7 against pgdg repo ∕ 2019-11-21 ∕ Pavel Stehule's blog
using pspg for SQLite ∕ 2019-11-20 ∕ Pavel Stehule's blog
watch mode for pspg ∕ 2019-10-27 ∕ Pavel Stehule's blog
dll for plpgsql_check 1.7.6 are available for PostgreSQL 10, 11, and 12 ∕ 2019-10-20 ∕ Pavel Stehule's blog
precompiled libraries for orafce 3.8 for PostgreSQL 10, 11 and 12 ∕ 2019-10-20 ∕ Pavel Stehule's blog
pspg can be used like csv viewer ∕ 2019-09-25 ∕ Pavel Stehule's blog
pspg 2.0.2 is out ∕ 2019-09-12 ∕ Pavel Stehule's blog
pspg 2.0.1 released ∕ 2019-09-09 ∕ Pavel Stehule's blog
pspg supports sort by selected column ∕ 2019-09-03 ∕ Pavel Stehule's blog
new release 1.7.0 of pspg ∕ 2019-08-31 ∕ Pavel Stehule's blog
Why you need plpgsql_check (if you write procedures in PLpgSQL) ∕ 2019-08-30 ∕ Pavel Stehule's blog
Vertical (column) cursor in pspg ∕ 2019-08-24 ∕ Pavel Stehule's blog
show csv files by pspg pager ∕ 2019-08-20 ∕ Pavel Stehule's blog
new releases of plpgsql_check and pspg ∕ 2019-07-24 ∕ Pavel Stehule's blog
new bugfix release of plpgsql_check ∕ 2019-05-21 ∕ Pavel Stehule's blog
how to don't emulate schema (global) variables ∕ 2019-05-19 ∕ Pavel Stehule's blog
pspg on Solaris ∕ 2019-05-02 ∕ Pavel Stehule's blog
new release of plpgsql_check - possibility to check SQL injection issue ∕ 2019-04-18 ∕ Pavel Stehule's blog
How to split string to array by individual characters? ∕ 2019-03-22 ∕ Pavel Stehule's blog
compiled dll of plpgsql 1.6 for PostgreSQL 10, 11 ∕ 2019-03-02 ∕ Pavel Stehule's blog
pspg is available in Fedora 29, Fedora 30 repository ∕ 2019-03-02 ∕ Pavel Stehule's blog
don't use SQL keywords as PLpgSQL variable names ∕ 2019-03-01 ∕ Pavel Stehule's blog
plpgsql_check - new report for code coverage ratio calculation ∕ 2019-01-30 ∕ Pavel Stehule's blog
New release of Orafce extension ∕ 2018-12-07 ∕ Pavel Stehule's blog
plpgsql_check can detect bad default volatility flag ∕ 2018-11-28 ∕ Pavel Stehule's blog
Orafce - simple thing that can help ∕ 2018-11-28 ∕ Pavel Stehule's blog
PostgreSQL 12 - psql - csv output ∕ 2018-11-28 ∕ Pavel Stehule's blog
plpgsql_check can be used as profiler ∕ 2018-11-25 ∕ Pavel Stehule's blog
new update pspg ∕ 2018-11-17 ∕ Pavel Stehule's blog
New functionality of plpgsql_extension ∕ 2018-10-11 ∕ Pavel Stehule's blog
Pager for data ∕ 2018-10-08 ∕ Pavel Stehule's blog
New features for pspg ∕ 2018-09-02 ∕ Pavel Stehule's blog
New release of pspg pager ∕ 2018-08-27 ∕ Pavel Stehule's blog
Safe programming in PL/pgSQL ∕ 2018-07-25 ∕ Pavel Stehule's blog
New release of pspg - 1.2.0 ∕ 2018-07-18 ∕ Pavel Stehule's blog
pspg has menu ∕ 2018-07-09 ∕ Pavel Stehule's blog
Article about PostgreSQL 11 ∕ 2018-06-13 ∕ Pavel Stehule's blog
plpgsql_check can identify variables with wrong type used in predicates and breaks index usage ∕ 2018-06-05 ∕ Pavel Stehule's blog
How to don't use PL/pgSQL and other fatal errors when PL/pgSQL is used ∕ 2018-05-23 ∕ Pavel Stehule's blog
dude's test speed ∕ 2018-05-17 ∕ Pavel Stehule's blog
ncurses-st-menu library is available ∕ 2018-05-10 ∕ Pavel Stehule's blog
ncurses CUA menu demo ∕ 2018-05-03 ∕ Pavel Stehule's blog
new presentation - plpgsql often issues ∕ 2018-05-01 ∕ Pavel Stehule's blog
pspg 1.1 with readline support ∕ 2018-04-26 ∕ Pavel Stehule's blog
short notice - pspg has integrated readline library now ∕ 2018-04-19 ∕ Pavel Stehule's blog
New projects st-menu, st-term ∕ 2018-04-09 ∕ Pavel Stehule's blog
How to write interactive pager ∕ 2018-03-25 ∕ Pavel Stehule's blog
some update about schema variables ∕ 2018-03-20 ∕ Pavel Stehule's blog
Release 1.0.0 of tabular data optimized pager - pspg ∕ 2018-03-16 ∕ Pavel Stehule's blog
pspg pager is available from Debian testing packages ∕ 2018-03-02 ∕ Pavel Stehule's blog
plpgsql_check will be available for PostgreSQL 11 ∕ 2018-02-18 ∕ Pavel Stehule's blog
new release of pspg ∕ 2018-02-12 ∕ Pavel Stehule's blog
schema variables ∕ 2018-02-07 ∕ Pavel Stehule's blog
nice unicode border like psql for mysql and pgcli? ∕ 2018-01-08 ∕ Pavel Stehule's blog
pspg 0.9 - bookmarks, search highlighting ∕ 2017-12-28 ∕ Pavel Stehule's blog
pgFouine revitalized ∕ 2017-12-15 ∕ Pavel Stehule's blog
pspg 0.8 released ∕ 2017-12-15 ∕ Pavel Stehule's blog
New release of pspg pager ∕ 2017-12-01 ∕ Pavel Stehule's blog
bugfix of precompiled dll of Orafce 3.6.2 ∕ 2017-12-01 ∕ Pavel Stehule's blog
short post again ∕ 2017-11-19 ∕ Pavel Stehule's blog
pspg suppports mysql too ∕ 2017-11-17 ∕ Pavel Stehule's blog
short post: new release of pspg is available ∕ 2017-11-14 ∕ Pavel Stehule's blog
bugfix of precompiled dll of Orafce 3.6.1 ∕ 2017-10-29 ∕ Pavel Stehule's blog
Orafce 3.6.0 for PostgreSQL 9.4-10.0 compiled for windows ∕ 2017-10-28 ∕ Pavel Stehule's blog
plpgsql_check 1.2.2 for windows (for PostgreSQL 9.4-10) ∕ 2017-10-27 ∕ Pavel Stehule's blog
PostgreSQL 10 - article ∕ 2017-10-07 ∕ Pavel Stehule's blog
pspg news ∕ 2017-09-30 ∕ Pavel Stehule's blog
New release of plpgsql_check ∕ 2017-09-15 ∕ Pavel Stehule's blog
short post - pspg is ready for release ∕ 2017-09-12 ∕ Pavel Stehule's blog
Article about migration from Oracle to PostgreSQL with Ora2pg ∕ 2017-09-07 ∕ Pavel Stehule's blog
New Ora2pg is available ∕ 2017-09-02 ∕ Pavel Stehule's blog
short update: please, test pspg ∕ 2017-08-15 ∕ Pavel Stehule's blog
PostgreSQL pager pspg is ready to work ∕ 2017-08-05 ∕ Pavel Stehule's blog
Postgres Pager (pager designed for psql) ∕ 2017-07-16 ∕ Pavel Stehule's blog
new packages in community repository ∕ 2017-07-05 ∕ Pavel Stehule's blog
replace_empty_string ∕ 2017-06-27 ∕ Pavel Stehule's blog
New version of PLpgSQL_check ∕ 2017-05-31 ∕ Pavel Stehule's blog
Orafce and plpgsql_check are ready for PostgreSQL 10 ∕ 2017-04-10 ∕ Pavel Stehule's blog
How to find unindexed foreign keys ∕ 2017-04-09 ∕ Pavel Stehule's blog
new command line tool pgimportdoc ∕ 2017-02-20 ∕ Pavel Stehule's blog
OpenERP configuration ∕ 2016-12-23 ∕ Pavel Stehule's blog
Orafce package for PostgreSQL 9.3, 9.4, 9.5, 9.6 for WIN32, WIN64 is available ∕ 2016-08-27 ∕ Pavel Stehule's blog
plpgsql_check for PostgreSQL 9.4, 9.5, 9.6 compiled for WIN32, WIN64 is available ∕ 2016-08-26 ∕ Pavel Stehule's blog
XMLTABLE implementation is done ∕ 2016-08-21 ∕ Pavel Stehule's blog
Good presentation about differences between PostgreSQL and Oracle from Oracle expert perspective ∕ 2016-08-21 ∕ Pavel Stehule's blog
Prototype of XMLTABLE function is done ∕ 2016-08-07 ∕ Pavel Stehule's blog
Orafce 3.3.0 was released ∕ 2016-05-25 ∕ Pavel Stehule's blog
plpgsql_check 1.0.5 released ∕ 2016-05-24 ∕ Pavel Stehule's blog
new release Orafce and plpgsql_check ∕ 2016-01-09 ∕ Pavel Stehule's blog
Fedora 23 on Toshiba PORTÉGÉ - few unresolved issues ∕ 2015-10-19 ∕ Pavel Stehule's blog
Run PLpgSQL function before login ∕ 2015-09-28 ∕ Pavel Stehule's blog
simple parallel run statement in every database in PostgreSQL cluster ∕ 2015-08-24 ∕ Pavel Stehule's blog
aliasing psql ∕ 2015-07-16 ∕ Pavel Stehule's blog
New Orafce and Plpgsql_check extensions released ∕ 2015-07-12 ∕ Pavel Stehule's blog
How to write fast database applications? ∕ 2015-05-31 ∕ Pavel Stehule's blog
How to write robust database application? ∕ 2015-05-31 ∕ Pavel Stehule's blog
New features in PostgreSQL 9.5 ∕ 2015-05-30 ∕ Pavel Stehule's blog
faster plpgsql in PostgreSQL 9.5 (second part) ∕ 2015-05-19 ∕ Pavel Stehule's blog
faster plpgsql in PostgreSQL 9.5 (first part) ∕ 2015-05-11 ∕ Pavel Stehule's blog
long term monitoring communication between PostgreSQL client and PostgreSQL server ∕ 2015-03-17 ∕ Pavel Stehule's blog
plpgsql_check is available for Microsoft Windows ∕ 2015-02-08 ∕ Pavel Stehule's blog
Simple multicolumn ouput in psql ∕ 2015-02-04 ∕ Pavel Stehule's blog
template_fdw ∕ 2015-02-02 ∕ Pavel Stehule's blog
how to push parameters to DO statement from command line ∕ 2015-01-18 ∕ Pavel Stehule's blog
most simply implementation of history table with hstore extension ∕ 2015-01-15 ∕ Pavel Stehule's blog
plpgsql_check is available via PGXN repository ∕ 2014-12-20 ∕ Pavel Stehule's blog
plpgsql_check is ready for OS X ∕ 2014-12-14 ∕ Pavel Stehule's blog
styles for unicode borders are merged (PostgreSQL 9.5) ∕ 2014-10-19 ∕ Pavel Stehule's blog
nice unix filter pv ∕ 2014-09-17 ∕ Pavel Stehule's blog
plpgsql_check rpm packages are available for PostgreSQL9.3 for RHEL7, 6 ∕ 2014-09-17 ∕ Pavel Stehule's blog
lot of fixes in plpgsql_check ∕ 2014-08-29 ∕ Pavel Stehule's blog
plpgsql_check 0.9 ∕ 2014-08-18 ∕ Pavel Stehule's blog
plpgsql_check is available for PostgreSQL 9.2 ∕ 2014-06-28 ∕ Pavel Stehule's blog
New PostgreSQL 9.4 article ∕ 2014-06-06 ∕ Pavel Stehule's blog

@kaja47, 0xDEADBEEF funkcionálně.cz, k47.cz