fast-sqlite3-inserts
MonkeyType
Our great sponsors
fast-sqlite3-inserts | MonkeyType | |
---|---|---|
11 | 9 | |
363 | 4,533 | |
- | 1.0% | |
0.0 | 5.4 | |
about 1 year ago | 11 days ago | |
Rust | Python | |
MIT License | 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.
fast-sqlite3-inserts
-
SQLite performance tuning: concurrent reads, multiple GBs and 100k SELECTs/s
I am experimenting with SQLite, where I try inserting 1B rows in under a minute. The current best is inserting 100M rows at 23s. I cut many corners to get performance, but the tweaks might suit your workload.
I have explained my rationale and approach here - https://avi.im/blag/2021/fast-sqlite-inserts/
the repo link - https://github.com/avinassh/fast-sqlite3-inserts
-
I/O is no longer the bottleneck
I am working on a project [0] to generate 1 billion rows in SQLite under a minute and inserted 100M rows inserts in 33 seconds. First, I generate the rows and insert them in an in-memory database, then flush them to the disk at the end. To flush it to disk it takes only 2 seconds, so 99% of the time is being spent generating and adding rows to the in-memory B Tree.
For Python optimisation, have you tried PyPy? I ran my same code (zero changes) using PyPy, and I got 3.5x better speed.
I published my findings here [1].
[0] - https://github.com/avinassh/fast-sqlite3-inserts
[1] - https://avi.im/blag/2021/fast-sqlite-inserts/
- Ask HN: Which personal projects got you hired?
-
Is there any language that is as similar as possible to Python in syntax, readability, and features, but is statically typed?
I have a side project where I tried to insert one billion rows in SQLite. I was able to insert 100 million rows using Python under 210 seconds. The same thing with PyPy took 120 seconds. I am wondering what kind of speed boost I would get with Cython
- Ask for benchmark. The owner can’t verify a 18% perf gain, could you?
-
Inserting One Billion Rows in SQLite Under A Minute
Measure, measure, measure! There is a PR which made really minor changes, but it got 2x speed boost with CPython version
- Inserting One Billion Rows in SQLite Under a Minute
- Weekly Coders, Hackers & All Tech related thread - 17/07/2021
-
How we achieved write speeds of 1.4 million rows per second
[somewhat related] Recently, I was benchmarking SQLite inserts and I managed to insert 3.3M records per second (100M in 33 ish seconds) on my local machine - https://github.com/avinassh/fast-sqlite3-inserts Ofcourse the comparison is not apples to apples, but sharing here if anyone finds it interesting
MonkeyType
-
Enhance Your Project Quality with These Top Python Libraries
MonkeyType collects runtime types of function arguments and return values, and can automatically generate stub files or add type annotations directly to your Python code based on the types collected at runtime.
-
A Tale of Two Kitchens - Hypermodernizing Your Python Code Base
To alleviate the burden of manual annotation, MonkeyType offers a clever solution. It dynamically observes the types entering and leaving functions during code execution. Based on this observation, it generates a preliminary draft of type annotations. This significantly reduces the effort needed to add type hints to legacy code.
- Do you know any library that automatically detects unused files / functions inside a project folder?
-
Programming Breakthroughs We Need
https://github.com/instagram/MonkeyType can perform the call logging, and can export a static typing file which is used by mypy, but also e.g. PyCharm. It doesn't expose such fine grained types, but you could build that based on the logged data.
-
Gradually introduce type checking to an existing typed codebase.
Which introduces MonkeyType, a python library that generatics static type annotations by collecting runtime types.
- Call me naive, but would it not be possible to create a tool for python the auto adds type hints at run time?
- Is there any language that is as similar as possible to Python in syntax, readability, and features, but is statically typed?
-
Typehole – Create TypeScript interfaces from JS runtime values automatically
Not sure if you're joking but there is something similar for python developed by a rather well known company https://github.com/Instagram/MonkeyType
- Cinder: Instagram's performance oriented fork of CPython
What are some alternatives?
tsbs - Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data
PythonBuddy - 1st Online Python Editor With Live Syntax Checking and Execution
julia - The Julia Programming Language
unimport - :rocket: The ultimate linter and formatter for removing unused import statements in your code.
plum - Multiple dispatch in Python
Cinder - Cinder is a community-developed, free and open source library for professional-quality creative coding in C++.
sqlite_micro_logger_arduino - Fast and Lean Sqlite database logger for Arduino UNO and above
typehole - TypeScript development tool for Visual Studio Code that helps you automate creating the initial static typing for runtime values
remixdb - RemixDB: A read- and write-optimized concurrent KV store. Fast point and range queries. Extremely low write-amplification.
cinder - Cinder is Meta's internal performance-oriented production version of CPython.
dynamic-dns - An automated dynamic DNS solution for Docker and DigitalOcean