tOlorun

-- change the public to schema of choice

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

tOlorun

/* commands to run on the coordinator */

CREATE EXTENSION citus;
SELECT master_add_node('10.0.0.2', 5432);
SELECT master_add_node('10.0.0.3', 5432);
SELECT start_metadata_sync_to_node(nodename, nodeport) FROM pg_dist_node;
SET citus.replication_model TO 'streaming'

CREATE TABLE events (
  event_id bigserial primary key,

tOlorun

Install SQL*Plus

1. Download .rpm package here
   • oracle-instantclinet*-basic-*.rpm
   • oracle-instantclinet*-devel-*.rpm
   • oracle-instantclinet*-sqlplus-*.rpm
2. Install alien (sudo apt-get install alien)
3. Convert the rpm files and install
   • sudo alien -i oracle-instantclinet*-basic-*.rpm

• sudo alien -i oracle-instantclinet*-devel-*.rpm

tOlorun

import asyncio
import aiopg
import aiopg.sa
import asyncpg
import asyncpgsa
import sqlalchemy as sa

pg_tables = sa.Table(
            'pg_tables', sa.MetaData(),
            sa.Column('schemaname'),