https://stackoverflow.com/questions/6600868/set-default-value-of-javascript-object-attributes```
// default num: 0, unit: ‘pics’
function items(op) {
const { num, unit } = Object.assign({}, { num: 0, unit: ‘pics’}, op);
}
ALTER TABLE `user` ADD `last name` VARCHAR(50) AS ( case `name` when admin then 0 else CONCAT(`name`, 'user') end ) ;
vscode remote ssh Error: EACCES: permission denied
https://github.com/microsoft/vscode/issues/48659
1. make sure that sudo -u newuser -i works in a regular ssh session without requesting a password 2. remove “-o RemoteCommand=none” and “bash” from extension.js like so```
sed -i s/"-o RemoteCommand=none"/""/ ~/.vscode/extensions/ms-vscode-remote.remote-ssh-*/out/extension.js
sed -i s/“bash”/""/ ~/.vscode/extensions/ms-vscode-remote.remote-ssh-*/out/extension.js
3\. create an ssh config entry with a RemoteCommand like this one:
Host pi-for-newuser
Hostname pi
User pi
RemoteCommand sudo -u newuser -i
[](https://1.bp.blogspot.com/-FXedlr85sQM/Xuw5z-9I5kI/AAAAAAAAZso/-0XXb2R1LWI7qAlYkZvN31GjVuKov9e_gCK4BGAsYHg/s1606/dddddd.jpg) Get Problem: mesg: ttyname failed: Inappropriate ioctl for device [https://unix.
https://firebase.google.com/docs/hosting/manage-cache?hl=zh-cn#using_cookies
将 Firebase 托管与 Cloud Functions 或 Cloud Run 搭配使用时，Cookie 通常会从传入的请求中剥离出来。这是实现高效的 CDN 缓存行为所必需的。只有特别指定的 __session Cookie 可以传入应用执行过程中。 __session Cookie（如果存在）会自动成为缓存键的一部分，也就是说，使用不同 Cookie 的两个用户绝不会收到彼此的已缓存响应。只有在您的应用根据用户授权提供不同的内容时，您才能使用 __session Cookie。
System on firebase functions always have problems that code start.
https://medium.com/@siriwatknp/cold-start-workaround-in-firebase-cloud-functions-8e9db1426bd3
So
google office https://firebase.google.com/docs/functions/networking
const http = require('http'); const functions = require('firebase-functions'); // Setting the `keepAlive` option to `true` keeps // connections open between function invocations const agent = new http.Agent({keepAlive: true}); exports.function = functions.https.onRequest((request, response) => { req = http.request({ host: '', port: 80, path: '', method: 'GET', agent: agent, // Holds the connection open after the first invocation }, res => { let rawData = ''; res.
最近寫mysql 發現 原來 mysql 在json內容時，也有支援一些操作
https://www.cnblogs.com/chuanzhang053/p/9139624.html
https://medium.com/micheh/%E5%9C%A8-mysql-%E4%BD%BF%E7%94%A8-json-5796a65701ad 再加上 mysql 還有另一個譆能 虛疑欄位 GENERATED ALWAYS AS
http://blog.changyy.org/2017/09/mysql-json-mysql-57.html
基本上可以把json內的某欄位值當成 virutal colume, 直接輸出 覺得這樣可以玩出很多變化 https://www.cnblogs.com/waterystone/p/5626098.html
