Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #10418 > unrolled thread

Advantage Database server

Started byJürgen Knauf <trotterklaus@googlemail.com>
First post2017-04-12 10:38 -0700
Last post2017-04-18 15:21 -0700
Articles 20 on this page of 45 — 14 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Advantage Database server Jürgen Knauf <trotterklaus@googlemail.com> - 2017-04-12 10:38 -0700
    Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-13 09:19 +0200
      Re: Advantage Database server Jürgen Knauf <trotterklaus@googlemail.com> - 2017-04-13 06:21 -0700
    Re: Advantage Database server Martin <Martin@spam.spam> - 2017-04-13 17:09 +0100
    Re: Advantage Database server D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2017-04-13 23:57 +0200
      Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-14 07:55 +0200
      Re: Advantage Database server franslaenen@gmail.com - 2019-12-30 00:37 -0800
        Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2020-01-06 16:55 +0100
    Re: Advantage Database server Sherlock <sherlock@sherlock.com.au> - 2017-04-13 17:42 -0700
      Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-14 07:56 +0200
      Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-14 12:32 +0200
    Re: Advantage Database server Jürgen Knauf <trotterklaus@googlemail.com> - 2017-04-14 09:04 -0700
      Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-14 21:03 +0200
        Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-14 21:29 +0200
          Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-15 09:36 +0200
      Re: Advantage Database server D.J.W. van Kooten <vankooten@removethis.ic2.com> - 2017-04-15 04:13 +0200
        Re: Advantage Database server Franz Rachbauer <office@rachbauer.org> - 2017-04-15 08:34 +0200
        Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-15 09:39 +0200
          Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-15 10:21 +0200
            Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-15 17:49 +0200
              Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-15 18:14 +0200
                Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-15 18:22 +0200
                  Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-15 19:29 +0200
                    Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-16 05:58 +0200
                      Re: Advantage Database server Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> - 2017-04-16 11:00 +0200
              Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-16 11:55 +0200
                Re: Advantage Database server Sherlock <sherlock@sherlock.com.au> - 2017-04-16 05:36 -0700
                  Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-16 21:07 +0200
                    Re: Advantage Database server "Rene J. Pajaron" <rjpajaron@gmail.com> - 2017-04-18 04:05 -0700
                      Re: Advantage Database server Sherlock <sherlock@sherlock.com.au> - 2017-04-18 05:20 -0700
                        Re: Advantage Database server "Rene J. Pajaron" <rjpajaron@gmail.com> - 2017-04-18 05:45 -0700
                        Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-18 20:24 +0200
                  Re: Advantage Database server "Rene J. Pajaron" <rjpajaron@gmail.com> - 2017-04-18 03:52 -0700
        Re: Advantage Database server "Marc Verkade" <marc@marc.marc> - 2017-04-19 18:00 +0200
          Re: Advantage Database server Sherlock <sherlock@sherlock.com.au> - 2017-04-20 04:57 -0700
          Re: Advantage Database server Jindřich Žák <keivulan@gmail.com> - 2023-10-23 10:22 -0700
    Re: Advantage Database server Jürgen Knauf <trotterklaus@googlemail.com> - 2017-04-14 23:46 -0700
      Re: Advantage Database server "Wolfgang Riedmann" <wriedmann@gmail.com> - 2017-04-15 09:42 +0200
    Re: Advantage Database server gloroveo@gmail.com - 2017-04-17 13:32 -0700
    Re: Advantage Database server aib@aib.org.nz - 2017-04-17 17:15 -0700
      Re: Advantage Database server aib@aib.org.nz - 2017-04-17 17:20 -0700
        Re: Advantage Database server James Martin <james@northwoodlumber.com> - 2017-04-18 08:21 -0400
          Re: Advantage Database server Sherlock <sherlock@sherlock.com.au> - 2017-04-18 05:46 -0700
            Re: Advantage Database server James Martin <james@northwoodlumber.com> - 2017-04-18 09:48 -0400
          Re: Advantage Database server aib@aib.org.nz - 2017-04-18 15:21 -0700

Page 1 of 3  [1] 2 3  Next page →


#10418 — Advantage Database server

FromJürgen Knauf <trotterklaus@googlemail.com>
Date2017-04-12 10:38 -0700
SubjectAdvantage Database server
Message-ID<286dc3c8-efd7-43f5-9668-8981466836d8@googlegroups.com>
Is there is an easy alternative to the Advantage Database Server.
It looks like that there is no further development.

Juergen

[toc] | [next] | [standalone]


#10425

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2017-04-13 09:19 +0200
Message-ID<el8n4gFu3lsU1@mid.individual.net>
In reply to#10418
Hi Jürgen,

> Is there is an easy alternative to the Advantage Database Server.

unfortunately not. GrafX many years ago had something very interesting,
but then the author (that was also the author of the Comix RDD) died
and the product was killed.

There seems to be something like Apollo http://www.apollodb.com/ but
they have no VO support, only Clipper, Delphi and Ado.NET clients
available.

Maybe they are interested in a client development for X#...

> It looks like that there is no further development.

that would be a shame.... I like ADS and it works very well. They have
moved the development to India, but I cannot immagine they are not
interested in selling it and maintaining it.

I see ADS as mature product, and I don't think there is so many
potential that a massive further development could be justified.

Do you have any source for this?

Wolfgang



-- 

[toc] | [prev] | [next] | [standalone]


#10431

FromJürgen Knauf <trotterklaus@googlemail.com>
Date2017-04-13 06:21 -0700
Message-ID<6a9c096a-d598-41f5-9e84-11b3800d64e6@googlegroups.com>
In reply to#10425
Am Donnerstag, 13. April 2017 09:19:46 UTC+2 schrieb Wolfgang Riedmann:
> Hi Jürgen,
> 
> > Is there is an easy alternative to the Advantage Database Server.
> 
> unfortunately not. GrafX many years ago had something very interesting,
> but then the author (that was also the author of the Comix RDD) died
> and the product was killed.
> 
> There seems to be something like Apollo http://www.apollodb.com/ but
> they have no VO support, only Clipper, Delphi and Ado.NET clients
> available.
> 
> Maybe they are interested in a client development for X#...
> 
> > It looks like that there is no further development.
> 
> that would be a shame.... I like ADS and it works very well. They have
> moved the development to India, but I cannot immagine they are not
> interested in selling it and maintaining it.
> 
> I see ADS as mature product, and I don't think there is so many
> potential that a massive further development could be justified.
> 
> Do you have any source for this?
> 
> Wolfgang
> 
> 
> 
> --

Hi Wolfgang,

thanks for your opinion.
Unfortunately, I have no sources.

Juregen


>>I see ADS as mature product, and I don't think there is so many
>>potential that a massive further development could be justified. 

[toc] | [prev] | [next] | [standalone]


#10435

FromMartin <Martin@spam.spam>
Date2017-04-13 17:09 +0100
Message-ID<oco7lk$oc$1@dont-email.me>
In reply to#10418
They better not as it is mission critical to us.

On 12/04/2017 18:38, Jürgen Knauf wrote:
> Is there is an easy alternative to the Advantage Database Server.
> It looks like that there is no further development.
>
> Juergen
>

[toc] | [prev] | [next] | [standalone]


#10439

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2017-04-13 23:57 +0200
Message-ID<7lsvec1mj91t926svu4f58usf3seuf11s9@4ax.com>
In reply to#10418
Replying on message of Wed, 12 Apr 2017 10:38:59 -0700 (PDT) from
Jürgen Knauf:


 Hello Jürgen,

>Is there is an easy alternative to the Advantage Database Server.
>It looks like that there is no further development.
>
I do know someone who is working on an alternative. I've been informed
it could still take a while and I expect this 'someone' to reveal his
plans once these are more mature so I won't say more about it here &
now.

I was interested in learning about this alternative because I agree
with you and also think that ADS is a bit going the "Grafx" direction.
No replies on questions ore only after multiple retries. Version 12
does not seem to have any significant improvements and I could name a
few which would be needed. 

For example: 
* Once a person logs out it takes a long time before the ADS
connection is cleared. 
* There's no fast way to just disconnect users (I would expect the
Configuration utility to take care of this, not fiddling around with
the Data Architect). 
* On line reindex doesn't seem to work for FTS tags 

and I can go on for a while.

I do not expect anyone to do much about it. SAP is about the worst
company a product like ADS could have moved to.

So I m really looking forward to the alternative if it all works out.

Dick

---
Deze e-mail is gecontroleerd op virussen door AVG.
http://www.avg.com

[toc] | [prev] | [next] | [standalone]


#10441

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2017-04-14 07:55 +0200
Message-ID<elb6ijFearbU1@mid.individual.net>
In reply to#10439
Hi Dick,

> * There's no fast way to just disconnect users (I would expect the
> Configuration utility to take care of this, not fiddling around with
> the Data Architect). 

there it is something you can do in your own application. I have it in
my ADS applications....


Wolfgang

-- 

[toc] | [prev] | [next] | [standalone]


#12735

Fromfranslaenen@gmail.com
Date2019-12-30 00:37 -0800
Message-ID<ee7ebe08-be8d-48db-9878-e1cd5ef548ad@googlegroups.com>
In reply to#10439
Op donderdag 13 april 2017 23:57:49 UTC+2 schreef D.J.W. van Kooten:
> Replying on message of Wed, 12 Apr 2017 10:38:59 -0700 (PDT) from
> Jürgen Knauf:
> 
> 
>  Hello Jürgen,
> 
> >Is there is an easy alternative to the Advantage Database Server.
> >It looks like that there is no further development.
> >
> I do know someone who is working on an alternative. I've been informed
> it could still take a while and I expect this 'someone' to reveal his
> plans once these are more mature so I won't say more about it here &
> now.
> 
> I was interested in learning about this alternative because I agree
> with you and also think that ADS is a bit going the "Grafx" direction.
> No replies on questions ore only after multiple retries. Version 12
> does not seem to have any significant improvements and I could name a
> few which would be needed. 
> 
> For example: 
> * Once a person logs out it takes a long time before the ADS
> connection is cleared. 
> * There's no fast way to just disconnect users (I would expect the
> Configuration utility to take care of this, not fiddling around with
> the Data Architect). 
> * On line reindex doesn't seem to work for FTS tags 
> 
> and I can go on for a while.
> 
> I do not expect anyone to do much about it. SAP is about the worst
> company a product like ADS could have moved to.
> 
> So I m really looking forward to the alternative if it all works out.
> 
> Dick
> 
> ---
> Deze e-mail is gecontroleerd op virussen door AVG.
> http://www.avg.com

Hello Dick,

It's been a while since.
Is there is an easy alternative to the Advantage Database Server you mentioned before because the dead horse gets heavier and heavier.

Best regards,
Frans
> >It lo

[toc] | [prev] | [next] | [standalone]


#12747

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2020-01-06 16:55 +0100
Message-ID<h7h3k8Fq7vhU1@mid.individual.net>
In reply to#12735
Hi Frans,

> Is there is an easy alternative to the Advantage Database Server you
> mentioned before because the dead horse gets heavier and heavier.

sometimes ago there were plans that the X# Development Team could build
a Xbase DBF database server.

Now that the DBFCDX RDD is ready, maybe we could try to raise some
funds for this - and at least my own (small) company is willing to
contribute some money for this.

Wolfgang

-- 

[toc] | [prev] | [next] | [standalone]


#10440

FromSherlock <sherlock@sherlock.com.au>
Date2017-04-13 17:42 -0700
Message-ID<1229aa5b-856a-4299-b775-b2e29ef3f8c9@googlegroups.com>
In reply to#10418
snip[ Is there is an easy alternative to the Advantage Database Server. ]

Never used it but we wrote a native Dataserver system around Postgres.
Our memo use was massive and the speed difference is so much faster.
We have large internal systems and wanted to move all our backend to Postgres.
It has been working for a year now.
Have not documented it but essentially without a massive amount of changes we have the same app with bBrowser and Reportpro working.
My developer has never had the time to document it.

It is a learning curve for DBF only developers.
Is this a viable option for VO'ers moving forward?
The number of datatypes compared to DBF is amazing inclusing JSON/JSONB. 

Phil 

[toc] | [prev] | [next] | [standalone]


#10442

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2017-04-14 07:56 +0200
Message-ID<elb6laFeb71U1@mid.individual.net>
In reply to#10440
Hi Phil,

this sounds very interesting!

There is something we could have to test? Is it something we could buy?

Wolfgang

Sherlock wrote:

> snip[ Is there is an easy alternative to the Advantage Database
> Server. ]
> 
> Never used it but we wrote a native Dataserver system around Postgres.
> Our memo use was massive and the speed difference is so much faster.
> We have large internal systems and wanted to move all our backend to
> Postgres.  It has been working for a year now.
> Have not documented it but essentially without a massive amount of
> changes we have the same app with bBrowser and Reportpro working.  My
> developer has never had the time to document it.
> 
> It is a learning curve for DBF only developers.
> Is this a viable option for VO'ers moving forward?
> The number of datatypes compared to DBF is amazing inclusing
> JSON/JSONB.
> 
> Phil 



-- 

[toc] | [prev] | [next] | [standalone]


#10443

FromKarl Faller <mail_withoutthat_@_drei-f_andthat_.de>
Date2017-04-14 12:32 +0200
Message-ID<rj81fc53bbtj9pggcovu2ca9s42rft1bgl@4ax.com>
In reply to#10440
On Fri, 14 Apr 2017 10:38:29 +0200, Johan Nel wrote:

>Have to agree with you.  I started using PostgreSQL way back when they 
>released the first Windows version, and I was so surprised when with my 
>then knowledge of MS-Access and Oracle was within less than an hour 
>comfortable with pgAdmin and administrating a server.  
FWIW, even i was able to install it ;-) - in essence it is a one-click
experience... 
Found it to be even less a hassle than to try some of the free
"containered" solutions at amazon etc.



Regards

Karl

[toc] | [prev] | [next] | [standalone]


#10444

FromJürgen Knauf <trotterklaus@googlemail.com>
Date2017-04-14 09:04 -0700
Message-ID<a519a992-d11a-46f3-a1e1-51a872ed2bf2@googlegroups.com>
In reply to#10418
Am Mittwoch, 12. April 2017 19:38:59 UTC+2 schrieb Jürgen Knauf:
> Is there is an easy alternative to the Advantage Database Server.
> It looks like that there is no further development.
> 
> Juergen

What about C# and SQL Server Express. Any eexperience?
Can I use it like "ADS Local Server"?

[toc] | [prev] | [next] | [standalone]


#10445

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2017-04-14 21:03 +0200
Message-ID<elckopFnb5oU1@mid.individual.net>
In reply to#10444
Hi Jürgen,

> > Is there is an easy alternative to the Advantage Database Server.
> > It looks like that there is no further development.
> > 
> > Juergen
> 
> What about C# and SQL Server Express. Any eexperience?
> Can I use it like "ADS Local Server"?

currently I know only two SQL products that are usable like ADS Local
Server: SQLite and Firebird Embedded.

All other SQL servers need to be installed onto a server machine.

Of course you need to change also your software because they don't work
like an RDD.

Wolfgang




-- 

[toc] | [prev] | [next] | [standalone]


#10446

FromKarl Faller <mail_withoutthat_@_drei-f_andthat_.de>
Date2017-04-14 21:29 +0200
Message-ID<cn82fc1ljmddn16oev4cgjojr2jokv52k4@4ax.com>
In reply to#10445
On Fri, 14 Apr 2017 21:03:52 +0200, Wolfgang Riedmann wrote:

>you need to change also your software because they don't work
>like an RDD.
Because of this it would be very interesting so see what Phil
(Sherlock) has done...

Karl

[toc] | [prev] | [next] | [standalone]


#10450

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2017-04-15 09:36 +0200
Message-ID<ele0sdFg1jU1@mid.individual.net>
In reply to#10446
Hi Karl,

> > you need to change also your software because they don't work
> > like an RDD.

> Because of this it would be very interesting so see what Phil
> (Sherlock) has done...

but if I understand correctly, they have done an own dataserver class,
not an RDD.

But of course, I'm very curios how they have done Softseek and
incremental read. But maybe PostGres has a positional interface - that
would make it work.

For such an interface (if it works) I'm willing to pay - of course only
with sources and the possibility to move to X#.

Wolfgang


-- 

[toc] | [prev] | [next] | [standalone]


#10447

FromD.J.W. van Kooten <vankooten@removethis.ic2.com>
Date2017-04-15 04:13 +0200
Message-ID<fiv2fc9jk415f326n2j12j9156kdgqvh5f@4ax.com>
In reply to#10444
Replying on message of Fri, 14 Apr 2017 09:04:07 -0700 (PDT) from
Jürgen Knauf:


 Hello Jürgen,

>What about C# and SQL Server Express. Any eexperience?
>Can I use it like "ADS Local Server"?

Maybe even with MySQL but I am not sure about that.  I have installed
the MySQL Workbench as this allows me to approach multiple on line
MySQL databases. 

Unless there are limitations my first choice would be to go for MySQL,
I would have the same environment for web data and local data and also
because MySQL is not from Microsoft. Here's some comparison:

https://db-engines.com/en/system/Microsoft+SQL+Server%3BMySQL

I think the major problem of SQL when your system is based upon DBF
files is that you can not replace that 1:1 with comparable MySQL
statements. E.g. a DO..WHILE loop replacing a value in a DBF should be
replaced with 1 SQL query in most cases otherwise it's much slower.

Geoff Schaller has written a tool to convert more easily to SQL. 

Dick


---
Deze e-mail is gecontroleerd op virussen door AVG.
http://www.avg.com

[toc] | [prev] | [next] | [standalone]


#10448

FromFranz Rachbauer <office@rachbauer.org>
Date2017-04-15 08:34 +0200
Message-ID<ocseti$ub5$1@gioia.aioe.org>
In reply to#10447
>
> I think the major problem of SQL when your system is based upon DBF
> files is that you can not replace that 1:1 with comparable MySQL
> statements. E.g. a DO..WHILE loop replacing a value in a DBF should be
> replaced with 1 SQL query in most cases otherwise it's much slower.
>
With some small extensions to SQLTable you can use MySQL similar like 
DBF including record locking. For a record approach this has enough 
speed. For mass updates you can use SQLStatement. A big advantage of 
MySQL (and other SQL DBs) are transactions and I'll never miss it.

Regards, Franz

[toc] | [prev] | [next] | [standalone]


#10451

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2017-04-15 09:39 +0200
Message-ID<ele12aFh31U1@mid.individual.net>
In reply to#10447
Hi Dick,

> > What about C# and SQL Server Express. Any eexperience?
> > Can I use it like "ADS Local Server"?
> 
> Maybe even with MySQL but I am not sure about that.  I have installed
> the MySQL Workbench as this allows me to approach multiple on line
> MySQL databases. 

even MySQL needs to be installed on the machine. I like MySQL, but
since it is a property of Oracle it is not more as free as before. You
could use MariaDB instead - a free fork. But I had tried to install it
and failed....

My choice was Firebird - it is really free, and works well on Windows
and Linux. But maybe I have to try out Postgresql....

Wolfgang

-- 

[toc] | [prev] | [next] | [standalone]


#10453

FromKarl Faller <mail_withoutthat_@_drei-f_andthat_.de>
Date2017-04-15 10:21 +0200
Message-ID<egl3fcdrqf3pm5d3tm2dnaa63h4apjn51t@4ax.com>
In reply to#10451
On Sat, 15 Apr 2017 09:39:53 +0200, Wolfgang Riedmann wrote:
>But maybe I have to try out Postgresql....
Especially in your case, the "foreign data wrapper" concept might habe
appeal - basically you talk to PG, which in turn talks transparently
to almost any thinkable datastorage system.

BTW, on the plus side i'd count also the docs - about 3k3 pages <g> -
but "hand written", not the bs auto-doc tools produce...

Karl

[toc] | [prev] | [next] | [standalone]


#10454

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2017-04-15 17:49 +0200
Message-ID<eletp8F60uuU1@mid.individual.net>
In reply to#10453
Hi Karl,

it seems I have to rethink my Firebird decision bevore it is to late...
I have read a book from the Succinctly series by Syncfusion:

http://www.syncfusion.com/resources/techportal/ebooks/postgres

and it seems very, very interesting.

Wolfgang



Karl Faller wrote:

> On Sat, 15 Apr 2017 09:39:53 +0200, Wolfgang Riedmann wrote:
> > But maybe I have to try out Postgresql....
> Especially in your case, the "foreign data wrapper" concept might habe
> appeal - basically you talk to PG, which in turn talks transparently
> to almost any thinkable datastorage system.
> 
> BTW, on the plus side i'd count also the docs - about 3k3 pages <g> -
> but "hand written", not the bs auto-doc tools produce...
> 
> Karl



-- 

[toc] | [prev] | [next] | [standalone]


Page 1 of 3  [1] 2 3  Next page →

Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web