nanom1t

nanom1t / instragram_next_id.sql

Created October 16, 2017 07:42 — forked from brent-hoover/instragram_next_id.sql

Instagram's sharding function. (see http://instagram-engineering.tumblr.com/post/10853187575/sharding-ids-at-instagram for explanation)

	CREATE OR REPLACE FUNCTION insta5.next_id(OUT result bigint) AS $$
	DECLARE
	our_epoch bigint := 1314220021721;
	seq_id bigint;
	now_millis bigint;
	shard_id int := 5;
	BEGIN
	SELECT nextval('insta5.table_id_seq') %% 1024 INTO seq_id;

	SELECT FLOOR(EXTRACT(EPOCH FROM clock_timestamp()) * 1000) INTO now_millis;

nanom1t / gist:cb086e21853926969da85726357f2e2f

Created May 1, 2017 18:42 — forked from klovadis/gist:5170446

Two Lua scripts for Redis to turn HGETALL and HMGET into dictionary tables

	-- gets all fields from a hash as a dictionary
	local hgetall = function (key)
	local bulk = redis.call('HGETALL', key)
	local result = {}
	local nextkey
	for i, v in ipairs(bulk) do
	if i % 2 == 1 then
	nextkey = v
	else
	result[nextkey] = v