Distributed scaling with Relational Databases
Background A lot of articles will talk about how to scale databases. Typically, they will talk about the purpose and the general idea of sharding and »
Storing passwords into a database
Don'ts Don'ts Don't put raw passwords in the database Don't put encoded passwords in the database (i.e. Base64) Don't put simple hashed passwords in the »
RDBMS Indexing
Introduction As illustrated in this article, indexing is one of the easiest and most effective tweaks you can add to your SQL database. However, indexing might »
Snowflake
Introduction Twitter's Snowflake is a ID generation scheme that tackles all of the requirements below: ID fits under 64 bits ID will be used with distribution »
NoSQL - the Radical Databases
NoSQL NoSQL is a category of databases that aren't relational. For example, MySQL would be a relational database, where as MongoDB would be a NoSQL database. »