On Friday 14 November 2003 01:36, Devdas Bhagat wrote: > On 13/11/03 22:19 +0530, Narayana wrote: > > Hello, > > Please start a totally new thread when you want to deal with a diferent > topic. > Your In-Reply-to header stays the same which breaks threaded clients > like mutt. > > > We are discussing about the implementation of Open source software in > > an academic environment (precisely on a University scale). The > > problem is whether to consider PostGreSQL or MySQL for the same. > > Do you need raw speed? Do you need transactions? ACID compliance? > Complex SQL queries? Views? Triggers? Stored Procedures?
SQL compliance? Reliability? Data integrity? Overloadable functions and operators? Schemas? High concurrent performace? So much for postgresql... For mysql, do you need windows support?..:-) > > > There is a debate that OS databases like the above mentioned have > > some disadvantages. > > Neither ships with tools for data mining. Neither has built in > development tools. Unless development and client libraries do not count in. Perhaps you meant GUI and IDE tools. > > So I wanted to find out as to whether it is really true. > > Are there any specific disadvantages ( from the technology > > implementation point of view , like usability, scalability etc.) > > from using PostGreSQL or MySQL in a University campus IT > > Implementation...?? > > AFAIK, PostgreSQL scales far better than MySQL, particularly as the > number of concurrent connections increases. Yes. MVCC helps a lot. Few useful links for postgresql. http://advocacy.postgresql.org/ http://tehdocs.postgresql.org/ http://advocacy.postgresql.org/ Find similar ones for mysql. That will give you(OP) good picture.. Shridhar ------------------------------------------------------- This SF.Net email sponsored by: ApacheCon 2003, 16-19 November in Las Vegas. Learn firsthand the latest developments in Apache, PHP, Perl, XML, Java, MySQL, WebDAV, and more! http://www.apachecon.com/ _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
