Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Location
    Middle USA
    Posts
    31

    Question What's a good web db for an Oracle admin?

    Hello...

    I'm looking for opinions on what web db options would be best for a person who primarily works in Oracle. I assume the cost of Oracle would make finding an affordable host impossible...and I haven't found one yet during my searches. That leaves me with Access, MySQL, MS SQL and PostgreSQL options.

    I currently utilize a lot of views, sub queries (...and unions, joins), stored procedures, triggers and transactions (roll back, commit) in Oracle at my job (I work on enterprise applications, most are not for websites though). I'd like to use many of these same options but I understand that the typical web db options listed above do not offer all of these. I've spent a bit of time research each and about as near as I can tell, PostgreSQL seems to be the closest to Oracle however, not many providers include ProstgreSQL (I don't understand the reason? Is it slow or does it require too many server resources?). MySQL doesn't seem to provide most of what I am looking for. I haven't spent much time researching MS SQL but I would assume many of the features I need are available (is MS SQL the same as Microsoft SQL Server? How come versions are frequently not listed in the hosts' offers?).

    Any opinions are appreciated. FYI, my primary site coding of choice will be PHP but may also include ASP. My sites are low traffic so my ability to pick up and use the db is of greater importance than it's performance unless there are obvious and serious performance issues with one of the options.

    Thanks in advance.

  2. #2
    Join Date
    Jan 2004
    Location
    Middle USA
    Posts
    31

    Did I ask a dumb question?

    Did I ask a dumb question? This is a pretty active board to not get any response at all after a couple days.

  3. #3
    Join Date
    Aug 2002
    Location
    Superior, CO, USA
    Posts
    633
    I agree that PostgreSQL is the closest to a commercial database. It contains all of the "real" database features. MySQL, especially the versions that are common (3.x), does not allow for the very common database related things you are used to.

    The reason that you can't find as many PostgreSQL hosting companies is that the vast majority of hosting providers would not understand what first normal form is if it bit them in the rear. There is a bias towards doing everything in code which goes against portabilty and is simply reinventing the wheel. Before I went to a dedicated server I hosted with multiple companies that had PostgreSQL. Now I run PostgreSQL and Tomcat on my server.

    If you Google for web hosting providers that offer PostgreSQL you'll find that they are out there. They are not as common nor as cheap but a good database design waits for you...

  4. #4
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    432
    PostgreSQL or MSSQL are the closest to oracle.
    Checkout www.crunzh.com for nice freeware programs. Including a program for monitoring your webserver.
    Any opinions in this post, unless otherwise noted, are my own personal opinions.

  5. #5
    Join Date
    Aug 2000
    Location
    Sheffield, South Yorks
    Posts
    3,480
    PostgreSQL gets my vote, having worked with Oracle myself for a year, I can say that afterwards Postgres was the easiest and most feature complete when compared to Oracle.
    Karl Austin :: KDA Web Services Ltd.
    UK Business Hosting and Managed Servers - Hosting for Business Users :: 0800 5429 764
    Call us today and ask about our hosting solutions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •