charlesnagy

RDS apply pending modifications

September 28, 2021
0

There are a lot of articles on the internet describing how to apply pending maintenance on AWS RDS but surprisingly very little (or none I found...

AWS

Stop using await in a Python forloop

October 8, 2020
0

Disclaimer: This might sound to be a rant but stay with me and you will see this will be a very good practical advise to speed...

python

Varchar vs Char in MySQL : understanding trailing spaces

February 26, 2018
0

MySQL is not a strictly typed database. Given that and the different character types some tricky situation might arise. Especially when it comes to trailing spaces....

mysql

Typeahead and autosuggest with pure Solr and Nginx

September 6, 2016
0

A long time ago I was writing about a very simple technic which can be used to quickly provide auto-suggest for websites with the support of...

Postgresql server fails to start in recovery with systemd

May 22, 2016
1

I ran into an issue while trying to setup a simple test system for myself to move from CentOS 6 to 7. When I was about...

Postgresql

Priority queue in Redis aka ZPOP

February 5, 2016
4

Redis list is great to use it as a processing queue. So great that it sort of became the standard and many people using that instead...

python

Python MySQLdb vs mysql-connector query performance

November 24, 2015
1

There are a lot of python driver available for MySQL and two stand out the most. The one, traditionally everybody’s choice, sort of industrial standard MySQLdb. It...

python

Multi variant AB testing vs Multi-Armed bandit

October 18, 2015
0

I’ve read a lot of discussions lately around different versions of experimenting/testing. People are seemed to be very religious about the subject and two cardinal questions...

methodology

5 steps to self-managing server infrastructure

October 13, 2015
0

Managing servers is a tedious work we all have to do to some extent. But it doesn’t have to fill our whole day. What if I tell...

methodology

Group by limit per group in PostgreSQL

September 27, 2015
3

In web applications it’s very common to try to limit the results by group. For example showing all the new posts with the the two latest...

Postgresql

RDS apply pending modifications

Stop using await in a Python forloop

Varchar vs Char in MySQL : understanding trailing spaces

Typeahead and autosuggest with pure Solr and Nginx

Postgresql server fails to start in recovery with systemd

Priority queue in Redis aka ZPOP

Python MySQLdb vs mysql-connector query performance

Multi variant AB testing vs Multi-Armed bandit

5 steps to self-managing server infrastructure

Categories

Links

Recent comments

Tweets