HeathHopkins / helpers.ts

Created January 21, 2024 01:04 — forked from rphlmr/helpers.ts

Drizzle ORM, deep sub queries

	export function distinctOn<Column extends AnyColumn>(column: Column) {
	return sql<Column["_"]["data"]>`distinct on (${column}) ${column}`;
	}

	export function jsonBuildObject<T extends SelectedFields>(shape: T) {
	const chunks: SQL[] = [];

	Object.entries(shape).forEach(([key, value]) => {
	if (chunks.length > 0) {
	chunks.push(sql.raw(`,`));

HeathHopkins / clear-db.ts

Created December 13, 2023 14:35 — forked from rphlmr/clear-db.ts

Drizzle snippets

	// Credits to Louistiti from Drizzle Discord: https://discord.com/channels/1043890932593987624/1130802621750448160/1143083373535973406

	import { sql } from 'drizzle-orm';

	const clearDb = async (): Promise<void> => {
	const query = sql<string>`SELECT table_name
	FROM information_schema.tables
	WHERE table_schema = 'public'
	AND table_type = 'BASE TABLE';
	`;

HeathHopkins / SparkCopyPostgres.scala

Created June 22, 2023 13:31 — forked from longcao/SparkCopyPostgres.scala

COPY Spark DataFrame rows to PostgreSQL (via JDBC)

	import java.io.InputStream

	import org.apache.spark.sql.execution.datasources.jdbc.JdbcUtils
	import org.apache.spark.sql.{ DataFrame, Row }

	import org.postgresql.copy.CopyManager
	import org.postgresql.core.BaseConnection

	val jdbcUrl = s"jdbc:postgresql://..." // db credentials elided
	val connectionProperties = {

HeathHopkins / README.md

Created March 9, 2023 00:37 — forked from Lazhari/README.md

Split a large CSV file and add headers to each file

Step One: Split file

$ split -l 5000 users.csv ./split-files

5000 is the number of lines you want for each file.)

HeathHopkins / Python3 Virtualenv Setup.md

Created March 3, 2022 21:47 — forked from pandafulmanda/Python3 Virtualenv Setup.md

Setting up and using Python3 Virtualenv on Mac

Python3 Virtualenv Setup

Requirements

Python 3
Pip 3

$ brew install python3

HeathHopkins / ubuntu-vnc-activate-remote.sh

Created April 9, 2021 13:04 — forked from samba/ubuntu-vnc-activate-remote.sh

Activate VNC support in Ubuntu, from command-line (for active sessions)

	#!/bin/sh

	# This assumes you have access to the system via SSH already, and need
	# remote VNC access as the same user, and you want only the primary display.
	export DISPLAY=:0

	# Encoded password with http://www.motobit.com/util/base64-decoder-encoder.asp
	export VNC_PASSWORD="dm5jX3Bhc3N3b3JkNzE=" # vnc_password71
	export VNC_PASSWORD="dm5jX3Bhc3M=" # vnc_password (a character limit is enforced?)
	# Sadly many common VNC clients don't support encryption.

HeathHopkins / mysql-docker.sh

Created July 10, 2020 20:12 — forked from spalladino/mysql-docker.sh

Backup and restore a mysql database from a running Docker mysql container

	# Backup
	docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql

	# Restore
	cat backup.sql \| docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE

HeathHopkins / use-nprogress.js

Created June 13, 2020 23:59 — forked from sergiodxa/use-nprogress.js

Hook to use NProgress in a Next.js application

	import { useRef, useEffect } from "react";
	import NProgress from "nprogress";
	import Router from "next/router";

	function useNProgress(showAfterMs = 300, options = {}) {
	const timer = useRef(null);

	function routeChangeStart() {
	const { showAfterMs } = this.props;
	clearTimeout(timer.current);

HeathHopkins / JS-LINQ.js

Created January 31, 2020 20:54 — forked from DanDiplo/JS-LINQ.js

JavaScript equivalents of some common C# LINQ methods. To help me remember!

	// JS array equivalents to C# LINQ methods - by Dan B.

	// Here's a simple array of "person" objects
	var people = [
	{ name: "John", age: 20 },
	{ name: "Mary", age: 35 },
	{ name: "Arthur", age: 78 },
	{ name: "Mike", age: 27 },
	{ name: "Judy", age: 42 },
	{ name: "Tim", age: 8 }

HeathHopkins / README-tomcat-as-systemd-service.md

Created August 13, 2019 13:13 — forked from drmalex07/README-tomcat-as-systemd-service.md

An example configuration for Tomcat as systemd service. #tomcat #systemd #systemd.service

README

Let Tomcat is download and installed under /opt/tomcat. Also, let tomcat be a non-provileged user under which the server will be running.

We assume that we keep server's binaries under /opt/tomcat and we will create a server instance named foo under /var/tomcat/ (carrying its own conf, logs, webapps, work, lib directories). See also https://dzone.com/articles/running-multiple-tomcat.

Create a template service unit file at /etc/systemd/system/[email protected]:

Heath Hopkins HeathHopkins

Split a large CSV file and add headers to each file

Step One: Split file

Python3 Virtualenv Setup

Requirements

README