Harbour and SQL: help build a a list

[Francesco Perillo]

I'd like to build a list of "methods" to use a SQL database from harbour.

It should be a ragionated list that describes the pros and cons of the method, validate the status of the code, supported OS, and provide some sample.

SQLMIX, TDoplhin, ADO Harbour, hbmysql, hbodbc, hgpgsql, rddsql... etc etc etc...

Can you please tell which lib you use and if it works?

Thank you

Francesco

[Guillermo Varona Silupú]

Hi Francesco

I am testing tDolphin, so far everything is fine.

Ref.: http://tdolphin.blogspot.com/

BR

GVARONAS

[Jayadev U]

Hi Francesco,

 

I have used SqlMix+MySql and ADORdd+MsSql with good results.

 

Warm regards,

 

Jayadev

--
--
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

---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to harbour-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/harbour-users/CADPHLr9wsJ-euD6D5OyP6B8fM0v%2B79wW3MFgXjV6XUkTAJx7YQ%40mail.gmail.com.

[David Field]

Hi Francesco,

SQLMIX by itself has nothing to do with SQL, it is an array or in memory DBF rdd.

RddSql+SQLMIX

I've used RddSql+SQLMIX, rddsql does the actual interface with SQL and SQLMIX presents the data retrieved as if a DBF file.

My experience with this was about 6 years ago and it seems to have been updated 15 months ago so some of this may no longer be true.

Pros: It seems to work with any SQL engine, my use was with MS SQL.

Cons: You can´t actually update the data by updating the in memory dbf presented by SQLMIX, you have to execute a SQL command.

I had problems with connection and no way to reconnect, also some problems with dates

HBMySql

Pros: I have not used in production, but have tested. Works very well and it is fast. 

Cons: Limited to MySql engine, could have some more methods to facilitate use.

HBODBC

Was my first attempt  with SQL. Can´t remember why but I immediately discarded.

TDolphin

Have not used, but again, limited to MySql and MariaDB

ADODB

Have been using for the last 5 years with MS SQL, MySql, MariaDB and SQLite

Pros: 

1. Works with any SQL engine, DBF file, Access, Excel

2. With the exception of a few differences between SQL commands from each engine, you can reuse or use your programming with any SQL engine.

3. Each connector is optimized by the makers of the specified SQL engine

4. You can work with several SQL engines at the same time.

5. It advises when your current record is no longer valid because of changes made by another user or process.

6. Many methods and properties that make it easy to use as accustomed by DBF users (FIND, SORT, FILTER, EOF, BOF, Move(n), MoveFirst(),MoveLast(), AddNew(),etc)

7. Used by all mayor MS products, PHP, etc

8. Good error system that allows you to identify the problem and recover within programming

9. I like the fact that you can identify added, modified or deleted records and can batch update records.

Cons;

(?) You must install the connector to the SQL engine you want to work with.

It is slower than HbMySql but hardly noticeable.

Regards,

David Field

[Anand K Gupta]

ADODB
Have been using for the last 5 years with MS SQL, MySql, MariaDB and SQLite
Pros:
1. Works with any SQL engine, DBF file, Access, Excel
2. With the exception of a few differences between SQL commands from each engine, you can reuse or use your programming with any SQL engine.
3. Each connector is optimized by the makers of the specified SQL engine
4. You can work with several SQL engines at the same time.
5. It advises when your current record is no longer valid because of changes made by another user or process.
6. Many methods and properties that make it easy to use as accustomed by DBF users (FIND, SORT, FILTER, EOF, BOF, Move(n), MoveFirst(),MoveLast(), AddNew(),etc)
7. Used by all mayor MS products, PHP, etc
8. Good error system that allows you to identify the problem and recover within programming
9. I like the fact that you can identify added, modified or deleted records and can batch update records.
Cons;
(?) You must install the connector to the SQL engine you want to work with.
It is slower than HbMySql but hardly noticeable.

Hi David,

I felt interested in it and want to check how I can use it for accessing both DBF and MySql Database I use in HMG MG.

But the first search link shows it is for PHP

https://adodb.org/dokuwiki/doku.php

Can I use it with HMG ?

I want to parallel access of both DBF and MySQL data in my application.

Please guide.

Regards,

Anand

Thanks

Anand

Working from Home

--
--
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

---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to harbour-user...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/harbour-users/44bf94e7-30aa-4e05-9ab9-80a2bd5d869f%40googlegroups.com.

[David Field]

Hello,

You can download sqlado.rar from https://groups.google.com/forum/m/#!forum/ado-harbour

Ado.prg has a clases DBADO that facilitates the use of the recordset and access to fields values.

If you have any questions or comments you may join the group.

Regards
David Field

[Anand K Gupta]

Thanks David

I have already joined the group.

I will post question there now.

Regards,

Anand

--
--
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

---
You received this message because you are subscribed to the Google Groups "Harbour Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to harbour-user...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/harbour-users/03e0688e-dfee-4056-8990-4c9fa6399ce7%40googlegroups.com.