andyrichardson

JSON to CSV

Conversion of JSON to CSV without libraries

const jsonToCSV = (data, columns) => {
  // Create CSV string
  const makeRow = (columns) => columns.map((c) => (c === undefined ? '' : `${JSON.stringify(c)}`)).join(',') + '\n';
 const resolvePath = (data, path) => path.reduce((obj, p) => obj[p], data);

andyrichardson

About

Frame times (90fps) are inconsistent causing linear movements to feel jittery/non-linear.

Version

• Quest 2 (v28)
• Virtual Desktop: V1.20.5 (client and streamer)

Reproduction (desktop)

• Make sure desktop is running at at least 90fps
• Visit this ufotest

andyrichardson

07/07/21

Events Pagination

Peek.2021-07-06.11-17.mp4

PR for using cursor based pagination for fetching apps.

• Dealt with a lot of pagination methods on Urql
• Follows Relay Cursor Connections Specification

andyrichardson

import { useLayoutEffect, useRef } from "react";
import { createPortal } from "react-dom";

const createPortalComponent = (el: HTMLElement) => ({ children }) => {
  const ref = useRef<HTMLElement>(document.createElement("div"));

  useLayoutEffect(() => {
    el.appendChild(ref.current);
    return () => el.removeChild(ref.current);
  }, []);

andyrichardson

<domain xmlns:qemu="http://libvirt.org/schemas/domain/qemu/1.0" type="kvm">
  <name>popos20.10</name>
  <uuid>6c914fa3-f90a-40d0-b17d-cc24ed8ee3d8</uuid>
    <metadata>
    <libosinfo:libosinfo xmlns:libosinfo="http://libosinfo.org/xmlns/libvirt/domain/1.0">
      <libosinfo:os id="http://system76.com/popos/20.10"/>
    </libosinfo:libosinfo>
  </metadata>
  <memory unit="KiB">4194304</memory>
  <currentMemory unit="KiB">4194304</currentMemory>

andyrichardson

csvToJson

const csvToJson = (arr: any[]) => {
  const keys = Object.keys(arr[0])
  return arr.reduce(
    (p, c) => `${p}\n${keys.map((k) => c[k]).join(',')}`,
    keys.join(','),
  )
}

andyrichardson

// ==UserScript==
// @name         Quip Style Change
// @namespace    http://tampermonkey.net/
// @version      0.1
// @description  Reduce bottom margin on section elements to make grouping of content more implicit.
// @author       Andy Richardson
// @match        https://your-quip-domain.com/* <- SWAP THIS
// @icon         https://www.google.com/s2/favicons?sz=64&domain=quip-apple.com
// @grant        none
// ==/UserScript==