python-mysql-replicati
pymssql
python-mysql-replicati | pymssql | |
---|---|---|
1 | 6 | |
- | 818 | |
- | 1.1% | |
- | 8.6 | |
- | 5 days ago | |
Python | ||
- | GNU Lesser General Public License v3.0 only |
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-mysql-replicati
-
Is anyone using PyPy for real work?
I'm maintaining an internal change-data-capture application that uses a python library to decode mysql binlog and store the change records as json in the data lake (like Debezium). For our most busiest databases a single Cpython process couldn't process the amount of incoming changes in real time (thousands of events per second). It's not something that can be easily parallelized, as the bulk of the work is happening in the binlog decoding library (https://github.com/julien-duponchelle/python-mysql-replicati...).
So we've made it configurable to run some instances with Pypy - which was able to work through the data in realtime, i.e. without generating a lag in the data stream. The downside of using pypy was increased memory usage (4-8x) - which isn't really a problem. An actually problem that I didn't really track down was that the test suite (running pytest) was taking 2-3 times longer with Pypy than with CPython.
A few months ago I upgraded the system to run with CPython 3.11 and the performance improvements of 10-20% that come with that version now actually allowed us to drop Pypy and only run CPython. Which is more convenient and makes the deployment and configuration less complex.
pymssql
- Is anyone using PyPy for real work?
-
Uploading CSV files in MSSQL database daily
Install pymssql, connect to the database, read data from files and do a lot of inserts.
-
What does Java do better than Python?
Support of vendors. For example, the MS SQL driver for Python is developed from community a nd for some time it was in a maintenance state because developer stopped the project (see this). Instead, the JDBC driver is developed directly from Microsoft
- Has anyone managed to connect to a SQL Server with Python on a Mac M1?
-
If you frequently use pymssql, checkout my first library: pymssql-utils. Any feedback would also be greatly appreciated!
pymssql-utils is a small library that wraps pymssql with the aim to make your life easier, and your database admins slightly happier.
- Pornspammer buys expired FOSS domain, edits its Read The Docs site
What are some alternatives?
preshed - 💥 Cython hash tables that assume keys are pre-hashed
asyncpg - A fast PostgreSQL Database Client Library for Python/asyncio.
python-mysql-replication - Pure Python Implementation of MySQL replication protocol build on top of PyMYSQL
dataset - Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.
psycopg2cffi - Port to cffi with some speed improvements
awesome-mysql - A curated list of awesome MySQL software, libraries, tools and resources
murmurhash - 💥 Cython bindings for MurmurHash2
SuperSQLite - A supercharged SQLite library for Python
sparc-curation - code and files for SPARC curation workflows
apsw - Another Python SQLite wrapper
clickhouse-driver - ClickHouse Python Driver with native interface support
pymssql-utils - A small library that wraps pymssql to make your life easier.