Friday, October 13, 2023

compiled dll of plpgsql_check 2.5.4 and Orafce 4.7.0 for PostgreSQL 15 and 16

I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 15 and PostgreSQL 16.

Setup:

  1. download orafce-4.7.0-x64.zip or plpgsql_check-2.5.4-x64.zip and extract files
  2. copy related dll file to PostgreSQL lib directory (NN is number of pg release)
    orafce-NN.dll -> "c:\Program Files\PostgreSQL\NN\lib"
  3. remove suffix "-15" or "-16" from dll file
    orafce-NN.dll -> orafce.dll
  4. copy *.sql and *.control files to extension directory
    *.sql, *.control -> "c:\Program Files\PostgreSQL\NN\share\extension"
  5. execute with super user rights SQL command CREATE EXTENSION
    CREATE EXTENSION orafce;

Friday, December 2, 2022

prepared dll of orafce 4.0.1 and plpgsql_check 2.2.5 for PostgreSQL 14 and PostgreSQL 15

I compiled and uploaded zip files with latest orafce and plpgsql_check for PostgreSQL 14 and PostgreSQL 15.

Setup:

  1. download orafce-4.0.1.zip or plpgsql_check-2.2.5.zip and extract files
  2. copy related dll file to PostgreSQL lib directory (NN is number of pg release)
    orafce-NN.dll -> "c:\Program Files\PostgreSQL\NN\lib"
  3. remove suffix "-14" or "-15" from dll file
    orafce-NN.dll -> orafce.dll
  4. copy *.sql and *.control files to extension directory
    *.sql, *.control -> "c:\Program Files\PostgreSQL\NN\share\extension"
  5. execute with super user rights SQL command CREATE EXTENSION
    CREATE EXTENSION orafce;

Monday, November 28, 2022

pspg 5.6.0

I released pspg 5.6.0. There is only one (not too visible change). It allows to use true color themes in "konsole" terminal (when TERM) is xterm-direct.

Sunday, November 20, 2022

pspg and nushell

I very like the concept of nushell. The concept of Unix pipes is famous (still), but little bit aged (we have more resources than was possible 40 years ago). Working with multi-column data with classical Unix tools is fragile and really not very friendly. More time I asked why conceptual development stopped at 80 years. nushell allows to work well with relations. There is similar project relational pipes. In old times the Microsoft has something similar based on DAO

I didn't find C API of nushell (it is 100% rust oriented), so I cannot to support nushell in pspg directly, but support via CSV format works perfectly. 

 


and same result displayed in pspg:


Update: pspg 5.5.10 supports nushell formats (table_mode) rounded (default) and heavy. The conversion to csv is not necessary.



Wednesday, November 2, 2022

orafce 4.0.0

Today I released orafce 4.0.0

The big change is merging orafce_sql project - so now directly in orafce is possible to use dbms_sql package.

Second change is code cleaning - support for PostgreSQL 9.6 and 10 was removed.

Friday, October 7, 2022

pspg 5.5.8

I released new version of pspg . This release can be interesting for users that uses some BSD platforms (like FreeBSD). Unfortunately, these platforms doesn't support alternate screen, and then can users can see some unwanted visual effects, when pspg is closed. Most unwanted are chars of bottom menu in command line.

New pspg introduces set of options, that can be used in this situation: --on-exit-reset (reset terminal), --on-exit-clean (clean terminal) and --on-exit-erase-line (erase last (bottom line)).

Friday, April 15, 2022

Orafce 3.21.0

I released Orafce 3.21.0. In this release, the Oracle regexp functions regexp_instr and regexp_replace was backported (and little bit modified) from PostgreSQL 15. The C implementation is more faster, and much more robust than PLpgSQL implementation. The problem was not in just PL/pgSQL, but in some missing possibilities of PostgreSQL regexp API available from SQL or PL/pgSQL.

Attention, although the code was backported from Postgres, the behavior is little bit different for making higher compatibility with Oracle. There is little bit different handling NULL values.