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


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

Database recommendation NOTHING SAP

Started byMartin <Martin@spam.spam>
First post2018-06-06 09:21 +0100
Last post2018-06-22 09:25 +0200
Articles 14 — 8 participants

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


Contents

  Database recommendation NOTHING SAP Martin <Martin@spam.spam> - 2018-06-06 09:21 +0100
    Re: Database recommendation NOTHING SAP "Wolfgang Riedmann" <wriedmann@gmail.com> - 2018-06-06 11:20 +0200
      Re: Database recommendation NOTHING SAP Martin <Martin@spam.spam> - 2018-06-06 11:14 +0100
      Re: Database recommendation NOTHING SAP "Rene J. Pajaron" <rjpajaron@gmail.com> - 2018-06-12 00:22 -0700
      Re: Database recommendation NOTHING SAP Gerhard Bunzel <g.bunzel@domonet.de> - 2018-06-16 18:34 +0200
    Re: Database recommendation NOTHING SAP Sherlock <sherlock@sherlock.com.au> - 2018-06-07 05:12 -0700
      Re: Database recommendation NOTHING SAP Martin <Martin@spam.spam> - 2018-06-08 12:43 +0100
    Database recommendation NOTHING SAP moshe attia <attiamx@gmail.com> - 2018-06-14 00:20 -0700
      Re: Database recommendation NOTHING SAP Glenn Keeler <glennkeeler@shaw.ca> - 2018-06-14 14:59 -0700
        Re: Database recommendation NOTHING SAP "Wolfgang Riedmann" <wriedmann@gmail.com> - 2018-06-15 07:11 +0200
          Re: Database recommendation NOTHING SAP Glenn Keeler <glennkeeler@shaw.ca> - 2018-06-15 08:00 -0700
    Re: Database recommendation NOTHING SAP Franz Rachbauer <office@rachbauer.org> - 2018-06-18 09:18 +0200
      Re: Database recommendation NOTHING SAP moshe attia <attiamx@gmail.com> - 2018-06-20 01:12 -0700
        Re: Database recommendation NOTHING SAP Franz Rachbauer <office@rachbauer.org> - 2018-06-22 09:25 +0200

#11679 — Database recommendation NOTHING SAP

FromMartin <Martin@spam.spam>
Date2018-06-06 09:21 +0100
SubjectDatabase recommendation NOTHING SAP
Message-ID<pf85i5$ouf$1@dont-email.me>
We need to start very soon on moving to a new database.

Currently we are 95% ISAM using ADS

We have 2 years to move to something else.

Any ideas please?

Decent performance is critical.

Anyone have the home address of the main person at SAP?

Want to join in a protest?

[toc] | [next] | [standalone]


#11680

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2018-06-06 11:20 +0200
Message-ID<fnpnbjF1c3iU1@mid.individual.net>
In reply to#11679
Hi Martin,

> We need to start very soon on moving to a new database.
> 
> Currently we are 95% ISAM using ADS
> 
> We have 2 years to move to something else.
> 
> Any ideas please?

My suggestion:

PostgreSQL

Open source, very powerful, runs on Linux and Windows. Easy to install.

Wolfgang


-- 

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


#11681

FromMartin <Martin@spam.spam>
Date2018-06-06 11:14 +0100
Message-ID<pf8c73$168$1@dont-email.me>
In reply to#11680
Thanks

I do not know the details but it appears ADS is being wound down slowly.

On 06/06/2018 10:20, Wolfgang Riedmann wrote:
> Hi Martin,
> 
>> We need to start very soon on moving to a new database.
>>
>> Currently we are 95% ISAM using ADS
>>
>> We have 2 years to move to something else.
>>
>> Any ideas please?
> 
> My suggestion:
> 
> PostgreSQL
> 
> Open source, very powerful, runs on Linux and Windows. Easy to install.
> 
> Wolfgang
> 
> 

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


#11694

From"Rene J. Pajaron" <rjpajaron@gmail.com>
Date2018-06-12 00:22 -0700
Message-ID<c03479a8-844e-4f0f-9de5-8b68b5c05d91@googlegroups.com>
In reply to#11680
On Wednesday, June 6, 2018 at 5:20:54 PM UTC+8, Wolfgang Riedmann wrote:
> Hi Martin,
> 
> > We need to start very soon on moving to a new database.
> > 
> > Currently we are 95% ISAM using ADS
> > 
> > We have 2 years to move to something else.
> > 
> > Any ideas please?
> 
> My suggestion:
> 
> PostgreSQL
> 
> Open source, very powerful, runs on Linux and Windows. Easy to install.
> 
> Wolfgang
> 
> 
> --

We are using PostgreSQL 10 (latest build is 10.4) and 11 is now on beta.

global PostgreSQL development group is very active 

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


#11706

FromGerhard Bunzel <g.bunzel@domonet.de>
Date2018-06-16 18:34 +0200
Message-ID<pg3e6d$1vr$1@news-1.m-online.net>
In reply to#11680
Hi all,

I'm also very interested for using Postgres in the future. Does anyone 
have a sample - maybe with using bBrowser - please?
What is the best connection to Postgres - Vo2ADO or ODBC or ??

Thanks in advance.

Best regards

Gerhard Bunzel


Am 06.06.2018 um 11:20 schrieb Wolfgang Riedmann:
> Hi Martin,
> 
>> We need to start very soon on moving to a new database.
>>
>> Currently we are 95% ISAM using ADS
>>
>> We have 2 years to move to something else.
>>
>> Any ideas please?
> 
> My suggestion:
> 
> PostgreSQL
> 
> Open source, very powerful, runs on Linux and Windows. Easy to install.
> 
> Wolfgang
> 
> 

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


#11682

FromSherlock <sherlock@sherlock.com.au>
Date2018-06-07 05:12 -0700
Message-ID<a265b6f9-2d09-445f-87c2-07a3c65db346@googlegroups.com>
In reply to#11679
Martin

POSTGRES without a doubt..

We have 10 years experience now with 3 products in the wild and 2 internal systems. Excellent product.

PG hosting lots of choice or on premises and Windows or Linux.

Phil

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


#11687

FromMartin <Martin@spam.spam>
Date2018-06-08 12:43 +0100
Message-ID<pfdq5c$hka$1@dont-email.me>
In reply to#11682
Thanks all


Oh and my boss was premature, 2 years active development, then support 
only at present.



On 07/06/2018 13:12, Sherlock wrote:
> Martin
> 
> POSTGRES without a doubt..
> 
> We have 10 years experience now with 3 products in the wild and 2 internal systems. Excellent product.
> 
> PG hosting lots of choice or on premises and Windows or Linux.
> 
> Phil
> 

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


#11699

Frommoshe attia <attiamx@gmail.com>
Date2018-06-14 00:20 -0700
Message-ID<71c8781b-e8b5-410d-9df2-6ceb193faeae@googlegroups.com>
In reply to#11679
https://mariadb.org
very easy db ..odbc connecting

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


#11701

FromGlenn Keeler <glennkeeler@shaw.ca>
Date2018-06-14 14:59 -0700
Message-ID<a8d6d3bc-1797-4ebc-8465-377ac52e761e@googlegroups.com>
In reply to#11699
On Thursday, 14 June 2018 01:20:49 UTC-6, moshe attia  wrote:
> https://mariadb.org
> very easy db ..odbc connecting

Now that we have had all these good recommendations, does anyone have a good whitepaper or other guide to shifting from Advantage/xBase to mySQL or PostgreSQL?

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


#11703

From"Wolfgang Riedmann" <wriedmann@gmail.com>
Date2018-06-15 07:11 +0200
Message-ID<foh04rFe1r0U1@mid.individual.net>
In reply to#11701
Hi Glenn,

> Now that we have had all these good recommendations, does anyone have
> a good whitepaper or other guide to shifting from Advantage/xBase to
> mySQL or PostgreSQL?

the major problem with this is that xBase/Advantage are record
oriented, and all SQL database are result oriented.
With xBase/Advantage you are working directly on the database file, an
SQL servers let you work on disconnected data.

IMHO an application to be moved over to SQL needs a compete redesign,
but an Italian company wrote a MySQL RDD. Most of things worked, but
for some windows they needed to redesign them.

Wolfgang 


-- 

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


#11704

FromGlenn Keeler <glennkeeler@shaw.ca>
Date2018-06-15 08:00 -0700
Message-ID<570c8fce-9d42-407a-b453-d2aab0496fb1@googlegroups.com>
In reply to#11703
> IMHO an application to be moved over to SQL needs a compete redesign,
> but an Italian company wrote a MySQL RDD. Most of things worked, but
> for some windows they needed to redesign them.

Thanks Wolfgang.

Since I also work with MySQL outside of VO, I am pretty familiar with the differences in record vs result orientation, and so I completely accept your advice that a redesign is necessary. 

What I was hoping for, though, was a whitepaper that outlined exactly this kind of change in thinking and typical design patterns and illustrated them in VO. 

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


#11707

FromFranz Rachbauer <office@rachbauer.org>
Date2018-06-18 09:18 +0200
Message-ID<pg7mbv$1981$2@gioia.aioe.org>
In reply to#11679
Hi Martin,
you can find a nearly record oriented approach using SQLTable for MySQL, 
including record locking for multiuser access under

http://www.rachbauer.org/TestMySQL.zip

Maybe it helps for switching from DBF to SQL. Requirements described in 
module _Start/!Readme!

Regards, Franz

---
Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
https://www.avast.com/antivirus

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


#11709

Frommoshe attia <attiamx@gmail.com>
Date2018-06-20 01:12 -0700
Message-ID<97731a24-472b-448b-bd6a-32f3a623d26c@googlegroups.com>
In reply to#11707
On Monday, June 18, 2018 at 10:18:25 AM UTC+3, Franz Rachbauer wrote:
> Hi Martin,
> you can find a nearly record oriented approach using SQLTable for MySQL, 
> including record locking for multiuser access under
> 
> http://www.rachbauer.org/TestMySQL.zip
> 
> Maybe it helps for switching from DBF to SQL. Requirements described in 
> module _Start/!Readme!
> 
> Regards, Franz
> 
> ---
> Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
> https://www.avast.com/antivirus

hi
Very Good example...
i allways use SQLSelect with MyISAM .

thank you.
moshe

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


#11714

FromFranz Rachbauer <office@rachbauer.org>
Date2018-06-22 09:25 +0200
Message-ID<pgi89j$ue0$1@gioia.aioe.org>
In reply to#11709
Hi Moshe,
with MyIsam it's not possible to do transactions and this is necessary 
to keep consistant states in db.

Franz

Am 20.06.2018 um 10:12 schrieb moshe attia:
> On Monday, June 18, 2018 at 10:18:25 AM UTC+3, Franz Rachbauer wrote:
>> Hi Martin,
>> you can find a nearly record oriented approach using SQLTable for MySQL,
>> including record locking for multiuser access under
>>
>> http://www.rachbauer.org/TestMySQL.zip
>>
>> Maybe it helps for switching from DBF to SQL. Requirements described in
>> module _Start/!Readme!
>>
>> Regards, Franz
>>
>> ---
>> Diese E-Mail wurde von Avast Antivirus-Software auf Viren geprüft.
>> https://www.avast.com/antivirus
> 
> hi
> Very Good example...
> i allways use SQLSelect with MyISAM .
> 
> thank you.
> moshe
> 

[toc] | [prev] | [standalone]


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


csiph-web