Posts

2021: The Year of Progressive Web Apps

3 minute read Published:

In 2021, progressive web apps will be the choice of more app developers than ever before. New APIs, absence of gatekeepers, lower development cost, their cross-platform nature, instant updates and the push by Google and Amazon will make them the optimal choice for most situations.

Three tips for faster bulk inserts into a PostgreSQL database

2 minute read Published:

Disabling fsync, removing indices and using pgcopy will significantly speed up the import of data

Tens of gigabytes of data. An amount that doesn’t quite fit into an Excel spreadsheet but doesn’t warrant the use of big data tools like Hadoop either. PostgreSQL can easily handle this volume. This post is about speeding up the initial import of a large number of rows.

Seriously bad advice about SSL errors in Python and a better fix

3 minute read Published:

This is a post about fixing certificate verify failed error in Python without compromising security of your code. Don’t blindly follow suggestions on the internet because some suggested solutions can have serious unintended consequences.