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

Read more

Read more

Read more