Feb 14, 2017 Tuesday

Is PostgreSQL good enough?

tldr; you can do jobs, queues, real time change feeds, time series, object store, document store, full text search with PostgreSQL. How to, pros/cons, rough performance and complexity levels are all discussed. Many sources and relevant documentation is linked to.

I need to store avatars from Sublevel in PostgreSQL for consistency but keep serving them with nginx.

Feb 13, 2017 Monday

Google Analytics setup

Google Analytics is a powerful yet quite complicated tool. And unfortunately, the truth is most people who use it don’t reap its full benefits.

Feb 13, 2017 Monday

An nginx.conf for 2017

With HTTP/2 in every browser, load balancing with automatic failover, IPV6, a sorry page, separate blog server, HTML5 SSE and A+ HTTPS.

A good way to separate https.conf from domain.conf files.

Jan 23, 2017 Monday

Simple Wi-Fi Yagi

The signal to my wireless adapter card dropped 6 dB when I removed the parasitics from the router dipole. The Yagi provides a fourfold increase in power, which will double the operating range. When signal strength is the limiting factor, it will quadruple throughput.

Jan 22, 2017 Sunday

A few Django ORM mistakes

See if you can figure out what's wrong with the code snippets below! Ask yourself what the problem is, what effect will it have, and how can you fix it? These examples are for Django, but probably apply to many other ORMs.

I used bug 2 & 3 solutions for Sublevel.

1 2 3 4 5 6 7 8 9 10 11 12