Category: System and Network

PgAdmin for PostgreSQL Database

# # Setup the repository # # Install the public key for the repository (if not done previously): sudo curl https://www.pgadmin.org/static/packages_pgadmin_org.pub | sudo apt-key add # Create the repository configuration…

PostgreSQL: Documentation: 13: psql

psql psql — PostgreSQL interactive terminal Synopsis psql [option…] [dbname [username]] Description psql is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results. Alternatively, input…

Explain Apache Rewrite with Htaccess in Chinese

Apache Rewrite with Htaccess 理解與技巧 在搜尋 Apache 針對網址改寫、避免訪問敏感檔案時,都會看到RewriteRule、RewriteCond 等的 Directive,但因為有時候不理解其中特性或Rule 跟 Cond 的差異等,加上若不熟悉正規表達式,完全只想逃避這些 Rule 們呢哭哭,因此本文將介紹: 一、開啟 Rewrite 功能 二、RewriteRule 三、RewriteCond 四、如何除錯 五、一些小特性 六、使用 Htaccess 的缺點 ※ 本文內容會盡量減少複雜的正規表達式,但若讀者對正規表達式一概不通的話,還是要先惡補一些些囉! (或是你願意等待筆者撰寫下一篇關於正規表達式的文章 :P) 一、開啟…