Viewing profile — syastrov

Probably more likely inefficient data access patterns, such as N+1 queries, inefficient algorithms, lack of parallelism

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…

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 …

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…

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…

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…

> 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 - wh…

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 -…

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 …

Haha, that made my day! (It’s a reference to That Mitchell and Webb Look).

Yes, you are right. I was just mentioning the name of the principle as used in the article.

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 re…

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 litt…

e.g. postgraphile

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://foru…

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…

Or use imgix for that part

For context: Heroku also has their own Redis add on.

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 com…

Another gem: http://www.christianpoulet.com/iemac/en/indexf.htm

JetBrains IDEs can generate methods for undefined names if you use an intention activated by ctrl+enter (or alt, I can’t remember)

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…

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…

You can also put some books under the laptop and use it as a screen while connected to an external keyboard at desk height.

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 thi…