Optimizing MySQL queries

One suboptimal database query can effectively paralyse whole application. Tracking down such bottleneck is one thing but speeding it up is not a trivial task. This article is intended to show how one can analyse and refactor slow database query. In all examples I was using MySQL Workbench and Sakila example database. DB’s structure is […]

Read More

Dive into Python’s asyncio, part 4 – simple chat with Sanic

Let’s roll with something practical, namely a simple chat application using Sanic framework mentioned in previous post. Sanic supports websockets out of the box thanks to the websockets library. It’s super easy to write a handler function by using decorator (#1):

This is what code looks like for a simple echo server. No error […]

Read More