General information
Category:
Databases and Admin issues
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only