Path: csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: "Wolfgang Riedmann" Newsgroups: comp.lang.clipper.visual-objects Subject: Re: Advantage Database server Date: Tue, 18 Apr 2017 20:24:24 +0200 Lines: 36 Message-ID: References: <286dc3c8-efd7-43f5-9668-8981466836d8@googlegroups.com> <02a18f2c-72eb-41b1-b963-f868cf1d5133@googlegroups.com> <0514a045-f7bf-4ce1-a2aa-ac83594f2310@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Trace: individual.net IhtcW0xfXPvGfhcPGi99MAr/QacObf378918QFuJsdp059giU= Cancel-Lock: sha1:cMgZvpXvtzj2uGWAt3BnrAepG+M= User-Agent: XanaNews/1.18.1.6 Xref: csiph.com comp.lang.clipper.visual-objects:10476 Hi Phil, thanks, this sounds very, very interesting! Wolfgang Sherlock wrote: > Rene > > Discussion with Ales this morning re sample app and thinking my > original Fastextsearch using the code and it has bBRowser. > > System we have is a full wrapper around the LIBPQ library with > classes that inherit from Dataserver. > > PgDataServerBase – a base class for the following: > PgSelect – a class which provides DataServer functionality to the > result of SQL queries. This class loads all results of the query in > the memory and doesn't allow SQL UPDATE / INSERT. PgTableServer – > this one provides access to the whole table, buffering just one row > at the time plus all newly inserted rows until Commit(). Allows > UPDATE / INSERT > > The interesting thing is the above classes actually implement methods > similar to DBServer, not SQLSelect / SQLTable etc because our systems > were using DBF and we wanted the transition to PostgreSQL with > minimal changes in the code – we aimed to directly replacing > DBServer derived classes by PgSelect / PgTableServer. > > Phil --