owensengoku owensengoku

🎯

Focusing

owensengoku / Generate Mongo Object ID in PostGres

Created December 31, 2015 07:12 — 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;