Techology Radar

In a larger Team it might be difficult to keep your technology stack up to date and have a vision of what things should be used soon or not. Moreover this knowledge is difficult to be shared, to let team members know what the other members think should be e.g. evaluated. Read more

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 […]