syastrov

5 ms·

1.
by syastrov 3y ago
Probably more likely inefficient data access patterns, such as N+1 queries, inefficient algorithms, lack of parallelism
2.
by syastrov 4y ago
It is super interesting! I was at a talk where a genetics company used the Smith-Waterman algorithm (1) to perform sequence alignment. Still I believe it took a long time (24 hours?) to perform the calculations. They were working on optimiz
3.
by syastrov 4y ago
I did an experiment of switching an app which uses Postgres to use SQLite. I ran into issues where I had a long running transaction in one process doing writes and another process doing reads and writes. As soon as the second process tried
4.
by syastrov 4y ago
One way to have the best of both worlds for situations where you have complicated read queries is to create database views for the queries. You can then define them as an unmanaged table in Django (requires some boilerplate) and query them
5.
by syastrov 4y ago
Similarly, we have amazingly powerful and reliable computer hardware, but continue to have software that is extremely slow and buggy and hard to use. I theorize that since software is so invisible/intangible, these complexities are not
6.
by syastrov 4y ago
Anyone tried any of the alternative full-text search extensions mentioned? Zombodb sounds good, except I would like that it didn’t work synchronously and fail transactions if there is a network error talking to ElasticSearch. I think most p
7.
by syastrov 4y ago
> That's where things got a bit hairy. Lila is built on Play Framework which is not yet ported to Scala 3. > So I forked it and butchered it to remove everything we don't need - which is actually most of the framework. I gue
8.
by syastrov 4y ago
About 15 years ago, my brother used to run a shoutcast (Internet radio) server. He wasn’t getting many listeners since the list of stations people browse was sorted by popularity - number of listeners. So I disassembled and then hexedited t
9.
by syastrov 4y ago
I was just curious if I could improve our PHP-based site’s performance. So I attached strace to an Apache process and followed the log of syscalls and counted milliseconds between them. Sure enough, I discovered that 20 ms was being spent e
10.
by syastrov 4y ago
Haha, that made my day! (It’s a reference to That Mitchell and Webb Look).
11.
by syastrov 4y ago
Yes, you are right. I was just mentioning the name of the principle as used in the article.
12.
by syastrov 4y ago
I experienced a case of zero one many that would have been better if YAGNI was applied. We were building a messaging system for a system that was being rewritten, where the only requirement was direct messaging between 2 users. It was sugge
13.
by syastrov 4y ago
I think there’s a trend to replace applications having information-dense designs with all actions at your fingertips with ones that add so much padding that you can only see a little bit of information at a time and in order to perform any
14.
by syastrov 4y ago
e.g. postgraphile
15.
by syastrov 4y ago
Someone mentioned it on a Django forum thread about async ORM [0]. It seems to have been ignored. Super cool idea and execution! I hope it gets some more exposure. [0] https://forum.djangoproject.com/t/asynchronous-orm&
16.
by syastrov 4y ago
There are a lot of comments about async ORM, but to me the support for application-level (e.g. if you use forms, admin, DRF, Graphene) validation of DB-level constraints is a super cool feature that solves a real pain point - having to dupl
17.
by syastrov 4y ago
Or use imgix for that part
18.
by syastrov 4y ago
For context: Heroku also has their own Redis add on.
19.
by syastrov 4y ago
I wrote an article [1] a few years ago to vent about how messed up and backward the experience has been for especially foreign filers. The “free” options provided by commercial companies are as TFA states unusable by large portions of the p
20.
by syastrov 5y ago
Another gem: http://www.christianpoulet.com/iemac/en/indexf.htm
21.
by syastrov 5y ago
JetBrains IDEs can generate methods for undefined names if you use an intention activated by ctrl+enter (or alt, I can’t remember)
22.
by syastrov 5y ago
Imgix has been quite nice: unlimited variants, pricing per master image plus bandwidth charges, and you can keep your images on S3. They even contacted us about setting up a custom agreement when they noticed we were going over the allotted
23.
by syastrov 5y ago
Most likely the actual work done by this extension is little compared to the actual work required to perform the queries…but… If you want to scale horizontally you can run multiple read replicas with something which distributes connections
24.
by syastrov 5y ago
You can also put some books under the laptop and use it as a screen while connected to an external keyboard at desk height.
25.
by syastrov 5y ago
I thought of this idea as well, but don’t think this is really the right approach. Many of these issues relate to specific features which developers subsequently avoid using. I think these types of initiatives should be more broadly targete
26.
by syastrov 5y ago
Wish I had a tool that could suggest things to do like the “cartoon” at the top of the article.
27.
by syastrov 5y ago
Kudos for open-sourcing it. Here’s to hoping some of the changes make their way into upstream CPython. What’s the compatibility story like? Is there a list somewhere of unsupported features?
28.
by syastrov 6y ago
A bit off-topic, but as the article notes, Stripe is using AWS. Could someone share their experiences with AWS versus Google Cloud for a smallish business using mostly compute plus managed Postgres? The pricing differences shouldn’t be an i
29.
by syastrov 6y ago
I’d like a tool that automatically suggests which indexes to add/remove, including use of different types of indexes and partial indexes, based on the queries being performed. Even better if it can automatically test the results of th
30.
by syastrov 6y ago
I’m just thinking about how much CO2 emission was spared by optimizing performance instead of scaling horizontally. It would be nice to see the effect on the environment as part of the decision-making process for deciding whether to optimiz

More ›