joocerMar 23, 2025

🧠 We taught Opteryx to think before it ORs.

Long chains of OR conditions? Opteryx now rewrites them into smarter, more efficient predicates—a trick we call predicate compaction.

One customer saw a 100x speed-up. Not bad for a bit of clever thinking. 💡⚡

Check it out and drop us a ⭐!
🔗 https://github.com/mabel-dev/opteryx

#OpenSource #SQL #Python #Performance #FOSS #Analytics #Data

GitHub - mabel-dev/opteryx: 🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives.

🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives. - mabel-dev/opteryx

GitHub
Show threadTom RitchfordMar 23, 2025

@opteryx Man, you have literally the worst commit names I've ever seen in a production-leverl repo. I went through pages of them, and I found only three that gave me even a hint of what they actually did.

https://xkcd.com/1296/

Git Commit

xkcd
Show threadjoocerJun 14, 2025

@TomSwirly I think those three are where the VSCode plug-in autofilled descriptions.

I always wondered why when I linked commits to an issue I needed to retype the issue description in the commit rather than the computer automating that for me? I'm not the world's first lazy developer.

Show threadTom Ritchford

@opteryx Oh, and you shouldn't retype the issue description in the commit ID most of the time, you should say what you did!

"Prevent race condition in initialization in foo.py (fix \#12234)"

Jun 14, 2025 at 1:15pmWeb
Show threadjoocerJun 14, 2025
@TomSwirly Thank you for taking the time to provide feedback, with examples. I appreciate that you have taken the time to highlight some of the things I've generally seen as secondary as things that others notice and draw conclusions from.
Show threadTom RitchfordJun 14, 2025

@opteryx The pleasure is all mine.

And don't get me wrong. This is evidence, not a smoking gun.

For example, the project I currently work on is very high quality, and yet there are a lot of failures in CI: https://github.com/pytorch/pytorch/commits/main/

The reasons for this are... complex but basically to do with having thousands of programmers working on one project (and also partly politics, as there exist a few parties who can bypass the CI and sometimes do).

Commits · pytorch/pytorch

Tensors and Dynamic neural networks in Python with strong GPU acceleration - Commits · pytorch/pytorch

GitHub