gitarena
fast-sqlite3-inserts
gitarena | fast-sqlite3-inserts | |
---|---|---|
4 | 11 | |
82 | 363 | |
- | - | |
3.6 | 0.0 | |
about 1 month ago | about 1 year ago | |
Rust | 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.
gitarena
-
Ask HN: Which personal projects got you hired?
GitArena - https://github.com/mellowagain/gitarena
GitArena is a GitHub/Gitea/GitLab clone written in Async Rust using Tokio and Actix-Web on the backend and server-rendered HTML with htmx for interactivity.
I commented on the "Who wants to be hired?" thread of this month with this being my main portfolio show-off project. It worked and I have gotten already 2 job offers now.
-
Ask HN: Who wants to be hired? (May 2022)
Hello! I'm Mari. I'm a self-taught software developer and have spent the past 10 years programming in my free time, mostly working on my own projects and contributing to open-source. I am currently working in retail and looking for a job as a software engineer in order to turn my passion into a living and getting a foothold in the industry.
My latest and greatest project I've recently been building is GitArena (https://github.com/mellowagain/gitarena), a software development platform similiar to the likes of GitHub, GitLab and Gitea. It features built-in vcs on top of Git and issue tracking, mostly focused on being able to be self hosted. It is written in Async Rust using Actix-Web running on the Tokio async runtime and PostgreSQL as persistent database. On the frontend it uses server rendered HTML with interactivity built in Vanilla JS and htmx. It also uses Semantic UI for CSS styling.
Thanks to my existing experience in retail, I'm very good at analyzing customer needs and can thus work efficiently on building and shipping customer-orientated solutions. I'm looking to take advantage of this in my future career.
Feel free to get in touch to learn more about me and my previous experiences.
- Doing M1 MacBook Pro (M1 Max, 64GB) Compile Benchmarks!
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
What are some alternatives?
substrate - Substrate: The platform for blockchain innovators
tsbs - Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data
monkey-rust - A dancing with interpreter and compiler
julia - The Julia Programming Language
sus - [WIP] An open-source clone of a popular impostor game.
plum - Multiple dispatch in Python
bl3_save_edit - Borderlands 3 Save/Profile Editor for Windows/MacOS and Linux!
sqlite_micro_logger_arduino - Fast and Lean Sqlite database logger for Arduino UNO and above
lychee - ⚡ Fast, async, stream-based link checker written in Rust. Finds broken URLs and mail addresses inside Markdown, HTML, reStructuredText, websites and more!
remixdb - RemixDB: A read- and write-optimized concurrent KV store. Fast point and range queries. Extremely low write-amplification.
cumulus - Write Parachains on Substrate
dynamic-dns - An automated dynamic DNS solution for Docker and DigitalOcean