Re: [OT] MySQL vs PostgreSQL and SAP DB (was RE: Struts and LargeResultSet)
Peter A. J. Pilgrim wrote: Robert J. Sanford, Jr. wrote: For my money, or the lack thereof :), I would much rather use PostgreSQL or SAP DB than MySQL for both feature AND, believe it or not, performance reasons. One of the developers on the SourceForge project did a very nice comparison of how SF would run on both MySQL and PostgreSQL and he was very surprised at the results. You can read about it at: http://www.phpbuilder.com/columns/tim2705.php3. Of course, he was using PHP instead of Struts :) The article appears to be lauding MySQL features albeit 1999 on some speed issues. I definitely miss the subselect SQL syntax which is definitely useful with Oracle and Sybase. MySQL 4.0 Beta is out and wait for it. Full Text Match capabilities. Is this the end of Lucene or eSearch ? No. I like the bit about not returning the whole table of data if the query matches more than half the number of rows in the database table. ... I personally think a DBMS should give you what you ask for :-) I've seen enough times when I actually *did* need to pull back that much data, that it would really tick me off if my DBMS made such a judgement call for me. That seems quite arrogant to me ... It should be the developer's job to determine what comes back; not the DBMS's job. As for LargeResultSets I don't think Sybase has rowset limit optimisation. Oracle I know a ROWID reverse keyword or is it ROWINDEX I cant remember. PostgreSQL has this functionality too -- and it's ACID-compliant. For my own personal work I chose PostgreSQL for several features that MySQL - nested queries, views, triggers and stored procedures being the biggies. Transactions weren't available with MySQL at the time I made my decision but, even with their current level of support for transactions, I cannot conceive of doing without the other features, views and stored procedures especially. And that is why I don't understand Sun's push for MySQL. Are there any enterprise level projects (heck, even department level projects) that you don't want to use views and stored procedures with? Sun's push for MySQL. Where did you read about this ? Here's the full story: http://news.com.com/2008-1082-947510.html rjsjr Well ISP / Java WebHoster only support MySQL, so I got no choice. You should (generally) be able to get them to provide you with PostgreSQL too. I'd be shocked if it wasn't already installed. SapDB is quite hot nowadays too, from my understanding. Go with a DBMS that passes the ACID test ... unless you honestly think you don't need all that stuff. (I've heard many folks say they don't need an ACID-compliant DBMS; I've never understood the statement. For certain confined applications you may not, but overall I think it is [or should be] a requirement) Regards, Eddie -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: [OT] MySQL vs PostgreSQL and SAP DB (was RE: Struts and Large ResultSet)
For my money, or the lack thereof :), I would much rather use PostgreSQL or SAP DB than MySQL for both feature AND, believe it or not, performance reasons. One of the developers on the SourceForge project did a very nice comparison of how SF would run on both MySQL and PostgreSQL and he was very surprised at the results. You can read about it at: http://www.phpbuilder.com/columns/tim2705.php3. Of course, he was using PHP instead of Struts :) For my own personal work I chose PostgreSQL for several features that MySQL - nested queries, views, triggers and stored procedures being the biggies. Transactions weren't available with MySQL at the time I made my decision but, even with their current level of support for transactions, I cannot conceive of doing without the other features, views and stored procedures especially. And that is why I don't understand Sun's push for MySQL. Are there any enterprise level projects (heck, even department level projects) that you don't want to use views and stored procedures with? rjsjr -Original Message- From: Eddie Bush [mailto:[EMAIL PROTECTED]] Sent: Monday, September 09, 2002 3:31 PM To: Struts Users Mailing List Subject: Re: [OT] RE: Struts and Large ResultSet And just above that he said: If you want to use Oracle, by all means, please do. I think the issue Oracle faces is they're trying desperately to embrace Linux, and Oracle's unbreakable Linux (pitch) certainly makes a statement. My retort would be unbreakable MySQL. Personally, I think it's kind of insane to tout MySQL as anything near unbreakable. Unless they're ready to push some heavy funding into MySQL to improve it's ACID-ity, comparing MySQL to Oracle is like comparing apples and oranges. Last I heard, MySQL was implementing atomicity -- without rollback -- LOL what *is* that? I'd much rather see them push PostgreSQL or SapDB. The argument (for MySQL still not being ACID compliant) is that they are still trying to figure out how to integrate those prinicpals without losing speed. Maybe Sun could help them along; I don't know. I know this: you gain somewhere -- you lose somewhere. ... unbreakable MySQL -- not unless it changes substantially. Good thread - thanks James. I hope my views don't offend anyone. I'm not really trying to diss MySQL -- it certainly has it's applications -- I just think touting it as a solution comparable with Oracle is ... I'm not going to say :-) out of fear of offend people I respect on this list. I don't think it should be done though. There are people that will look to Sun and embrace whatever they see them embrace -- and just as whole-heartedly as Sun seems to. I think embracing MySQL so strongly would be to their detriment ... Regards, Eddie (How precious is your data to you? No, *really*?!) James Mitchell wrote: Sorry for getting in late on this one. I was just at Google, and Google's an all-MySQL shop. Why did they do it? Because they looked at DB2 and it was expensive and it didn't offer any added value. - Jonathan Schwartz Here's the full story: http://news.com.com/2008-1082-947510.html James Mitchell Software Engineer\Struts Evangelist Struts-Atlanta, the Open Minded Developer Network http://www.open-tools.org/struts-atlanta -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: [OT] MySQL vs PostgreSQL and SAP DB (was RE: Struts and LargeResultSet)
Robert J. Sanford, Jr. wrote: For my money, or the lack thereof :), I would much rather use PostgreSQL or SAP DB than MySQL for both feature AND, believe it or not, performance reasons. One of the developers on the SourceForge project did a very nice comparison of how SF would run on both MySQL and PostgreSQL and he was very surprised at the results. You can read about it at: http://www.phpbuilder.com/columns/tim2705.php3. Of course, he was using PHP instead of Struts :) The article appears to be lauding MySQL features albeit 1999 on some speed issues. I definitely miss the subselect SQL syntax which is definitely useful with Oracle and Sybase. MySQL 4.0 Beta is out and wait for it. Full Text Match capabilities. Is this the end of Lucene or eSearch ? No. I like the bit about not returning the whole table of data if the query matches more than half the number of rows in the database table. As for LargeResultSets I don't think Sybase has rowset limit optimisation. Oracle I know a ROWID reverse keyword or is it ROWINDEX I cant remember. For my own personal work I chose PostgreSQL for several features that MySQL - nested queries, views, triggers and stored procedures being the biggies. Transactions weren't available with MySQL at the time I made my decision but, even with their current level of support for transactions, I cannot conceive of doing without the other features, views and stored procedures especially. And that is why I don't understand Sun's push for MySQL. Are there any enterprise level projects (heck, even department level projects) that you don't want to use views and stored procedures with? Sun's push for MySQL. Where did you read about this ? rjsjr Well ISP / Java WebHoster only support MySQL, so I got no choice. -- Peter Pilgrim +-\ +-+++++ Java Technologist | | | ||||| 'n' Shine | O | | || --+| ---+ /\| ._ / | | \ \ || / \ | | \ \ | |+-- || ---+ A new day /_ _\ Up| | | | | ||||| is coming ||+-+ +-+ +-+++++ home page=http://www.xenonsoft.demon.co.uk/; / -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: [OT] MySQL vs PostgreSQL and SAP DB (was RE: Struts and Large ResultSet)
Peter A. J. Pilgrim commented: Robert J. Sanford, Jr. wrote: For my money, or the lack thereof :), I would much rather use PostgreSQL or SAP DB than MySQL for both feature AND, believe it or not, performance reasons. One of the developers on the SourceForge project did a very nice comparison of how SF would run on both MySQL and PostgreSQL and he was very surprised at the results. You can read about it at: http://www.phpbuilder.com/columns/tim2705.php3. Of course, he was using PHP instead of Struts :) The article appears to be lauding MySQL features albeit 1999 on some speed issues. I definitely miss the subselect SQL syntax which is definitely useful with Oracle and Sybase. PostgreSQL had a short thread on this: http://marc.theaimsgroup.com/?l=postgresql-generalm=102987283829569w=2 You do want to follow the link to infoworld in this post, BTW MySQL 4.0 Beta is out and wait for it. Full Text Match capabilities. Is this the end of Lucene or eSearch ? No. I like the bit about not returning the whole table of data if the query matches more than half the number of rows in the database table. As for LargeResultSets I don't think Sybase has rowset limit optimisation. Oracle I know a ROWID reverse keyword or is it ROWINDEX I cant remember. For my own personal work I chose PostgreSQL for several features that MySQL - nested queries, views, triggers and stored procedures being the biggies. Transactions weren't available with MySQL at the time I made my decision but, even with their current level of support for transactions, I cannot conceive of doing without the other features, views and stored procedures especially. And that is why I don't understand Sun's push for MySQL. Are there any enterprise level projects (heck, even department level projects) that you don't want to use views and stored procedures with? Sun's push for MySQL. Where did you read about this ? You'd have to follow a couple of links from the one above, so -- http://www.infoworld.com/articles/hn/xml/02/08/14/020814hnmcnealyint.xml about half-way down the page. -- Joel Rees [EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: SAP DB
On Sat, 2002-09-07 at 08:35, John Nicholas wrote: Ferran Parra wrote: Hi is the SAP DB open source database a good DBMS?? why not is popular than mysql?? thanks --- Ferran Parra [EMAIL PROTECTED] http://www.mubimedia.com MUBIMEDIA S.L. C/ Mallorca, 275, 1r 2a 08008 BCN Tel: 93 215 21 91 / Fax: 93 215 41 21 --- 1) hasn't been open as long 2) mysql is good enough for most people 3) reputation for being difficult to install 4) more people know mysql so it's easier to get help if you get stuck John 1) Since Oct 2000. Has been around for a very long time as a commercial enterprise database. 2) Why settle for good enough when something which rivals Oracle's feature-set is available. 3) Specify three directories prompted by a script is not hard. 4) Hard to dispute that one. However I had linux issue, got to the bottom of it with lengthy mail list archives. there's an example script in the install which build a frsh databse, creates uses tables, and another to drop the entire instance. There's more than enough there to play with. Some more $0.02 -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: SAP DB
Ferran Parra wrote: Hi is the SAP DB open source database a good DBMS?? why not is popular than mysql?? thanks --- Ferran Parra [EMAIL PROTECTED] http://www.mubimedia.com MUBIMEDIA S.L. C/ Mallorca, 275, 1r 2a 08008 BCN Tel: 93 215 21 91 / Fax: 93 215 41 21 --- 1) hasn't been open as long 2) mysql is good enough for most people 3) reputation for being difficult to install 4) more people know mysql so it's easier to get help if you get stuck John -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
SAP DB
Hi is the SAP DB open source database a good DBMS?? why not is popular than mysql?? thanks --- Ferran Parra [EMAIL PROTECTED] http://www.mubimedia.com MUBIMEDIA S.L. C/ Mallorca, 275, 1r 2a 08008 BCN Tel: 93 215 21 91 / Fax: 93 215 41 21 ---
RE: SAP DB
Hi, I am also interested in Comments about this question. I am working on SAP DB right now and feel it is very good for my needs. I never worked on MySql to compare both of them. -Ravi -Original Message- From: Ferran Parra [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 12:21 PM To: Struts Users Mailing List Subject: SAP DB Hi is the SAP DB open source database a good DBMS?? why not is popular than mysql?? thanks --- Ferran Parra [EMAIL PROTECTED] http://www.mubimedia.com MUBIMEDIA S.L. C/ Mallorca, 275, 1r 2a 08008 BCN Tel: 93 215 21 91 / Fax: 93 215 41 21 --- -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: SAP DB
SAPDB is simply awesome. I've been ramping up a personal project which needs a complete DB arsenal, and I was worried until I met SAPDB. MySQL slows for inserts hand has a lack of SQL support. PostgreSQL has more SQL but it's slower. Both have issues over page size, data limitations. SAPDB... I went to the site, filled out some details and they mailed me the CD for free (that's Germany to Australia, for free). It's easy to install and comes with enough tools to rival Oracle out of the box. On the CD is all the implementations for all platforms (Win, Linux and all them unix's) Data limitations... is a 2GB long varchar a limitation?... Docco is also excellent. Including a document which mentions all the Oracle SQL syntax and if it supports it or not, and if it does but in a different way. The database is amazing, and I have no idea why more people aren't using it. You can download whatever you want, but my modem has a hard time of the 45MB or so. Just get the CD. I take my hat off to SAP for opening it up with the realisation that it's not where their money comes from. I'm converted. Every time I play and dig deeper I'm impressed all over. Comes with a little web server for web based administration. You wont be disappointed. Arron. On Fri, 2002-09-06 at 02:20, Ferran Parra wrote: Hi is the SAP DB open source database a good DBMS?? why not is popular than mysql?? thanks --- Ferran Parra [EMAIL PROTECTED] http://www.mubimedia.com MUBIMEDIA S.L. C/ Mallorca, 275, 1r 2a 08008 BCN Tel: 93 215 21 91 / Fax: 93 215 41 21 --- -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]