plum
fast-sqlite3-inserts
Our great sponsors
| plum | fast-sqlite3-inserts | |
|---|---|---|
| 2 | 9 | |
| 170 | 274 | |
| - | - | |
| 7.7 | 3.9 | |
| about 2 months ago | 6 months ago | |
| Python | Rust | |
| MIT License | MIT License |
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.
plum
- Is there any language that is as similar as possible to Python in syntax, readability, and features, but is statically typed?
-
How Julia Uses Multiple Dispatch to Beat Python
Singledispatch is old, dates back to py2: https://docs.python.org/3/library/functools.html#functools.s...
I definitely agree that multiple dispatch is a lot harder :). But most of the examples in the article didn't need it, and it would have been appropriate I think to show equivalent code in Python. All that article did was make me think the author didn't know Python very well.
There are several libraries for multiple dispatch too, for e.g. https://github.com/wesselb/plum
fast-sqlite3-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
-
Python programmers prepare for pumped-up performance: Article describes Pyston and plans to upstream Pyston changes back into CPython, plus Facebook's Cinder: "publicly available for anyone to download and try and suggest improvements."
I am working on this side project where I am trying to figure out the quickest way possible to generate an SQLite DB with 1B rows. The CPython version was able to 100M rows in 520 seconds and the same code under Pypy completed in 160 seconds. Here is the github code - https://github.com/avinassh/fast-sqlite3-inserts
What are some alternatives?
multipledispatch - Multiple dispatch
runtype - Utilities for run-time type validation and multiple dispatch
tsbs - Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data
Envoy - Elegant SSH tasks for PHP.
Pomander - Deploy your PHP with PHP. Inspired by Capistrano and Vlad.
MonkeyType - A Python library that generates static type annotations by collecting runtime types
python - Official Python client library for kubernetes
dynamic-dns - An automated dynamic DNS solution for Docker and DigitalOcean
snmalloc-rs - rust bindings of snmalloc
Nim - Nim is a statically typed compiled systems programming language. It combines successful concepts from mature languages like Python, Ada and Modula. Its design focuses on efficiency, expressiveness, and elegance (in that order of priority).
julia - The Julia Programming Language
Lua - Lua is a powerful, efficient, lightweight, embeddable scripting language. It supports procedural programming, object-oriented programming, functional programming, data-driven programming, and data description.