PhotoPrism: Browse Your Life in Pictures

PhotoPrism® is a privately hosted app for browsing, organizing, and sharing your photo collection. It makes use of the latest technologies to tag and find pictures automatically without getting in your way. Say goodbye to solutions that force you to upload your visual memories to the cloud! Read more

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