infras

g0v.hackmd.io

Hackfoldr 快取計畫 - HackMD

index.php

``` &lt;?php // Note: https://g0v.hackmd.io/A175kRMVSxGqBRCerawXIA // License: BSD License function getCSV($id, $skip_ethercalc_down = true) { if ($skip_ethercalc_down and file_exists("/tmp/ethercalc-down") and file_get_contents("/tmp/ethercalc-down") &gt; time() - 5 * 60) { // if ethercalc is down in 5 minutes and $skip_ethercalc_down is true, skip it throw new Exception("ethercalc is down in 5 minutes"); } $curl = curl_init("<https://ethercalc.net/_/{$id}/csv>"); curl_setopt($curl, CURLOPT_RETURNTRANSFER, true); curl_setopt($curl, CURLOPT_TIMEOUT, 5); $content = curl_exec($curl); $info = curl_getinfo($curl); if (200 != $info['http_code']) { throw new Exception("fetch error: " . curl_error($curl)); } if (file_exists("/tmp/ethercalc-down")) { unlink("/tmp/ethercalc-down"); } return $content; } function printContent($content, $header_note) { header('Access-Control-Allow-Methods: GET'); header('Access-Control-Allow-Origin: *'); header('Content-Type: text/csv; charset=utf-8'); header('X-Cache-Status: ' . $header_note); echo $content; exit; } // check URI must be /_/{$name}/csv $uri = $_SERVER['REQUEST_URI']; if (!preg_match('#^/_/([^/?]+)/csv$#', $uri, $matches)) { die("only allow /_/{name}/csv URL"); } $id = $matches[1]; // env DATABASE_URL=mysql://{user}:{pass}@{ip}/{db} // connect to db if (!preg_match('#mysql://(.*)(:.*)@(.*)/(.*)#', getenv('DATABASE_URL'), $matches)) { die("need DATABASE_URL"); } $db_user = $matches[1]; $db_password = ltrim($matches[2], ':'); $db_ip = $matches[3]; $db_name = $matches[4]; $db = new PDO(sprintf("mysql:host=%s;dbname=%s", $db_ip, $db_name), $db_user, $db_password); $db-&gt;setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $sql = "SELECT * FROM cache WHERE id = " . $db-&gt;quote($id); $stmt = $db-&gt;prepare($sql); $stmt-&gt;execute(); // cache miss if (!$row = $stmt-&gt;fetch()) { try { $content = getCSV($id, false); $sql = sprintf("INSERT INTO cache (id, cache_at, content) VALUES (%s, %d, %s)", $db-&gt;quote($id), intval(time()), $db-&gt;quote($content) ); $db-&gt;prepare($sql)-&gt;execute(); printContent($content, "Cache miss, fetch it"); exit; } catch (Exception $e) { die("backend error: " . $e-&gt;getMessage()); } } // cache hit but expired if ($row['cache_at'] &lt; time() - 5 * 60) { try { $content = getCSV($id); $sql = sprintf("UPDATE cache SET cache_at = %d, content = %s WHERE id = %s", intval(time()), $db-&gt;quote($content), $db-&gt;quote($id) ); $db-&gt;prepare($sql)-&gt;execute(); printContent($content, "Cache hit but expired, update"); exit; } catch (Exception $e) { printContent($row['content'], "backend error, use cache"); } } printContent($content, "Cache hit"); ```

npm

zh-stroke-data

常用國字標準字體筆劃 XML 資料檔

#63 change from ethercalc.org to ethercalc-cache.g0v.tw

為了暫時解決因為 ethercalc 不穩而讓 hackfoldr 常常看不到內容的問題 我建置了 <http://ethercalc-cache.g0v.tw|ethercalc-cache.g0v.tw> ，一層可以擋在 ethercalc 前面的 proxy 程式放在 <https://github.com/g0v/ethercalc-cache|https://github.com/g0v/ethercalc-cache> 相關說明在 <https://g0v.hackmd.io/A175kRMVSxGqBRCerawXIA|https://g0v.hackmd.io/A175kRMVSxGqBRCerawXIA> 請幫忙變更 hackfoldr，謝謝