Feb 1, 2015

QNAP - PHP/PostgreSQL連線問題

在停電之後,QNAP重新啟動,沒想到發現以下問題:
Your PHP installation does not support PostgreSQL. You need to recompile PHP using the --with-pgsql configure option.
這時,大部分會想到的解法就是「QNAP App Center重裝PostgreSQL」,這會導致原來建立的使用者帳號和資料庫都消失!

Jan 17, 2015

QNAP/Linux Tool - Access PostgreSQL from SSMS (SQL Server Management Studio)

If you are familiar to use Microsoft SQL Server, you should be appreciated by the easy access among servers and cross database provided by SQL Server. Especially access all servers' databases through SSMS (SQL Server Management Studio) environment. Fortunately, accessing PostgreSQL from SSMS is simple and convenient.


Jan 13, 2015

Dec 21, 2014

R - Install Packages

Do by learning. I think you have learned programming like C#, Java, or C++ so that the following article is setting a problem to learn by example.
How to install packages in my R environment? 
http://upload.wikimedia.org/wikipedia/commons/c/c0/MaPlot-edgeR.smear-wikipedia.png

R - An Introduction to the R Programming Environment

R is an integrated software packages for data processing, calculation and graphical
display with following advantages.
http://www.r-project.org/Rlogo.jpg