MySQL Batch Updates Not Working

08 May 2015 Looking at "SHOW PROCESSLIST" and it looks like your queries are running individually instead of in batches like you sent?

This happens because MySQL runs each update statement individually, but you should still be able to see the batches when the queries are in the "init" state.

Use this query to see the batched queries:
SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST where state="init";

New Flask Template

23 Mar 2015 https://github.com/xen/flask-project-template/

It's also an interesting example of using docker for a flask project.

"Error response from daemon: 404 page not found" - Docker

13 Feb 2015 This required setting the following in my /etc/environment:

no_proxy=/var/run/docker.sock

When Not to Use Generator Expressions

28 Jan 2015 http://stackoverflow.com/a/26635939

I found that post very helpful. I didn't know it's a better idea to use a list comprehension rather than a generator expression for "".join().

mod_wsgi + Flask

28 Jan 2015

Here’s my mod_wsgi configuration for a flask app that uses Flask-Admin.

WSGIDaemonProcess makermanager2 user=www-data group=www-data threads=5 WSGIScriptAlias /makermanager2 /var/www/makermanager2/runserver.wsgi <Directory /var/www/makermanager2> WSGIProcessGroup makermanager2 WSGIApplicationGroup %{GLOBAL} Order deny,allow Allow from all </Directory> Alias /makermanager2/assets /var/www/makermanager2/application/static <Directory /var/www/makermanager2/application/static> Order allow,deny Allow from all </Directory> Alias /makermanager2/static/admin /opt/Envs/prod/src/flask-admin-master/flask_admin/static/ <Directory /opt/Envs/prod/src/flask-admin-master/flask_admin/static/> Order allow,deny Allow from all </Directory>

Trailing slashes matter! If you set a trailing slash, it will only set the alias for that directory and not all of the directories below it.

Request.Args Empty During Tests - Flask

27 Jan 2015 https://github.com/mitsuhiko/flask/issues/801#issuecomment-21513278

If you're using app.test_client().get, it's very important to use a relative url or your parameters will be removed.

# will not pass request.args
rv = self.client.get('http://0.0.0.0:5000/view/?foo=bar')

# works just fine
rv = self.client.get('/view/?foo=bar')

Self-Hosting Fonts

23 Jan 2015 https://github.com/CSSLint/csslint/wiki/Bulletproof-font-face

That's the most helpful guide I found for self-hosting your own fonts and preventing compatibility issues.

Dokku Change Nginx Timeout

21 Jan 2015 None of the plug-ins for doing custom nginx configurations were working for me.

So, I changed the following two files:
/var/lib/dokku/plugins/nginx-vhosts/templates/nginx.ssl.conf
/var/lib/dokku/plugins/nginx-vhosts/templates/nginx.conf

I added the following under "location / {":
proxy_connect_timeout 300s;
proxy_read_timeout 300s;

Supervisord Tips and Gotchas

21 Jan 2015 If you make configuration changes, the changes will not take effect until you:

supervisorctl reread
supervisorctl update

"redirect_stderr=true" will cause both stderr and stdout to appear in the "stdout" log.

You get to select which user runs the command with the "user" parameter.

For example: user=root

Supervisord keeps its own set of environmental variables with the "environment" parameter. It won't pick up env variables from /etc/environment.

For example: environment=A="1",B="2"

For Gunicorn, use a configuration file rather than putting all your arguments into the "command" parameter.

For example, -t will be ignored here:
command=/path/to/gunicorn main:application -t 300

Instead use:
command=/path/to/gunicorn main:application -c /path/to/gunicorn.conf.py

Installing python-ldap on Dokku

20 Jan 2015 Install this plugin: https://github.com/F4-Group/dokku-apt#installation

Create an apt-packages file in the root directory of your repository with the following lines:
python-dev
libldap2-dev
libsasl2-dev
libssl-dev

Now, commit your new apt-packages file and python-ldap should install successfully.

I also had trouble installing pymssql, and got an error saying "_mssql.c:314:22: fatal error: sqlfront.h: No such file or directory". Similar fix, just add "freetds-dev" to your apt-packages file.

Older Newer