Blog: Pavel Stehule

213 blogs updated: 20 min. ago
New release of Orafce extension
I released new mostly release of Orafce. Today it is massive package of emulation often used Oracle's API and the emulation is on maximum wh...
07-12-2018 08:32:51 Pavel Stehule PostgreSQL
plpgsql_check can detect bad default volatility flag
Common performance problem of plpgsql function when these functions are used from some more complex queries is using default VOLATILE flag. ...
28-11-2018 21:10:38 Pavel Stehule PostgreSQL
Orafce - simple thing that can help
I merged small patch to master branch of Orafce. This shows a wide PostgreSQL possibilities and can decrease a work necessary for migration ...
28-11-2018 14:34:00 Pavel Stehule PostgreSQL
PostgreSQL 12 - psql - csv output
After some years and long discussion, a psql console has great feature - csv output (implemented by Daniel V rit ). Usage is very simple, ju...
28-11-2018 07:52:09 Pavel Stehule PostgreSQL
plpgsql_check can be used as profiler
Today I integrated profiling functionality into plpgsql_check. When you enable profiling, then you don't need configure more. postgres=# sel...
25-11-2018 18:54:34 Pavel Stehule PostgreSQL
new update pspg
I released new update of pspg . It is bugfix release + new HiColor theme.
17-11-2018 13:30:29 Pavel Stehule PostgreSQL
New functionality of plpgsql_extension
I am working on new release of plpgsql_check extension - . Interesting new function is possibility to return list of used relation and funct...
11-10-2018 16:57:34 Pavel Stehule PostgreSQL
Pager for data
Any Unix like systems has great feature - a pager. The history of pagers is pretty old. Originally was used manually. The result of some pro...
08-10-2018 10:39:38 Pavel Stehule PostgreSQL
New features for pspg
I wrote some (I useful) features for pspg possibility to show/hide row numberspossibility to hide/show row cursor Load from GitHub 1.6.0 rel...
02-09-2018 10:24:39 Pavel Stehule PostgreSQL
New release of pspg pager
I redesigned some work with mouse - ncurses native implementation is simple, but slow by design. A default layout of pspg is based on old No...
27-08-2018 10:53:11 Pavel Stehule PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.