Re: Need database recommendation
I recently ported a small Oracle web application to PostgreSQL. Using Apache, Red Hat 6.2 and JDK1.2.2. The database only used tables, views, and sequences, so it's a pretty small test case, and the conversion went without much difficulty. The only issues were: 1. In my Oracle app I was updating the views. Can't do that in PostgreSQL. No problem though, I just edited the table directly. 2. Oracle has some nice text formating and date conversion functions which are not in PostgreSQL. I'm just living without them until I write some replacement functions. 3. PostgreSQL Documentation is still not finished. Don't stray to far, you will find yourself all on your own. All in all. I am happy with PostgreSQL. Looking forward to seeing it mature a little bit. Once that happens, I expect it to shake up the industry a bit. Much like Linux is doing now. Rick
Re: Need database recommendation
Check out Postgres at postgreSQL.org transactions, views, joins some issues with foreign key integrity blobs but going in new release soon...opensource too... At 07:42 PM 11/27/00 , you wrote: Go with oracle. You can't lose. Derek - Original Message - From: "Ralph Einfeldt" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 24, 2000 8:58 AM Subject: AW: Need database recommendation The answer depends on your requirements: - do you need views sub selects outer joins (which versions) transctions - whats are the requirements in terms of reliability (redundancy) scalability (performance, datavolume) - whats is your budget Some of our expiriences mySQL The last time we checked, transactions (or to be more precise the interface to berkley db) was alpha. I think this will take some time to become a stable release. It is not clear what this mean to the performance, because I don't know any result with this engine. No views. I like to use views to hide some complexities of the underlying db model. No subselects. This is a very bad thing for delete. You have do implement loops where you normaly use sub selects. Sybase ASA Cheapest full featered commercial RDBMS for web applications. Blobs are just 32K in the current release (Although the documentation says something different) Oracle Quite expensive. Never the less the db I made the best experiences with. Interbase Some nasty bugs with outer joins Cloudscape, InstantDB, Hypersonis SQL All thre do not support views -Ursprüngliche Nachricht- Von: c cw288 [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 22. November 2000 21:00 An: [EMAIL PROTECTED] Betreff: Need database recommendation Hi all, We are going to develop an application on apache + tomcat + mod_jk on Solaris 8, and we need a database for our application. There are lots of databases exit, we need some recommendation of which is easier to implement. Thanks, Cathy __ ___ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com Sanjay Arora, CEO. Transcontinental Data Processing Software Ltd. SCF 17, Phase 7, Mohali - 160 062. INDIA. Phone: +91-172-223295/223899. Fax: +91-172-223297 Email: [EMAIL PROTECTED]
Re: Need database recommendation
Go with oracle. You can't lose. Derek - Original Message - From: "Ralph Einfeldt" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 24, 2000 8:58 AM Subject: AW: Need database recommendation The answer depends on your requirements: - do you need views sub selects outer joins (which versions) transctions - whats are the requirements in terms of reliability (redundancy) scalability (performance, datavolume) - whats is your budget Some of our expiriences mySQL The last time we checked, transactions (or to be more precise the interface to berkley db) was alpha. I think this will take some time to become a stable release. It is not clear what this mean to the performance, because I don't know any result with this engine. No views. I like to use views to hide some complexities of the underlying db model. No subselects. This is a very bad thing for delete. You have do implement loops where you normaly use sub selects. Sybase ASA Cheapest full featered commercial RDBMS for web applications. Blobs are just 32K in the current release (Although the documentation says something different) Oracle Quite expensive. Never the less the db I made the best experiences with. Interbase Some nasty bugs with outer joins Cloudscape, InstantDB, Hypersonis SQL All thre do not support views -Ursprüngliche Nachricht- Von: c cw288 [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 22. November 2000 21:00 An: [EMAIL PROTECTED] Betreff: Need database recommendation Hi all, We are going to develop an application on apache + tomcat + mod_jk on Solaris 8, and we need a database for our application. There are lots of databases exit, we need some recommendation of which is easier to implement. Thanks, Cathy __ ___ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
Re: Need database recommendation
Hi Cathy, Oracle is a great DBMS; however, it is somewhat difficult to manage and set-up if you are not a DBA. You may also want to check out IBM's DB2, which is less expensive, and (in my experience) faster and much easier to develop an application around. In addition, DB2 supports the SQL 92 standards to a greater degree with fewer proprietary "additions." However, with how much Oracle is used in our industry; many people consider them to be the standard... We had to port our application from DB2 6.1 to Oracle 8i, and saw about a factor of 3 decrease in performance (on average). Of course, none of us were Oracle DBAs, but with just the default settings DB2 performs at a measurably higher level. I know that an Oracle expert can tweak it to get it running very quickly, but there is a reason that you pay those guys $200-$300/hr. As far as reliability and redundancy goes, DB2 runs 4 out of the 5 largest databases in the world, so you're not going to be compromising there... :) I am developing my current project using DB2 7.1 Tomcat; Everything is working very nicely so far! :) Check out http://www-4.ibm.com/software/data/db2/udb/downloads.html for a free download. I don't have any experience with DB2 on Solaris; my current application runs on Linux (and my previous experience was on NT). Good Luck! Scott - Original Message - From: "Derek DeMoro" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, November 27, 2000 11:42 AM Subject: Re: Need database recommendation Go with oracle. You can't lose. Derek - Original Message - From: "Ralph Einfeldt" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, November 24, 2000 8:58 AM Subject: AW: Need database recommendation The answer depends on your requirements: - do you need views sub selects outer joins (which versions) transctions - whats are the requirements in terms of reliability (redundancy) scalability (performance, datavolume) - whats is your budget Some of our expiriences mySQL The last time we checked, transactions (or to be more precise the interface to berkley db) was alpha. I think this will take some time to become a stable release. It is not clear what this mean to the performance, because I don't know any result with this engine. No views. I like to use views to hide some complexities of the underlying db model. No subselects. This is a very bad thing for delete. You have do implement loops where you normaly use sub selects. Sybase ASA Cheapest full featered commercial RDBMS for web applications. Blobs are just 32K in the current release (Although the documentation says something different) Oracle Quite expensive. Never the less the db I made the best experiences with. Interbase Some nasty bugs with outer joins Cloudscape, InstantDB, Hypersonis SQL All thre do not support views -Ursprüngliche Nachricht- Von: c cw288 [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 22. November 2000 21:00 An: [EMAIL PROTECTED] Betreff: Need database recommendation Hi all, We are going to develop an application on apache + tomcat + mod_jk on Solaris 8, and we need a database for our application. There are lots of databases exit, we need some recommendation of which is easier to implement. Thanks, Cathy __ ___ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
AW: Need database recommendation
The answer depends on your requirements: - do you need views sub selects outer joins (which versions) transctions - whats are the requirements in terms of reliability (redundancy) scalability (performance, datavolume) - whats is your budget Some of our expiriences mySQL The last time we checked, transactions (or to be more precise the interface to berkley db) was alpha. I think this will take some time to become a stable release. It is not clear what this mean to the performance, because I don't know any result with this engine. No views. I like to use views to hide some complexities of the underlying db model. No subselects. This is a very bad thing for delete. You have do implement loops where you normaly use sub selects. Sybase ASA Cheapest full featered commercial RDBMS for web applications. Blobs are just 32K in the current release (Although the documentation says something different) Oracle Quite expensive. Never the less the db I made the best experiences with. Interbase Some nasty bugs with outer joins Cloudscape, InstantDB, Hypersonis SQL All thre do not support views -Ursprüngliche Nachricht- Von: c cw288 [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 22. November 2000 21:00 An: [EMAIL PROTECTED] Betreff: Need database recommendation Hi all, We are going to develop an application on apache + tomcat + mod_jk on Solaris 8, and we need a database for our application. There are lots of databases exit, we need some recommendation of which is easier to implement. Thanks, Cathy __ ___ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
Re: Need database recommendation
If a commercial solution is acceptable, you might consider Progress (www.progress.com). Very powerful, high reliability, well suited to web based applications. Contact me off-line if you want more details. -- /* == */ William E. Colls Tel 613 591 0079 PROComputer SystemsFax 613 591 3924 67 Willow Glen Dr www.procomsys.com Kanata Ontario Canada PEG Member 1998051404 Specialists in Progress Software development since 1985
Re: AW: Need database recommendation
I reccomend IMS, but if your budget is under 4 Million, I'd go with DB2 UDB. You can get the Personal Edition for free from http://service.software.ibm.com/cgi-bin/d2w/sdl/segment/input?segment=DMx=28y=8 I have been using DB2 with Tomcat and JServ for about a year and a half and have been very satisfied. Another option not mentioned is PostgreSQL. Available here: http://looking-glass.usask.ca:82/ I have used PostgreSQL with PHP in the past. I'm sure that there is a JDBC driver available too. Regards, Raimee Stevens DB2 UDB NLV Team - IBM Toronto Lab Email: [EMAIL PROTECTED] VM: RAIMEE@TOROLAB2 Phone: (416)448-3706 T/L 778-3706 Fax: (416)448-4414 Ralph Einfeldt [EMAIL PROTECTED] on 11/24/2000 02:58:10 PM Please respond to [EMAIL PROTECTED] To: "'[EMAIL PROTECTED]'" [EMAIL PROTECTED] cc: Subject: AW: Need database recommendation The answer depends on your requirements: - do you need views sub selects outer joins (which versions) transctions - whats are the requirements in terms of reliability (redundancy) scalability (performance, datavolume) - whats is your budget Some of our expiriences mySQL The last time we checked, transactions (or to be more precise the interface to berkley db) was alpha. I think this will take some time to become a stable release. It is not clear what this mean to the performance, because I don't know any result with this engine. No views. I like to use views to hide some complexities of the underlying db model. No subselects. This is a very bad thing for delete. You have do implement loops where you normaly use sub selects. Sybase ASA Cheapest full featered commercial RDBMS for web applications. Blobs are just 32K in the current release (Although the documentation says something different) Oracle Quite expensive. Never the less the db I made the best experiences with. Interbase Some nasty bugs with outer joins Cloudscape, InstantDB, Hypersonis SQL All thre do not support views -Ursprüngliche Nachricht- Von: c cw288 [mailto:[EMAIL PROTECTED]] Gesendet: Mittwoch, 22. November 2000 21:00 An: [EMAIL PROTECTED] Betreff: Need database recommendation Hi all, We are going to develop an application on apache + tomcat + mod_jk on Solaris 8, and we need a database for our application. There are lots of databases exit, we need some recommendation of which is easier to implement. Thanks, Cathy __ ___ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
Need database recommendation
Hi all, We are going to develop an application on apache + tomcat + mod_jk on Solaris 8, and we need a database for our application. There are lots of databases exit, we need some recommendation of which is easier to implement. Thanks, Cathy _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
Re: Need database recommendation
Cathy, This isn't particularly germain to this mailing list, but in the event that some kind soul does answer, you might help yourself by giving some idea of your requirements and budget. The quality of advice you get is proportional to the quality of the question... unless you are on usenet where noise always prevails. ;) Duane On Wed, 22 Nov 2000, c cw288 wrote: Hi all, We are going to develop an application on apache + tomcat + mod_jk on Solaris 8, and we need a database for our application. There are lots of databases exit, we need some recommendation of which is easier to implement. Thanks, Cathy _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com
Re: Need database recommendation
Cathy, Probably Oracle 8.1.6 (8.1.5 = 8i was a little buggy) -- There are others as well...e.g. some of my best friends swear by Informix, Sybase et.al. There is also Poet (haven't heard that much from them lately..) and some of the other OODs. I believe all Database Companies are tending towards OOD. One reason for (me personally) choosing Oracle is that, and this may just be a rumor, Oracle is developed on Sun OS (Solaris). (The claim is that Larry Ellison and Scott M were each others "best man" at their respective weddings). This just may be "modern folklore" however...:( But if its true, Oracle developed on Sun OS, then, choosing Oracle would make sense. On the other hand Oracle (and perhaps the other Database Companies) look to be committed to Linux and (NT) so PL/SQL, Java -- should not be a "porting issue". Oracle "dmp" files (if export full) can be pretty much easily imported to other Oracles on other platforms... But again any other "industrial strength database" should be able to do that as well. I hope this helps, regards, mike anderson c cw288 wrote: Hi all, We are going to develop an application on apache + tomcat + mod_jk on Solaris 8, and we need a database for our application. There are lots of databases exit, we need some recommendation of which is easier to implement. Thanks, Cathy _ Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com begin:vcard n:Anderson;Michael tel;pager:510-872-1085 tel;cell:510-681-4982 tel;fax:480-816-0346 tel;home:N/A tel;work:510-644-2966 x-mozilla-html:FALSE url:http://www.eye-go.com/ org:Eye-go.com;IT version:2.1 email;internet:[EMAIL PROTECTED] title:CTO adr;quoted-printable:;;2477 Virginia Street=0D=0ASuite 305=0D=0A;Berkeley;CA;94709;USA fn:Michael G.Anderson C.TO. end:vcard