Tips and Tricks for Clean RDB Schemas

I'm online!



λ



Scala



JS

Mongo
Riak
Redis
Couchbase
CouchDB
ElasticSearch

Titan
Cassandra
Kafka
Hbase
Neo4J
Datomic

I've played with lots of NoSQL dbs over the years



Postgres

But most of my work is done with postgres nowadays

Why bother with SQL?

Too complex, not flexible enough

relational algebra

Very well defined mathematical foundations. Clear, rigorous design

relational thinking

Very natural way to think



Data consistency

Strong guarantees regarding the validity and the consistency of stored data

Exploratory queries

Very easy to mix and match data. Data can be used in unforeseen ways due to good composability