Warning: Creating default object from empty value in /srv/kunden/webs/cmsagenten/blog.it-agenten.com/wp-content/themes/skeptical/functions/admin-hooks.php on line 160
Tag Archives: ubuntu

Tuning Django ORM (part 1): Text Queries

Concerning text queries, Django ORM offers several helper functions. However, some of those are not backed by a database index and will be slow. Fortunately, on PostgreSQL these searches can be sped up with GIN or GIST indexes quite easily.

Continue Reading

Backup: Rolling MySQL snapshots in two lines of code

Short is sweet — you can’t make that many mistakes in two lines of code. When I recently looked for a quick way to enable regular backups of a MySQL DB for a project our team started working on, I first looked at automysqlbackup. After installing and configuring, I found it didn’t work on the [...]

Continue Reading