Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-07-19 Thread Vailton Renato
About RDD we are working now and start an outline that must be done quickly on the features offered, points that still need adjustments and a roadmap. About xDevStudio I am testing an implementation of gettext in it, but not yet finished writing it because I'm working too into help routines. I ho

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-07-15 Thread Massimo Belgrano
Hi renato Have you same update news regarding sqlrdd & xdevstudio? 2009/6/7 Vailton Renato > > AFAIK we still miss something like Mediator or SQLRDD. > > We here in Brazil we have developed and tested a new RDD based on SQL > LIB that will work similar to SQLRDD and the Mediator and to be > subm

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-08 Thread Mindaugas Kavaliauskas
Hi, Viktor Szakáts wrote: Or, RDDSQL itself may track these changes and automatically generate the UPDATE/INSERT requests to SQL server. Given that the recordset can be the result of any kind of queries, this doesn't seem to be doable (seemed a good idea for a few minutes though :). The probl

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-08 Thread Viktor Szakáts
I see. Overall to me RDDSQL looks like a proper and common wrapper implementation to our existing and not very much compatible solutions: HBPGSQL, HBMYSQL, HBFBIRD and HBODBC. And instead of direct API calls and Harbour classes it makes this functionality accessible through the existing Harbour

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-08 Thread Lorenzo Fiorini
On Mon, Jun 8, 2009 at 9:18 AM, Viktor Szakáts wrote: > I see. Overall to me RDDSQL looks like a proper and common wrapper > implementation to our existing and not very much compatible solutions: > HBPGSQL, HBMYSQL, HBFBIRD and HBODBC. And instead of direct > API calls and Harbour classes it makes

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-08 Thread Viktor Szakáts
Thanks Przemek. Useful insights, they confirm my concerns. Actually, since I see no chances that we will have an open source Mediator clone any time soon, for me the best option still seems remote access, and that means GTNET. Currently you solve it on *nix servers only, but it would be very good

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-08 Thread Przemyslaw Czerpak
On Mon, 08 Jun 2009, Szak�ts Viktor wrote: Hi, > I see. Overall to me RDDSQL looks like a proper and common wrapper > implementation to our existing and not very much compatible solutions: > HBPGSQL, HBMYSQL, HBFBIRD and HBODBC. And instead of direct > API calls and Harbour classes it makes this

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-08 Thread Viktor Szakáts
Hi Mindaugas, >> RDDSQL can make a very nice one-way interface to SQL DBs. > > I'm not sure what you mean by saying "one-way". Do you mean it is a read > only? The answer is: Yes and No. > > It does not generate hidden queries. It means, that >   SOMEFIELD := value > will not generate SQL query an

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Sudip Bhattacharyya
Hello Angel, Thanks a lot. Regards. Sudip Angel Pais wrote: > > HI Sudip > > > Sudip Bhattacharyya escribió: >> Hello Angel Pais, >> >> I felt really bad reading your mail. > > That wasn`t the intention. Just a general warning. I've seen this happen > in xharbour.org. When there where f

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Mindaugas Kavaliauskas
Hi, one more letter about RDDSQL. Actually it was not asked yet, but I feel it is a naturally the next question. Does RDDSQL supports indexing? The answer is: Yes and No. :) Well, actually I would say much much more Yes, than No. RDDSQL DOES NOT generates hidden queries. Code: DBUSEAREA

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Mindaugas Kavaliauskas
Hi, RDDSQL can make a very nice one-way interface to SQL DBs. I'm not sure what you mean by saying "one-way". Do you mean it is a read only? The answer is: Yes and No. It does not generate hidden queries. It means, that SOMEFIELD := value will not generate SQL query and execute "UPDATE

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Mindaugas Kavaliauskas
Massimo Belgrano wrote: with sqlrdd and mediatior you can migrate with very little changes in the xBase source code. Only to declare the RDD, a function call to connect to the database and a substitution for the function file() for an equivalent that returns the presence of the table Hi, yes

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Viktor Szakáts
Hi Mindaugas, >>> For me f.e. it's not very clear what is the difference >>> between xhb SQLRDD and our RDDSQL. > > Victor, please read below. It's an old text, but I deleted some complicated > parts, replaced some old names with new one hoping that it will help to > catch the main idea. If it is

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Vailton Renato
In my view are different tools for different purposes. ___ Harbour mailing list Harbour@harbour-project.org http://lists.harbour-project.org/mailman/listinfo/harbour

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Massimo Belgrano
> > Massimo, you are making things more confusing (as it happens many times). Sorry for my confusing and for my bad English >> sqlrdd from harbour com can be used as complete replacement for an >> application written using dbfcdx > > These is no such thing "harbour com", there is xharbour.com. Ple

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Mindaugas Kavaliauskas
Hi, Massimo, you are making things more confusing (as it happens many times). sqlrdd from harbour com can be used as complete replacement for an application written using dbfcdx These is no such thing "harbour com", there is xharbour.com. Please, feel the difference between harbour and xhar

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Vailton Renato
This project is being developed under USRRDD and we are finalizing the SEEK with indices compounds (two or more fields) and providing some examples and details of the resources that we have done and are missing (not yet 100% complete because there are many details involved) We plan that accept the

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Viktor Szakáts
Hi Vailton, Sounds very good. Brdgs, Viktor On Sun, Jun 7, 2009 at 9:14 PM, Vailton Renato wrote: >> AFAIK we still miss something like Mediator or SQLRDD. > > We here in Brazil we have developed and tested a new RDD based on SQL > LIB that will work similar to SQLRDD and the Mediator and to be

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Viktor Szakáts
On Sun, Jun 7, 2009 at 9:17 PM, Massimo Belgrano wrote: > Here i can help you > sqlrdd from harbour com can be used as complete replacement for an > application written using dbfcdx > you must change file("test.dbc") to sr_file() and optimise set filter, > populating intelligent recorset for having

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Massimo Belgrano
it is a very good information i know that your product are always good : SQL LIB RDD& xDevStudio do you plan submit to harbour? 2009/6/7 Vailton Renato : >> AFAIK we still miss something like Mediator or SQLRDD. > > We here in Brazil we have developed and tested a new RDD based on SQL > LIB that

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Massimo Belgrano
Here i can help you sqlrdd from harbour com can be used as complete replacement for an application written using dbfcdx you must change file("test.dbc") to sr_file() and optimise set filter, populating intelligent recorset for having better performance I have converted one big application in few da

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Vailton Renato
> AFAIK we still miss something like Mediator or SQLRDD. We here in Brazil we have developed and tested a new RDD based on SQL LIB that will work similar to SQLRDD and the Mediator and to be submitted soon... We hope to finalize some details to release this tool together with source code for acce

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Szakáts Viktor
Guys, Few times I see issues here which would better appear on a user list, and I agree that an - active - user list and also "evangelist" work would really do good service for Harbour, but this very thread certainly wasn't among those ones. Just take it easy, I'm sure you've misinterpreted some

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Sudip Bhattacharyya
Hello Angel Pais, I felt really bad reading your mail. I joined this list advised by Pritpal Bedi, when I started using GTWVG and faced many problems. IMHO, he advised me to join in this list, because my queries may be helpful for betterment of the software, or I shall get answers from "develope

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Sudip Bhattacharyya
Hello Xavi, Thanks a lot for your mail. I was waiting for your mail :) >Learn SQL! MySQL and PostgreSQL are servers of SQL and this means that .- >SQL it's used for abstracted physical data from the application using it. >You send text SQL commands to server and receives, if no error, aff

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-07 Thread Xavi
Hi Sudip and everybody, I'm not an "expert in-depth" in PostgreSQL but of course I'll try my best. what should be "your" suggestion to start with - MySql, PostgreSql or any other? Learn SQL! MySQL and PostgreSQL are servers of SQL and this means that .- SQL it's used for abstracted ph

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-05 Thread Sudip Bhattacharyya
Hello Xavi, > So... How many times faster than postgres should be? 8-) hmm... Ok no > marketing with postgres. :) May be I am out of the track, but I can't resist myself to know about PostgreSql from you ;) I have no experience about prosgreSql. I have little experience about MySql. In HMG Forum

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-05 Thread Xavi
So, how can we use it? May be a silly question, ... It's a very intelligent question but ... even if free, would be better than other solutions to choose wisely. It's 5 times faster than Oracle hmm... Ok costly 5 times more. :( So... How many times faster than postgres should be? 8-)

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-05 Thread Sudip Bhattacharyya
Pritpal Bedi wrote: > > Yep > > > Angel Pais wrote: >> >> Not published in their site. >> So expect a very restrictive and expensive one. >> Some old mesages (googled) talk about $175.000 per CPU >> > > Cache is a costly database. That is why I never dared to offer this lib. > > Regards

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-04 Thread Pritpal Bedi
Yep Angel Pais wrote: > > Not published in their site. > So expect a very restrictive and expensive one. > Some old mesages (googled) talk about $175.000 per CPU > Cache is a costly database. That is why I never dared to offer this lib. Regards Pritpal Bedi -- View this message in context:

Re: [Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-04 Thread Massimo Belgrano
Compliment,Compliment,Compliment Impressive also Documentation This can be a great opportunity for most developer so it is a special day for most of us with few line we can integrate our application with InterSystems Caché®, we are working with a high-performance object database that runs SQL five

[Harbour] A Real-time RDBMS RDD for Harbour Family of Compilers

2009-06-04 Thread Pritpal Bedi
Hello Everybody Today is a special day in my life and I have decided to share one of my best developments with all of you. Let me introduce CacheRDD, a real-time RDBMS RDD for Harbour family of compilers. This is the FIRST RDD in whole history of xbase dialect that is a TRUE RDBMS RDD. Please v