NextID Postgres Extension

Postgres Extension for ID generation based on Instagram ID. check out the post: instagram-engineering.com.

Requirements

Postgres Server and Dev tools.

Use the C++ make to install extension direct in Postgres.

make install
make clean

Create extension in your database:

CREATE EXTENSION nextid;

Generate ID with extension:

SELECT c_next_id(NEXTVAL('id_seq'), 1) FROM generate_series(1, 100);