A peewee extension for TiDB.
Project description
peewee-tidb
TiDB dialect for peewee.
Installation
Install from PyPI
pip install peewee-tidb
Install from source
pip install git+https://github.com/wd0517/peewee-tidb.git@main
Usage
from peewee import *
from peewee_tidb import TidbDatabase
db = TiDBDatabase(
'peewee',
host='127.0.0.1',
port=4000,
user='root',
password=''
)
Using AUTO_RANDOM
AUTO_RANDOM
is a feature in TiDB that generates unique IDs for a table automatically. It is similar to AUTO_INCREMENT
, but it can avoid write hotspot in a single storage node caused by TiDB assigning consecutive IDs. It also have some restrictions, please refer to the documentation.
from peewee_tidb import BigAutoRandomField
class MyModel(BaseModel):
id = BigAutoRandomField(shard_bits=6, range=54, primary_key=True)
Note
AUTO_RANDOM
is supported after TiDB v3.1.0, and only support define withrange
after v6.5.0, sorange
will be ignored if TiDB version is lower than v6.5.0.
Using AUTO_ID_CACHE
AUTO_ID_CACHE
allow users to set the cache size for allocating the auto-increment ID, as you may know, TiDB guarantees that AUTO_INCREMENT values are monotonic (always increasing) on a per-server basis, but its value may appear to jump dramatically if an INSERT operation is performed against another TiDB Server, This is caused by the fact that each server has its own cache which is controlled by AUTO_ID_CACHE
. But from TiDB v6.4.0, it introduces a centralized auto-increment ID allocating service, you can enable MySQL compatibility mode by set AUTO_ID_CACHE
to 1
when creating a table without losing performance.
To use AUTO_ID_CACHE
in peewee, you can set table_settings
in Meta
class.
class MyModel(BaseModel):
name = CharField(max_length=32, unique=True)
class Meta:
table_settings = "auto_id_cache=1;"
Some Known Issues
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
Built Distribution
Hashes for peewee_tidb-0.1.1-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 94d26b61669e78646f3c28a30ac8b7e173223b6136327f76488a47275f67c732 |
|
MD5 | 4e9d7dad24ff32405986094aa3a28af1 |
|
BLAKE2b-256 | 15be6e1c425138b937159d9834a229d95254560de1d5212e2e4b17efdf0e78dd |