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.3.tar.gz (8.0 kB view details)

Uploaded Source

File details

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

File metadata

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

File hashes

Hashes for shardgather-0.1.3.tar.gz
Algorithm Hash digest
SHA256 32edebaea88edf38bbeed0c7777b59f26bab69f125678ec95b214f5fd53be90f
MD5 b5b9cbe55aacb59f5dc04d49e7f40a83
BLAKE2b-256 565f5d7ea73aef0c7933c931d97d2a0e73f0ca3f2ae91f09393455e6bc2eda85

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