Blog

PostgreSQL, PostGIS, PHP. Performance of extracting geodata

July 16, 2012, 11:00 AM

Which way is the best to extract geo data from SQL: WKT or GeoJSON?

Everyone who developes geographical web-applications meets necessity to select geo-objects in PHP-application (or similar component). PostGIS provides us many functions to format geodata. Which of them is the most optimal one?

Yii:: Setting static properties of modules in config

July 14, 2012, 3:00 PM

The light trick not to break your OOP model structure

You may face a situation when you need to access to a configurable module's property from everywhere and you don't have an instance of this module's class.

Reasonability of using temporary SQL tables. Where is the borderline?

July 12, 2012, 5:00 PM

The pratical performance test in PostgreSQL.

Thousands of rows to import but you need to filter them out using power of SQL. What should we use: temporary table or usual permanent table (emptying the latter manually)? The answer is not trivial…