Articles tagged with: Development

PostgreSQL - PostGIS compatibility issues

Summary: Compatibility issues encountered when updating from PostgreSQL 9.1 to PostgreSQL 9.3 with PostGIS 2.0 installed, and a solution.


PowerShell-ing

Summary: My transition from despising Windows scripting capabilities to appreciating and using PowerShell for tasks such as image watermarking and mass file renaming.


SQL LIMIT in UPDATE when the RDBMS doesn't allows it

Summary: How to use SQL LIMIT in UPDATE queries when the RDBMS doesn't allow it. And some optimization techniques for handling large data imports.


If you can't win, fail fast

Summary: The importance of setting hard limits in software development to prevent system crashes due to overloading.


A small LEGO Mindstorms EV3 Node.js library

Summary: Creating a small library for LEGO Mindstorms EV3 using Javascript.