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>
  `
}

timwis

FORMAT: 1A

# Dataface

Build and manage data with a spreadsheet-like interface.

# Group Sheets

Resources related to sheets (which is what dataface calls database tables).

timwis

SELECT
	cols.column_name,
	cols.data_type,
	cols.character_maximum_length,
	cols.column_default,
	cols.is_nullable::boolean,
	constr.constraint_type,
	pg_catalog.col_description(cls.oid, cols.ordinal_position::int)::jsonb
FROM
	pg_catalog.pg_class cls,