Eugene Khabarov ekhabarov

🛠️

Building something

Golang, gRPC/Protobuf, Bazel, generators & APIs.

ekhabarov / Generate Mongo Object ID in PostGres

Created March 2, 2016 20:08 — forked from jamarparris/Generate Mongo Object ID in PostGres

Create ObjectIds in PostGres following the MongoDB semantics. Very similar to the Instagram approach linked below. http://docs.mongodb.org/manual/reference/object-id/ http://instagram-engineering.tumblr.com/post/10853187575/sharding-ids-at-instagram

	CREATE OR REPLACE FUNCTION generate_object_id() RETURNS varchar AS $$
	DECLARE
	time_component bigint;
	machine_id int := FLOOR(random() * 16777215);
	process_id int;
	seq_id bigint := FLOOR(random() * 16777215);
	result varchar:= '';
	BEGIN
	SELECT FLOOR(EXTRACT(EPOCH FROM clock_timestamp())) INTO time_component;
	SELECT pg_backend_pid() INTO process_id;

ekhabarov / postgres_queries_and_commands.sql

Created January 22, 2016 20:43 — forked from rgreenjr/postgres_queries_and_commands.sql

Useful PostgreSQL Queries and Commands

	-- show running queries (pre 9.2)
	SELECT procpid, age(query_start, clock_timestamp()), 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(query_start, clock_timestamp()), usename, query
	FROM pg_stat_activity
	WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'

ekhabarov / sse.go

Created January 5, 2016 07:02 — forked from ismasan/sse.go

Example SSE server in Golang