swombat.com

daily articles for founders

Swombat.com is no longer actively maintained, but all the posts here are still available for your use. The original objective was to regularly summarise and comment on the best articles for founders each day, as well as occasionally post our my own thoughts and advice, so that you could read the most useful articles while focusing on building your own startup. As most of the articles in the founders library were selected to be "evergreens", I hope you still find them useful!

Running a startup in the UK (or with a UK subsidiary)? Get in touch with my company, GrantTree. We help with government funding.

Dmitri Melikyan extracts the following key points about the choice of SQL vs NoSQL for startups:

Relational databases are not easily scalable. It will require a lot of efforts to build a scalable and redundant setup.

Relational databases provide a very rich function set, which makes the application layer of the product simpler (as long as no performance requirements/problems exist)

There are NoSQL data stores, which are scalable easily, but they are mainly key-value stores with a very limited function set.

It is very easy to develop on schema-Â­free NoSQL databases, especially for fresh projects, but making data consistent from one release to another will require additional programming and tracking.

On the other hand, altering of a schema in some relational databases, e.g. MySQL with millions of records will take time, which may lead to downtimes of the whole application.

And:

Ideally, I'd encourage startups to architect in a way that allows use of different data stores for different features.

One small quibble... the "SQL doesn't scale" myth is just that, a myth. "Proper" SQL databases like Oracle or SQL Server, while expensive, can scale quite handily to enormous amounts of data. Most startups, even if extremely successful, will never grow to the Google-like scale that requires a NoSQL solution like BigTable.

Use what makes sense for your context, but don't underestimate the ability of SQL to scale.