Archives

Using PostgreSQL as a Data Warehouse

– Instead of updating tables build their replacements under a different name then rename them. This makes updating heavy-to-compute table instant. Works even for schemas: rebuild a schema as schemaname_next rename the current to schemaname_old then rename schemaname_next to schemaname. Read more

Ask HN: Tools you have made for yourself?

Thank you. Then I fully scripted my video editing using Python+MoviePy [2]. The time savings are sweet. I just feed it my raw video and get the finished video a few minutes later. It cuts out all the dead air as well as the parts I don’t want (which I indicate in-video). Read more

Don’t Feed the Thought Leaders

Hedgehogs are at stage 2. You move from stage 1 to stage 2 by adopting frameworks; hence, hedgehogs are seen as “thought leaders” because they teach the frameworks that lead MOST people to more mastery. Read more

Towards Inserting One Billion Rows in SQLite Under A Minute

Current Best: 100M rows inserts in 33 seconds. (you can check the source code on Github) Recently, I ran into a situation where I needed a test database with lots of rows and needed it fast. So I did what any programmer would do: wrote a Python script to generate the DB. Unfortunately, it was […]

Zihua Li

五年前，我在 GitHub 开源了一个 macOS 上的 Redis 管理工具，取名 Medis，同时把它放到了 App Store 以 30 元一个的价格出售。换句话说，你既可以直接免费下载使用，也可以花 30 元购买，两者功能一样，全凭自愿。 Read more

Typesense

Craft delightful search-as-you-type experiences with Typesense. Meticulously engineered for performance & ease of use. Read more

Essential Xcode Shortcuts for More Efficient Coding

As developers, we spend a considerable amount of time in our IDE, so it’s worth becoming an expert in using it. Simply being able to edit code doesn’t cut it – you need to become proficient. Read more