dql

Dev Build:
0.1 Branch:
0.2 Branch:
Documentation:: http://dql.readthedocs.org/
Downloads:: http://pypi.python.org/pypi/dql
Source:: https://github.com/mathcamp/dql

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;

And don’t forget to use help!

Changelog

0.3.0

Feature: SELECT and COUNT can have FILTER clause
Feature: FILTER clause may OR constraints together

0.2.1

Bug fix: Crash when printing ‘COUNT’ queries

0.2.0

Feature: Python 3 support

0.1.0

First public release

Metadata

Release files for dql 0.3.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for dql 0.3.0
File	Size	Uploaded
dql-0.3.0.tar.gz	20.7 kB	Jun 27, 2014	Details

Release files / dql-0.3.0.tar.gz

Download URL	dql-0.3.0.tar.gz
Size	20.7 kB
Tags	Source
SHA-256 checksum How to use checksums	`32ce53238f82c6b4aff90fcc6ac73900bbcf95d0d33337d591e473cb9c687b53`
BLAKE2b-256 checksum How to use checksums	`01aaa67fda80af73398154dd73571d4d08f44f7a0359da1bc8072cebd69ecb6e`
Upload date	Jun 27, 2014
Uploaded using Trusted Publishing? What is trusted publishing?	No