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 2 of 3 — ← Prev page 1 [2] 3 Next page →
| From | Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> |
|---|---|
| Date | 2017-04-15 18:14 +0200 |
| Message-ID | <afh4fchcbsj663u6ra2kb7n7a7nk3kft06@4ax.com> |
| In reply to | #10454 |
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
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-04-15 18:22 +0200 |
| Message-ID | <elevmsF6d3nU1@mid.individual.net> |
| In reply to | #10455 |
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... 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 --
[toc] | [prev] | [next] | [standalone]
| From | Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> |
|---|---|
| Date | 2017-04-15 19:29 +0200 |
| Message-ID | <d8l4fchaulshoiu4uib1078q010ca8pep8@4ax.com> |
| In reply to | #10456 |
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
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-04-16 05:58 +0200 |
| Message-ID | <elg8esFdmm9U1@mid.individual.net> |
| In reply to | #10457 |
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 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. I like this approach, and it is one of the reasons I'm using Debian 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 ;-) these are not the sort of companies I like or I see as examples 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 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 ( Xbase.Future is the only one that I see as must, but unfortunately this year I'm away for holiday ). Wolfgamg --
[toc] | [prev] | [next] | [standalone]
| From | Karl Faller <mail_withoutthat_@_drei-f_andthat_.de> |
|---|---|
| Date | 2017-04-16 11:00 +0200 |
| Message-ID | <40c6fc51o03stu4490femcjs2n9mu5p4md@4ax.com> |
| In reply to | #10458 |
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"... > >> 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, 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
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-04-16 11:55 +0200 |
| Message-ID | <elgtd1FhefoU1@mid.individual.net> |
| In reply to | #10454 |
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 --
[toc] | [prev] | [next] | [standalone]
| From | Sherlock <sherlock@sherlock.com.au> |
|---|---|
| Date | 2017-04-16 05:36 -0700 |
| Message-ID | <02a18f2c-72eb-41b1-b963-f868cf1d5133@googlegroups.com> |
| In reply to | #10460 |
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
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-04-16 21:07 +0200 |
| Message-ID | <elhtmvFnks8U1@mid.individual.net> |
| In reply to | #10461 |
Hi Phil, of course, if you are willing to share your sources, I'm willing to pay, and maybe port to X#. Wolfgang Sherlock wrote: > 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 --
[toc] | [prev] | [next] | [standalone]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2017-04-18 04:05 -0700 |
| Message-ID | <a611e873-1ab6-44e6-8fee-0380293c0375@googlegroups.com> |
| In reply to | #10462 |
On Monday, April 17, 2017 at 3:07:14 AM UTC+8, Wolfgang Riedmann wrote: > Hi Phil, > > of course, if you are willing to share your sources, I'm willing to > pay, and maybe port to X#. > > Wolfgang > > > Sherlock wrote: > > > 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 > > > > -- Me too... very interested too.. -- Rene
[toc] | [prev] | [next] | [standalone]
| From | Sherlock <sherlock@sherlock.com.au> |
|---|---|
| Date | 2017-04-18 05:20 -0700 |
| Message-ID | <0514a045-f7bf-4ce1-a2aa-ac83594f2310@googlegroups.com> |
| In reply to | #10469 |
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
[toc] | [prev] | [next] | [standalone]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2017-04-18 05:45 -0700 |
| Message-ID | <7d231ec0-683c-44ef-86b5-b332c447dcd9@googlegroups.com> |
| In reply to | #10471 |
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 On Tuesday, April 18, 2017 at 8:20:24 PM UTC+8, Sherlock wrote: > 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
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-04-18 20:24 +0200 |
| Message-ID | <eln3uqFo4dsU1@mid.individual.net> |
| In reply to | #10471 |
Hi Phil, thanks, this sounds very, very interesting! Wolfgang Sherlock wrote: > 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 --
[toc] | [prev] | [next] | [standalone]
| From | "Rene J. Pajaron" <rjpajaron@gmail.com> |
|---|---|
| Date | 2017-04-18 03:52 -0700 |
| Message-ID | <545d1557-d5a8-40ad-9278-0715f227fc77@googlegroups.com> |
| In reply to | #10461 |
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 On Sunday, April 16, 2017 at 8:36:34 PM UTC+8, Sherlock wrote: > 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
[toc] | [prev] | [next] | [standalone]
| From | "Marc Verkade" <marc@marc.marc> |
|---|---|
| Date | 2017-04-19 18:00 +0200 |
| Message-ID | <od81cn$ke1$1@dont-email.me> |
| In reply to | #10447 |
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:fiv2fc9jk415f326n2j12j9156kdgqvh5f@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
[toc] | [prev] | [next] | [standalone]
| From | Sherlock <sherlock@sherlock.com.au> |
|---|---|
| Date | 2017-04-20 04:57 -0700 |
| Message-ID | <b40749dd-71d3-41c5-bbed-6d6309da8158@googlegroups.com> |
| In reply to | #10478 |
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 ]
[toc] | [prev] | [next] | [standalone]
| From | Jindřich Žák <keivulan@gmail.com> |
|---|---|
| Date | 2023-10-23 10:22 -0700 |
| Message-ID | <7d04f057-5266-4cc4-b871-f4e6488ce397n@googlegroups.com> |
| In reply to | #10478 |
Dne středa 19. dubna 2017 v 18:00:21 UTC+2 uživatel Marc Verkade napsal: > 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 was interested in your project, but unfortunately it is no longer available. Could you restore the link? Thank you
[toc] | [prev] | [next] | [standalone]
| From | Jürgen Knauf <trotterklaus@googlemail.com> |
|---|---|
| Date | 2017-04-14 23:46 -0700 |
| Message-ID | <bb26cdc4-804c-44ea-9596-80edb952e2d9@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 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
[toc] | [prev] | [next] | [standalone]
| From | "Wolfgang Riedmann" <wriedmann@gmail.com> |
|---|---|
| Date | 2017-04-15 09:42 +0200 |
| Message-ID | <ele17aFi15U1@mid.individual.net> |
| In reply to | #10449 |
Hi Jürgen, > > 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 it is no further developed, and prefers SQLite as local storage. Wolfgang --
[toc] | [prev] | [next] | [standalone]
| From | gloroveo@gmail.com |
|---|---|
| Date | 2017-04-17 13:32 -0700 |
| Message-ID | <b33609a1-63f6-4ce8-9b0c-aa745aaa8928@googlegroups.com> |
| In reply to | #10418 |
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 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
[toc] | [prev] | [next] | [standalone]
| From | aib@aib.org.nz |
|---|---|
| Date | 2017-04-17 17:15 -0700 |
| Message-ID | <42da18cc-8ef5-475e-99af-bb1b4e0dcbe0@googlegroups.com> |
| In reply to | #10418 |
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 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.
[toc] | [prev] | [next] | [standalone]
Page 2 of 3 — ← Prev page 1 [2] 3 Next page →
Back to top | Article view | comp.lang.clipper.visual-objects
csiph-web