Archive for the tag 'postgresql'

Sep 06 2014

Data/API Servers/Services for Single Page Web Applications

Published under Technology

A Client needs a Server, or at least a Service Over the last few years the team at Oasis Digital has created various complex “single page” web applications, using AngularJS, KnockoutJS, and other tools. These applications’ assets and code are be statically hosted (cheaply on  CDN if needed), but of course each application needs a backend data service (possibly […]

Comments Off on Data/API Servers/Services for Single Page Web Applications

Mar 03 2010

Mobile Workforce Management, a Five Year SaaS Mission Completed

Published under Business

Here is the story of a substantial chunk of my professional life over the last five years. I didn’t tell this story in real time (for various good reasons), though I have mentioned bits of it in various talks. In 2004, I co-founded a vertical market Software as a Service firm, Mobile Workforce Management (MWM). […]

Comments Off on Mobile Workforce Management, a Five Year SaaS Mission Completed

Dec 16 2009

Unrealistic Cost Expectations, and How to Fix Them

Published under Technology

I suppose there have been hiring companies with wildly unrealistic cost expectations forever; the internet just makes it more visible. Take, for example, this job post for PostgreSQL expert, which I republish here for criticism and comment, anonymized: We are looking for a postgre expert with indepth Oracle skill to help with the following project: […]

Comments Off on Unrealistic Cost Expectations, and How to Fix Them

Oct 22 2008

Analyzing PostgreSQL logs with pgFouine (on Ubuntu 8.04)

Published under Technology

pgFouine is a slick, useful, and free tool for analyzing PostgreSQL query workloads. It works without any impact on the running PostgreSQL: it analyzes the PG log output. The caveat is that it needs PG configured to write the right kind of log output. Sadly, as of version 8.3 PG has a wrinkle in how […]

One response so far

Oct 21 2008

Multicast your DB backups with UDPCast

Published under Technology

At work we have a set of database machines set up so that one is the primary machine, making backups once per day, and several other machines restore this backup once per day, for development, ad hoc reporting, and other secondary purposes. We started out with an obvious approach: back up on server1, to a […]

One response so far

Oct 19 2008

Network / System Monitoring Smorgasbord

Published under Technology

At one of my firms (a Software as a Service provider), we have a Zabbix installation in place to monitor our piles of mostly Linux servers. Recently we look a closer look at it and and found ample opportunities to monitor more aspects, of more machines and device, more thoroughly. The prospect of increased investment […]

4 responses so far

Older Entries »