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

Ext Js Pathfinder progress report #5

Just a quick update. I solved problems with failing tests after switching to my own example Ext JS page. Apparently, PhantomJS doesn’t like protocol mismatch – I served my page using HTTP, but Ext JS assets were served using Sencha’s CDN with HTTPS.

Removing protocol part from links and letting browser adjust it to […]

Read More