xvaara

CREATE OR REPLACE FUNCTION delete_segmentby(_tbl regclass, _col varchar, _id anyelement, OUT result integer)
    LANGUAGE plpgsql AS
$$
DECLARE
	_schema varchar := (SELECT nspname
		FROM pg_catalog.pg_class AS c
		JOIN pg_catalog.pg_namespace AS ns
		  ON c.relnamespace = ns.oid
		WHERE c.oid = _tbl);
	_table_name varchar := (

xvaara

<template>
  <component
    :is="tag"
    ref="wrapper"
    :style="{
      minWidth: '1px',
      minHeight: '1px',
    }"
  >
    <slot v-if="show" />

xvaara

<template>
  <div ref="el" class="stats" :style="style">
    <div class="memory">
      Mem: {{ memory }}
    </div>
    <svg :viewBox="'0 0 60 '+chartHeight" class="chart" :style="'height: ' + chartHeight + 'px;'">
      <polyline
        :points="chartData"
      />
    </svg>

xvaara

const graphiqlBrandingTweak = {
  ["postgraphile:graphiql:html"](html: string) {
    console.log("Applying GraphiQL Branding Tweak...");
    return html.replace(
      "</head>",
      `<style type="text/css">
        @media (prefers-color-scheme: dark) {
          html {
            filter: invert(1) hue-rotate(180deg);
          }

xvaara

const ROOT_URL = process.env.ROOT_URL;
const httpEndpoint = `${ROOT_URL}/graphql`;

export default (context) => {
  // console.log("apollo", context);
  return {
    httpEndpoint: httpEndpoint,
    headers: { "CSRF-Token": context.$config.token }
  };
};

xvaara

DROP TABLE IF EXISTS accumulator_lua;
CREATE TABLE accumulator_lua (id BIGSERIAL PRIMARY KEY, new_value INT, sum_previous INT);

DROP TABLE IF EXISTS accumulator_lua_pre;
CREATE TABLE accumulator_lua_pre (id BIGSERIAL PRIMARY KEY, new_value INT, sum_previous INT);

DROP TABLE IF EXISTS accumulator_v8;
CREATE TABLE accumulator_v8 (id BIGSERIAL PRIMARY KEY, new_value INT, sum_previous INT);

DROP TABLE IF EXISTS accumulator_plpgsql;

xvaara

SELECT
    p.parent,
    con.consrc as chunk_constraint,
    t.tablename,
    indexname,
    c.reltuples AS num_rows,
    pg_size_pretty(pg_relation_size(quote_ident(t.schemaname)::text || '.' || quote_ident(t.tablename)::text)) AS table_size,
    pg_size_pretty(pg_relation_size(quote_ident(t.schemaname)::text || '.' || quote_ident(indexrelname)::text)) AS index_size,
    CASE WHEN indisunique THEN 'Y'
       ELSE 'N'

xvaara

Keybase proof

I hereby claim:

• I am xvaara on github.
• I am xvaara (https://keybase.io/xvaara) on keybase.
• I have a public key ASDqYcEr-yFp4UUtT9Uo_oBL7UHluZSaFJduF0VKPa_wLwo

To claim this, I am signing this object:

xvaara

Linux debian 2.6.32-5-amd64 #1 SMP Thu Mar 22 17:26:33 UTC 2012 x86_64

The programs included with the Debian GNU/Linux system are free software;
the exact distribution terms for each program are described in the
individual files in /usr/share/doc/*/copyright.

Debian GNU/Linux comes with ABSOLUTELY NO WARRANTY, to the extent
permitted by applicable law.
Last login: Sun Apr  8 10:27:03 2012

xvaara

#!/bin/sh
# run on a clean debian stable
# install webgui 8, using my little tweaks to get things going. 
# xdanger


#percona mysql 5.5
gpg --keyserver  hkp://keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
gpg -a --export CD2EFD2A | apt-key add -
echo "deb http://repo.percona.com/apt squeeze main" >> /etc/apt/sources.list