Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Has anybody used VFP with MySQL?
Message
From
11/02/2002 13:35:28
 
General information
Forum:
Linux
Category:
Databases and Admin issues
Miscellaneous
Thread ID:
00616069
Message ID:
00618473
Views:
30
Ingres began as a project at UC Berkley to develop a RDBMS. It was then sold to Ingres Corp.

Postgres began as a project at UC Berkley to develop an Object RDBMS after Ingres. PostreSQL is a merging of Postgres and SQL.

Although some postings on the Internet claim that Postgres is based on Ingres, it is my understanding that Postgres was built from the ground up with new code.

>PostgreSQL is, IMO, a better designed engine. Most features were designed in from the beginning and not added as an after thought. (Ingress came from an earlier version of PostgreSQL.) Several features that are really powerful is the ability to use more than one languge in UDFs, to inherit from other tables, and UDFs themselves. UDFs are not as powerful as Oracle's package paradigm, but the PostgreSQL UDF commands are, in many instances, indentical to Oracles.
>Speed used to be a problem with PostgreSQL but it is not a problem now. Witht he latest release, 7.2, users can continue using PostgreSQL while the admin does a vacuum. In prior releases everyone had to quite PostgreSQL before the admin could do a vacuum. MySQL is good for medium to light stuff, but repeated experience has shown that it breaks down under heavy loads.
>JLK
>
>
>
>>
>>My biggest complaint about VFP has been the lack of security on the tables. Several of my users discovered that word and excel could get to the tables (normally I would have thought this was a good thing) and did not use release the connections correctly. This caused me major grief in many ways.
>>
>>John
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform