timwis

SELECT
	con.oid as "constraint_oid",
	conname as "constraint_name",
  pg_catalog.pg_get_constraintdef(con.oid, true) as "constraint_definition",
  conrelid as "constrained_table_oid",
	col.attname as "constrained_column_name",
  confrelid as "referenced_table_oid",
  ref.attname as "referenced_column_name"
FROM pg_catalog.pg_constraint as con
CROSS JOIN UNNEST(conkey) WITH ORDINALITY as constrained_cols(col_num, col_index)

timwis

<template>
  <b-autocomplete
    v-bind="$attrs"
    :data="features"
    :loading="isLoading"
    field="properties.name"
    keep-first
    @typing="search"
    @select="option => selected = option"
  >

timwis

#!/usr/bin/env bash

import () {
  csvjson "${3:-/dev/stdin}" \
  | jq --raw-output '.[] | @sh "echo orc add-entry '"$1"' user \(.'"$2"') \(tostring)"' \
  | xargs -0 bash -c
}

export_ () {
  orc ls "$1" user | cut -f 4 | in2csv -f ndjson

timwis

<template>
  <LMap id="map" :center="center" :zoom="zoom">
    <LTileLayer
      :options="layerOptions"
      :tile-layer-class="tileLayerClass" />
  </LMap>
</template>

<script>
import { LMap, LTileLayer } from 'vue2-leaflet'

timwis

problem statement

• enterprises will inevitably have more data being collected and maintained than their IT departments can keep up with, so business users resort to using spreadsheets or proprietary/incompatible tools.
• hard to share or integrate this data with other systems
• eventually the IT departments have to come in and build on top of or fix these tools (crazy formatting, having to reverse engineer the export)
• there isn't really a great alternative
  • access: desktop software, outdated, not multi-user.
  • airtable: prioprietary, saas-only and could disappear/pivot.
  • salesforce: expensive, proprietary, easy to cross the line where it's very difficult to port (e.g. workflows, notifications).

goals

timwis

import { mapActions, mapState } from 'vuex'

export default {
  computed: mapState({
    services: (state) => state.services
  }),
  methods: mapActions([
    'getServices'
  ]),
  async created () {

timwis

Keybase proof

I hereby claim:

• I am timwis on github.
• I am timwis (https://keybase.io/timwis) on keybase.
• I have a public key ASDZvrXjQGJWWeDkYoCfyTS1tZaempyiVUgGSj0wMRJkhwo

To claim this, I am signing this object:

timwis

<template lang="pug">
div.crosshairs
</template>

<script>
import L from 'leaflet'
import esri from 'esri-leaflet'
import 'leaflet-easybutton'

export default {

timwis

const Nestable = require('react-nestable').default
const React = require('react')
const ReactDOM = require('react-dom')
const Nanocomponent = require('nanocomponent')
const css = require('sheetify')

css('react-nestable/dist/Nestable/Nestable.css')
css('react-nestable/dist/Icon/Icon.css')

module.exports = class TaskList extends Nanocomponent {

timwis

const html = require('bel')

window.CustomButton = function (props) {
  console.log('Called CustomButton', props)
  return html`
    <button style="background-color: ${props.color}">
      ${props.label}
    </button>
  `
}