I don't know Oracle would want to be discussed as competitors to MySQL... I thought Oracle and MSSQL were competing at the medium-high level with DB2 above them. However I've never actually come across a project using DB2 so who knows.
Not a dig at MySQL though - merely commenting that "medium high" in DB terms is pretty gigantic these days.
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Reply to: MySQL v PostgreSQL
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "MySQL v PostgreSQL"
Collapse
-
Originally posted by stek View PostJust to throw a spanner in the works and not really relevant - but my Oracle DBA pals ridicule DB2 summert raw, how does DB2 fit in the Proper Oracle, MySQL, Postgres scheme of things? Separate topic if admin wants to split off...
Leave a comment:
-
Nick (or anyone) is Visual Studio - including the free DB Express version - any good for MySQL?
Leave a comment:
-
Leave a comment:
-
Just to throw a spanner in the works and not really relevant - but my Oracle DBA pals ridicule DB2 summert raw, how does DB2 fit in the Proper Oracle, MySQL, Postgres scheme of things? Separate topic if admin wants to split off...
Leave a comment:
-
Originally posted by minestrone View PostI have heard it said many times that postgesql is the faster one but the tools set up for postgresql were pretty crap if I am being honest. I have a comfort zone with using GUIs on the database rather than going commando with command line. THe more advaned the gui is probably one of my main judgment crireria for DB technology.
Now, when mySQL was taken on by SUN it was a natural fit, when mySQL went into proper database teritory with stored procs I honestly believe that Oracle shat a brick and bought SUN to hinder mySQL, what with plenty of big start ups going on about using mySQL.
THe old mySQL GUI was a great, then they upgaded it to a pile of cack. was that down to oracle?
Leave a comment:
-
Originally posted by minestrone View PostI have heard it said many times that postgesql is the faster one but the tools set up for postgresql were pretty crap if I am being honest. I have a comfort zone with using GUIs on the database rather than going commando with command line. THe more advaned the gui is probably one of my main judgment crireria for DB technology.
I prefer the command line interface to many of the GUIs I have come across, so PostgreSQL wasn't a hassle for me.
Originally posted by minestrone View PostNow, when mySQL was taken on by SUN it was a natural fit, when mySQL went into proper database teritory with stored procs I honestly believe that Oracle shat a brick and bought SUN to hinder mySQL, what with plenty of big start ups going on about using mySQL.
THe old mySQL GUI was a great, then they upgaded it to a pile of cack. was that down to oracle?Last edited by Sysman; 27 October 2012, 13:12.
Leave a comment:
-
I have heard it said many times that postgesql is the faster one but the tools set up for postgresql were pretty crap if I am being honest. I have a comfort zone with using GUIs on the database rather than going commando with command line. THe more advaned the gui is probably one of my main judgment crireria for DB technology.
Now, when mySQL was taken on by SUN it was a natural fit, when mySQL went into proper database teritory with stored procs I honestly believe that Oracle shat a brick and bought SUN to hinder mySQL, what with plenty of big start ups going on about using mySQL.
THe old mySQL GUI was a great, then they upgaded it to a pile of cack. was that down to oracle?
Leave a comment:
-
Originally posted by portseven View Post+1
Though I hear that Postgress is enjoying a bit of a revival due to Oracle messing with MySQL, I am also seeing more use of Hadoop based databases, with additions to allow it to hold and manipulate structured data.
Isn't that a bit like sending an innocent 12 year old to live with her paedophile batchelor uncle?
Leave a comment:
-
Originally posted by NickFitz View PostMySQL is much more widely installed on standard (i.e. cheap) virtual server web hosting. I think that's because, for a while around ten years ago, MySQL was actually more advanced and stable than Postgres.
At that time I preferred the PostgreSQL documentation to the MySQL stuff too. I haven't compared them lately.
I looked into comparison benchmarks a few years ago, but too much of the stuff I found on the interwebs was comparing a well tuned installation of one with an out-of-the-box-defaults installation of the other.
Anyone who has seen what happened to other software products after being taken over by Oracle has a right to feel twitchy. In the case I am familiar with prices shot up and the run time libraries no longer came as part of the OS. That was fine for MegaBank Inc, but not for many smaller companies, nor the software houses who developed for them.
Oracle's handling of OpenOffice didn't bode well.
I'd like to know the real reasons Apple switched from MySQL to PostgreSQL. I suspect that steering clear of involvement with Oracle was the primary reason.
Leave a comment:
-
Originally posted by pmeswani View PostI don't know much about postgres, but with MySQL, you can do clustering, replication and is more industry standard than postgres.
Though I hear that Postgress is enjoying a bit of a revival due to Oracle messing with MySQL, I am also seeing more use of Hadoop based databases, with additions to allow it to hold and manipulate structured data.
Leave a comment:
-
MySQL is much more widely installed on standard (i.e. cheap) virtual server web hosting. I think that's because, for a while around ten years ago, MySQL was actually more advanced and stable than Postgres.
Anyway, it depends on the criteria by which one defines "better". If, for example, one is doing a GIS app then Postgres is much better than MySQL, whose geospatial extensions do Euclidean calculations of things like distance between points rather than dealing with the anomalies arising from the shape of the Earth. But in other ways, MySQL could well be better, even if only in the sense of an organisation having a lot of experience with it. The team at Flickr do remarkable things with it.
Leave a comment:
-
Originally posted by OwlHoot View PostWhy do so many sites and apps still use MySQL when PostgreSQL is also free and, in many if not most respects, better?
Leave a comment:
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Leave a comment: