iPhone DZone: Fresh Links On Your iPhone by matt on 7/5/08
Reading DZone on your iPhone just got a little bit easier. Visit http://dzone.com/iphone from your iPhone to try out our beta iPhone support. You can view stories, filter by tags, and login. We'd appreciate your feedback at feedback@dzone.com.
PostgreSQL 8.3 TSearch Cheat Sheet Overview
Using PostgreSQL 8.3 integrated full-text search capabilities
0 commentsSave Tags: database, how-to, open source
Choosing the right Database Procedural Language PL in PostgreSQL
Brief summary of pros and cons of using PL languages in PostgreSQL and when to use them
0 commentsSave Tags: database, opinion
How to calculate Running Totals and Sums in SQL
Describes ansi SQL standard way of calculating cumulative sums
0 commentsSave Tags: database, how-to
What can PostgreSQL learn from MySQL
There has been a lot of talk lately about PostgreSQL and what MySQL can learn from the PostgreSQL clan. We would like to look at the reverse of that.... more »
2 commentsSave Tags: database
Setting up PostgreSQL as a Linked Server in Microsoft SQL Server 64-bit - Postgres OnLine Journal
Describes how to configure Postgresql as a SQL server 2005 64-bit linked server.
0 commentsSave Tags: database, how-to, open source
REST in PostgreSQL Part 2 B - The REST Server service with PHP 5
Demonstrates simple REST service in PHP
0 commentsSave Tags: database, how-to, open source, php
How to SELECT ALL EXCEPT some columns in a table - Postgres OnLine Journal
Shows how to exclude certain columns from a SELECT query.
0 commentsSave Tags: database, how-to, open source
REST in PostgreSQL Part 2 A - The REST Server service with ASP.NET - Postgres OnLine Journal
Example of creating REST webservice in ASP.NET and Mono.NET using C#, VB.NET , MonoBasic against a postgresql databse
0 commentsSave Tags: .net, database, how-to, web services
Showcasing REST in PostgreSQL - The PreQuel - Postgres OnLine Journal
Provides a brief summary of what REST is and where it came from. This is a prequel into a REST implementation using PostgreSQL as back-end database.
0 commentsSave Tags: database, how-to, open source
PLR Part 3: PL/R and Geospatial Data Abstraction Library (GDAL) RGDAL
Describes how to install RGDAL library in R-Statistical environment and call functions from PostgreSQL PL/R language.
0 commentsSave Tags: database, how-to, open source, tools
TSearch Primer - Postgres OnLine Journal
Show how to use TSearch - the full text search engine now fully integrated in PostgreSQL 8.3
0 commentsSave Tags: database, how-to, open source
GDAL OGR2OGR for Data Loading
Simple technique for data loading into postgresql and other databases
0 commentsSave Tags: database, how-to, open source
How to convert a table column to another data type in Postgresql
The USING syntax is particularly handy because it allows you to control how casts are done. Let us suppose you have a text or varchar field that you... more »
0 commentsSave Tags: database, how-to
PostgreSQL 8.3 is out and the Project Moves On
Details where PostgreSQL is headed and why its a good choice.
0 commentsSave Tags: database, open source
Reading PgAdmin Graphical Explain Plans
Shows some neat snapshots of graphical explain plans in postgresql pgadmin III admin tool.
0 commentsSave Tags: database, how-to, open source
The Anatomy of PostgreSQL - Part 2 - Database Objects
Brief summary of objects found in a PostgreSQL database
0 commentsSave Tags: database
Trojan SQL Function Hack A PL Lemma in Disguise
Demonstrates how to get around the issue of not being able to use set-returning plpgsql functions in the SELECT part of a postgresql statement and why... more »
0 commentsSave Tags: database
Table-Driven and Data Driven Programming
Data/Table-Driven programming is the technique of factoring repetitious programming constructs into data and a transformation pattern. This new data... more »
0 commentsSave Tags: php
