• Home

  • Custom Ecommerce
  • Application Development
  • Database Consulting
  • Cloud Hosting
  • Systems Integration
  • Legacy Business Systems
  • Security & Compliance
  • GIS

  • Expertise

  • About Us
  • Our Team
  • Clients
  • Careers

  • Blog

  • VisionPort

  • Contact
  • Our Blog

    Ongoing observations by End Point Dev people

    Blog posts tagged ‘database’

    Only Try This At Home

    Josh Williams · May 19, 2011

    NOTIFY vs Prepared Transactions in Postgres (the Bucardo solution)

    Greg Sabino Mullane · May 3, 2011

    MySQL Integer Size Attributes

    Mark Johnson · April 28, 2011

    Postgres query caching with DBIx::Cache

    Greg Sabino Mullane · April 25, 2011

    DBD::Pg query cancelling in Postgres

    Greg Sabino Mullane · April 4, 2011

    Annotating Your Logs

    Josh Williams · March 31, 2011

    Postgres Build Farm Animal Differences

    Greg Sabino Mullane · March 29, 2011

    check_postgres without Nagios (Postgres checkpoints)

    Greg Sabino Mullane · January 21, 2011

    DBD::Pg, UTF-8, and Postgres client_encoding

    Greg Sabino Mullane · January 13, 2011

    Character encoding in perl: decode_utf8() vs decode('utf8')

    David Christensen · December 31, 2010

    PostgreSQL 9.0 High Performance Review

    David Christensen · November 30, 2010

    Utah Open Source Conference 2010 part 1

    Jon Jensen · November 12, 2010

    Upgrading old versions of Postgres

    Greg Sabino Mullane · October 11, 2010

    PostgreSQL 8.4 in RHEL/CentOS 5.5

    Jon Jensen · September 28, 2010

    Postgres configuration best practices

    Greg Sabino Mullane · September 27, 2010

    Anonymous code blocks

    Josh Tolley · September 23, 2010

    pg_wrapper’s very symbolic links

    Josh Williams · September 22, 2010

    Listen/Notify improvements in PostgreSQL 9.0

    Greg Sabino Mullane · September 21, 2010

    PostgreSQL odd checkpoint failure

    David Christensen · September 14, 2010

    Distributed Transactions and Two-Phase Commit

    Josh Tolley · July 29, 2010

    PostgreSQL: Migration Support Checklist

    David Christensen · July 22, 2010

    Views across many similar tables

    Jeff Boes · July 13, 2010

    NoSQL at RailsConf 2010: An Ecommerce Example

    Steph Skardal · June 14, 2010

    pgcrypto pg_cipher_exists errors on upgrade from PostgreSQL 8.1

    Greg Sabino Mullane · June 10, 2010

    The PGCon “Hall Track”

    Josh Tolley · May 25, 2010

    Postgres Conference — PGCon2010 — Day Two

    Greg Sabino Mullane · May 24, 2010

    PostgreSQL Conference - PGCon 2010 - Day One

    Greg Sabino Mullane · May 21, 2010

    PostgreSQL 8.4 on RHEL 4: Teaching an old dog new tricks

    David Christensen · May 19, 2010

    PostgreSQL switches to Git

    Greg Sabino Mullane · May 19, 2010

    Finding the PostgreSQL version — without logging in!

    Greg Sabino Mullane · May 17, 2010

    PostgreSQL template databases to restore to a known state

    Greg Sabino Mullane · May 12, 2010

    Tail_n_Mail does Windows (log file monitoring)

    Greg Sabino Mullane · May 9, 2010

    Tickle me Postgres: Tcl inside PostgreSQL with pl/tcl and pl/tclu

    Greg Sabino Mullane · May 4, 2010

    Viewing Postgres function progress from the outside

    Greg Sabino Mullane · April 28, 2010

    Modifying Models in Rails Migrations

    Sonny Cook · April 8, 2010

    PostgreSQL Conference East 2010 review

    Greg Sabino Mullane · March 29, 2010

    NoSQL Live: The Dynamo Derivatives (Cassandra, Voldemort, Riak)

    Ethan Rowe · March 12, 2010

    Quick Thoughts on NoSQL Live Boston Conference

    Ethan Rowe · March 11, 2010

    PostgreSQL UTF-8 Conversion

    Jon Jensen · March 9, 2010

    Riak Install on Debian Lenny

    Ethan Rowe · March 4, 2010

    PostgreSQL EC2/EBS/RAID 0 snapshot backup

    Jon Jensen · February 23, 2010

    MySQL Ruby Gem CentOS RHEL 5 Installation Error Troubleshooting

    Adam Vollrath · February 9, 2010

    PostgreSQL version 9.0 release date prediction

    Greg Sabino Mullane · February 5, 2010

    Splitting Postgres pg_dump into pre and post data files

    Greg Sabino Mullane · January 20, 2010

    Gathering server information with boxinfo

    Greg Sabino Mullane · January 15, 2010

    Postgres Upgrades — Ten Problems and Solutions

    Greg Sabino Mullane · January 11, 2010

    Postgres SQL Backup Gzip Shrinkage, aka Don’t Panic!!!

    David Christensen · January 9, 2010

    State of the Postgres project

    Greg Sabino Mullane · January 4, 2010

    Monitoring Postgres log files with tail_n_mail

    Greg Sabino Mullane · January 1, 2010

    MySQL and Postgres command equivalents (mysql vs psql)

    Greg Sabino Mullane · December 24, 2009

    Verifying Postgres tarballs with PGP

    Greg Sabino Mullane · December 21, 2009

    Editing large files in place

    Greg Sabino Mullane · December 13, 2009

    Live by the sword, die by the sword

    Greg Sabino Mullane · December 13, 2009

    Fun with SQL

    Josh Tolley · October 10, 2009

    Permission denied for postgresql.conf

    Greg Sabino Mullane · September 21, 2009

    Text sequences

    Greg Sabino Mullane · August 20, 2009

    Perl+Postgres: changes in DBD::Pg 2.15.1

    Greg Sabino Mullane · August 12, 2009

    Comparing databases with check_postgres

    Greg Sabino Mullane · July 28, 2009

    Bucardo and truncate triggers

    Greg Sabino Mullane · July 14, 2009

    MDX

    Josh Tolley · July 14, 2009

    Competitors to Bucardo version 1

    Jon Jensen · May 18, 2009

    The design of Bucardo version 1

    Jon Jensen · May 15, 2009

    Being at the MySQL User Conference: how Postgres fits in

    Selena Deckelmann · April 30, 2009

    OpenSQL Camp 2008

    Greg Sabino Mullane · November 19, 2008

    10,000 databases on a PostgreSQL cluster

    Jon Jensen · November 10, 2008

    Authorize.Net Transaction IDs to increase in size

    Dan Collis-Puro · September 2, 2008

    MySQL vs. PostgreSQL mailing list activity

    Jon Jensen · July 31, 2008

    PGCon 2008 Report

    Greg Sabino Mullane · June 13, 2008

    DBD::Pg 2.0.0 Released

    Greg Sabino Mullane · February 25, 2008

    Bucardo: Replication for PostgreSQL

    Greg Sabino Mullane · October 10, 2007

    Greg Sabino Mullane’s PostgreSQL tips and how-to articles

    Jon Jensen · January 15, 2007

    Trouble with MySQL 4.1 under heavy load

    Jon Jensen · June 16, 2006

    PostgreSQL Supports Two-Phase Commit

    Jeff Boes · May 8, 2006

    PostgreSQL 8.1 Shows Database Progress

    Jon Jensen · November 14, 2005

    Previous page • Page 2 of 2