FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour for my culture
damianodec
Posts: 434
Joined: Wed Jun 06, 2007 02:58 PM
for my culture
Posted: Fri Mar 08, 2013 07:26 PM

Hi,
what kind of database used for your FWH application (DBF,SQL, ADS...) ?
how many users are connected to the database (about) ?
thank to all

FiveWin for xHarbour 24.02 - Feb. 2024 - Embarcadero C++ 7.60 for Win32 Copyright (c) 1993-2023

FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 - Harbour 3.2.0dev (r1904111533)

Visual Studio 2019 - Pelles C V.8.00.60 (Win64)
damianodec
Posts: 434
Joined: Wed Jun 06, 2007 02:58 PM
Re: for my culture
Posted: Sat Mar 09, 2013 03:17 PM

Nobody helps me?

FiveWin for xHarbour 24.02 - Feb. 2024 - Embarcadero C++ 7.60 for Win32 Copyright (c) 1993-2023

FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 - Harbour 3.2.0dev (r1904111533)

Visual Studio 2019 - Pelles C V.8.00.60 (Win64)
Rick Lipkin
Posts: 2706
Joined: Fri Oct 07, 2005 01:50 PM
Re: for my culture
Posted: Sat Mar 09, 2013 04:57 PM

damianodec

There is no good answer to your question .. Things to consider for the type of database to use depends on your audience and their infrastructure.

My personal opinion is this :

1) .dbf\cdx is great for local applications to be run on a single computer or shared on a network for a small group of people. If your audience grows to multiple locations over a wide area network Advantage Database server would be the next logical step.

My personal favorite is to use ADO to be able to manipulate Sql Client\Server databases such as Ms Access, MS Sql Server, Oracle, etc. Generally you code once and only change the 'connection string' for the different RDMS. As a bonus Microsoft gives you the ADO connectivity client for Ms Access and MS Sql Server on every Desktop from WinXP thru Windows 8... Oracle, dB2 and MySql will need clients to be loaded on each desktop running your application. I chose to use Ms Access and Ms Sql Server.

Here is a good write up on how ADO works with FiveWin :

http://wiki.fivetechsoft.com/doku.php?i ... uffss=ado

Rick Lipkin

&

Rimantas
Posts: 437
Joined: Fri Oct 07, 2005 12:56 PM
Re: for my culture
Posted: Sat Mar 09, 2013 05:12 PM
Rick Lipkin wrote:
My personal favorite is to use ADO to be able to manipulate Sql Client\Server databases such as Ms Access, MS Sql Server, Oracle, etc. Generally you code once and only change the 'connection string' for the different RDMS. As a bonus Microsoft gives you the ADO connectivity client for Ms Access and MS Sql Server on every Desktop from WinXP thru Windows 8... Oracle, dB2 and MySql will need clients to be loaded on each desktop running your application. I chose to use Ms Access and Ms Sql Server.

Rick Lipkin


Not so true , Rick ... :-) . Simply MySql , with which I'm working , only needs connection string . Native lib works perfect and with a good speed in Harbour + Fwh app. Also I'm using the same MySql database from Internet ( JavaScript + PhP app ) . So need only did all work in client server ( install Wamp and install mine Harbour + Fwh app ) and all enterprise local network clients can work with mine program . Also through Internet too . Nothing requires for clients PC . Only create desktop link from server to Harbour app or save Internet address as Favorite in browser ... :-)
Rimantas U.
Rick Lipkin
Posts: 2706
Joined: Fri Oct 07, 2005 01:50 PM
Re: for my culture
Posted: Sat Mar 09, 2013 05:13 PM

Rimantas

Thank you for your correction ..

Rick

damianodec
Posts: 434
Joined: Wed Jun 06, 2007 02:58 PM
Re: for my culture
Posted: Sat Mar 09, 2013 07:36 PM

Thanks,
So, do you think that FWH & mysql is a very good choice?

FiveWin for xHarbour 24.02 - Feb. 2024 - Embarcadero C++ 7.60 for Win32 Copyright (c) 1993-2023

FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 - Harbour 3.2.0dev (r1904111533)

Visual Studio 2019 - Pelles C V.8.00.60 (Win64)
Rick Lipkin
Posts: 2706
Joined: Fri Oct 07, 2005 01:50 PM
Re: for my culture
Posted: Sat Mar 09, 2013 08:49 PM

damianodec

There is nothing wrong with MySql+Fwh .. many successful friends here use MySql and Daniel Garcia-Gil's TDolphan Library

http://tdolphin.blogspot.com/

Rick Lipkin

ADutheil
Posts: 368
Joined: Sun May 31, 2009 06:25 PM
Re: for my culture
Posted: Sat Mar 09, 2013 09:47 PM

I followed the MySQL path an never looked back. TDolphin helps a lot.

Regards,



André Dutheil

FWH 13.04 + HB 3.2 + MSVS 10
Daniel Garcia-Gil
Posts: 2365
Joined: Wed Nov 02, 2005 11:46 PM
Re: for my culture
Posted: Sun Mar 10, 2013 12:04 AM

Hello

if you plan is use more than one database engine (postgres, oracle, mysql server, etc), the best way is ADO, the big difference between ADO and Mysql API (used by TDolphin) with Mysql API you dont need install any ODBC client, not need create DSN, only need a dll and link a library

our best documentation is the source code
Isla de Margarita Venezuela.
danielgarciagil@gmail.com
http://tdolphin.blogspot.com/
https://www.dropbox.com/referrals/NTI5Njk4MDc1OQ?src=global9
MarcoBoschi
Posts: 1091
Joined: Thu Nov 17, 2005 11:08 AM
Re: for my culture
Posted: Mon Mar 11, 2013 04:18 PM

LAN
DBFCDX
twenty users
an average of 50,000 records modified every day
about a hundred touched tables every day in about 900 tables
bye

Marco Boschi
info@marcoboschi.it
damianodec
Posts: 434
Joined: Wed Jun 06, 2007 02:58 PM
Re: for my culture
Posted: Mon Mar 11, 2013 05:20 PM

ciao Marco,
in una LAN con tre sedi distaccate pensi sia una buona scelta?
grazie per l'eventuale risposta.

FiveWin for xHarbour 24.02 - Feb. 2024 - Embarcadero C++ 7.60 for Win32 Copyright (c) 1993-2023

FWH 64 for Harbour 19.06 (MSVC++) Jun. 2019 - Harbour 3.2.0dev (r1904111533)

Visual Studio 2019 - Pelles C V.8.00.60 (Win64)

Continue the discussion

Static archive · New replies & topics via GitHub Discussions