https://github.com/penguinolog/sqlalchemy_jsonfield
json sqlalchemy
Score: 22.056943484925284
Last synced: about 4 hours ago
JSON representation
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 (over 9 years ago)
- Default Branch: master
- Last Pushed: 2026-10-12T15:53:58.000Z (22 days ago)
- Last Synced: 2026-10-19T07:38:35.688Z (15 days ago)
- Topics: json, sqlalchemy
- Language: Python
- Size: 178 KB
- Stars: 24
- Watchers: 2
- Forks: 2
- Open Issues: 3
-
Metadata Files:
- Readme: README.rst
- Changelog: CHANGELOG.rst
- License: LICENSE
- Code of conduct: CODE_OF_CONDUCT.md
Owner metadata:
- Name: Aleksei 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: 28
- Last Synced at: 2026-10-30T12:07:42.125Z
- Profile URL: https://github.com/penguinolog
GitHub Events
Total
- Create event: 7
- Delete event: 7
- Issue comment event: 12
- Pull request event: 16
- Pull request review event: 3
- Push event: 11
- Watch event: 1
- Total: 57
Last Year
- Create event: 4
- Delete event: 3
- Issue comment event: 3
- Pull request event: 11
- Pull request review event: 1
- Push event: 3
- Total: 25
Committers metadata
Last synced: 1 day ago
Total Commits: 109
Total Committers: 5
Avg Commits per committer: 21.8
Development Distribution Score (DDS): 0.257
Commits in past year: 7
Committers in past year: 2
Avg Commits per committer in past year: 3.5
Development Distribution Score (DDS) in past year: 0.429
| Name | Commits | |
|---|---|---|
| Alexey Stepanov | p****g@g****m | 81 |
| dependabot[bot] | 4****] | 25 |
| jnnkB | 2****B | 1 |
| Massimiliano della Rovere | m****e@g****m | 1 |
| Alexey Stepanov | A****v@a****m | 1 |
Issue and Pull Request metadata
Last synced: 1 day ago
Total issues: 4
Total pull requests: 30
Average time to close issues: 8 days
Average time to close pull requests: 3 months
Total issue authors: 4
Total pull request authors: 4
Average comments per issue: 1.0
Average comments per pull request: 0.93
Merged pull request: 24
Bot issues: 0
Bot pull requests: 27
Past year issues: 0
Past year pull requests: 5
Past year average time to close issues: N/A
Past year average time to close pull requests: about 1 month
Past year issue authors: 0
Past year pull request authors: 1
Past year average comments per issue: 0
Past year average comments per pull request: 1.2
Past year merged pull request: 2
Past year bot issues: 0
Past year bot pull requests: 5
Top Issue Authors
- DavidKorczynski (1)
- 0x55AAh (1)
- Kache (1)
- alper (1)
Top Pull Request Authors
- dependabot[bot] (27)
- massimiliano-della-rovere (1)
- penguinolog (1)
- jnnkB (1)
Top Issue Labels
- enhancement (1)
Top Pull Request Labels
- dependencies (27)
- github_actions (7)
- enhancement (1)
Package metadata
- Total packages: 14
-
Total downloads:
- conda: 242,132 total
- pypi: 2,827,754 last-month
- Total docker downloads: 25,040,824
- Total dependent packages: 10 (may contain duplicates)
- Total dependent repositories: 174 (may contain duplicates)
- Total versions: 36
- Total maintainers: 2
pypi.org: 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.3 (published 6 months ago)
- Last Synced: 2026-11-02T00:03:45.412Z (1 day ago)
- Versions: 17
- Dependent Packages: 6
- Dependent Repositories: 172
- Downloads: 2,827,754 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)
proxy.golang.org: github.com/penguinolog/sqlalchemy_jsonfield
- Homepage:
- Status: removed
- Documentation: https://pkg.go.dev/github.com/penguinolog/sqlalchemy_jsonfield#section-documentation
- Licenses: apache-2.0
- Latest release: v0.0.0-20260622160955-83c74d2ecc0a (published 4 months ago)
- Last Synced: 2026-11-02T00:03:42.481Z (1 day ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent packages count: 4.373%
- Average: 4.52%
- Dependent repos count: 4.668%
conda-forge.org: sqlalchemy-jsonfield
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 almost 6 years ago)
- Last Synced: 2026-03-17T06:12:04.532Z (8 months ago)
- Versions: 2
- Dependent Packages: 2
- Dependent Repositories: 1
- Downloads: 239,764 Total
-
Rankings:
- Dependent packages count: 19.607%
- Dependent repos count: 24.407%
- Average: 38.253%
- Stargazers count: 49.743%
- Forks count: 59.254%
anaconda.org: sqlalchemy-jsonfield
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.2 (published over 1 year ago)
- Last Synced: 2026-08-01T05:03:47.834Z (3 months ago)
- Versions: 4
- Dependent Packages: 2
- Dependent Repositories: 1
- Downloads: 2,368 Total
-
Rankings:
- Dependent packages count: 20.447%
- Average: 45.432%
- Dependent repos count: 51.404%
- Stargazers count: 52.371%
- Forks count: 57.505%
nixpkgs-unstable: python313Packages.sqlalchemy-jsonfield
SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support
- Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-unstable/pkgs/development/python-modules/sqlalchemy-jsonfield/default.nix#L48
- Licenses: Apache-2.0
- Latest release: 1.0.3 (published 2 days ago)
- Last Synced: 2026-11-01T11:13:36.202Z (2 days ago)
- Versions: 2
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
- Maintainers (1)
nixpkgs-unstable: python314Packages.sqlalchemy-jsonfield
SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support
- Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-unstable/pkgs/development/python-modules/sqlalchemy-jsonfield/default.nix#L48
- Licenses: Apache-2.0
- Latest release: 1.0.3 (published 2 days ago)
- Last Synced: 2026-11-01T11:47:42.159Z (2 days ago)
- Versions: 2
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
- Maintainers (1)
nixpkgs-24.05: python311Packages.sqlalchemy-jsonfield
SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support
- Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.05/pkgs/development/python-modules/sqlalchemy-jsonfield/default.nix#L47
- Licenses: Apache-2.0
- Latest release: 1.0.2 (published 9 months ago)
- Last Synced: 2026-05-12T14:58:58.314Z (6 months ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
- Maintainers (1)
nixpkgs-24.11: python311Packages.sqlalchemy-jsonfield
SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support
- Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.11/pkgs/development/python-modules/sqlalchemy-jsonfield/default.nix#L46
- Licenses: Apache-2.0
- Latest release: 1.0.2 (published 9 months ago)
- Last Synced: 2026-10-04T02:27:29.057Z (about 1 month ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
- Maintainers (1)
nixpkgs-23.11: python311Packages.sqlalchemy-jsonfield
SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support
- Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.11/pkgs/development/python-modules/sqlalchemy-jsonfield/default.nix#L52
- Licenses: Apache-2.0
- Latest release: 1.0.1.post0+2023-04-24 (published 9 months ago)
- Last Synced: 2026-03-07T11:38:30.982Z (8 months ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
- Maintainers (1)
nixpkgs-24.05: python312Packages.sqlalchemy-jsonfield
SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support
- Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.05/pkgs/development/python-modules/sqlalchemy-jsonfield/default.nix#L47
- Licenses: Apache-2.0
- Latest release: 1.0.2 (published 9 months ago)
- Last Synced: 2026-08-04T04:03:16.281Z (3 months ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
- Maintainers (1)
nixpkgs-23.05: python310Packages.sqlalchemy-jsonfield
SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support
- Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.05/pkgs/development/python-modules/sqlalchemy-jsonfield/default.nix#L52
- Licenses: Apache-2.0
- Latest release: 1.0.1.post0+2023-04-24 (published 9 months ago)
- Last Synced: 2026-04-03T07:10:25.887Z (7 months ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
- Maintainers (1)
nixpkgs-24.11: python312Packages.sqlalchemy-jsonfield
SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support
- Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-24.11/pkgs/development/python-modules/sqlalchemy-jsonfield/default.nix#L46
- Licenses: Apache-2.0
- Latest release: 1.0.2 (published 9 months ago)
- Last Synced: 2026-08-07T20:04:30.739Z (3 months ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
- Maintainers (1)
nixpkgs-23.11: python310Packages.sqlalchemy-jsonfield
SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support
- Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.11/pkgs/development/python-modules/sqlalchemy-jsonfield/default.nix#L52
- Licenses: Apache-2.0
- Latest release: 1.0.1.post0+2023-04-24 (published 9 months ago)
- Last Synced: 2026-04-11T20:00:27.982Z (7 months ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
- Maintainers (1)
nixpkgs-23.05: python311Packages.sqlalchemy-jsonfield
SQLALchemy JSONField implementation for storing dicts at SQL independently from JSON type support
- Homepage: https://github.com/penguinolog/sqlalchemy_jsonfield
- Documentation: https://github.com/NixOS/nixpkgs/blob/nixos-23.05/pkgs/development/python-modules/sqlalchemy-jsonfield/default.nix#L52
- Licenses: Apache-2.0
- Latest release: 1.0.1.post0+2023-04-24 (published 9 months ago)
- Last Synced: 2026-08-14T07:30:01.076Z (3 months ago)
- Versions: 1
- Dependent Packages: 0
- Dependent Repositories: 0
-
Rankings:
- Dependent repos count: 0.0%
- Dependent packages count: 0.0%
- Average: 100%
- Maintainers (1)
Dependencies
- sqlalchemy *
- typing >=3.6
- lxml *
- mypy >=0.910
- actions/checkout v3.3.0 composite
- actions/setup-python v4.5.0 composite
- python slim build
- mariadb latest
- postgres alpine
- flake8 *
- flake8-bugbear *
- flake8-docstrings *
- pep8-naming *
- coverage >=5.0 test
- pytest >=6.0 test
- pytest-asyncio * test
- pytest-cov * test
- pytest-mock * test