flozano’s gists

jimblom / certs.sh

Last active May 23, 2022 16:27

Update Java cacerts

	#!/bin/sh

	# certs.sh

	# use this for Yocto/Edison:
	LIB=lib
	# use this for WRLinux/Gateway
	# LIB=lib64
	if [ -f /usr/$LIB/jvm/java-8-openjdk/jre/lib/security/cacerts ]; then
	mv /usr/$LIB/jvm/java-8-openjdk/jre/lib/security/cacerts \

001101 / accounting.sql

Created February 18, 2017 09:08 — forked from NYKevin/accounting.sql

Basic double-entry bookkeeping system, for PostgreSQL.

	CREATE TABLE accounts(
	id serial PRIMARY KEY,
	name VARCHAR(256) NOT NULL
	);

	CREATE TABLE entries(
	id serial PRIMARY KEY,
	description VARCHAR(1024) NOT NULL,
	amount NUMERIC(20, 2) NOT NULL CHECK (amount > 0.0),
	-- Every entry is a credit to one account...

ststeiger / Foreign_key_dependencies_PGSQL.sql

Last active January 4, 2025 19:59

List tables by foreign-key dependencies PostgreSQL (also works on MS-SQL with minor modifications)

	DROP TABLE IF EXISTS CTE_AllTables;
	-- CREATE TEMPORARY TABLE IF NOT EXISTS CTE_AllTables

	CREATE TEMPORARY TABLE CTE_AllTables AS
	SELECT
	ist.table_schema AS OnTableSchema
	,ist.table_name AS OnTableName
	,tForeignKeyInformation.FkNullable
	-- WARNING: TableSchema or Tablename can contain entry-separator (';' used)
	,CAST(DENSE_RANK() OVER (ORDER BY ist.table_schema, ist.table_name) AS varchar(20)) AS OnTableId

t3rmin4t0r / MonBuffers.java

Created January 15, 2016 06:59

Monitoring direct memory in the JVM (from https://blogs.oracle.com/alanb/entry/monitoring_direct_buffers, adapted for JDK8)

	import java.io.File;
	import java.util.*;
	import java.lang.management.BufferPoolMXBean;
	import java.lang.management.ManagementFactory;
	import javax.management.MBeanServerConnection;
	import javax.management.ObjectName;
	import javax.management.remote.*;

	import com.sun.tools.attach.VirtualMachine; // Attach API

popravich / PostgreSQL_index_naming.rst

Last active January 6, 2025 08:57

PostgreSQL index naming convention to remember

The standard names for indexes in PostgreSQL are:

{tablename}_{columnname(s)}_{suffix}

where the suffix is one of the following:

pkey for a Primary Key constraint;

key for a Unique constraint;

excl for an Exclusion constraint;

idx for any other kind of index;

davidcaste / inflate_body.lua

Last active November 26, 2024 14:32

Nginx config: receive a request with a gzipped body, inflate it, and pass it to a proxied server

	-- Debian packages nginx-extras, lua-zlib required

	ngx.ctx.max_chunk_size = tonumber(ngx.var.max_chunk_size)
	ngx.ctx.max_body_size = tonumber(ngx.var.max_body_size)

	function create_error_response (code, description)
	local message = string.format('{"status":400,"statusReason":"Bad Request","code":%d,"exception":"","description":"%s","message":"HTTP 400 Bad Request"}', code, description)
	ngx.status = ngx.HTTP_BAD_REQUEST
	ngx.header.content_type = "application/json"
	ngx.say(message)

JaiHirsch / GradeInserter.java

Created March 29, 2015 16:52

MongoDB 3.0 java driver Codec example - main class to run the Grades Codec example

	package org.scratch;

	import org.bson.Document;
	import org.bson.codecs.Codec;
	import org.bson.codecs.configuration.CodecRegistries;
	import org.bson.codecs.configuration.CodecRegistry;

	import com.mongodb.MongoClient;
	import com.mongodb.MongoClientOptions;
	import com.mongodb.client.MongoCollection;

JaiHirsch / GradesCodec.java

Created March 29, 2015 16:51

MongoDB 3.0 java driver Codec example - Codec class for the mapping the Grades bean

	package org.scratch;

	import org.bson.BsonReader;
	import org.bson.BsonString;
	import org.bson.BsonValue;
	import org.bson.BsonWriter;
	import org.bson.Document;
	import org.bson.codecs.Codec;
	import org.bson.codecs.CollectibleCodec;
	import org.bson.codecs.DecoderContext;

JaiHirsch / Grades.java

Last active October 8, 2018 02:37

MongoDB 3.0 java driver Codec example - base class for the Codec mapping (bean)

	/*
	MongoDB bean object for java 3.0 driver mapping
	*/

	package org.scratch;

	import org.bson.BsonDocument;
	import org.bson.BsonDocumentWrapper;
	import org.bson.codecs.configuration.CodecRegistry;
	import org.bson.conversions.Bson;

mosheeshel / RabbitContainerRule.java

Created October 2, 2014 14:33

JUnit @rule for starting a RabbitMQ container (based on other rule - see comments)

	package rules;

	import com.google.common.collect.ImmutableMap;
	import org.eclipse.jdt.launching.SocketUtil;

	import java.util.HashMap;
	import java.util.Map;

	/**
	* Created with IntelliJ IDEA.

Francisco A. Lozano flozano