More information about the Underscore mailing list

[_] Database choice for a social media platform

Erik Wallace erik.wallace at lewdewe.com
Thu May 19 09:27:13 BST 2016

Can anyone shed more light on the MySQL vs Postgresql debate? I'm somewhat on the fence about this.

@Tom
Thanks. I didn't know about the MongoDB 16MB limit. I've been suspicious of MongoDB for a while now, despite how cool they say it is, after all I've not yet seen it mentioned in any list of popular business databases.

@Aaron
It's a bit of a coin toss between MySQL and Postgresql for me. I've very little experience of Postgresql and it's oddities but plenty with MySQL. I'm the typical "good at many things, master of none" generic web/software developer, not a database expert, so it sounds like MySQL might be the best bet for now if it does a decent job without specialised tuning. When it comes to JSON support, from what little I've read so far, I'm leaning towards liking the JSON support in Cassandra more than Postgresql, so my current thinking is a potential mix of MySQL/Postgresql, Cassandra and memcache.


Kind Regards,
Erik Wallace

________________________________________
From: Underscore <underscore-bounces at under-score.org.uk> on behalf of Aaron Trevena <aaron.trevena at gmail.com>
Sent: 19 May 2016 09:05:01
To: underscore at under-score.org.uk
Subject: Re: [_] Database choice for a social media platform

On 18 May 2016 at 18:59, Russ Topia <russf at topia.com> wrote:
> Nice questions, today.
>
> Briefly:  Drop the mongo idea. Many have trouble scaling it. And also skip MySQL, in favour of PostgreSQL, if you are staying relational.

Agreed on mongo, we've found that it only really delivers for some
rapid prototyping and some edge cases, really large data or high load
and it buckles like wet cardboard.

Lots of people turn their nose up at mysql, but it can and does scale
well with only a small ammount of tuning, a lot less than postgres.

Postgres has killer features now though, with the native jsonb support
and foreign data wrappers - we've found jsonb as fast or faster than
mongo, even after tuning both heavily, and you still get the benefits
of relational queries and joins.

Cheers,

A.

--
Aaron J Trevena, BSc Hons
http://www.aarontrevena.co.uk
LAMP System Integration, Development and Consulting
--
underscore_ list info/archive -> http://www.under-score.org.uk/mailman/listinfo/underscore