Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #10974
| Path | csiph.com!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail |
|---|---|
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
| Newsgroups | comp.lang.clipper.visual-objects |
| Subject | Re: Postgres general Question |
| Date | Tue, 12 Sep 2017 07:34:28 +0200 |
| Lines | 56 |
| Message-ID | <f1p9v6Fidp2U1@mid.individual.net> (permalink) |
| References | <6d3a0a33-250f-4f2b-884e-5e13f78b40b9@googlegroups.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=utf-8 |
| X-Trace | individual.net SWB8PxdyfULGFhKCXldkAQjZZJhTOERaClSL4ki2TpF1LLGJQ= |
| Cancel-Lock | sha1:A/B0t30+fxAfPV4z+dO5TLADtb0= |
| User-Agent | XanaNews/1.18.1.6 |
| Xref | csiph.com comp.lang.clipper.visual-objects:10974 |
Show key headers only | View raw
Hi Frank,
there is an architectural difference between DBF and any SQL engine.
DBF is record-based, whereas SQL is selection based.
That means that in DBF you are reading record per record and you can
stop at any time.
In SQL you need to make a selection first, and the server returns the
selected records - all.
Therefore you should rethink your applicationif you are moving to any
SQL engine.
It may possible that there is some software that works with PostgreSQL
directly on the record level and hides the SQL interface, but VO2ADO is
it not.
In SQL engines you can have indexes, but they are used by the engine
automatically to speed up your queries.
To have your records ordered, in SQL you need the orderby clause.
SQL has much more power than DBF, but not everything works better with
SQL than with DBF.
Therefore I have used the Advantage Database Server in a few projects:
I was able to move my DBF applications fast to a server based engine,
and could add SQL selects where needed.
Of course, the next generation of my software is SQL based because DBFs
don't work very well with newer server and client versions, and
customers are asking more and more features that are difficult to
implement with DBF databases.
Wolfgang
Frank M wrote:
> Hello,
>
> my first beginning with VO2ADO and PostgreSQL, and beginners Problems
> :-)
>
> I can connect and open PG Tables with VO2ADO, that work. When try to
> open or set an Index with AdoServer:SetOrder("Ordername") i get the
> Error: "SETINDEX not supported by provider" I try two different
> Driver. It is general possible to use AdoServer like DbServer? Is
> this not possible with PG? I know that i have later to rewrite the
> Syntax to real SQL Select, but i like the way, step for step to do
> this later.
>
> Frank
--
Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-11 07:54 -0700
Re: Postgres general Question Franz Rachbauer <office@rachbauer.org> - 2017-09-11 18:14 +0200
Re: Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-11 09:27 -0700
Re: Postgres general Question Franz Rachbauer <office@rachbauer.org> - 2017-09-12 07:13 +0200
Re: Postgres general Question "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-09-12 07:34 +0200
Re: Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-12 00:06 -0700
Re: Postgres general Question "Karl-Heinz" <invalid@invalid.invalid> - 2017-09-12 13:53 +0200
Re: Postgres general Question James Martin <james@northwoodlumber.com> - 2017-09-12 17:11 -0400
Re: Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-12 23:58 -0700
Re: Postgres general Question "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-09-13 10:01 +0200
Re: Postgres general Question "Rene J. Pajaron" <rjpajaron@gmail.com> - 2017-09-13 23:36 -0700
Re: Postgres general Question James Martin <james@northwoodlumber.com> - 2017-09-14 14:08 -0400
Re: Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-16 07:17 -0700
Re: Postgres general Question Frank M <frank_muessner@gmx.de> - 2017-09-18 04:09 -0700
csiph-web