PostgreSQL Portable

[AUGE_OHR]

hi,

if some need a "portable" PostgreSQL Database look here
https://sourceforge.net/projects/pgsqlportable/

[Ismach]

Uhhhh Genial!!!
Thanks AUGE_OHR

[AUGE_OHR]

PostgreSQL 64 Bit Client for HMG

hi,

i want to build a 64 Bit PostgreSQL App but it seems there is no libhbpgsql.a and liblibpq.a in HMG\LIB-64\
there is a File HbPgSql.rar for MiniGUI which work with LibPQ.DLL up to v9.x but all is for 32 Bit ...

when want to use LibPQ.DLL 64 Bit > v10 you also need some "other" *.DLL

06.12.2021 01:06 3.712.308 libcrypto-1_1-x64.dll
09.11.2021 05:21 475.769 libintl-9.dll
07.08.2019 03:15 287.232 libpq.dll
06.12.2021 01:06 937.872 libssl-1_1-x64.dll

i have start Project with CLASS TPQServer which is also include.
ZIP File include LIB, DLL and tpostgre.prg

liblibpq_64.zip

libhbpgsql.a and liblibpq.a ( MinGW )

(2.23 MiB) Downloaded 174 times

have fun

[AUGE_OHR]

hi,

i have begin to re-write my Xbase++ PGU App to harbour HMG
it can (quick) "Import" DBF to PostgreSQL Table

it is special made for Table > 100000 ROW so i use a "virtual" GRID

HbPGU.JPG (522.34 KiB) Viewed 3263 times

it is special made for PgDBE Concept of Alaska Xbase++ v2.x which have some "internal" FIELD(s)

Code: Select all

   " __deleted    boolean NOT NULL DEFAULT false, "
   " __record     serial  NOT NULL, "
   " __rowversion integer NOT NULL DEFAULT 0, "
   " __keyversion integer NOT NULL DEFAULT 0, "
   " __lock_owner integer NOT NULL DEFAULT 0, "

and use a PRIMARY KEY on __record

Code: Select all

   " CONSTRAINT " + cTable + "_pkey PRIMARY KEY (__record)"

i need __record ( => RECNO() ) for "re-position" when change Column in GRID
so it will not work well with "normal" PosgreSQL Table
other "internal" FIELD(s) are for Network

if you are interest "how" it work i will make a new Thread for it