Skip to content

Instantly share code, notes, and snippets.

View xvaara's full-sized avatar

Jukka Raimovaara xvaara

View GitHub Profile
/usr/local/lib/python2.6/dist-packages/djangoratings/fields.py:316: DeprecationWarning: A Field class whose get_db_prep_save method hasn't been updated to take a `connection` argument.
class RatingField(IntegerField):
/usr/local/lib/python2.6/dist-packages/djangoratings/fields.py:316: DeprecationWarning: A Field class whose get_db_prep_lookup method hasn't been updated to take `connection` and `prepared` arguments.
class RatingField(IntegerField):
Syncing...
Creating tables ...
Installing custom SQL ...
Installing indexes ...
No fixtures found.
Internal Server Error: /
Traceback (most recent call last):
File "/usr/local/lib/python2.6/dist-packages/django/core/handlers/base.py", line 111, in get_response
response = callback(request, *callback_args, **callback_kwargs)
File "/usr/local/lib/python2.6/dist-packages/django/utils/decorators.py", line 93, in _wrapped_view
response = view_func(request, *args, **kwargs)
File "/usr/local/lib/python2.6/dist-packages/django/views/decorators/vary.py", line 22, in inner_func
response = func(*args, **kwargs)
File "/home/webdev/bongaus/qr-spotter/qr/spotter/views.py", line 148, in index
return _base(request, 'index', c)
@xvaara
xvaara / install.xdanger.sh
Created April 6, 2012 10:33
install webgui 8 on debian stable
#!/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
@xvaara
xvaara / output.txt
Created April 8, 2012 08:34
my output from wg8 install
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
xvaara / keybase.md
Created February 23, 2017 23:21
keybase

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
xvaara / index_stats.sql
Last active October 14, 2017 23:13
TimescaleDB index stats
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
xvaara / bencmark.sql
Created September 19, 2018 19:10
Benchmark PL/pgSQL, PL/v8, PL/lua-ng
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
xvaara / apollo.js
Last active November 8, 2020 19:28
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
xvaara / postgraphiql.ts
Last active October 28, 2021 06:06
Dark mode for PostgraphiQL
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
xvaara / memory-stats.vue
Last active November 10, 2021 14:32
monitor v8 memory usage in chrome based browsers.
<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>