Page 1 of 1

PostgreSQL Portable

Posted: Tue Jan 04, 2022 11:28 am
by AUGE_OHR
hi,

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

Re: PostgreSQL Portable

Posted: Fri Jan 07, 2022 2:29 am
by Ismach
Uhhhh Genial!!!
Thanks AUGE_OHR

Re: PostgreSQL Portable

Posted: Mon Jan 31, 2022 5:06 am
by 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 :D 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 173 times
have fun

Re: PostgreSQL Portable

Posted: Sun Feb 06, 2022 12:28 pm
by 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
HbPGU.JPG (522.34 KiB) Viewed 3262 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