Other News

Community

XPathing XML data with PostgreSQL

(Leo Hsu and Regina Obe) One of my favorite tools and I think that of many folks working with GIS and other kinds of Multimedia is the GDAL/OGR suite. Though I started using it to conquer GIS ETL activities, I found myself using it for problems that are inherently not GIS at all. I talked about the

Community

SQL Server Functions: The Basics

(Jeremiah Peschka) A function, in any programming environment, lets you encapsulate reusable logic and build software that is “composable”, i.e. built of pieces that can be reused and put together in a number of different ways to meet the needs of the users. Functions hide the steps and the complexi

Community

Database Objects: Stored Procedures

(Buck Woody) There are two main categories of these objects in a SQL Server Database: Things that store data and things that access or provide access to data. In the previous tutorials I’ve explained the objects that fit the first category — Tables. Other than Indexes (which are actually also Tables