mingfang

-- Row Level Security Using JWT
-- Based on https://www.enterprisedb.com/blog/application-users-vs-row-level-security
-- and https://docs.postgrest.org/en/v12/explanations/db_authz.html

-- as admin user

-- create test tables
DROP TABLE IF EXISTS chat CASCADE;
CREATE TABLE chat
(

mingfang

export default function f(body) {
    const code = `
        with(this){
            return(async function(){
                ${body}
            }).call(this)
        }
    `
    return new Function(code)
};

mingfang

import child_process from 'child_process';

function spawnPromise(cmd, args, options) {
    return new Promise(function (resolve, reject) {
        const process = child_process.spawn(cmd, args, options);
        process.on('close', function (code) {
            resolve(code);
        });
        process.on('error', function (err) {
            reject(err);

mingfang

CREATE EXTENSION IF NOT EXISTS age;

LOAD 'age';
SET search_path = ag_catalog, "$user", public;

-- Apache AGE load_sql
CREATE OR REPLACE FUNCTION public.load_sql(query agtype) RETURNS SETOF agtype AS $$
BEGIN
    RETURN QUERY EXECUTE FORMAT($sql$
        WITH query AS (%s) 

mingfang

CREATE EXTENSION IF NOT EXISTS age;
CREATE EXTENSION IF NOT EXISTS pg_trgm;

LOAD 'age';
SET search_path = ag_catalog, "$user", public;

-- Apache AGE graph_search
CREATE OR REPLACE FUNCTION public.graph_search(graph agtype, label agtype, property agtype, search agtype) RETURNS SETOF agtype AS $$
DECLARE
    fts TEXT;

mingfang

export SRC="10.0.4.5:5000"
export DEST="10.0.4.5:6000"

curl -s http://${SRC}/v2/_catalog | jq .repositories[] | xargs -I {} \
skopeo sync \
--src-tls-verify=false --src docker --src-creds ${DOCKER_USER}:${DOCKER_PASS} \
--dest-tls-verify=false --dest docker --dest-creds ${DOCKER_USER}:${DOCKER_PASS} \
${SRC}/{} ${DEST}

mingfang

<script>
    import {onDestroy, onMount} from "svelte"

    export let component
    let container
    let root

    onMount(async ()=> {
        const  {createRoot} = await import('react-dom/client')
        const  {createElement} = await import('react')

mingfang

volume=70
speakers="192.168.2.103 192.168.2.60"
for host in $speakers; do
  echo $host
  # enable optical direct mode
  curl -s http://$host/opticaldirect/enabled -XPOST
  # name must be Left or Right
  curl -s http://$host/device/name | jq .
  role=$(curl -s http://$host/device/name | jq -r .data.name)
  curl -s http://$host/opticaldirect/role -d "{\"role\":\"Front$role\"}" -H "Content-Type: application/json" 

mingfang

package main

import (
    "context"
    "flag"
    "os"
    "os/exec"

    "go.uber.org/cadence/.gen/go/cadence/workflowserviceclient"
    "go.uber.org/cadence/activity"

mingfang