Skip to content

Instantly share code, notes, and snippets.

View gczh's full-sized avatar
🏠
Working from home

Gabriel Chuan gczh

🏠
Working from home
View GitHub Profile
@gczh
gczh / create-drizzle-clients.ts
Created June 4, 2024 06:32
Creates multiple drizzle clients without creating new connections each time
import {
drizzle as drizzleClient,
PostgresJsDatabase,
} from "drizzle-orm/postgres-js";
import postgres from "postgres";
import * as database1Schema from "./schemas/database1/schema";
import * as database2Schema from "./schemas/database2/schema";
const createDrizzleClientSingleton = <TSchema extends Record<string, unknown>>(
db: string,
@gczh
gczh / db.rake
Created July 10, 2023 14:15
rake task to pg_dump for rails 7 development to production
# frozen_string_literal: true
# apt install postgresql-client
# apt-get -y install bash-completion wget
# wget --no-check-certificate --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | apt-key add -
# echo "deb http://apt.postgresql.org/pub/repos/apt/ `lsb_release -cs`-pgdg main" | sudo tee /etc/apt/sources.list.d/pgdg.list
# apt-get update
# apt-get -y install postgresql-client-12
namespace :db do
@gczh
gczh / keybase.md
Created May 11, 2022 03:42
Keybase

Keybase proof

I hereby claim:

  • I am gczh on github.
  • I am gabrielchuan (https://keybase.io/gabrielchuan) on keybase.
  • I have a public key whose fingerprint is CB9D 7558 5C83 B764 FDC4 7CA2 5E0A 96BD 532B B97E

To claim this, I am signing this object:

@gczh
gczh / hello.rb
Created June 12, 2014 05:55
Sample rb gist for vic
def new
hello world
end
@gczh
gczh / gist:9892359
Created March 31, 2014 13:35
Multiple navbar-collapse for Bootstrap 3 Techcrunch Style
<nav class="navbar navbar-default" role="navigation">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#search">Toggle search</button>
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#links">Toggle links</button> <a class="navbar-brand" href="#">Brand</a>
</div>
<ul class="collapse navbar-collapse nav navbar-nav" id="links">
<li class="active"><a href="#">Link</a>
@gczh
gczh / gist:9892202
Created March 31, 2014 13:26
Nav outside of navbar-collapse for Bootstrap 3
<!-- credits to http://stackoverflow.com/questions/18610249/twitter-bootstrap-3-navbar-navbar-right-outside-navbar-collapse?rq=1 -->
<div class="container">
<div class="navbar-header pull-left">
<a class="navbar-brand" href="#">BRAND</a>
</div>
<div class="navbar-header pull-right">
<ul class="nav navbar-nav pull-left">
<li>
<a href="#">Fixed Link</a>
</li>
@gczh
gczh / gist:9891841
Last active August 29, 2015 13:57
Techcrunch's Navbar Mobile Search Dropdown for Bootstrap
<nav class="navbar navbar-default" role="navigation">
<div class="container-fluid">
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target="#bs-example-navbar-collapse-2">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Brand</a>