Abel Terefe abelbryo

rpherrera / makebib.perl

Created January 27, 2013 03:22

Plain Text to BibTeX references converter. Taken from: http://www.snowelm.com/~t/doc/tips/makebib.perl Original post: http://www.snowelm.com/~t/doc/tips/makebib.en.html

	#!/usr/bin/perl -T
	# $Id: makebib.perl,v 1.18 2006/02/06 05:34:04 t Exp $
	#
	# This program is free software; you can redistribute it and/or modify
	# it under the terms of the GNU General Public License as published by
	# the Free Software Foundation; either version 2 of the License, or
	# (at your option) any later version.
	#
	# This program is distributed in the hope that it will be useful,
	# but WITHOUT ANY WARRANTY; without even the implied warranty of

rgreenjr / postgres_queries_and_commands.sql

Last active May 3, 2025 05:25

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(clock_timestamp(), query_start), usename, current_query
	FROM pg_stat_activity
	WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%'
	ORDER BY query_start desc;

	-- show running queries (9.2)
	SELECT pid, age(clock_timestamp(), query_start), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

samgiles / postgistogeojson.js

Created April 4, 2012 07:38

A function that converts a PostGIS query into a GeoJSON object.

	/*
	* A function that converts a PostGIS query into a GeoJSON object.
	* Copyright (C) 2012 Samuel Giles <[email protected]>
	*
	* This program is free software: you can redistribute it and/or modify
	* it under the terms of the GNU General Public License as published by
	* the Free Software Foundation, either version 3 of the License, or
	* (at your option) any later version.
	*
	* This program is distributed in the hope that it will be useful,

shiawuen / index.html

Created December 29, 2011 15:05

Sample to upload file by chunk

	<!DOCTYPE HTML>
	<html lang="en-US">
	<head>
	<meta charset="UTF-8">
	<title>test upload by chunk</title>
	</head>
	<body>
	<input type="file" id="f" />

	<script src="script.js"></script>