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 details)

Uploaded Source

File details

Details for the file shardgather-0.1.4.tar.gz.

File metadata

  • Download URL: shardgather-0.1.4.tar.gz
  • Upload date:
  • Size: 8.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for shardgather-0.1.4.tar.gz
Algorithm Hash digest
SHA256 9065a79a994c0614583719696178092287d600d075ee64bfd8366c4cd6f7b285
MD5 93673ac2d17668393a267ced660225e5
BLAKE2b-256 4a3bf31871bf0eb4257c77c508c3ae5af327807d0cca9f358b7279c2352a53ab

See more details on using hashes here.

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