Pre-release
This release is a pre-release and may not be stable for production use.
DQL
- Build:
- 0.1 Build:
- Documentation:
- Downloads:
- Source:
A simple, SQL-ish language for DynamoDB
Getting Started
Install with pip:
pip install dql
Here are some basic DQL examples to get you going:
Start the REPL:
$ dql -a <access key> -s <secret key> us-west-1>
Creating a table:
us-west-1> CREATE TABLE forum_threads (name STRING HASH KEY,
> subject STRING RANGE KEY)
> THROUGHPUT (4, 2);
Inserting data:
us-west-1> INSERT INTO forum_threads (name, subject, views, replies)
> VALUES ('Self Defense', 'Defense from Banana', 67, 4),
> ('Self Defense', 'Defense from Strawberry', 10, 0),
> ('Cheese Shop', 'Anyone seen the camembert?', 16, 1);
Queries:
us-west-1> SCAN forum_threads; us-west-1> COUNT forum_threads WHERE name = 'Self Defense'; us-west-1> SELECT * FROM forum_threads WHERE name = 'Self Defense';
Mutations:
us-west-1> UPDATE forum_threads SET views += 1 WHERE
> name = 'Self Defense' AND subject = 'Defense from Banana';
us-west-1> DELETE FROM forum_threads WHERE name = 'Cheese Shop';
Changing tables:
us-west-1> ALTER TABLE forum_threads SET THROUGHPUT (8, 4); us-west-1> DROP TABLE forum_threads;
0.1.0
First public release
