Skip to content

Instantly share code, notes, and snippets.

View seancolsen's full-sized avatar

Sean Colsen seancolsen

40 followers · 10 following
  • Knoxville, TN, USA
  • 12:25 (UTC -04:00)
View GitHub Profile
@seancolsen
seancolsen / nav-updates.md
Created July 20, 2022 16:55
Navigation Updates

Context

Users need to be able to quickly browse the data model so that they can complete tasks that involve performing actions in various tables or navigating to related tables. Besides indicating the location, these navigation elements should also be used to show the hierarchical structure and the relationships between the various data model parts.

Hierarchical Structure

The navigation design will be based on the following hierarchical structure:

image

Removing Tabs

Tabs will be phased out as part of the new navigation improvements. The new navigation considers the problems that tabs addressed and incorporates them into the design.

@seancolsen
seancolsen / celestial_bodies.sql
Created April 20, 2022 14:42
Celestial Bodies
DROP TABLE IF EXISTS "star";
CREATE TABLE "star" (
"id" serial NOT NULL,
"name" VARCHAR(255) NOT NULL,
CONSTRAINT "star_pkey" PRIMARY KEY ("id")
);
INSERT INTO "star" ("id", "name") VALUES
(1, 'Sun');
DROP TABLE IF EXISTS "planet";
@seancolsen
seancolsen / Analytics.md
Created May 5, 2021 21:53
Analytics Proposal

Analytics Proposal

Overall

  • The analytics system is its own app with its own repo and its own database.
  • Eventually it could even have its own server, especially if disk space becomes an issue. But we'd start by deploying it on the prod server. A separate server would also be nice if we end up wanting to perform any analytics that turn out to be computationally intensive. A cheap VPS that's slow but has a big disk would be ideal.
  • It has a REST interface to receive data
  • No authentication at first, just don't expose it outside of localhost
  • We could use whatever stack for this tiny thing, really. It might be a cool opportunity to try something new. Maybe you want to build it in Haskell or Rust? Personally, I'd consider trying Deno and Oak because I think Deno is eventually going to supplant Node, and Oak is the Deno equivalent of Express. But we could always just build it in Flask. I'm fine with anything here.
@seancolsen
seancolsen / full-height-test.html
Created October 11, 2020 18:39
full-height-test
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8">
<meta name="viewport"
content="width=device-width, height=device-height, initial-scale=1, user-scalable=no, viewport-fit=cover">
</head>
<body>
<div id='layout'>
@seancolsen
seancolsen / civicrm-review-template-sublist-1.0.md
Created October 25, 2017 19:18

Checklist

(Move each criterion that you evaluate into "Passing" or "Failing". Add comments describing any failures.)

  • Not evaluated
    • A JIRA ticket is mentioned (or not needed) (r-jira)
    • The automated tests pass (r-test)
    • The code looks good (r-code)
    • It works as advertised (r-run)
    • Users will be able to transition to this change easily (r-users)
@seancolsen
seancolsen / alert0.js
Last active August 1, 2017 18:46
alert0
alert(0);
@seancolsen
seancolsen / useful-snippets.md
Last active July 30, 2017 20:17
Useful text snippets for random programming stuff

Useful snippets

A scratch pad of things that are hard to remember

vim

save with sudo

@seancolsen
seancolsen / amp test
Created July 23, 2017 22:35
Create test application
Create data directory: /home/sean/.amp/canary/data/kMPtKRrAp5ugpMRqFeSRQ0OP46UJfD9p
AMP_URL='http://localhost:7979'
AMP_ROOT='/home/sean/.amp/canary'
AMP_DB_DSN='mysql://canary_9e1ct:daNfLSMv1DRlh8Rx@127.0.0.1:3306/canary_9e1ct?new_link=true'
AMP_DB_USER='canary_9e1ct'
AMP_DB_PASS='daNfLSMv1DRlh8Rx'
AMP_DB_HOST='127.0.0.1'
AMP_DB_PORT='3306'
AMP_DB_NAME='canary_9e1ct'
@seancolsen
seancolsen / crowd-funding-large-extensions.md
Last active June 5, 2017 20:49

Crowd-funding large extensions

This is a chronological description so you can see my plans for bootstrapping the model. The plan so far includes just me, and I'm not totally committed to going forward with it.

  1. Brand: I would build a new brand for a dev shop. Here's what I've come up with so far (still a working name)
    • Name: Left Join Labs
    • Domain: leftjoinlabs.com (already registered)
    • Logo: logo
    • Website: haven't started on this
@seancolsen
seancolsen / leftjoinlabs.svg
Created June 2, 2017 04:36
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.