Skip to content

Instantly share code, notes, and snippets.

View tjokimie's full-sized avatar

Tuomo Jokimies tjokimie

16 followers · 8 following
View GitHub Profile
@dhoko
dhoko / listDirectives.js
Last active May 29, 2025 01:31
AngularJs - get list of all registered directives
const listDirectivesApp = () => {
const listDirectives = name => {
return angular
.module(name)
._invokeQueue
.filter(item => 'directive' === item[1])
.map(item => item[2][0]);
};
return angular
@henriquemenezes
henriquemenezes / postgresql-set-id-seq.sql
Created March 31, 2016 12:23
PostgreSQL set Next ID Sequence Value to MAX(id) from Table
-- Get Max ID from table
SELECT MAX(id) FROM table;
-- Get Next ID from table
SELECT nextval('table_id_seq');
-- Set Next ID Value to MAX ID
SELECT setval('table_id_seq', (SELECT MAX(id) FROM table));
@rmtsrc
rmtsrc / postgres-json-cheatsheet.md
Last active June 7, 2024 05:21
Using JSON in Postgres by example

PostgreSQL JSON Cheatsheet

Using JSON in Postgres by example.

Quick setup via Docker

  1. Download and install: Docker Toolbox
  2. Open Docker Quickstart Terminal
  3. Start a new postgres container:
    docker run --name my-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres
@vitorbritto
vitorbritto / rm_mysql.md
Last active July 8, 2025 13:59
Remove MySQL completely from Mac OSX

Remove MySQL completely

  1. Open the Terminal

  2. Use mysqldump to backup your databases

  3. Check for MySQL processes with: ps -ax | grep mysql

  4. Stop and kill any MySQL processes

  5. Analyze MySQL on HomeBrew:

    brew remove mysql
@Kartones
Kartones / postgres-cheatsheet.md
Last active July 11, 2025 19:43
PostgreSQL command line cheatsheet

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

  • -E: will describe the underlaying queries of the \ commands (cool for learning!)
  • -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)
@jeffjo
jeffjo / gist:9459921
Last active December 13, 2018 08:17
NPM Shrinkwrap Workflow

#NPM Shrinkwrap Workflow

Our workflow consists of the following steps:

  1. Hack on changes and merge to master
  2. CI detects commits to master and runs tests
  3. CI machine runs npm test
  4. Once tests pass, deployable artifact is built on separate system - call this the "build phase"
  5. Build machine runs npm install to install dependencies
  6. Build machine creates gzipped tarball (which includes dependencies) and pushes gzip file to artifact server
@joshuakemmerling
joshuakemmerling / index.html
Created March 29, 2013 13:45
Pure CSS horizontal scrolling shadows
<!DOCTYPE html>
<html>
<head>
<style>
.scrollbox {
overflow: auto;
width: 200px;
max-height: 200px;
margin: 50px auto;
@ryanjones
ryanjones / travis.yml
Created March 6, 2013 22:20
Create db/user for test db in travis yml
before_script:
- psql -c 'CREATE USER the_user WITH CREATEDB;' -U postgres
- psql -c 'CREATE database the_db_test;' -U postgres
- psql -c 'ALTER DATABASE the_db_test OWNER TO the_user' -U postgres