A sharding app to include in your project so that you can shard your data.
Project description
# [Django Sharding](https://github.com/JBKahn/django-sharding)
Django Sharding is a library and part-framework for sharding Django applications.
Note: Does not support Django 1.10.3 due to a [bug in the release](https://github.com/JBKahn/django-sharding/issues/48).
It helps you to scale your applications by sharding your data across multiple databases in a consistent way.
[![Build Status](https://travis-ci.org/JBKahn/django-sharding.svg?branch=master)](https://travis-ci.org/JBKahn/django-sharding)
[![PyPI version](https://badge.fury.io/py/django-sharding.svg)](https://badge.fury.io/py/django-sharding)
[![PyPi downloads](https://img.shields.io/pypi/dm/django-sharding.svg)](https://crate.io/packages/django-sharding/)
[![Coverage Status](https://coveralls.io/repos/JBKahn/django-sharding/badge.svg?branch=master&service=github)](https://coveralls.io/github/JBKahn/django-sharding?branch=master)
### What is Sharding?
Sharding is a way of horizontally partitioning your data by storing different rows of the same table in multiple tables across multiple databases. This helps to increase the number of connections to a given resource as well as improves read performance of your application.
### Read The Documentation
For information about how to setup sharding in your application, [read the documentation](http://josephkahn.io/django-sharding/).
### Developer Experience
I wrote this library after working on this problem for [Wave](https://www.waveapps.com) and not being able to find a library that suited our needs. What we were looking for was something that was powerful, extensible and customizable. This library was created for just that purpose and includes at least one implementation of each part of the pipeline with room to replace any individual components.
### Influences
The package was influenced by my experiences at Wave as well as the help and code of my co-workers.
### Installation
Check out the [installation section](http://josephkahn.io/django-sharding/docs/installation/Settings.html) of the docs for basic package setup.
### Basis Setup & Usage
#### Sharding by User
Select a model to shard by and open up the models.py file. Here we'll use the user model:
```python
from django.contrib.auth.models import AbstractUser
from django_sharding_library.decorators import shard_storage_config
from django_sharding_library.models import ShardedByMixin
@shard_storage_config()
class User(AbstractUser, ShardedByMixin):
pass
```
Add that custom User to your settings file using the string class path:
```python
AUTH_USER_MODEL = '<app_with_user_model>.User'
```
#### Create Your First Sharded Model
Define your new model, eg:
```python
from django.db import models
from django_sharding_library.decorators import model_config
from django_sharding_library.fields import TableShardedIDField
from django_sharding_library.models import TableStrategyModel
@model_config(database='default')
class ShardedCarIDs(TableStrategyModel):
pass
@model_config(sharded=True)
class Car(models.Model):
id = TableShardedIDField(primary_key=True, source_table_name='app.ShardedCarIDs')
ignition_type = models.CharField(max_length=120)
company = models.ForeignKey('companies.Company')
def get_shard(self):
return self.company.user.shard
```
### Running migrations
Run them as normal, for example:
```
./manage.py makemigrations <app_name>
# To let django run the migrations in all the right places.
./manage.py migrate <app>
# To specify the database to run it on
./manage.py migrate <app> --database=<database_alias>
```
### Acccessing sharded data
```python
# TODO: Update this with methods.
shard = User.shard
Car.objects.using(shard).get(id=123)
```
Django Sharding is a library and part-framework for sharding Django applications.
Note: Does not support Django 1.10.3 due to a [bug in the release](https://github.com/JBKahn/django-sharding/issues/48).
It helps you to scale your applications by sharding your data across multiple databases in a consistent way.
[![Build Status](https://travis-ci.org/JBKahn/django-sharding.svg?branch=master)](https://travis-ci.org/JBKahn/django-sharding)
[![PyPI version](https://badge.fury.io/py/django-sharding.svg)](https://badge.fury.io/py/django-sharding)
[![PyPi downloads](https://img.shields.io/pypi/dm/django-sharding.svg)](https://crate.io/packages/django-sharding/)
[![Coverage Status](https://coveralls.io/repos/JBKahn/django-sharding/badge.svg?branch=master&service=github)](https://coveralls.io/github/JBKahn/django-sharding?branch=master)
### What is Sharding?
Sharding is a way of horizontally partitioning your data by storing different rows of the same table in multiple tables across multiple databases. This helps to increase the number of connections to a given resource as well as improves read performance of your application.
### Read The Documentation
For information about how to setup sharding in your application, [read the documentation](http://josephkahn.io/django-sharding/).
### Developer Experience
I wrote this library after working on this problem for [Wave](https://www.waveapps.com) and not being able to find a library that suited our needs. What we were looking for was something that was powerful, extensible and customizable. This library was created for just that purpose and includes at least one implementation of each part of the pipeline with room to replace any individual components.
### Influences
The package was influenced by my experiences at Wave as well as the help and code of my co-workers.
### Installation
Check out the [installation section](http://josephkahn.io/django-sharding/docs/installation/Settings.html) of the docs for basic package setup.
### Basis Setup & Usage
#### Sharding by User
Select a model to shard by and open up the models.py file. Here we'll use the user model:
```python
from django.contrib.auth.models import AbstractUser
from django_sharding_library.decorators import shard_storage_config
from django_sharding_library.models import ShardedByMixin
@shard_storage_config()
class User(AbstractUser, ShardedByMixin):
pass
```
Add that custom User to your settings file using the string class path:
```python
AUTH_USER_MODEL = '<app_with_user_model>.User'
```
#### Create Your First Sharded Model
Define your new model, eg:
```python
from django.db import models
from django_sharding_library.decorators import model_config
from django_sharding_library.fields import TableShardedIDField
from django_sharding_library.models import TableStrategyModel
@model_config(database='default')
class ShardedCarIDs(TableStrategyModel):
pass
@model_config(sharded=True)
class Car(models.Model):
id = TableShardedIDField(primary_key=True, source_table_name='app.ShardedCarIDs')
ignition_type = models.CharField(max_length=120)
company = models.ForeignKey('companies.Company')
def get_shard(self):
return self.company.user.shard
```
### Running migrations
Run them as normal, for example:
```
./manage.py makemigrations <app_name>
# To let django run the migrations in all the right places.
./manage.py migrate <app>
# To specify the database to run it on
./manage.py migrate <app> --database=<database_alias>
```
### Acccessing sharded data
```python
# TODO: Update this with methods.
shard = User.shard
Car.objects.using(shard).get(id=123)
```
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
django_sharding-4.0.0.tar.gz
(31.7 kB
view hashes)
Built Distribution
Close
Hashes for django_sharding-4.0.0-py2-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8b2745ad89ca917843ee4a20c852e71881703476d33b9e0b350f2bb0b8da8b8b |
|
MD5 | 4ca1529efd7788b8c32edf51d96c7665 |
|
BLAKE2b-256 | 020814151312e41e9bc7e9c12000e6567996b6cdef8687aaf17755e69de54bff |