End Point Team

Our team, headquartered in New York City, has developed, maintained, and hosted ecommerce and other web solutions since its founding in 1995. We combine web application development, database and hosting expertise with understanding clients' objectives to excel in client satisfaction.

PostgreSQL tip: arbitrary serialized rows

March 8, 2010

Sometimes when using PostgreSQL, you want to deal with a record in its serialized form. If you're dealing with a specific table, you can accomplish this using the table name itself: psql # CREATE TA... (PostgreSQL tip: arbitrary serialized rows cont.)

PostgreSQL tip: dump objects into a new schema

February 16, 2010

Sometimes the need arises to export a PostgreSQL database and put its contents into its own schema; say you've been busy developing things in the public schema. Sometime people suggest manipulating th... (PostgreSQL tip: dump objects into a new schema cont.)

GNU diff: changing the output filenames

February 15, 2010

I was working on a script to monitor/compare remote versions of a file and compare against our local mirror; part of this work involved fetching the remote file to a temporary location and doing a diff... (GNU diff: changing the output filenames cont.)

PostgreSQL tip: using pg_dump to extract a single function

January 31, 2010

A common task that comes up in PostgreSQL is the need to dump/edit a specific function. While ideally, you're using DDL files and version control (hello, git!) to manage your schema, you don't always ... (PostgreSQL tip: using pg_dump to extract a single function cont.)

Slony: Cascading Subscriptions

January 28, 2010

Sometime you run into a situation where you need to replicate one dataset to many machines in multiple datacenters, with different costs associated with sending to each (either real costs as in bandwi... (Slony: Cascading Subscriptions cont.)