JAVA Web World

Server: Tomcat

JAVA Web Solution:
Spring.IO - http://spring.io/guides/gs/rest-service/

Search Engine:
SOLR

DBA - Things to know

DBA -  Things to know

Statistics
https://www.simple-talk.com/sql/performance/managing-sql-server-statistics/

AWS RDS and more

Disaster Recovery
https://www.cloudendure.com/blog/9-steps-to-make-amazon-rds-work-cloud-disaster-recovery/

http://blog.celingest.com/en/2013/03/19/disaster-recovery-aws-high-availability-architectures/

The first thing you need to know.

AWS SDK and AWS API

Build website with existing open-source framework

CMS
 http://anandkg22.hubpages.com/hub/Top-12-Best-Content-Management-Systems-You-Can-Freely-Use-For-Website-Building

• WordPress
• Umbraco (.NET)
• Orchar (.NET)
• Drupal
• Joomla
• dotCMS (JAVA)

eCommerce
http://www.webappers.com/2010/07/09/15-best-free-open-source-ecommerce-platforms/

1. Magento
Megento is a feature-rich eCommerce paltform built on open-source technology tha tprovides online merchants with unpercedented flexibility and control over the look, content and functionality of their eCommerce store.
Magento's intuitive administration interface features powerful marketing, search engine optimzation and catalog-management tools to give merchants the power to create sites that are tailoeir unique business needs.

2. Prestashop
Prestashop is an award winning e-commerce solution having won the Best Open Source Business Application. Having been distributed under the open source license, Prestashop now powers thousands and thousands of online stores across the globe.
It is also backed by an active community of developers who frequently develop various add-ons for extending the functionalities of Prestashop. Currently, PrestaShop has around 275 eCommerce features that make online business an easier and simpler affair for online merchants.

3. OpenCart
OpenCart is an open source PHP-based online shopping cart system. A robust eCommerce solution for internet merchants with the ability to create their own online business and participate in eCommerce at  a minimal cost.
OpenCart is a turn-key ready "out of the box" shopping cart solution. You simply install, select your template, add products and you're ready to start accepting order.

4. VirtueMart
VirtueMart is an open-source eCommerce solution to be used together with a content management system (CMS) called Joomla!
Joomla! and VirtueMart are written in PHP and can be used in typical PHP/MySQL environments.

5. OsCommerce
OSCommerce is an online shop eCommerce solution that offers a wide range of out-of-the-box features that allows online stores to be setup fairly quickly with ease, and is available for free as an Open Source base solution.
Today, osCommerce has been take to the next level, moving towards an eCommerce framework solution that not only remains easy to setup and maintain, but also making it easier for store administrators to resent their stores to their customers with their own unique requirements.

6. OpenCart
Not only does OpenCart look great, it's extremely scalable. You can create an unlimited number of categories, sell an unlimited number of products, accept multiple currentcises, use mutiple languages, and choose from over 20 payment and 8 shipping methods. It's user-friendly and search-engine-friendly too, so will help you prominence in Google. Customers can even review and rate the items you sell. It's not as popular as osCommerce, so help and guidance is not so freely available, but it's a darn sight better looking.

7. nopCommerce (.NET)

WIKI
1. Blue Spice
http://www.blue-spice.org/

PHP
CodeIgnite
Zend Framework 2

GoLittleDolphin - Kids Education

Blog
http://golittledolphin.blogspot.com.au/

Site Design

Logging Solution

Logging Solution

Requirements:

1. Fast and Multiple Threads
2. Good Format and Programmable
3. Auto Rollover
4. Easy to Use

Solutions

• Logging API - Log Entry - https://logentries.com/product/
• Log4Net
• N-Log
• Log with Elastic Search and More

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';

China IT

CSDN.NET
http://www.csdn.net/

51CTO
http://www.51cto.com/

 2013年8月排名

China IT Forum Ranking

- http://www.360doc.com/content/13/0309/19/4417035_270422703.shtml

中国IT论坛(技术社区)排名

csdn 、java eye 、infoQ几乎垄断了技术社区领域。如果程序员出现问题在网上搜索，基本上的都是这三个网站提供的内容。另外参考中国网站排名并结合程序员最常去的技术社区，补充提供另外6家网站。

1.    csdn - csdn的注册人数多（号称过两百万的用户），但新手多。

2.    java eye - java eye注册用户刚突破10万，但更为专业。

3.    infoQ - infoQ相对来说是比较新的技术、新概念。

4.    编程爱好者网站 - 提供刻盘服务和求职招聘服务。

5.    ChinaJavaWorld www.chinajavaworld.com 中国Java开发者站点。

6.    51CTO  http://bbs.51cto.com

7.    Linux论坛、Ubuntu中文论坛http://forum.ubuntu.org.cn

8.    LinuxPK http://bbs.linuxpk.com 全球最大中文开源门户

9.    编程论坛http://bbs.bccn.net 中国最大开发者社区

中国十大IT网站排名

参考一览网（http://sort.elanw.com/elanw_top_trade/elanw_top_83.htm）提供的排名信息选取前20名和其他口碑好的网站进行Alexa排名查询，我将查询得出的TOP10整理如下。在同一主题（IT网站）下，利用alexa排名分析比较准备可信。

1.    中关村在线  Zol.com.cn

2.    太平洋电脑网Pconline.com.cn

3.    电脑之家 Pchome.net

4.    It168.com

5.    天极网Yesky.com

6.    eNet硅谷动力Enet.com.cn

7.    51cto.com

8.    赛迪网Ccidnet.com在各个国家/地区的排名情况:

9.    IT世界 It.com.cn在各个国家/地区的排名情况:

10.   计世网 Ccw.com.cn在各个国家/地区的排名情况:

WinRT Application

Basic
winrt-vs-net-application-development
http://devproconnections.com/net-framework/winrt-vs-net-application-development

Json

JSON Escape Special Characters

Use \' for you quotation into your text.

See this list of special character used in JSON :
[REF] how-to-escape-special-characters-in-building-a-json-string
\b  Backspace (ascii code 08)
\f  Form feed (ascii code 0C)
\n  New line
\r  Carriage return
\t  Tab
\v  Vertical tab
\'  Apostrophe or single quote
\"  Double quote
\\  Backslash character

JSONP

•  JSONP is only for GET, though, not POST 
• http://stackoverflow.com/questions/6809053/simple-jquery-php-and-jsonp-example
• Basically, Server Side: need to return something like "CallbackFunctionName({'data': 'value'})"
• Client Side: type is JSONP, add ?callback=CallbackFunctionName to the GET request
  

 There is another way to make cross domain call

• http://stackoverflow.com/questions/6396623/jquery-getjson-access-control-allow-origin-issue
• Basically it's related with some HTTP Headers:
  

  Access-Control-Request-xxx

Tools:

• JSON Viewer by Eyal Post