Skip to content

Instantly share code, notes, and snippets.

💭
🥃

David E. Wheeler theory

💭
🥃
View GitHub Profile
View curl-fc-repo.txt
$ curl sfc-repo.snowflakecomputing.com -v
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 0 0 0 0 0 0 0 --:--:-- --:--:-- --:--:-- 0* Trying 99.84.41.12...
* TCP_NODELAY set
* Connected to sfc-repo.snowflakecomputing.com (99.84.41.12) port 80 (#0)
> GET / HTTP/1.1
> Host: sfc-repo.snowflakecomputing.com
> User-Agent: curl/7.64.1
View curl-sfc-repo-docker.sh
# # In docker container
# curl -v sfc-repo.snowflakecomputing.com/index.html
* Expire in 0 ms for 6 (transfer 0x5560e6f4ef50)
* Expire in 1 ms for 1 (transfer 0x5560e6f4ef50)
* Expire in 0 ms for 1 (transfer 0x5560e6f4ef50)
* Expire in 2 ms for 1 (transfer 0x5560e6f4ef50)
* Expire in 1 ms for 1 (transfer 0x5560e6f4ef50)
* Expire in 1 ms for 1 (transfer 0x5560e6f4ef50)
* Expire in 4 ms for 1 (transfer 0x5560e6f4ef50)
* Expire in 2 ms for 1 (transfer 0x5560e6f4ef50)
View purge_old_deltas.sql
DO $$
DECLARE
target TEXT;
BEGIN
FOR target IN
SELECT table_name
FROM information_schema.tables
WHERE table_schema = 'bucardo'
AND table_name LIKE 'track_%'
LOOP
View limit-lowercase.patch
--- a/bucardo.schema
+++ b/bucardo.schema
@@ -73,8 +73,9 @@ RETURNS TRIGGER
LANGUAGE plpgsql
AS $bc$
BEGIN
-
- NEW.setting = LOWER(NEW.setting);
+ IF NEW.name <> ALL('{log_conflict_file,warning_file,email_debug_file,flatfile_dir,reason_file,stats_script_url,stopfile,log_timer_format}') THEN
+ NEW.setting = LOWER(NEW.setting);
View no-lc.patch
--- a/bucardo
+++ b/bucardo
@@ -8755,7 +8755,8 @@ sub config {
for my $noun (@nouns) {
$noun =~ /(\w+)=(.+)/ or die $setusage;
- my ($setting,$val) = (lc $1,$2);
+ my $setting = lc $1;
+ my $val = $setting eq 'log_timer_format' ? $2 : lc $2;
View gist:306590e6ae88f9fd3d11f28092c33bc7
# Installs build dependency.
$ cpanm --quiet -L try --notest DBI
Successfully installed Test-Simple-1.302140
Successfully installed DBI-1.641
2 distributions installed
# Installs configure dependency.
$ cpanm --quiet -L try --notest Widget::Meta
Successfully installed Module-Build-0.4224
Successfully installed Widget-Meta-0.06
View Dockerfile
FROM alpine:latest
RUN apk add --update less
ENV TERM xterm-256color
ENTRYPOINT echo -e "Color me \033[31mRED" | less
View pgenv.sh
#!/bin/bash
# Versions:
# 10.4 9.6.9 9.5.13 9.4.18 9.3.23 9.2.24 9.1.24 9.0.19 8.4.22 8.3.23 8.2.23 8.1.23 8.0.26
BASE=$HOME/pg
PGSQL=$BASE/pgsql
PG_DATA=$PGSQL/data
PG_CTL="$PGSQL/bin/pg_ctl -D $PG_DATA"
View pg.patch
diff --git a/lib/App/Sqitch/Engine/pg.pm b/lib/App/Sqitch/Engine/pg.pm
index 71a8d2cc..11e55ca1 100644
--- a/lib/App/Sqitch/Engine/pg.pm
+++ b/lib/App/Sqitch/Engine/pg.pm
@@ -45,15 +45,22 @@ has _psql => (
my $self = shift;
my $uri = $self->uri;
my @ret = ( $self->client );
- for my $spec (
- [ username => $self->username ],
View plv8-centos7-output.txt
+ make PG_CONFIG=/usr/pgsql-9.4/bin/pg_config -j16
sed -e 's/^#undef PLV8_VERSION/#define PLV8_VERSION "2.1.0"/' plv8_config.h.in > plv8_config.h
echo "extern const unsigned char coffee_script_binary_data[] = {" >coffee-script.cc
echo "extern const unsigned char livescript_binary_data[] = {" >livescript.cc
sed -e 's/@PLV8_VERSION@/2.1.0/g' plv8.control.common | g++ -E -P -DLANG_plv8 - > plv8.control
sed -e 's/@LANG_NAME@/plv8/g' plv8.sql.common | sed -e 's/@PLV8_VERSION@/2.1.0/g' | g++ -E -P -I. -I./ -I/usr/pgsql-9.4/include/server -I/usr/pgsql-9.4/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -DLANG_plv8 - > plv8--2.1.0.sql
sed -e 's/@PLV8_VERSION@/2.1.0/g' plv8.control.common | g++ -E -P -DLANG_plcoffee - > plcoffee.control
sed -e 's/@LANG_NAME@/plcoffee/g' plv8.sql.common | sed -e 's/@PLV8_VERSION@/2.1.0/g' | g++ -E -P -I. -I./ -I/usr/pgsql-9.4/include/server -I/usr/pgsql-9.4/include/internal -D_GNU_SOURCE -I/usr/include/libxml2 -I/usr/include -DLANG_plcoffee - > plcoffee--2.1.0.sq
You can’t perform that action at this time.