QNAP - Upgrade Node.js

QNAP App Center可以安裝Node.js，方便撰寫server-side JavaScript程式。但是QNAP似乎支援跟新版很慢 (可能是要等Linux Station完善吧)，目前還是version 0.8.22-2。

QNAP NAS使用【免費】SSL憑證之問題與解法

上一篇【QNAP NAS使用自有SSL憑證之問題與解法】事單位花錢購買domain SSL憑證。若個人小資族要使用https，可以參考：「伺服器設置應用」 - 自己來弄一個適用於QNAP NAS 的 SSL 憑證。

http://slproweb.com/products/Win32OpenSSL.html

QNAP NAS使用自有SSL憑證之問題與解法

QNAP可以參考【如何購買與使用myQNAPcloud SSL憑證？】每月花幾二十塊美金，讓自有NAS更安全。至於為何需要購買myQNAPcloud SSL憑證？就是要讓NAS具備專業服務之形象，避免出現以下畫面。

QNAP - QTS 4.2 Container Station (Based on LXC and Docker)

QNAP Container Station (QTS 4.2 軟體容器工作站) 支援 LXC 與 Docker® 兩項輕量級虛擬技術，可在 QNAP NAS 上執行完整的 Linux® 虛擬機，並由 Docker® Hub 線上市集下載來自全球各地數以千計的應用程式。

QTS 4.2重要功能：Container (LXC/Docker)

QNAP/Linux - Python Programming 03 (Command-Line Arguments)

Arguments of C console application are defined in array "argv", in which the count of arguments is "args". Python supports more flexible method to write console applications with Unix-like "option -" and "long option: --".

python -h (or --help)

QNAP/Linux - Python Programming 02 (Basic Syntax)

Python Programming of Tutorialspoint is a good playground for beginners of Python programming. From basic to advance tutorials, including useful resources, it is easy peasy lemon squeezy for beginners to learn from this site. Following contents only shows something important that I think you should notice. If you have no time to completely review all pages of the site, just "learn by doing" from available python source codes.

QNAP/Linux - Python Programming 01 (Setup and the First Program)

Python is programming language that lets you work quickly and integrate systems more effectively. It's really true!

https://www.python.org/

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」，這會導致原來建立的使用者帳號和資料庫都消失！

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.

Web Programming Style - MVC (Model View Control)

Model–View–Controller (MVC) is a software pattern for implementing user interfaces. It divides a given software application into three interconnected parts, so as to separate internal representations of information from the ways that information is presented to or accepted from the user. ... Wikipedia

http://en.wikipedia.org/wiki/File:MVC-Process.svg

QNAP/Linux PHP Programming 00 - Introduction

The article is an introduction for readers who have experiences on coding, such as C/C++ programming. Hence, common programming syntax, naming policy, or coding style are omitted in this blog.

QNAP/Linux Tool - PostgreSQL / phpPgAdmin

In QNAP/Linux Tool - Create PostgreSQL Account and Database, we have create an user account "nas" and a database "testdb" through commands. Sometimes you just want to take a glimpse on the status of PostgreSQL, phpPgAdmin is an useful Web tool.

Login PostgreSQL through phpPgAdmin Web UI with account "postgres"

QNAP/Linux Tool - Create PostgreSQL Account and Database

Since several developers share the same QNAP machine to write PHP and PostgreSQL programs, you should obey following steps to create individual db account. From now on, each programmer uses your own db account to develop PHP/DB Apps.

用固態硬碟 (SSD) 升級QNAP TS-212P - 超靜音

QNAP TS-212P安裝傳統SATA HD (兩顆Mirror RAID0) 的結果是 ...

http://www.qnap.com/i/_images/product/items/117_1.png

QNAP/Linux Tool - Setting PostgreSQL and PHP Environment

To make your PHP easily connect to PostgreSQL installed in QNAP, you can use ipkg (install Optware IPKG) command to install PHP-PostgreSQL interface (php-pgsql).
[~] # ipkg install php-pgsqlInstalling php-pgsql (5.2.17-2) to root...Downloading http://ipkg.nslu2-linux.org/feeds/optware/cs08q1armel/cross/unstable/php-pgsql_5.2.17-2_arm.ipk
Installing php (5.2.17-2) to root...

QNAP/Linux Tool - PostgreSQL

QNAP has packaged the widely-used DBMS, PostgreSQL, from Linux open source. The supported version is newer than that packaged in OptIPKG. As for why choosing PostgreSQL, please see Ubuntu Programming Lesson 01 - Install PostgreSQL (Why PostgreSQL).

PostgreSQL is available on QNAP App Center

QNAP/Linux Tool - wget (2) Backup the whole website and page content

In the previous blog, QNAP/Linux Tool - wget (1) Mirror Websites, the whole website html files were archived in your QNAP NAS. It's simple way to backup your blog articles, however, media contents within blogs are not fetched and archived.

QNAP/Linux Tool - wget (1) Mirror Websites

GNU Wget was developed to fetch files from the Internet (the Web), in which HTTP, HTTPS, FTP, and many widely used protocols are supported. Since 1996, wget was born for the crawling Web requirement. I firstly studied wget source code in 1998 due to developing crawler programs for search engine.

http://upload.wikimedia.org/wikipedia/commons/a/a7/Wget-1.10-kde-3.4.2-de.png

QNAP NAS - Find Useful Packages in IPKG List

In this article, we will find and try useful packages. Writing notes about the package with functions, supported architecture (ARM, x86 or x86_64), bugs and tested results.

QNAP NAS - IPKG and Optware IPKG App

QNAP NAS is a good platform for understanding the practices of developing embedded systems, since QNAP OS (QTS) is a minimized Linux OS for optimizing the performance of NAS. That is you can not install any software with only one click on setup.exe, the pre-required libraries and packages must manually installed before you can run a powerful App written with Qt for example. In Ubuntu, you are familiar with using apt-get to install packages. In QTS, you must learn how to use ipkg.