Skip to content

Instantly share code, notes, and snippets.

View thomasbaldwin's full-sized avatar

Thomas Baldwin thomasbaldwin

  • New York, New York
View GitHub Profile
@dpapathanasiou
dpapathanasiou / SchemaSpy-HOWTO.md
Last active February 17, 2024 19:45
How to use SchemaSpy to generate the db schema diagram for a PostgreSQL database

SchemaSpy is a neat tool to produce visual diagrams for most relational databases.

Here's how to use it to generate schema relationship diagrams for PostgreSQL databases:

  1. Download the jar file from here (the current version is v6.1.0)

  2. Get the PostgreSQL JDBC driver (unless your installed version of java is really old, use the latest JDBC4 jar file)

  3. Run the command against an existing database. For most databases, the schema (-s option) we are interested in is the public one:

var gulp = require('gulp');
var pug = require('gulp-pug');
var stylus = require('gulp-stylus');
var babel = require('gulp-babel');
var concat = require('gulp-concat');
var copy = require('gulp-copy');
gulp.task('default', ['compile']);
gulp.task('compile', ['pug','styl','babel','img'] );
@LGCX
LGCX / Result.js
Created July 2, 2021 17:01
React Code-Snippet Sample Gist
import React, { useEffect, useState } from 'react';
import {Modal, ModalTitle} from 'react-bootstrap';
import getTestData from '../testData';
import './Result.css';
import generateMapsURL from '../generateMapsURL';
const Result = (props) => {
const [imageURL, setImageURL] = useState(null);
const [show, setShow] = useState(false);
const handleClose = () => setShow(false);