Getting Started
Thanks for trying Columno Beta!
After downloading and installing, the Columno server is listening on port 5435. The server is PostgreSQL-compatible and you may connect to it using:psql -p 5435 -h localhost -U <any user/pass> -d "dynamodb -region:<REGION (default: eu-west-1)> -table:<default: columno> -accessKeyId:<AWS_ACCESS_KEY_ID> -privateKey:<AWS_SECRET_KEY>"
The database name,
-d
, holds the API credentials to your Amazon DynamoDB.There is no need for you to create or configure anything in DynamoDB — Columno creates and maintains the DynamoDB table (default 5 read/5 write threads).
Now you may INSERT data to any given table, e.g.:
INSERT INTO Persons (name, city, age, mature) VALUES ('Col Umno', 'Aarhus', 1, false);
INSERT INTO Persons (name, city, age, mature) VALUES ('Seeplu Splus', 'Aarhus', 35, true);
And then SELECT:
SELECT * FROM Persons ORDER BY name DESC;
SELECT name, age FROM Persons WHERE age>20 AND mature=true OR age<5 ORDER BY name DESC LIMIT 2;
If you have any questions or comments, please contact us!