python-cx_Oracle
ultrajson
| python-cx_Oracle | ultrajson | |
|---|---|---|
| 1 | 5 | |
| 892 | 4,393 | |
| 0.0% | 0.5% | |
| 3.0 | 7.0 | |
| 26 days ago | 14 days ago | |
| C | C | |
| GNU General Public License v3.0 or later | GNU General Public License v3.0 or later |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
python-cx_Oracle
-
Ask HN: How to optimise databases for latency rather than throughput?
Hm, maybe I need to run my tests again.
> https://github.com/oracle/python-cx_Oracle/issues/555#issue-...
This is what I saw for Oracle running on RDS. My ping was pretty stable: 500us.
What I found was that RDMSs are an order of magnitude slower even without the network latency.
ultrajson
-
Ultimate Guide to JSON Parsing in Python
So json is reliable and powerful though not as fast as some other community json libraries like ujson or orjson which are further optimized for speed.
-
orjson: Fast, correct Python JSON lib supporting dataclasses, datetimes, NumPy
Written in Rust!
TIL ujson is basically deprecated and they recommend switching to orjson https://github.com/ultrajson/ultrajson
> UltraJSON's architecture is fundamentally ill-suited to making changes without risk of introducing new security vulnerabilities. As a result, this library has been put into a maintenance-only mode. Support for new Python versions will be added and critical bugs and security issues will still be fixed but all other changes will be rejected. Users are encouraged to migrate to orjson which is both much faster and less likely to introduce a surprise buffer overflow vulnerability in the future.
-
Processing JSON 2.5x faster than simdjson with msgspec
ujson
-
Benchmarking Python JSON serializers - json vs ujson vs orjson
For most cases, you would want to go with python’s standard json library which removes dependencies on other libraries. On other hand you could try out ujsonwhich is simple replacement for python’s json library. If you want more speed and also want dataclass, datetime, numpy, and UUID instances and you are ready to deal with more complex code, then you can try your hands on orjson
-
The fastest tool for querying large JSON files is written in Python (benchmark)
I asked about this on the Github issue regarding these benchmarks as well.
I'm curious as to why libraries like ultrajson[0] and orjson[1] weren't explored. They aren't command line tools, but neither is pandas right? Is it perhaps because the code required to implement the challenges is large enough that they are considered too inconvenient to use through the same way pandas was used (ie, `python -c "..."`)?
[0] https://github.com/ultrajson/ultrajson
What are some alternatives?
DBD-Oracle - Oracle database driver for the DBI module
marshmallow - A lightweight library for converting complex objects to and from simple Python datatypes.
oracle-db-tools - This project is a repository of sample code that will demonstrate various concepts to assist developers in building applications around Oracle Database technologies. SDKs and scripts will be available to integrate with SQL Developer, Data Modeler, Oracle REST Data Services and DBaaS.
pysimdjson - Python bindings for the simdjson project.
surrealdb.py - SurrealDB SDK for Python
python-rapidjson - Python wrapper around rapidjson