sqlmix

[Paola Bruccoleri]

Hi all ..
(sorry my english)
someone is using this RDD in production? I guess it will be simplerto
use with the contribution of mysql that brings harbor (the libmysql)
From what I understand, intended to be similar to sqlrdd, but this
additionbe commercial, for now only available for harbor and xHarbour.
Any comments are welcome, thank you very much

[DaNiEl MaXiMiLiAnO]

Hola Paola: no interprete bien tu mensaje en Harbour List hacerca del RDD y que necesitas

Saludos

                DaNIEl MaXiMiLiAnO

---

De: Paola Bruccoleri <pbruc...@adinet.com.uy>
Para: Lista Harbour-users <harbou...@googlegroups.com>
Enviado: jueves, 26 de julio de 2012 19:51
Asunto: [harbour-users] sqlmix

-- You received this message because you are subscribed to the Google
Groups "Harbour Users" group.
Unsubscribe: harbour-users+unsub...@googlegroups.com
Web: http://groups.google.com/group/harbour-users

[Filip Stoklosa]

Any comments are welcome, thank you very much

I tried to use, i noticed few things:

1. commands

index on ...
set index to ... 

are not working the same way as for dbfntx

2. function

dbcommitall

causes error (I opened dbfntx and sqlmix tables at the same time)

3. although there is written that sqlmix and arrayrdd is the same (?) there was a small differences during tests

4. I think the idea of SQLMIX described in /contrib/rddsql/readme.txt is very good.

5. It might be worth to add function "update" within the meaning of:

dbusearea( ... "SQLMIX"...)
repl ...
dbupdatearea()

Regards
Filip

[M.FACCIO adinet]

ENG

Hi Paola

Please review Massimo document about SQLMIX and RDD, and also user an developer list comments about usage.
https://docs.google.com/document/d/1HKSB9igyS8fBCZzL2enoXrgc9i4DHpItqVp149h5mS0/edit#bookmark=id.sq3v48pqa71k

I am using in production successfully with MYSQL, with SQLITE (i've found some GPFs and some workarrounds, but basically it is working, I will post the results of my test.) And also ARRAYRDD (creating "DBF" files on the fly on memory so I achieve amazing speedups for totalizations etc.

You must understand that what you obtain is APPEND to a ARRAYRDD, the content of the SQL QUERY, if you need to update SQL tables, you need to send RDDINFO execute commands.
 RDDINFO(RDDI_EXECUTE, "INSERT INTO country values ('URU', 'Uruguay',3000000)")

That ARRAYRDD database you can manage just like a DBF, with some limitations, like relations, dbcommit, and other methods not implemented. But you can browse, index, etc.
Feel free to contact me in Spanish (I'm from Paysandù, Uruguay). But keep posting in English in this list to help other not Spanish users.


Maurizio


SPA


Por favor revisa el documento de Massimo SQLMIX y RDD, y también la lista de desarrolladores y usuarios acerca de su uso.
https://docs.google.com/document/d/1HKSB9igyS8fBCZzL2enoXrgc9i4DHpItqVp149h5mS0/edit#bookmark=id.sq3v48pqa71k


Estoy utilizando en la producción con éxito con MySQL, SQLite (que he encontrado algunos GPF y workarrounds algunos, pero básicamente está funcionando, voy a postear los resultados de mis tests.) Y ARRAYRDD también (la creación de archivos "dbf" sobre la marcha de la memoria, así he conseguido aceleraciones increíbles para totalizaciones etc

  Debes entender que lo que obtenemos es hacer un APPEND a un ARRAYRDD, del contenido de la consulta SQL, si necesitas actualizar las tablas de SQL, es necesario enviar RDDINFO_EXECUTE commands
  RDDINFO (RDDI_EXECUTE, "INSERT INTO valores de los países ('URU', 'Uruguay', 3000000)")

Esa base de datos ARRAYRDD puede administrar como un DBF, con algunas limitaciones, como las relaciones, los dbcommit, y otros métodos no implementados. Sin embargo,  puedes browsear, índexar, etc


Saludos

[Paola Bruccoleri]

El 26/07/2012 10:38 p.m., DaNiEl MaXiMiLiAnO escribió:

Hola Paola: no interprete bien tu mensaje en Harbour List hacerca del RDD y que necesitas

Saludos

                DaNIEl MaXiMiLiAnO

Hola Daniel..
es que he visto que hablan de este RDD que aparentemente sirve para acceder a cualquier motor de base de datos usando la misma sintaxis que siempre hemos usado con las dbfs, tal como lo hace el SQLRDD, que es de pago (y funciona con xharbour/borland bcc).
Quizás no se llame así... no sé.. estoy investigando esto
Muchas gracias!

buscando en los mensajes de la lista, hay uno de Massimo Belgrano del 12/05/10 que empieza:

afaik last version of rddado is not working in harbour (after ole modification)
rddsql is best choice
AFAIK RDDSQL talk directly with the sql language
this is message post by Mindaugas Kavaliauskas on this  list
.....
	
Architecture


              +-------------+
              |             |
              | SQLMIX RDD  |
              |             |
              +-------------+
                   |  ^
                   V  |
              +-------------+    +---------+
              |             |--->|         |
              | SQLBASE RDD |    |   SDD   |
              |             |<---|         |
              +-------------+    +---------+

---

De: Paola Bruccoleri <pbruc...@adinet.com.uy>
Para: Lista Harbour-users <harbou...@googlegroups.com>
Enviado: jueves, 26 de julio de 2012 19:51
Asunto: [harbour-users] sqlmix

Hi all ..
(sorry my english)
someone is using this RDD in production? I guess it will be simplerto use with the contribution of mysql that brings harbor (the libmysql)
From what I understand, intended to be similar to sqlrdd, but this additionbe commercial, for now only available for harbor and xHarbour.
Any comments are welcome, thank you very much

-- You received this message because you are subscribed to the Google
Groups "Harbour Users" group.
Unsubscribe: harbour-users+unsub...@googlegroups.com
Web: http://groups.google.com/group/harbour-users

Se certificó que el correo no contiene virus.
Comprobada por AVG - www.avg.es
Versión: 2012.0.2197 / Base de datos de virus: 2437/5157 - Fecha de la versión: 26/07/2012

--
You received this message because you are subscribed to the Google
Groups "Harbour Users" group.

Unsubscribe: harbour-user...@googlegroups.com
Web: http://groups.google.com/group/harbour-users