anze3db

7 ms·

1.
UV with Django(blog.pecar.me)
1 points by anze3db 2y ago|0 comments
2.
by anze3db 2y ago
Great point. I thought that `vacuum into` blocks writes, but it's only `vacuum` that blocks! I've updated the blog post, thanks!
3.
by anze3db 2y ago
I'm in a few Discord servers, but I have no idea how to find you there :)
4.
by anze3db 2y ago
I agree 100% with everything you wrote. It was very surprising to me that every transaction and every write operation blocks the whole database and not only the table it's performed upon (it makes sense since it's all a single fil
5.
by anze3db 2y ago
Don't get me wrong, the PR review is still rigorous and can take weeks. But everybody I interacted with during the process was very supportive and helpful, so the overall experience was great!
6.
by anze3db 2y ago
Stephen has a whole series of blog posts on SQLite (in Rails) that I highly recommend. I've learned most of what I know about SQLite from him! https://fractaledmind.github.io/2024/04/15/sqlite-on-rails-t.
7.
by anze3db 2y ago
From what I understand, you still need the experimental WAL2 mode[0] to not have this problem. [0] https://www.sqlite.org/cgi/src/doc/wal2/doc/wal2.md
8.
by anze3db 2y ago
While this blog post was at the #2 spot on HN it was getting 0.138 rps, so yeah 14k RPS is A LOT! That said it's still good to know when your tools will break! As far as I understand it's not really about RPS but more about consta
9.
by anze3db 2y ago
From what I know, the journal_size_limit PRAGMA still affects WAL mode, but it doesn't solve the issue of the WAL file potentially growing uncontrollably. Am I missing something?
10.
by anze3db 2y ago
I've heard this is a potential issue but I've never encountered it. Do you know about the experimental WAL2 branch[0] that splits the WAL file into two to circumvent this problem? You'd have to compile SQLite yourself from th
11.
by anze3db 2y ago
I can confirm. My experience contributing has been very positive!
12.
by anze3db 2y ago
That's rough. Is your code using transactions? If so, making sure you use `begin immediate` will help!
13.
by anze3db 2y ago
I'm not a Django core dev, but I have managed to get my changes merged into Django already (the transaction_mode setting in 5.1 was my contribution). Carlton does seem to be onboard with my idea[0], so I'm optimistic that we can m
14.
by anze3db 2y ago
Hey HN! I'm the author of the blog post. I didn't mention this in the post, but I'll try to merge some of these settings into Django by making them the new default or the default for new projects created with the start projec
15.
by anze3db 2y ago
This joke makes some good points.
16.
by anze3db 2y ago
You've missed: pdm, uv, pip-tools, pipx, rye, and probably some others. Only pdm and poetry generate cross-platform lock files by default as far as I know, but there are a lot of people trying to solve this problem right now. It's
17.
by anze3db 3y ago
I'm not sure if you can compare a project that came out of a university and got adopted by Apple with a project developed by a VC backed company with no revenue. I'm sure Charlie has the best intentions with both ruff and uv, but
18.
by anze3db 3y ago
If they stop development on Ruff today, Ruff won't be useful anymore after a few new Python releases. If the maintainers of the tools that Ruff is replacing stop maintaining them, the whole Python community will be in a really bad plac
19.
by anze3db 3y ago
What they are doing is already discouraging people from contributing to the projects their tools are replacing[0]. If they go out of business and stop supporting their tools, it might leave the Python community in a bad place. [0] https:&#
20.
by anze3db 3y ago
I hope they answer this ASAP. People in the Python community are already concerned that Astral is following the Embrace, extend, and extinguish playbook.
21.
Django SQLite Benchmark(blog.pecar.me)
1 points by anze3db 3y ago|1 comments
22.
Django, SQLite, and the Database Is Locked Error(blog.pecar.me)
1 points by anze3db 3y ago|0 comments
23.
by anze3db 3y ago
I'd love to read your thesis! If it's possible please send a link :)
24.
Show HN: Flakytest.dev – Improve your flaky test handling process(flakytest.dev)
3 points by anze3db 3y ago|3 comments
25.
by anze3db 3y ago
I personally wouldn't trust it with anything that involves submitting forms. What if it gets any data wrong? Even watching the demo video made me feel anxious! I guess I'm finally on the other side of this Douglas Adams quote: &gt
26.
by anze3db 3y ago
That makes sense if you already have a pub/sub service running. But if you have a pub/sub service running, you probably also have a service that can count events so you won't need ratelimitapi.com. In this case, I'm gues
27.
by anze3db 3y ago
I like the simplicity of the landing page! For me personally, the tool would be more useful if I could adjust the duration and the rate limit count without redeploying my code, but I'd also sooner spin up my own Redis instance than use
28.
by anze3db 3y ago
Awesome, thank you!
29.
by anze3db 3y ago
Excellent, thank you! This is my project: https://github.com/anze3db/django-tui
30.
by anze3db 3y ago
Looks like a cool project! I really like the idea of seeing surging packages, but I probably won't remember to check your site every week. I'd be happy to sign up to a mailing list to receive the surge list in my inbox every week

More ›