DBA - choose right database for your project

NoSQL Database

• RethinkDB (http://www.rethinkdb.com/)
• MongoDB
• RavenDB

When is NoSql database not a good choice?

• If you need full ACID support or strong schema enforcement — in this case you are better off using a relational database such as MySQL or PostgreSQL.
• If you are doing deep, computationally-intensive analytics you are better off using a system like Hadoop or a column-oriented store like Vertica.
• If you absolutely need high write availability and do not mind dealing with conflicts, you may be better off with a Dynamo-style system like Riak.

Node-JS

WHY
http://www.toptal.com/nodejs/why-the-hell-would-i-use-node-js#.

Projects

https://stormpath.com/blog/build-app-nodejs-express-passport-stormpath/

WINDOWS
https://github.com/coreybutler/node-windows

Greate Sites Collection

API Documentation

• https://developers.digitalocean.com/

Online Store

• http://www.stuckonyou.com.au/

Tech Sites

• 喜欢它的颜色 http://www.rethinkdb.com/  
• http://www.newicon.net/case-study-type/recent-work/
•  简单实用优雅 - 清新 https://www.campaignmonitor.com/features/
• 简单鲜明有趣 http://loop-sandbox.rnd.apac-streaming.digitalturbine.com/volume/pricing.html
• 简洁实用适合童车网站 http://www.sitecore.net/ 
• http://now.tibco.com/ 大气严谨

Design

• http://www.point2design.com.au/our-work/ 

国内优秀网站

• TMALL

MySQL Things

MySQL Doc 

• http://dev.mysql.com/doc/

MySQL Tools

• http://www.percona.com/downloads/

Common Commands

Show Databases;

show processlist;
show events;

Show Tables;

Describe TABLE_NAME; 

NO LOCK

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
SELECT * FROM TABLE_NAME ;
COMMIT ;

SQL (Agent) JOB 

SET GLOBAL event_scheduler = ON;

http://www.sitepoint.com/how-to-create-mysql-events/

TEMP TABLE

CREATE TEMPORARY TABLE IF NOT EXISTS tmp_C AS (SELECT * FROM `Carrier`);

select * from tmp_C;

VARIABLE

select @CarrierId :=  Id from TableName where `Name` = 'T';