Skip to main content

A tool for running SQL on multiple sharded databases

Project description

```
_____ __ _____ ____ ____ _________ ________ ____________
/ ___// / / / | / __ \/ __ \/ ____/ |/_ __/ / / / ____/ __ \
\__ \/ /_/ / /| | / /_/ / / / / / __/ /| | / / / /_/ / __/ / /_/ /
___/ / __ / ___ |/ _, _/ /_/ / /_/ / ___ |/ / / __ / /___/ _, _/
/____/_/ /_/_/ |_/_/ |_/_____/\____/_/ |_/_/ /_/ /_/_____/_/ |_|

```

A script that runs a SQL statement against a collection of sharded databases and gathers the results


Installation
============

- (optional) Create a virtual environment:

```bash
virtualenv shardgather-env
source shardgather-env/bin/activate
```

From source
-----------

```bash
git clone https://github.com/kevinjqiu/shardgather.git
cd shardgather
pip install -r requirements.txt
python setup.py install
```


From PyPI (not yet)
-------------------

```python
pip install shardgather
```


Usage
=====

Generate a sample config
------------------------

shardgather -g > config.ini

or

shardgather --mkcfg > config.ini

Read queries from a SQL file
----------------------------

shardgather -c config.ini query.sql

Read queries from standard input
--------------------------------

shardgather -c config.ini -

Press Ctrl+D to terminate the input.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

shardgather-0.1.4.tar.gz (8.0 kB view hashes)

Uploaded Source

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page