Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #10418 > unrolled thread
| Started by | Jürgen Knauf <trotterklaus@googlemail.com> |
|---|---|
| First post | 2017-04-12 10:38 -0700 |
| Last post | 2017-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
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 →
| From | Jürgen Knauf <trotterklaus@googlemail.com> |
|---|---|
| Date | 2017-04-12 10:38 -0700 |
| Subject | Advantage 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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-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]
| From | Jürgen Knauf <trotterklaus@googlemail.com> |
|---|---|
| Date | 2017-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]
| From | Martin <Martin@spam.spam> |
|---|---|
| Date | 2017-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2017-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-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]
| From | franslaenen@gmail.com |
|---|---|
| Date | 2019-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2020-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]
| From | Sherlock <sherlock@sherlock.com.au> |
|---|---|
| Date | 2017-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-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]
| From | Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> |
|---|---|
| Date | 2017-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]
| From | Jürgen Knauf <trotterklaus@googlemail.com> |
|---|---|
| Date | 2017-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-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]
| From | Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> |
|---|---|
| Date | 2017-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-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]
| From | D.J.W. van Kooten <vankooten@removethis.ic2.com> |
|---|---|
| Date | 2017-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]
| From | Franz Rachbauer <office@rachbauer.org> |
|---|---|
| Date | 2017-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-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]
| From | Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> |
|---|---|
| Date | 2017-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-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