How Python List Works

And why some methods take constant time while others take linear. | Continue reading


@antonz.org | 3 years ago

Good Code Criterion

Optimize T, keep an eye on R. | Continue reading


@antonz.org | 4 years ago

SQLite is not a toy database

Here is why SQLite is a perfect tool for you - whether you are a developer, data analyst, or geek. | Continue reading


@antonz.org | 4 years ago

How to create a 1M record table with a single query

Let’s say you want to check how a query behaves on a large table - but there is no such table at hand. This is not a problem if your DBMS supports SQL recursion: lots of data can be generated with a single query. The WITH RECURSIVE clause comes to the rescue. | Continue reading


@antonz.org | 4 years ago