Hacker News: keosak

New comment by keosak in "AI;DR (AI; Didn't Read)"

keosak — Tue, 18 Aug 2026 08:15:00 +0000

> We absolutely care about what the team members want , like, hate etc.

Do the people above you in management care as much? It's the top levels of management that decide hiring, firing and budgets.

New comment by keosak in "Upsert in SQL"

keosak — Mon, 25 Sep 2023 17:50:04 +0000

INSERT ... ON CONFLICT has a problem with CHECK constraints. The constraint must be satisfied in the INSERT tuple even if the row already exists and UPDATE will be executed. I recently dealt with this at work and the resulting CTE query was very similar to MERGE, except MERGE has better syntax.

New comment by keosak in "New UUID Formats"

keosak — Mon, 13 Jun 2022 08:36:33 +0000

They don't utterly destroy performance, but there is some hit if you use UUID v4 random values due to database index scattering. That's why this new proposal exists. It adds new versions of UUID that are mostly incrementing in time, so that they group better.

New comment by keosak in "Understanding UUIDs, ULIDs and string representations"

keosak — Wed, 05 Jan 2022 08:39:12 +0000

It is a hash, but in the format of a UUID. This is useful if you are storing it in the database, since there is usually a dedicated data type for UUIDs. Also, you can mix UUID v4 and v5 IDs freely.

New comment by keosak in "Django vs. Flask"

keosak — Tue, 04 Jul 2017 09:27:19 +0000

Extensions can register themselves with the Flask application object, so you can look there: current_app.extensions['whatever']. However, it is not specified what exactly this dictionary contains, so eg. SQLAlchemy puts a custom State class there. You can still get the extension object out of it, it's just that there is no common convention.

http://flask.pocoo.org/docs/0.12/api/#flask.Flask.extensions

https://github.com/mitsuhiko/flask-sqlalchemy/blob/master/fl...

New comment by keosak in "Guido van Rossum: The Theory of Type Hinting for Python 3.5"

keosak — Sat, 20 Dec 2014 11:52:14 +0000

The "documented information" you want is mentioned in the article. Guido links to a blog post by Jeremy Siek and a paper by Vitousek, Siek and Baker. Read the blog post, section "Why subtyping does not work".

http://wphomes.soic.indiana.edu/jsiek/what-is-gradual-typing...

http://wphomes.soic.indiana.edu/jsiek/files/2014/03/retic-py...

New comment by keosak in "Celery – Best Practices"

keosak — Wed, 18 Jun 2014 13:31:47 +0000

Points 1 and 2 are only valid because the Celery database backend implementation uses generic SQLAlchemy. Chances are, if you are using a relational database, it's PostgreSQL. And it does have an asynchronous notification system (LISTEN, NOTIFY), and this system allows you to specify which channel to listen/notify on.

With the psycopg2 module, you can use this mechanism together with select(), so your worker thread(s) don't have to poll at all. They even have an example in the documentation.

http://www.postgresql.org/docs/9.3/interactive/sql-notify.ht...

http://initd.org/psycopg/docs/advanced.html#async-notify

New comment by keosak in "Slides from Felix von Leitner's talk on C and compiler optimizations"

keosak — Fri, 06 Nov 2009 18:24:09 +0000

You are right that it does not look like what is usually called "tail call", ie. call to 'fact' is not the last evaluated expression. However, this doesn't mean that the compiler can't optimize it, provided that the last expression is simple enough. GCC can probably optimize arithmetic expressions. I have read somewhere (can't find it though) that Erlang bytecode compiler also optimizes prepending to a list and some other primitive operations. This means that in these cases you don't have to explicitly use accumulator variable because the compiler will create it for you.