Node.js執行外部程式 - Child Process

http://nodejs.org/api/child_process.html

GLSL Web Shader Tool

http://shdr.bkcore.com/

SPDY協定

進入Google Chrome SPDY
chrome://net-internals/#spdy

SPDY包含加密。

Windows環境變數、標準路徑變數表

Windows Environment Variables:

Variable	Default value: Windows XP	Default value: Windows 7/2008
%ALLUSERSPROFILE%	C:\Documents and Settings\All Users	C:\ProgramData
%APPDATA%	C:\Documents and Settings\{username}\Application Data	C:\Users\{username}\AppData\Roaming
%CommonProgramFiles%	C:\Program Files\Common Files	C:\Program Files\Common Files
%COMMONPROGRAMFILES(x86)%	C:\Program Files (x86)\Common Files	C:\Program Files (x86)\Common Files
%COMPUTERNAME%	{computername}	{computername}
%COMSPEC%	C:\Windows\System32\cmd.exe	C:\Windows\System32\cmd.exe
%HOMEDRIVE%	C:	C:
%HOMEPATH%	\Documents and Settings\{username}	\Users\{username}
%LOCALAPPDATA%	N/A (but can be manually added LOCALAPPDATA=%USERPROFILE%\Local Settings\Application Data)	C:\Users\{username}\AppData\Local
%LOGONSERVER%	\\{domain_logon_server}	\\{domain_logon_server}
%PATH%	C:\Windows\System32\;C:\Windows\;C:\Windows\System32\Wbem;{plus program paths}	C:\Windows\System32\;C:\Windows\;C:\Windows\System32\Wbem;{plus program paths}
%PATHEXT%	.COM; .EXE; .BAT; .CMD; .VBS; .VBE; .JS ; .WSF; .WSH;	.COM; .EXE; .BAT; .CMD; .VBS; .VBE; .JS ; .WSF; .WSH; .MSC
%ProgramData%	N/A	C:\ProgramData
%ProgramFiles%	C:\Program Files	C:\Program Files
%ProgramFiles(x86)% 1	C:\Program Files (x86)	C:\Program Files (x86)
%PROMPT%	Code for current command prompt format,usually $P$G C:>	Code for current command prompt format,usually $P$G C:>
%PSModulePath%	N/A	%SystemRoot%\system32\WindowsPowerShell\v1.0\Modules\
%Public%	N/A	C:\Users\Public
%SYSTEMDRIVE%	C:	C:
%SYSTEMROOT%	C:\Windows	C:\Windows
%TEMP% and %TMP%	C:\Documents and Settings\{username}\Local Settings\Temp	C:\Users\{Username}\AppData\Local\Temp
%USERDOMAIN%	{userdomain}	{userdomain}
%USERNAME%	{username}	{username}
%USERPROFILE%	%SystemDrive%\Documents and Settings\{username}	%SystemDrive%\Users\{username}
%WINDIR%	C:\Windows	C:\Windows

MongoDB 指令

進入MongoDB主控台
bin/mongo.exe

顯示資料庫們
show dbs

使用資料庫
use test

顯示資料表們
show collections
或
show tables

搜尋整個資料表
db.YOUR_TABLE.find()

刪除資料表內資料
db.foo.remove({})

刪除資料表
db.foo.drop()

釋放不需要的空間
db.repairDatabase()

FYI:
http://netkiller.github.io/nosql/mongodb/mongo.html

建立 admin 帳號密碼

use admin
db.createUser({
    user: "admin帳號",
    pwd: "admin密碼",
    roles: [ { role: "root", db: "admin" } ]
})

登入 admin 建立一般 user 帳號密碼

use admin
db.auth("admin帳號","admin密碼")

db.createUser({
    user: "user帳號",
    pwd: "user密碼",
    roles: [ { role: "readWrite", db: "user資料庫" } ]
})

(舊)建立admin帳號密碼

use admin
db.createUser(
  {
    user: "admin",
    pwd: "密碼",
    roles: [ { role: "userAdminAnyDatabase", db: "admin" } ]
  }
)

(舊)建立product帳號密碼

use 資料庫
db.createUser(
    {
        user: "帳號",
        pwd: "密碼",
        roles: [ { role: "dbAdmin", db: "資料庫" } ]
    }
)

資料庫還原

mongorestore -d airdental --directoryperdb C:\restore\airdental