Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Advantage Database server
1,168 views
Skip to first unread message
Jürgen Knauf
Apr 12, 2017, 1:38:59 PM4/12/17
to
Is there is an easy alternative to the Advantage Database Server.
It looks like that there is no further development.
Juergen
It looks like that there is no further development.
Juergen
Wolfgang Riedmann
Apr 13, 2017, 3:19:46 AM4/13/17
to
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
--
> Is there is an easy alternative to the Advantage Database Server.
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.
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
--
Jürgen Knauf
Apr 13, 2017, 9:21:35 AM4/13/17
to
thanks for your opinion.
Unfortunately, I have no sources.
Juregen
Martin
Apr 13, 2017, 12:09:19 PM4/13/17
to
They better not as it is mission critical to us.
D.J.W. van Kooten
Apr 13, 2017, 5:57:49 PM4/13/17
to
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
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.
>
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
Sherlock
Apr 13, 2017, 8:42:06 PM4/13/17
to
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
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
Wolfgang Riedmann
Apr 14, 2017, 1:55:33 AM4/14/17
to
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
--
> * 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).
my ADS applications....
Wolfgang
--
Wolfgang Riedmann
Apr 14, 2017, 1:57:00 AM4/14/17
to
Hi Phil,
this sounds very interesting!
There is something we could have to test? Is it something we could buy?
Wolfgang
--
this sounds very interesting!
There is something we could have to test? Is it something we could buy?
Wolfgang
Johan Nel
Apr 14, 2017, 4:38:44 AM4/14/17
to
Hi Phil,
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. Take
on top of that the effort that goes into maintaining it and the
documentation. For the people not familiar with it, there is a
maillist going out every Monday and I think the following just give
some insight into the professionalism (09 April weekly update):
Had an instance of it running on a 2003 Server for 3 years without ever rebooting the server or having to restart the Database service. Was a bit of naughty behavior from my side. The company I worked for were under the impression the backend was an Oracle server, they decommissioned a server and I asked if I can use it for some testing purposes... The server now runs as a virtual machine and still is the most stable one in the company.
Take on top of that Slony the Master to Slave replication service, pgAgent the job scheduler, the list goes on and on of freeware extensions, and as you mentioned the built in column types are just amazing.== Applied Patches == Tom Lane pushed: - Document psql's behavior of recalling the previously executed query. Various psql slash commands that normally act on the current query buffer will automatically recall and re-use the most recently executed SQL command instead, if the current query buffer is empty. Although this behavior is ancient (dating apparently to commit 77a472993), it was documented nowhere in the psql reference page. For that matter, we'd never bothered to define the concept of "current query buffer" explicitly. Fix that. Do some wordsmithing on relevant command descriptions to improve clarity and consistency. Discussion: https://postgr.es/m/9b4ea968-753f-4b5f...@manitou-mail.org http://git.postgresql.org/pg/commitdiff/68dba97a4dea5c5c915e31978a475107c17c458d - Doc: clarify behavior of OT_WHOLE_LINE and OT_FILEPIPE psql slash commands. This is another bit of ancient behavior that was documented poorly (in a couple of cases) or not at all (in several others). Discussion: https://postgr.es/m/9b4ea968-753f-4b5f...@manitou-mail.org http://git.postgresql.org/pg/commitdiff/ffac5998b4c18920f86d80f1bddbde9ebcf0a314
Had an instance of it running on a 2003 Server for 3 years without ever rebooting the server or having to restart the Database service. Was a bit of naughty behavior from my side. The company I worked for were under the impression the backend was an Oracle server, they decommissioned a server and I asked if I can use it for some testing purposes... The server now runs as a virtual machine and still is the most stable one in the company.
--
Johan Nel
George, South Africa
Johan Nel
George, South Africa
 |
Virus-free. www.avast.com |
Karl Faller
Apr 14, 2017, 6:32:34 AM4/14/17
to
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
>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.
experience...
Found it to be even less a hassle than to try some of the free
"containered" solutions at amazon etc.
Regards
Karl
Jürgen Knauf
Apr 14, 2017, 12:04:09 PM4/14/17
to
Can I use it like "ADS Local Server"?
Wolfgang Riedmann
Apr 14, 2017, 3:03:57 PM4/14/17
to
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
--
> > 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"?
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
--
Karl Faller
Apr 14, 2017, 3:29:26 PM4/14/17
to
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
>you need to change also your software because they don't work
>like an RDD.
(Sherlock) has done...
Karl
D.J.W. van Kooten
Apr 14, 2017, 10:13:09 PM4/14/17
to
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.
Jürgen Knauf:
Hello Jürgen,
>What about C# and SQL Server Express. Any eexperience?
>Can I use it like "ADS Local Server"?
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.
Johan Nel
Apr 15, 2017, 1:59:24 AM4/15/17
to
Jürgen,
On 2017/04/14 18:04, Jürgen Knauf wrote:What about C# and SQL Server Express. Any experience?
Can I use it like "ADS Local Server"?
You can use most RDBMS as a local server. My experience is with
PostgreSQL and it has a setting "listen_addresses" that you set to
localhost which will then make it a "Local Server". It is exactly
the same installation between a server and local installation.
There are more settings that you would maybe want to set for
localhost e.g. max_concurrent_connections. It has quite a small
memory footprint.
Franz Rachbauer
Apr 15, 2017, 2:34:27 AM4/15/17
to
>
> 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
> 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.
>
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
Jürgen Knauf
Apr 15, 2017, 2:46:04 AM4/15/17
to
Am Mittwoch, 12. April 2017 19:38:59 UTC+2 schrieb Jürgen Knauf:
I use in C# the SQL Syntax and there is also no RDD functionality.
Maybe SQL Server Express LocalDB is interesting?
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/sql-server-2016-express-localdb
Wolfgang Riedmann
Apr 15, 2017, 3:36:47 AM4/15/17
to
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
--
> > 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...
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
--
Wolfgang Riedmann
Apr 15, 2017, 3:39:57 AM4/15/17
to
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
--
> > 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.
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
--
Wolfgang Riedmann
Apr 15, 2017, 3:42:36 AM4/15/17
to
Hi Jürgen,
> > Is there is an easy alternative to the Advantage Database Server.
> > It looks like that there is no further development.
>
it is no further developed, and prefers SQLite as local storage.
Wolfgang
--
> > Is there is an easy alternative to the Advantage Database Server.
> > It looks like that there is no further development.
>
> Thank you for the answers!
> I use in C# the SQL Syntax and there is also no RDD functionality.
>
> Maybe SQL Server Express LocalDB is interesting?
> https://docs.microsoft.com/en-us/sql/database-engine/configure-windows
> /sql-server-2016-express-localdb
if I remember correctly, Microsoft itself discourages its use because
> I use in C# the SQL Syntax and there is also no RDD functionality.
>
> Maybe SQL Server Express LocalDB is interesting?
> https://docs.microsoft.com/en-us/sql/database-engine/configure-windows
> /sql-server-2016-express-localdb
it is no further developed, and prefers SQLite as local storage.
Wolfgang
--
Karl Faller
Apr 15, 2017, 4:21:10 AM4/15/17
to
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
>But maybe I have to try out Postgresql....
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
Wolfgang Riedmann
Apr 15, 2017, 11:50:03 AM4/15/17
to
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
--
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
Apr 15, 2017, 12:14:26 PM4/15/17
to
On Sat, 15 Apr 2017 17:49:58 +0200, Wolfgang Riedmann wrote:
>and it seems very, very interesting.
It is, certainly. Keep in mind, that the book is on 9.4 level, if you
>and it seems very, very interesting.
have a look through the "what's new" of 9.5 and especially 9.6, the
progress is breathtaking. That said, V10 is due for, IIRC, September,
and usually they are very good in their timing...
Karl
Wolfgang Riedmann
Apr 15, 2017, 12:22:55 PM4/15/17
to
Hi Karl,
do you have experiences with the stability of Postgresql? This is IMHO
one of the most important things.
Wolfgang
P.S. the most stable DBMS I know is Oracle, and with MySQL sometimes I
had problems with corrupt tables. And I know that even MS SQL is not
completely immune against data corruption...
--
do you have experiences with the stability of Postgresql? This is IMHO
one of the most important things.
Wolfgang
P.S. the most stable DBMS I know is Oracle, and with MySQL sometimes I
had problems with corrupt tables. And I know that even MS SQL is not
completely immune against data corruption...
Karl Faller
Apr 15, 2017, 1:29:46 PM4/15/17
to
Hi Wolfgang,
>Hi Karl,
>
>do you have experiences with the stability of Postgresql?
Not personally, as i'm to small - that said, since i installed it, i
never had any issue with the server running...
>This is IMHO
>one of the most important things.
AFAIS, the mantra of the core members of the community is "Data
integrity". One can hear sometimes folks moaning, how "difficult" it
can be to get a patch committed, but in the end, it is to the benefit
of all to keep the level as high as possible.
Given, that enterprise like Skype, flightaware, Zalando, Caixa Bank,
and up to very recent, Uber, use it, i doubt "we" will encounter any
problem here ;-)
I think, they have a lively "usergroup" in Italy, which organizes
meetings and conferences - and these are affordable (even for amateurs
like me <g>) the next might be
https://www.postgresql.org/about/event/2071/ in June
HTH
Karl
>Wolfgang
>
>P.S. the most stable DBMS I know is Oracle, and with MySQL sometimes I
>had problems with corrupt tables. And I know that even MS SQL is not
>completely immune against data corruption...
>
>
>Karl Faller wrote:
>
>> On Sat, 15 Apr 2017 17:49:58 +0200, Wolfgang Riedmann wrote:
>>
>> > and it seems very, very interesting.
>> It is, certainly. Keep in mind, that the book is on 9.4 level, if you
>> have a look through the "what's new" of 9.5 and especially 9.6, the
>> progress is breathtaking. That said, V10 is due for, IIRC, September,
>> and usually they are very good in their timing...
>>
>> Karl
Regards
Karl
>Hi Karl,
>
>do you have experiences with the stability of Postgresql?
never had any issue with the server running...
>This is IMHO
>one of the most important things.
integrity". One can hear sometimes folks moaning, how "difficult" it
can be to get a patch committed, but in the end, it is to the benefit
of all to keep the level as high as possible.
Given, that enterprise like Skype, flightaware, Zalando, Caixa Bank,
and up to very recent, Uber, use it, i doubt "we" will encounter any
problem here ;-)
I think, they have a lively "usergroup" in Italy, which organizes
meetings and conferences - and these are affordable (even for amateurs
like me <g>) the next might be
https://www.postgresql.org/about/event/2071/ in June
HTH
Karl
>Wolfgang
>
>P.S. the most stable DBMS I know is Oracle, and with MySQL sometimes I
>had problems with corrupt tables. And I know that even MS SQL is not
>completely immune against data corruption...
>
>
>Karl Faller wrote:
>
>> On Sat, 15 Apr 2017 17:49:58 +0200, Wolfgang Riedmann wrote:
>>
>> > and it seems very, very interesting.
>> It is, certainly. Keep in mind, that the book is on 9.4 level, if you
>> have a look through the "what's new" of 9.5 and especially 9.6, the
>> progress is breathtaking. That said, V10 is due for, IIRC, September,
>> and usually they are very good in their timing...
>>
>> Karl
Karl
Wolfgang Riedmann
Apr 15, 2017, 11:58:21 PM4/15/17
to
Hi Karl,
> > do you have experiences with the stability of Postgresql?
> Not personally, as i'm to small - that said, since i installed it, i
> never had any issue with the server running...
the biggest problems with data integrity I have my MySQL are on single
> > do you have experiences with the stability of Postgresql?
> Not personally, as i'm to small - that said, since i installed it, i
> never had any issue with the server running...
user PCs. They sometimes are only switched of, loose the power, ...
I had never any issue with MySQL on my webservers that are running in a
closed datacenter, and they have really heavily used databases.
> > This is IMHO
> > one of the most important things.
> AFAIS, the mantra of the core members of the community is "Data
> integrity". One can hear sometimes folks moaning, how "difficult" it
> can be to get a patch committed, but in the end, it is to the benefit
> of all to keep the level as high as possible.
Linux on my Linux servers: they release only when the thing is stable,
and maintain it for a long time. As I have seen, with Progresql it is
the same...
> Given, that enterprise like Skype, flightaware, Zalando, Caixa Bank,
> and up to very recent, Uber, use it, i doubt "we" will encounter any
> problem here ;-)
otherwise....
> I think, they have a lively "usergroup" in Italy, which organizes
> meetings and conferences - and these are affordable (even for amateurs
> like me <g>) the next might be
> https://www.postgresql.org/about/event/2071/ in June
partecipate in only discussions like this, and not going to any events
( Xbase.Future is the only one that I see as must, but unfortunately
this year I'm away for holiday ).
Wolfgamg
--
Johan Nel
Apr 16, 2017, 2:51:01 AM4/16/17
to
Hi Wolfgang,
If you need assistance, I am more than willing to assist with PG. I never had any issues with PG even with "just turning off" my local PC. Even had a server that had a hardware failure. Recreated a new machine with same version, copy the data folder over onto the new machine and voila up and running again. It has a Write Ahead Log (WAL) that it will by default use at startup if any issues are found with the database. There is quite detail documentation about it.
Regards,
--
Johan Nel
George, South Africa
George, South Africa
|
Virus-free. www.avast.com |
Karl Faller
Apr 16, 2017, 5:00:23 AM4/16/17
to
Wolfgang,
>the biggest problems with data integrity I have my MySQL are on single
>user PCs. They sometimes are only switched of, loose the power, ...
as Johan said, WAL takes care of that - Data is either "hard" on disk,
or not written at all...
>> Given, that enterprise like Skype, flightaware, Zalando, Caixa Bank,
>> and up to very recent, Uber, use it, i doubt "we" will encounter any
>> problem here ;-)
>
>these are not the sort of companies I like or I see as examples
>otherwise....
<g> - only wanted to demonstrate folks like these can't and wouln't
afford to work with something "unreliable"...
if you need to tap into some grounds really "foreign" to you, there
are possibilites to get first hand info, and that for affordable
prices.
Would love to go to X#future, but strictly economically spoken, i
can't justiy my spending for FOX, - another at least 1k my wife would
kill me ;-)
Karl
>the biggest problems with data integrity I have my MySQL are on single
>user PCs. They sometimes are only switched of, loose the power, ...
or not written at all...
>> Given, that enterprise like Skype, flightaware, Zalando, Caixa Bank,
>> and up to very recent, Uber, use it, i doubt "we" will encounter any
>> problem here ;-)
>
>these are not the sort of companies I like or I see as examples
>otherwise....
afford to work with something "unreliable"...
>
>> I think, they have a lively "usergroup" in Italy, which organizes
>> meetings and conferences - and these are affordable (even for amateurs
>> like me <g>) the next might be
>> https://www.postgresql.org/about/event/2071/ in June
>
>I'm not the ideal person for such events, unfortunately. I prefer to
>partecipate in only discussions like this, and not going to any events
Understood. As above, wanted to show: community is active & growing,
>> I think, they have a lively "usergroup" in Italy, which organizes
>> meetings and conferences - and these are affordable (even for amateurs
>> like me <g>) the next might be
>> https://www.postgresql.org/about/event/2071/ in June
>
>I'm not the ideal person for such events, unfortunately. I prefer to
>partecipate in only discussions like this, and not going to any events
if you need to tap into some grounds really "foreign" to you, there
are possibilites to get first hand info, and that for affordable
prices.
Would love to go to X#future, but strictly economically spoken, i
can't justiy my spending for FOX, - another at least 1k my wife would
kill me ;-)
Karl
Wolfgang Riedmann
Apr 16, 2017, 5:55:47 AM4/16/17
to
Hi Johan,
> If you need assistance, I am more than willing to assist with PG.
thank you very much! I hope to not need assistance....
It looks like I will have to port my SQL library to Postgresql (after
having it for Firebird and SQLite)... May be I will post these 3
libraries complete with the Base SQL lib on my server...
> I
> never had any issues with PG even with "just turning off" my local
> PC. Even had a server that had a hardware failure. Recreated a new
> machine with same version, copy the data folder over onto the new
> machine and voila up and running again. It has a Write Ahead Log
> (WAL) that it will by default use at startup if any issues are found
> with the database. There is quite detail documentation about it.
this is good to hear! I'll install it onto my development machine and
remove Firebird (and save a yearly amount for the database manager I
need for Firebird). Maybe the PG people needs a few bucks...
What I would miss is a "local database" like ADS local server. Firebird
has one, but it does not works very well.... So I better use SQLite for
that.
Wolfgang
--
> If you need assistance, I am more than willing to assist with PG.
It looks like I will have to port my SQL library to Postgresql (after
having it for Firebird and SQLite)... May be I will post these 3
libraries complete with the Base SQL lib on my server...
> I
> never had any issues with PG even with "just turning off" my local
> PC. Even had a server that had a hardware failure. Recreated a new
> machine with same version, copy the data folder over onto the new
> machine and voila up and running again. It has a Write Ahead Log
> (WAL) that it will by default use at startup if any issues are found
> with the database. There is quite detail documentation about it.
remove Firebird (and save a yearly amount for the database manager I
need for Firebird). Maybe the PG people needs a few bucks...
What I would miss is a "local database" like ADS local server. Firebird
has one, but it does not works very well.... So I better use SQLite for
that.
Wolfgang
--
Johan Nel
Apr 16, 2017, 6:17:24 AM4/16/17
to
Hi Wolfgang,
On 2017/04/16 11:55, Wolfgang Riedmann
wrote:
What I would miss is a "local database" like ADS local server. Firebirdhas one, but it does not works very well.... So I better use SQLite for that.
Just use PostgreSQL it has a small memory footprint. On my personal
computer I run 8.4, 9.0 - 9.6 and my computer still start up in 5
seconds
---
---
Sherlock
Apr 16, 2017, 8:36:34 AM4/16/17
to
All VO'ers
Maybe this one reply can deal with all your comments and suggestions.
We use MySQL for like 15 years.. for web but not a solution for applications on say clients servers and other limitations. One issue is since Oracle bought it it is NOT FREE when use non privately and not on a webserver. Read the fine print and is $1000 US per server per year. I bought out a company who wrote a system and had 80 sites and it was $80k USD per annum. We have no budget for this. With say DBF/FPT and you are running a file structure and have say host for say 80 clients you have to add prefix and do other things to manage the data.
With POSTGRES you have "schemas" and can work the same as folders.. magic.
Recomment only install PS 9.6+ and use the installers from "EnterpriseDB".
PG is stable, rock solid, local, we server, Linux, windows and Amazon, GOogle you name it is covered. The DATASERVER work is a native wrapper around PG and not an ODBC setup which I found was missing functionality. With PG you have so many more data types so the CDMLN types of DBF can be 127 types in PG.
How to move forward and I have another VOers wanting to use it commercially and not sure how to proceed financially. I need to get it somewhat documented with samples so you can run your own tests. We are using in 100% everyday and built proof. One great thing about PG is national JSON and JSONB and as developers JSON Is everywhere for document exchange and data interchange.
What would be the interest and how can this group work to train others.
We have teams work totally with web and others totally desktop and POSTGRES we can all use interchangeably. MySQL is no competitor to MySQL which good and reliable is just not as good and comprehensive as a product. The licensing for PG is FREE for private and commercial use. Simple as that.
Phil
Maybe this one reply can deal with all your comments and suggestions.
We use MySQL for like 15 years.. for web but not a solution for applications on say clients servers and other limitations. One issue is since Oracle bought it it is NOT FREE when use non privately and not on a webserver. Read the fine print and is $1000 US per server per year. I bought out a company who wrote a system and had 80 sites and it was $80k USD per annum. We have no budget for this. With say DBF/FPT and you are running a file structure and have say host for say 80 clients you have to add prefix and do other things to manage the data.
With POSTGRES you have "schemas" and can work the same as folders.. magic.
Recomment only install PS 9.6+ and use the installers from "EnterpriseDB".
PG is stable, rock solid, local, we server, Linux, windows and Amazon, GOogle you name it is covered. The DATASERVER work is a native wrapper around PG and not an ODBC setup which I found was missing functionality. With PG you have so many more data types so the CDMLN types of DBF can be 127 types in PG.
How to move forward and I have another VOers wanting to use it commercially and not sure how to proceed financially. I need to get it somewhat documented with samples so you can run your own tests. We are using in 100% everyday and built proof. One great thing about PG is national JSON and JSONB and as developers JSON Is everywhere for document exchange and data interchange.
What would be the interest and how can this group work to train others.
We have teams work totally with web and others totally desktop and POSTGRES we can all use interchangeably. MySQL is no competitor to MySQL which good and reliable is just not as good and comprehensive as a product. The licensing for PG is FREE for private and commercial use. Simple as that.
Phil
Wolfgang Riedmann
Apr 16, 2017, 3:07:14 PM4/16/17
to
Hi Phil,
of course, if you are willing to share your sources, I'm willing to
pay, and maybe port to X#.
Wolfgang
--
of course, if you are willing to share your sources, I'm willing to
pay, and maybe port to X#.
Wolfgang
glor...@gmail.com
Apr 17, 2017, 4:33:01 PM4/17/17
to
On Wednesday, April 12, 2017 at 12:38:59 PM UTC-5, 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
> Is there is an easy alternative to the Advantage Database Server.
> It looks like that there is no further development.
>
Are you sure? We still use ADS which is now owned by SAP.
https://www.sap.com/cmp/dg/crm-xu15-int-ads12ddm/index.html
https://www.sap.com/product/data-mgmt/advantage-database-server.html
a...@aib.org.nz
Apr 17, 2017, 8:15:53 PM4/17/17
to
On Thursday, 13 April 2017 05:38:59 UTC+12, 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
I looked at Mediator recently. It's at www.otc.pl
> Is there is an easy alternative to the Advantage Database Server.
> It looks like that there is no further development.
>
> Juergen
This translates ISAM database instructions into SQL. I works for Harbour and probably for VO as well - I'm about to confirm this.
Your Harbour or VO application connects to Mediator and Mediator connects to SQL. I installed version 5 and tested it successfully with Harbour and MySQL but have found out that I have to downgrade to version 4 to get VO working.
No need to change your code, just recompile with different libraries/RDDs.
Chris.
a...@aib.org.nz
Apr 17, 2017, 8:20:03 PM4/17/17
to
Rene J. Pajaron
Apr 18, 2017, 6:52:57 AM4/18/17
to
Hey Phil,
Joining FOX program this June, and very interested to know if the class you have can be migrated to X# and ADO.NET.
Our cloud apps are now PostgreSQL hosted at Azure, and only our core banking remains in ADS.
--
Rene
Joining FOX program this June, and very interested to know if the class you have can be migrated to X# and ADO.NET.
Our cloud apps are now PostgreSQL hosted at Azure, and only our core banking remains in ADS.
--
Rene
Rene J. Pajaron
Apr 18, 2017, 7:05:26 AM4/18/17
to
--
Rene
Sherlock
Apr 18, 2017, 8:20:24 AM4/18/17
to
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
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
James Martin
Apr 18, 2017, 8:21:27 AM4/18/17
to
Did you check the speed?
James
James
Rene J. Pajaron
Apr 18, 2017, 8:45:27 AM4/18/17
to
Hey Phil,
Very interesting. Although I already do have Excel to ADS Table converter (also works in reverse) written in C# using ADS ADO.NET classes, planning to make a RDD like classes all in C# to mimic functionality of VO-Dataserver using Devart dotConnect for PostgreSQL which our cloud apps are already based upon.
I keep this in mind when I start that one and with X#, I can migrate our apps to PostgreSQL with minimal changes.
--
Rene
Very interesting. Although I already do have Excel to ADS Table converter (also works in reverse) written in C# using ADS ADO.NET classes, planning to make a RDD like classes all in C# to mimic functionality of VO-Dataserver using Devart dotConnect for PostgreSQL which our cloud apps are already based upon.
I keep this in mind when I start that one and with X#, I can migrate our apps to PostgreSQL with minimal changes.
--
Rene
Sherlock
Apr 18, 2017, 8:46:22 AM4/18/17
to
James
Question re speed to me... I assume.
It is very fast.
We were badly affected with SMB issues, memos huge.
It is definitely 15 times faster than it was.
DBF/FPT system on Terminal Server works great but on a LAN is not that good with the throttling of shared files.
With SQL / Postgres you are using IP address.
Have not tested yet moving all the data to say AMAZON, VM with Postgres or native PG installation with VO app.
All is work for us and our main commercially applications we have moved to DELPHI or C#. However even their future will be replaced with 100% web applications.
Phil
Phil
Question re speed to me... I assume.
It is very fast.
We were badly affected with SMB issues, memos huge.
It is definitely 15 times faster than it was.
DBF/FPT system on Terminal Server works great but on a LAN is not that good with the throttling of shared files.
With SQL / Postgres you are using IP address.
Have not tested yet moving all the data to say AMAZON, VM with Postgres or native PG installation with VO app.
All is work for us and our main commercially applications we have moved to DELPHI or C#. However even their future will be replaced with 100% web applications.
Phil
Phil
James Martin
Apr 18, 2017, 9:48:37 AM4/18/17
to
Good to hear. I was wondering about the speed of Mediator.
James
James
Wolfgang Riedmann
Apr 18, 2017, 2:24:27 PM4/18/17
to
Hi Phil,
thanks, this sounds very, very interesting!
Wolfgang
--
thanks, this sounds very, very interesting!
Wolfgang
a...@aib.org.nz
Apr 18, 2017, 6:21:35 PM4/18/17
to
On Wednesday, 19 April 2017 00:21:27 UTC+12, James Martin wrote:
> Did you check the speed?
>
> James
>
> Did you check the speed?
>
> James
>
Marc Verkade
Apr 19, 2017, 12:00:21 PM4/19/17
to
Hey all,
I have done the transition from DBF to SQL Server in 2015 by creating a
MC_SQLDbf class with VO2ADO which acted exactly like a DBFServer.
Next to that I created a mechanism to transform a repository containing a
DBF Bake-it (our main VO application) to a new repository with a SQL Bake-it
by using Reposcript (very nice piece of software!) and some replacement
mechanism.
Also I created a DBF to SQL application which synchronized DBF tables to SQL
at certain intervals so Bake-it SQL and Bake-it DBF could be used
simultaneously more or less.
In that way our developers could still work on the Bake-it DBF version and
when we want, generate a SQL Bake-it on the fly.
The project took me about 3 months work over a period of 9 months but
finally everything went well and after we converted some 'sluggish' routines
to stored procedures on the server, it was lightning fast too!
I did take a look at the SQL classes of Geoff Schaller but these were to
complicated for us to use and I decided to write my own SQL wrapper. Also
had some help from Robert which is a great guy creating great software!
To keep thing fast, I created a mechanism to only load data when needed and
made sure I eliminated all full-table scans by using the SQL profiler.
At the end I only had to change a few windows, the way our selection windows
were working (which loaded all records when starting) and routines to speed
up things with code like:
If Universe:IsSQL
// Do this by using a stored procedure
Else
// Do that the DBF or DBFSQL way
End
The hard part was to change our Crystal Reports routines and convert the
>800 reports we had created through the years but even this was not that
hard when I learned our guys how to do that and made a nice manual.
The very nice part was that development could still take place in a DBF
environment and a Bake-it SQL could be generated on-the-fly with the Bake-it
SQL Converter application (screenshot at
http://www.extravestiging.nl/download/BakeItSQLConverter.jpg ) which created
a completely fresh Bake-it SQL repository based on the Bake-it DBF
repository, compiled the libraries and created a fresh Bake-itSQL.Exe
At the end, this process and Bake-it SQL were working very well, was stable,
lightning fast when using stored procedures at certain places and was ready
for testing and deployment.
Here the project of the Bake-It SQL Converter... perhaps somebody finds it
useful... http://www.extravestiging.nl/download/BakeItSQLConverter.zip
But then, the management of Marti, my old company, for which I did this
project decided to pull the plug because nobody at Marti wanted to develop
in VO anymore and there was no expertise to maintain Bake-it SQL and
eventually convert VO to X#... They probably did not think I was able to
complete the DBF to SQL transition and were waiting for me to fail.... But I
managed to deliver a fully working, lightning fast Bake-it SQL which nobody
wanted to maintain...
A pity... It was a nice project.... but now a dead project...
Even more a pity when considering over 400 companies work on a daily basis
with Bake-it in The Netherlands. IMHO the DBF to SQL transition could be a
nice step in the future for them especially when Bake-it would be converted
to X# which would not be that hard since we did not use very exotic stuff in
our code... And Robert did manage to convert Bake-it to Vulcan in the past
and showed it in Cologne many years ago.... But VO is now in maintenance
mode at Marti, nothing new going on and no new people wanting to learn xBase
/ VO or X#...
Thanx everybody for VO and especially Brian for saving VO from the evil CA,
Robert for making VO stable and fast, Frans for teaching me VO, Don, Mr.
Parker, Phil, Paul P, Geoff, Chris, Rod, Dick, Sherlock, Gary, Fabrice, Ed,
Adriano, Meinhard and all others I forgot to mention... It was nice knowing
you all!
It was very nice using VO, for me it was a very productive and successful
product, but those days are over since I only do ASP.Net, C# and VB.Net
nowadays... I plan to to X# in the future but I am too busy to make time for
that right now.
Regards, Marc
"D.J.W. van Kooten" schreef in bericht
news:fiv2fc9jk415f326n...@4ax.com...
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
I have done the transition from DBF to SQL Server in 2015 by creating a
MC_SQLDbf class with VO2ADO which acted exactly like a DBFServer.
Next to that I created a mechanism to transform a repository containing a
DBF Bake-it (our main VO application) to a new repository with a SQL Bake-it
by using Reposcript (very nice piece of software!) and some replacement
mechanism.
Also I created a DBF to SQL application which synchronized DBF tables to SQL
at certain intervals so Bake-it SQL and Bake-it DBF could be used
simultaneously more or less.
In that way our developers could still work on the Bake-it DBF version and
when we want, generate a SQL Bake-it on the fly.
The project took me about 3 months work over a period of 9 months but
finally everything went well and after we converted some 'sluggish' routines
to stored procedures on the server, it was lightning fast too!
I did take a look at the SQL classes of Geoff Schaller but these were to
complicated for us to use and I decided to write my own SQL wrapper. Also
had some help from Robert which is a great guy creating great software!
To keep thing fast, I created a mechanism to only load data when needed and
made sure I eliminated all full-table scans by using the SQL profiler.
At the end I only had to change a few windows, the way our selection windows
were working (which loaded all records when starting) and routines to speed
up things with code like:
If Universe:IsSQL
// Do this by using a stored procedure
Else
// Do that the DBF or DBFSQL way
End
The hard part was to change our Crystal Reports routines and convert the
>800 reports we had created through the years but even this was not that
hard when I learned our guys how to do that and made a nice manual.
The very nice part was that development could still take place in a DBF
environment and a Bake-it SQL could be generated on-the-fly with the Bake-it
SQL Converter application (screenshot at
http://www.extravestiging.nl/download/BakeItSQLConverter.jpg ) which created
a completely fresh Bake-it SQL repository based on the Bake-it DBF
repository, compiled the libraries and created a fresh Bake-itSQL.Exe
At the end, this process and Bake-it SQL were working very well, was stable,
lightning fast when using stored procedures at certain places and was ready
for testing and deployment.
Here the project of the Bake-It SQL Converter... perhaps somebody finds it
useful... http://www.extravestiging.nl/download/BakeItSQLConverter.zip
But then, the management of Marti, my old company, for which I did this
project decided to pull the plug because nobody at Marti wanted to develop
in VO anymore and there was no expertise to maintain Bake-it SQL and
eventually convert VO to X#... They probably did not think I was able to
complete the DBF to SQL transition and were waiting for me to fail.... But I
managed to deliver a fully working, lightning fast Bake-it SQL which nobody
wanted to maintain...
A pity... It was a nice project.... but now a dead project...
Even more a pity when considering over 400 companies work on a daily basis
with Bake-it in The Netherlands. IMHO the DBF to SQL transition could be a
nice step in the future for them especially when Bake-it would be converted
to X# which would not be that hard since we did not use very exotic stuff in
our code... And Robert did manage to convert Bake-it to Vulcan in the past
and showed it in Cologne many years ago.... But VO is now in maintenance
mode at Marti, nothing new going on and no new people wanting to learn xBase
/ VO or X#...
Thanx everybody for VO and especially Brian for saving VO from the evil CA,
Robert for making VO stable and fast, Frans for teaching me VO, Don, Mr.
Parker, Phil, Paul P, Geoff, Chris, Rod, Dick, Sherlock, Gary, Fabrice, Ed,
Adriano, Meinhard and all others I forgot to mention... It was nice knowing
you all!
It was very nice using VO, for me it was a very productive and successful
product, but those days are over since I only do ASP.Net, C# and VB.Net
nowadays... I plan to to X# in the future but I am too busy to make time for
that right now.
Regards, Marc
"D.J.W. van Kooten" schreef in bericht
news:fiv2fc9jk415f326n...@4ax.com...
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
Sherlock
Apr 20, 2017, 7:57:43 AM4/20/17
to
Marc
Fine words and completely understand the journey.
We needed a way forward with minimal code changes and it works.
The project completely developed from scratch only relies on Dataserver and no other libraries or other systems code.
The goal was not really to take VO forward but more to move our data into SQL for use from many other languages we deal with. In the long term VO will not be there but it is nice to know say X# is option DotNet world.
But when you have legacy systems you have to do what you have to do to keep it going and move forward.
Phil [ Sherlock ]
Fine words and completely understand the journey.
We needed a way forward with minimal code changes and it works.
The project completely developed from scratch only relies on Dataserver and no other libraries or other systems code.
The goal was not really to take VO forward but more to move our data into SQL for use from many other languages we deal with. In the long term VO will not be there but it is nice to know say X# is option DotNet world.
But when you have legacy systems you have to do what you have to do to keep it going and move forward.
Phil [ Sherlock ]
frans...@gmail.com
Dec 30, 2019, 3:37:24 AM12/30/19
to
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,
>
> 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.
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
> 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 looks like that there is no further development.
> >
> 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.
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
Wolfgang Riedmann
Jan 6, 2020, 10:55:55 AM1/6/20
to
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
--
> Is there is an easy alternative to the Advantage Database Server you
> mentioned before because the dead horse gets heavier and heavier.
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
--
Jindřich Žák
Oct 23, 2023, 1:22:44 PM10/23/23
to
Dne středa 19. dubna 2017 v 18:00:21 UTC+2 uživatel Marc Verkade napsal:
I was interested in your project, but unfortunately it is no longer available.
Could you restore the link?
Thank you
Could you restore the link?
Thank you
0 new messages