Tiago Montes retweeted
PyCon Portugal 2025 is happening July 24-26! 🎉
Three days of python, innovation, and an incredible community. Mark your calendars and get ready for something amazing!
More details coming soon—stay tuned! 👀✨
#pyconportugal2025 #python
Tiago Montes retweeted
New blog post:
Query Engines: Gatekeepers of the Parquet File Format
In this post, Laurens Kuiper argues that we are wasting a lot of bits by not using the Parquet format to its full extent – a limitation caused by the lack of support for Parquet features in some systems.
duckdb.org/2025/01/22/parque…
Tiago Montes retweeted
My PEP 773 is up for discussion - replacing the Windows Python installer (with an install manager tool)!
Full text link below, but first, have a quick glimpse into the future of how to install Python on Windows 👀 /1
Tiago Montes retweeted
Last year, I added a new integer type to DuckDB called VARINT, capable of storing up to 1,262,612 digits.
I initially implemented a quadratic algorithm to convert it to VARCHAR, which was slow. (My plan was to eventually get inspired by CPython.) However, an external contributor beat me to it:
github.com/duckdb/duckdb/pul…
They even referenced "The Art of Computer Programming" and implemented a solution that's more than an order of magnitude faster than my naive approach. Just excellent!
Tiago Montes retweeted
Parallel Python fans, we want your talks! 🚀 Last year, Samet Yaslan covered sub-interpreters vs NoGIL vs multiprocessing: youtu.be/HdTtJKevxfQ
Tiago Montes retweeted
New blog post by @__AlexMonahan__
Vertical Stacking as the Relational Model Intended: UNION ALL BY NAME
Alex takes us on a journey that starts in 1969 with a research report, touches on the little known CORRESPONDING keyword in the SQL standard, and ends in the present with some of DuckDB's friendly SQL features – and their recent performance improvements.
Read more at duckdb.org/2025/01/10/union-…
Tiago Montes retweeted
Do you use BRIN indexes on Geometry? Let me know, we are thinking of removing them.
Tiago Montes retweeted
Estes foram os quatro vídeos mais vistos da série «Isto Não É Assim Tão Simples» em 2024. Planeta em mudança, jovens e política, migrações e idadismo: temas que marcaram o ano. Reveja agora os conteúdos mais vistos e conte-nos: qual foi o seu favorito? 👇
Tiago Montes retweeted
Last week I focused on addressing quirks in python-build-standalone and fixing the common pain points with uv-installed Pythons.
For example: if you've ever run into this tkinter error, it's now fixed.
ALT A build failure indicating that Tcl wasn't installed properly.
Tiago Montes retweeted
We’re happy to announce EuroPython 2025 at the Prague Congress Centre, July 14–20! 🎊
🚀 The Call for Contributors is open! Join our amazing team – submit your interest by December 22nd: forms.gle/kY7jqSJTjEhFccWJ6
For more info, visit our website: ep2025.europython.eu
Tiago Montes retweeted
PS: If you wonder what QUALIFY is, it's like HAVING but for window functions. See duckdb.org/docs/sql/query_sy…
The Mu Editor sunset: we’re wrapping it up.
Full announcement and way forward in the linked blog post.
madewith.mu/mu/users/2024/12…
Tiago Montes retweeted
We upgraded to Postgres 17 last week and I ran numbers for real life perf gains over the ~9 days worth of API telemetry since.
They are looking VERY good, with a 15% reduction in request duration at P50. Even better than my synthetic bench a few months back.
Writeup to come.
Tiago Montes retweeted
A Map Comparing Actual Distances to Their Representation on the Mercator Projection
Tiago Montes retweeted
Today we’d like to share an incredible keynote from PyConPT 2024: "Paying Attention with Python" by Nicholas Tollervey
Explore how attention shapes what we create, with practical, creative, and humorous insights. 🐍✨
Watch now: youtu.be/ONiZ-mEkrtg?si=S8qP…
#pyconpt24 #keynote
Tiago Montes retweeted
What are some #Python expressions for checking if a strings consists of only "0"s and "1"s? Find out on BlueSky.... bsky.app/profile/nedbat.com/…
Tiago Montes retweeted
Always a good reminder: both Ruff and uv see more PyPI downloads from Windows than macOS.
Tiago Montes retweeted
A core value I try to instill in everyone on my team is to be helpful, both to each other and especially to customers.
One way we do that is by educating, teaching about Postgres and great data practices.
At conferences my favorite thing we hand out is not about our products or SWAG. Yes, I love our kids activity book that has coloring pages, word search, and then activities to teach kids SQL, but it's not my favorite thing. It's a handout with a collection of Postgres tips.
Tiago Montes retweeted
I am predictably triggered by this 1 billion loops benchmark thing.
If you vectorize the Python, it's ~10x faster than Rust, C, etc. With less code!
The point here is _not_ that Python itself is fast. It's not!
The point is that Python makes this accessible, and even the norm!
ALT 1 Billion Loop Iterations benchmark with NumPy