Eric Satterwhite esatterwhite

esatterwhite / pgquery.js

Created March 19, 2024 17:43

a valiant effort at a simple query builder for postgres

	'use strict'

	const kClause = Symbol('kQueryClause')
	const kPosition = Symbol('kQueryPosition')
	const kWhere = Symbol('kQueryWhere')

	const AND_BREAK = '\nAND '
	const ISNULL_EXP = /true\|1/
	const SELECT_EXP = /^SELECT/i
	const SELECT_REPLACEMENT = 'SELECT 1::SMALLINT as __id, '

esatterwhite / fastify-registered-schemas.js

Last active October 1, 2023 03:21

Wonky fastify schema validation handling

	'use strict'
	const fastify = require('fastify')
	const fluent = require('fluent-json-schema')

	const WhizBang = fluent
	.object()
	.additionalProperties(false)
	.id('whizbang')
	.title('WhizBang')
	.prop(

esatterwhite / zdb-agg.sql

Last active October 1, 2023 03:23

zdb spotlite search query example

	WITH results AS (
	select
	JSONB_ARRAY_ELEMENTS(
	zdb.extract_the_agg_data(
	index => 'spotlite_zdx'
	, field => 'organization_id'
	, response => arbitrary_agg::JSONB
	) -> 'buckets'
	) AS bucket
	FROM zdb.arbitrary_agg(

esatterwhite / inputs.js

Last active October 1, 2023 03:21

possible input / output jsonb aggregate

esatterwhite / subclass.js

Last active September 30, 2023 03:13

Classes stop being classes

	'use strict';

	function typeOf( item ){
	if(item === null) {
	return 'null';
	} else if(item === undefined) {
	return 'undefined';
	}

	if( typeof item.$family == 'function' ){

esatterwhite / jsdoc-class-header.sublime-snippet

Created August 12, 2015 13:31

Sublime Snippets

	<snippet>
	<content><![CDATA[
	/**
	* Description
	* @constructor
	* @alias module:$TM_FILENAME
	* @param {TYPE} [param]
	* @param {TYPE} [?param.val=1j]
	* @example var x = new require('$TM_FILENAME');
	* @tutorial <tutorial-name>

esatterwhite / conf.js

Created December 11, 2014 20:21

Config the everything

	/jshint node:true, laxcomma: true, smarttabs: true/
	'use strict';
	/**
	The conf package reads configurations options in an overriding fashion from a number of sources. In order of importance:

	1. System level overrides
	2. Command line arguments
	3. Environment variables
	4. A configuration file(s)
	5. System specified defaults

esatterwhite / spiritshop.json

Created October 2, 2014 15:21

	{
	"apps" : [{
	"name" : "Alice",
	"script" : "/home/esatterwhite/dev/js/spiritshop-api/server.js",
	"instances": 3,
	"port":3001,
	"env": {
	"logger": "stdout",
	"log__stdout__prettyPrint":0,
	"NODE_PATH":"/home/esatterwhite/dev/js/spiritshop-api/packages"

esatterwhite / proxy.js

Last active October 1, 2023 03:21

	var zmq = require( "zmq" )
	, xpub // xpub to redistribute messages over known port
	, xsub; // xsub to recieve incomming messaes

	var xpub_url = 'tcp://0.0.0.0:9999'
	var xsub_url = 'tcp://0.0.0.0:9998';

	var noop = function(){"use strict";}
	xpub = zmq.socket( "xpub" );
	xsub = zmq.socket( "xsub" );

esatterwhite / publisher.js

Created April 30, 2013 14:47