maleghast

pg_dump -> psql

e.g.

1. pg_dump -U [username] -h [hostname] -p [port number] -d [source database] -t [source_table] > [output_filename].sql

2. cat [output_filename].sql | psql -U [username] -h [hostname] -p [port number] -d [target database]

If the [target database] already has the table that you want to copy, then run the pg_dump with a "-a" flag to dump 'data only'

maleghast

(defn treemap-label
  []
  (r/create-class
   {:reagent-render (fn
                      []
                      (let [props (r/props this)]
                        [:g
                         [:text
                          {:x (/ (+ (:x props) (:width props)) 2)
                           :y (+ (/ (+ (:y props) (:height props)) 2) 7)

maleghast

(ns maleghast.aoc2023.day1
  (:require [clojure.string :as str]
            [clojure.java.io :as io])
  (:gen-class))
​
(defn first-and-last
  [vec-of-nums-as-strings]
  (str (first vec-of-nums-as-strings) (last vec-of-nums-as-strings)))
​
(defn numbers-as-text-to-digits

maleghast

(ns maleghast.aoc2023.day2
  (:require [clojure.string :as str]
            [clojure.java.io :as io])
  (:gen-class))

(def colour-maximums {:blue 14 :green 13 :red 12})

(defn check-game-valid
  [game-data]
  (reduce