Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #11679 > unrolled thread
| Started by | Martin <Martin@spam.spam> |
|---|---|
| First post | 2018-06-06 09:21 +0100 |
| Last post | 2018-06-22 09:25 +0200 |
| Articles | 14 — 8 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | Martin <Martin@spam.spam> |
|---|---|
| Date | 2018-06-06 09:21 +0100 |
| Subject | Database 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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2018-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]
| From | Martin <Martin@spam.spam> |
|---|---|
| Date | 2018-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]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2018-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]
| From | Gerhard Bunzel <g.bunzel@domonet.de> |
|---|---|
| Date | 2018-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]
| From | Sherlock <sherlock@sherlock.com.au> |
|---|---|
| Date | 2018-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]
| From | Martin <Martin@spam.spam> |
|---|---|
| Date | 2018-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]
| From | moshe attia <attiamx@gmail.com> |
|---|---|
| Date | 2018-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]
| From | Glenn Keeler <glennkeeler@shaw.ca> |
|---|---|
| Date | 2018-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]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2018-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]
| From | Glenn Keeler <glennkeeler@shaw.ca> |
|---|---|
| Date | 2018-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]
| From | Franz Rachbauer <office@rachbauer.org> |
|---|---|
| Date | 2018-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]
| From | moshe attia <attiamx@gmail.com> |
|---|---|
| Date | 2018-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]
| From | Franz Rachbauer <office@rachbauer.org> |
|---|---|
| Date | 2018-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