https://github.com/penguinolog/sqlalchemy_jsonfield

json sqlalchemy

Last synced: about 1 month ago

Repository metadata:

SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support

Host: GitHub
URL: https://github.com/penguinolog/sqlalchemy_jsonfield
Owner: penguinolog
License: apache-2.0
Created: 2017-02-18T21:23:15.000Z (almost 8 years ago)
Default Branch: master
Last Pushed: 2024-09-04T07:48:18.000Z (4 months ago)
Last Synced: 2024-10-16T00:47:49.112Z (2 months ago)
Topics: json, sqlalchemy
Language: Python
Size: 158 KB
Stars: 22
Watchers: 3
Forks: 2
Open Issues: 4
Metadata Files:
- Readme: README.rst
- Changelog: CHANGELOG.rst
- License: LICENSE
- Code of conduct: CODE_OF_CONDUCT.md

Owner metadata:

Name: Alexey Stepanov
Login: penguinolog
Email:
Kind: user
Description: Lazy developer
Website:
Location: The Netherlands
Twitter:
Company: NVIDIA
Icon url: https://avatars.githubusercontent.com/u/16033331?u=510fb42112fd4f8ea7eba1b75d151b5e55a02e7c&v=4
Repositories: 14
Last Synced at: 2024-04-21T04:58:26.716Z
Profile URL: https://github.com/penguinolog
Sponsor URL:

Committers metadata

Last synced: about 1 month ago

Total Commits: 94
Total Committers: 6
Avg Commits per committer: 15.667
Development Distribution Score (DDS): 0.213

Commits in past year: 5
Committers in past year: 2
Avg Commits per committer in past year: 2.5
Development Distribution Score (DDS) in past year: 0.2

Name	Email	Commits
Alexey Stepanov	p**g@g**m	74
dependabot[bot]	4****]	16
Alexey Stepanov	A**v@a**m	1
Massimiliano della Rovere	m**e@g**m	1
Alexey Stepanov	p****g	1
jnnkB	2****B	1

Issue and Pull Request metadata

Last synced: about 1 month ago

Package metadata

Total packages: 3
Total downloads:
- pypi: 10,323,369 last-month
Total docker downloads: 25,040,824
Total dependent packages: 10 (may contain duplicates)
Total dependent repositories: 174 (may contain duplicates)
Total versions: 21
Total maintainers: 1

pypi: sqlalchemy-jsonfield

SQLALchemy JSONField implementation for storing dicts at SQL

Homepage:
Documentation: https://sqlalchemy-jsonfield.readthedocs.io/
Licenses: Apache-2.0
Latest release: 1.0.2 (published about 1 year ago)
Last Synced: 2024-11-10T23:44:04.681Z (about 1 month ago)
Versions: 16
Dependent Packages: 6
Dependent Repositories: 172
Downloads: 10,323,369 Last month
Docker Downloads: 25,040,824
Rankings:
- Downloads: 0.223%
- Dependent repos count: 1.151%
- Average: 1.177%
- Dependent packages count: 2.156%
Maintainers (1)
- penguinolog

SqlAlchemy provides JSON field support for several database types (PostgreSQL and MySQL for now) and semi-working dict <-> JSON <-> VARCHAR example, but... In real scenarios we have tests on sqlite, production on MySQL/MariaDB/Percona/PostgreSQL and some of them (modern Oracle MySQL & PostgreSQL) support JSON, some of them (SQLite, Percona & MariaDB) requires data conversion to Text (not VARCHAR). As addition, we have different levels of Unicode support on database and connector side, so we may be interested to switch JSON encoding between d eployments.

Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
Licenses: Apache-2.0
Latest release: 1.0.0 (published about 4 years ago)
Last Synced: 2024-10-16T21:01:58.952Z (2 months ago)
Versions: 2
Dependent Packages: 2
Dependent Repositories: 1
Rankings:
- Dependent packages count: 19.607%
- Dependent repos count: 24.407%
- Average: 38.253%
- Stargazers count: 49.743%
- Forks count: 59.254%

conda: sqlalchemy-jsonfield

Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
Licenses: Apache-2.0
Latest release: 1.0.0 (published about 4 years ago)
Last Synced: 2024-11-10T23:44:24.085Z (about 1 month ago)
Versions: 3
Dependent Packages: 2
Dependent Repositories: 1
Rankings:
- Dependent packages count: 20.447%
- Average: 45.432%
- Dependent repos count: 51.404%
- Stargazers count: 52.371%
- Forks count: 57.505%

Dependencies

requirements.txt pypi

sqlalchemy *
typing >=3.6

mypy_requirements.txt pypi

lxml *
mypy >=0.910

.github/workflows/pythonpackage.yml actions

actions/checkout v3.3.0 composite
actions/setup-python v4.5.0 composite

Dockerfile docker

python slim build

docker-compose.yml docker

mariadb latest
postgres alpine

flake8_requirements.txt pypi

flake8 *
flake8-bugbear *
flake8-docstrings *
pep8-naming *

pytest_requirements.txt pypi

coverage >=5.0 test
pytest >=6.0 test
pytest-asyncio * test
pytest-cov * test
pytest-mock * test