dallarosa

package main

import (
        "io/ioutil"
        "log"
        "strings"
)

func main() {
        input, err := ioutil.ReadFile("myfile")

CodingDoug

Copying Data from a Google Sheet into Firebase Realtime Database in real time via Apps Script

If you're trying to do this, you came to the right place!

Watch this code work in real time: https://twitter.com/CodingDoug/status/942576182276497409

See also this gist for copying in the other direction: https://gist.github.com/CodingDoug/ffc4f050cc489a0280eb7f4cbe36af07

Setup

anarazel

WITH
  constants AS (
    SELECT
      current_setting('server_version') AS version,
      current_setting('block_size')::int AS block_size,
      current_setting('autovacuum_vacuum_cost_delay') AS cost_delay,
      1000 / extract(milliseconds FROM current_setting('autovacuum_vacuum_cost_delay')::interval) AS delays_per_sec,
      COALESCE(NULLIF(current_setting('autovacuum_vacuum_cost_limit')::int, -1), current_setting('vacuum_cost_limit')::int) AS cost_limit,
      current_setting('vacuum_cost_page_hit')::int AS cost_hit,
      current_setting('vacuum_cost_page_miss')::int AS cost_miss,