Database Patterns

Notes on PostgreSQL

Pages

http://martinfowler.com/bliki/UserDefinedField.html

Essentially, he recommends using an XML field, or allowing the user to ALTER their own schema.

Subscribe to: Posts (Atom)

Broadcasting PostgreSQL NOTIFY messages to WebSocket Clients

In this post, I look at how to broadcast NOTIFY messages from a Postgres database to WebSocket clients using Spring MVC 4. Source code her...
Trees and Paths using WITH RECURSIVE in PostgreSQL

Let's say we had some data like this - from the United Nations geoscheme for world regions: create table subregions ( id smallint pr...
TF-IDF Text Search in Postgres

/* see http://blog.databasepatterns.com/2014/07/postgresql-install-smlar-extension.html */ create extension if not exists smlar; /* your ...
Installing the debugger for pgAdmin on Windows

Software used: Windows 7 64-bit PostgreSQL 9.3 installed from EnterpriseDB installer pgAdmin III 1.18 Steps: 1. Open c:\program f...
Setting up OpenBSD's LDAP Server (ldapd) with StartTLS and SASL

OpenBSD has its own LDAP server, ldapd. Here's how to configure it for use with StartTLS and SASL authentication I don't cover com...
Steps to install the smlar extension into Postgres

The smlar extension lets you do TF-IDF and cosine similarity calculations in Postgres. If you figure out how to compile these on Windows (...
PostgreSQL 9.6 Wish List

First, a huge congratulations and thank you to the PostgreSQL Global Development Group for shipping such great features in 9.5! I'm te...

▼ 2013 (2)
- ► November (1)
- ▼ August (1)
  - Martin Fowler on User-Defined Fields

Simple theme. Powered by Blogger.