Articles tagged with: Development

Don't load if you can stream

Summary: The importance of efficient data handling in computer applications, specifically not fully loading large datasets into memory.


Easy URL Rewritting using ASP.NET 4.0

Summary: Removing FeedBurner from my website, and using ASP.NET 4.0's rewriting rules to handle URL redirections instead.


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.