Monday, December 20, 2021

2021 Resume

This year was not too good. Fortunately, I lost nobody from my family, but (unfortunately) my friends yes. I had not too much trainings, so there was more time to write code. 

pspg

  • clipboard support with CSV, text and INSERT formats
  • better handling mouse in xterm mode 1002
  • vertical scrollbar
  • possibility to select range for export
  • query stream mode
  • backslash commands supports
  • code re-factoring, and significant flickering reduction
  • export to program
  • switch to primary screen by ^o
  • progressive data loading
  • pretty printing of help texts
  • support for custom themes
  • new visual effects and possibility to read SQLcl output
  • kqueue (BSD) support
  • smooth horizontal scrolling

plpgsql_check

  • short syntax for pragma, pragmas TABLE and TYPE
  • little bit smarter check of format string used by format function in EXECUTE command
  • possibility to save execution's profile of aborted on cancelled function.

orafce

PostgreSQL

  • unistr in PostgreSQL 14
  • performance optimization of CALL command in PostgreSQL 14
  • possibility to use pspg together with \watch command (PSQL_WATCH_PAGER) in PostgreSQL 15
  • lot of revisions of patch for possibility to read options from file for pg_dump
  • significant refactoring of patch of implementation session variables

Some projects are very (too) long. But I hope, so they are near to final stage, and so next  year will be more time for more usual life, and less time for coding.

 

 

Tuesday, November 2, 2021

pspg 5.5.0

 Today I released pspg 5.5. There are few new interesting features:

  • stream mode based on continuous reading from file (uses kqueue) is supported on BSD Unix,
  • There are two new visual effects - possibility to hide border line, and possibility to highlight odd rows
  • pspg can be used in Oracle's SQLcl client too. It should to work with default format and with ANSICONSOLE format,
  • one char vertical scrolling is supported too. 




 

Sunday, October 31, 2021

Orafce 3.17.0

I released Orafce 3.17.0. This is bugfix only release. Giles Darold wrote a patch that fixes orafce's regexp functions for NULL arguments.

Tuesday, October 12, 2021

pspg 5.4.1 released

I released bugfix release of pspg. The problem with copy to clipboard on macos (using by pbcopy) is fixed in this release.

Monday, October 11, 2021

Orafce 3.16.2 for Postgres 12, 13 and 14 for Microsoft Windows

I made dll of orafce 3.16.2. These dll are available from archive orafce-3.16.2-x64-win.zip Instalation is simple. Copy related dll file to directory Program files/Postgres/version/lib and rename this dll just to orafce. Next, copy orafce.control and orafce--3.16.sql to Program files/Postgres/version/share/extension. Last step is executing command CREATE EXTENSION orafce in the database, where you want to use orafce. It can require redistributable runtime for Visual Studio 2019. Usually an good idea is set SEARCH_PATH to include schema oracle.

plpgsql_check 2.0.4 for Microsoft Windows and Postgres 12, 13 and 14.

I made dll of plpgsql_check 2.0.4. These dll are available from archive plpgsql_check-2.0.4-x64-win.zip Instalation is simple. Copy related dll file to directory Program files/Postgres/version/lib and rename this dll just to plpgsql_check. Next, copy plpgsql_check.control and plpgsql_check-2.0.sql to Program files/Postgres/version/share/extension. Last step is executing command CREATE EXTENSION plpgsql_check in the database, where you want to use plpgsql_check. It can require redistributable runtime for Visual Studio 2019.

Sunday, October 10, 2021

pspg 5.4.0

I released pspg version 5.4.0.. In this release there is an possibility to customize buildin color themes:
template = 1
template_menu = 3

background = black, white
data = black, white
label = black, white, italic, bold
border = #000000, white
footer = lightgray, white
cursor_data = blue, white, italic, bold, dim, reverse
cursor_border = blue, blue , italic, bold, dim, reverse
cursor_label = blue, white, italic, bold, dim, reverse
cursor_footer = blue, white, italic, bold, dim, reverse
cursor_bookmark = red, white, italic, bold, dim, reverse
cross_cursor = white, blue, italic, bold
cross_cursor_border = brightblue, blue
status_bar = black, lightgray
title = black, lightgray
scrollbar_arrows = black, white
scrollbar_background = lightgray, white
scrollbar_slider = white, gray