Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
V6s5, How to UNC to an internet served database
Message
From
07/01/2004 05:29:13
Dorin Vasilescu
ALL Trans Romania
Arad, Romania
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00863850
Message ID:
00864544
Views:
17
This message has been marked as a message which has helped to the initial question of the thread.
Hi

>
>I have 2 other names on the list MySQL and FireBird as backend dataabses any suggestions?

A year ago I choosed Firebird from same two options (Postgres hadn't Windows version at that time) . I have no regrets yet and I'm very pleased to work with Firebird. MySQL has a lot of table handlers and table types and lacks features that I can't work the way I need without.

OTOH, Firebird has a well designed database engine, with record versioning (this means no lock escalation or lock conflicts for both read or write transactions, easy online backup and automatic crash recovery) and very flexible trigger support (unlimited number of BEFORE or AFTER triggers and posibility to specify trigger execution order)

I've almost finished a services API wrapper class for Firebird (will work probably with Interbase too).
Using this class, one can easyly invoke database maintenace (backup/restore), get database statistics or set database properties, add or modify users in security database, all within VFP applications. I think that I can post the class in download section soon.

Dorin

>>In addition to WC and WS (Martin's suggestion), there is ActiveVFP (http://www.activevfp.com/activevfp.asp). There are also some others listed on the link. I haven't used them so I can't intelligently comment on them.
>
>All these alternative will keep us with FoxPro as a database, right?
>
>I have 2 other names on the list MySQL and FireBird as backend dataabses any suggestions?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform