What do you think this is, an IT forum?
- 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!
MySQL or PostgreSQL for high-volume high-performance database?
Collapse
X
-
"Never argue with stupid people, they will drag you down to their level and beat you with experience". Mark Twain -
Originally posted by scooterscot View PostWhat do you think this is, an IT forum?Comment
-
If you should settle on MySQL, use MariaDB instead. It's free of Oracle's control, completely compatible with MySQL, and under rather more active development by all accounts.
It's an open source project created by a bunch of the original MySQL developers who jumped ship when Oracle took over in 2010. More info: https://en.wikipedia.org/wiki/MariaDBComment
-
Originally posted by NickFitz View PostIf you should settle on MySQL, use MariaDB instead. It's free of Oracle's control, completely compatible with MySQL, and under rather more active development by all accounts.
It's an open source project created by a bunch of the original MySQL developers who jumped ship when Oracle took over in 2010. More info: https://en.wikipedia.org/wiki/MariaDB
The last couple of years I was performance testing both this and Postgres for high volumes of data and each has their strengths and weaknesses. I can't tell you which one is better as it depends upon the workload and I doubt very much you would be using the same hardware as I was but there are plenty of presentations on the web of the work I performed“Brexit is having a wee in the middle of the room at a house party because nobody is talking to you, and then complaining about the smell.”Comment
-
Many thanks for all the replies, and I have been following this thread although it may not have seemed like it.
To those who asked for more details on the intended use, I was asking more for a general feel for how the two compared these days, and didn't have a specific database structure in mind.Work in the public sector? Read the IR35 FAQ hereComment
-
Edge your bets by using an instance of both. Can then see which works best for you when it's all designed and up and running, and in the meantime you have a failover redundant hot backup which can be kept in sync, so if one goes up in smoke you have another already available.Maybe tomorrow, I'll want to settle down. Until tomorrow, I'll just keep moving on.Comment
-
MySQL 8 apparently introduces a lot of new features: https://mysqlserverteam.com/whats-ne...lly-available/Comment
-
-
I haven't done much backend work in recent years (mostly mobile) but PostgreSQL is my goto choice (except for tiny projects where I might even use sqlite). I can't remember the last time I used MySQL. Possibly before Oracle bought it.Comment
-
If you talking high volume high performance in the context of a financial app handling millions of transactions, MySQL and PostGre do not come any close to Apache Cassandra. In fact even Oracle and MSSQL struggle to cope.Vote Corbyn ! Save this country !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
Comment