Blog: Pavel Stehule

211 blogs updated: 76 min. ago
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
Safe programming in PL/pgSQL
PL/pgSQL is verbose practical language based on Oracle's PL/SQL, that is based on years ago very popular programming language ADA. ADA langu...
25-07-2018 07:59:39 Pavel Stehule PostgreSQL
New release of pspg - 1.2.0
This release can be fully configured from menu (themes can be selected from menu too). The setting can be persistent to file /.pspgconf:
18-07-2018 22:47:16 Pavel Stehule PostgreSQL
pspg has menu
The pager pspg has more than 30 keyboard short cuts, what can be hard to use for beginners without Linux command line knowleadge. For this r...
09-07-2018 17:12:06 Pavel Stehule PostgreSQL
Article about PostgreSQL 11
My new article is in Czech language, but Google translator can help.
13-06-2018 11:42:07 Pavel Stehule PostgreSQL
plpgsql_check can identify variables with wrong type used in predicates and breaks index usage
Simple example: create table bigtable(id bigint, ...) ... declare _id numeric; begin _id := ... FOR r IN SELECT * FROM bigtable WHERE id = _...
05-06-2018 22:55:23 Pavel Stehule PostgreSQL
New projects st-menu, st-term
I started two new projects: st-menu and st-term. These projects should to fill gap of Unix libraries. I was surprised, so there are not a co...
31-05-2018 13:47:00 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.