Our Blog

Ongoing observations by End Point people

Blog posts tagged ‘database’

Systematic Query Building with Common Table Expressions

Josh Tolley · June 12, 2018

Recycling Web Workers: Just Proper Hygiene

Josh Williams · March 23, 2018

Using PostgreSQL cidr and inet types, operators, and functions

Phin Jensen · September 28, 2017

Amazon AWS upgrades to Postgres with Bucardo

Greg Sabino Mullane · June 6, 2017

DBA Revenge: How To Get Back at Developers

Josh Williams · April 1, 2017

Seedbank: Structured Seed Files for Rails Projects

Patrick Lewis · December 21, 2016

Connect Multiple JPA repositories using Static and Dynamic Methods

Selvakumar Arumugam · November 16, 2016

Making cross-blogs queries in multi-site WordPress performant

Kamil Ciemniewski · November 2, 2016

WAL-based Estimates For When a Record Was Changed

Josh Williams · July 1, 2016

Randomized Queries in Ruby on Rails

Kent Krenrich · May 12, 2016

Postgres 9.5: three little things

Greg Sabino Mullane · January 28, 2016

PostgreSQL Point-in-time Recovery: An Unexpected Journey

David Christensen · January 15, 2016

Postgres checksum performance impact

Greg Sabino Mullane · December 31, 2015

Pgbouncer user and database pool_mode with Scaleway

Greg Sabino Mullane · September 24, 2015

Bucardo replication from Postgres to sqlite and mariadb using pgbench

Greg Sabino Mullane · August 12, 2015

Selectively firing Postgres triggers

Greg Sabino Mullane · July 15, 2015

Heroku: dumping production database to staging

Marina Lohova · June 17, 2015

Updated NoSQL benchmark: Cassandra, MongoDB, HBase, Couchbase

Josh Williams · June 4, 2015

Postgres “unsupported frontend protocol” mystery

Greg Sabino Mullane · May 28, 2015

Connected to PgBouncer or Postgres?

Greg Sabino Mullane · May 18, 2015

Handling databases in dev environments for web development

Spencer Christensen · April 21, 2015

New NoSQL benchmark: Cassandra, MongoDB, HBase, Couchbase

Jon Jensen · April 13, 2015

Postgres searchable release notes—​one page with all versions

Greg Sabino Mullane · March 11, 2015

Temporary tables in SQL query optimization

Jeff Boes · February 25, 2015

Postgres ON_ERROR_ROLLBACK explained

Greg Sabino Mullane · February 24, 2015

Postgres pg_dump implicit cast problem patched!

Greg Sabino Mullane · February 16, 2015

Postgres custom casts and pg_dump

Greg Sabino Mullane · February 10, 2015

DBD::Pg escaping placeholders with backslashes

Greg Sabino Mullane · January 12, 2015

DBD::Pg: one ping to rule them all

Greg Sabino Mullane · January 7, 2015

PostgreSQL conflict handling with Bucardo and multiple data sources

Greg Sabino Mullane · July 24, 2014

Version 5 of Bucardo database replication system

Greg Sabino Mullane · June 23, 2014

Why Can’t I Edit this Database Table? Don’t Forget the Client!

Mark Johnson · June 11, 2014

DBD::Pg, array slices, and pg_placeholder_nocolons

Greg Sabino Mullane · May 25, 2014

Custom plans prepared statements in PostgreSQL 9.2

Greg Sabino Mullane · April 28, 2014

MySQL, ASCII Null, and Data Migration

Mark Johnson · February 26, 2014

Rails ActiveRecord with Database Column Defaults

Kent Krenrich · February 7, 2014

Copy Data Between MySQL Databases with Sequel Pro

Greg Davidson · January 10, 2014

Increasing MySQL 5.5 max_connections on RHEL 5

Jon Jensen · December 24, 2013

Database federation performance showdown

Josh Tolley · December 19, 2013

How to Enable MySQL Event Scheduler

Emanuele “Lele” Calò · November 26, 2013

How to DRY out your Active Record queries with Squeel

Kamil Ciemniewski · October 24, 2013

Ecommerce Innovation 2013

Richard Templet · October 16, 2013

SFTP virtual users with ProFTPD and Rails: Part 2

Brian Gadoury · July 10, 2013

Window functions in action

Josh Tolley · June 5, 2013

Foreign Data Wrappers

Josh Tolley · May 13, 2013

Dimensional Modeling

Josh Tolley · May 8, 2013

NoSQL benchmark of Cassandra, HBase, MongoDB

Jon Jensen · March 12, 2013

SFTP virtual users with ProFTPD and Rails: Part 1

Brian Gadoury · December 20, 2012

Detecting table rewrites with the ctid column

Greg Sabino Mullane · November 26, 2012

Postgres alter column problems and solutions

Greg Sabino Mullane · November 9, 2012

An Encouraging LinuxFest

Josh Williams · October 29, 2012

Postgres system triggers error: permission denied

Greg Sabino Mullane · October 25, 2012

Case Sensitive MySQL Searches

Brian Buchalter · October 18, 2012

The Real Cost of Data Roundtrip

Szymon Lipiński · October 3, 2012

Pl/Perl multiplicity issues with PostgreSQL - the Highlander restriction

Greg Sabino Mullane · September 4, 2012

Enforcing Transaction Compartments with Foreign Keys and SECURITY DEFINER

Mark Johnson · September 4, 2012

Postgres log_statement='all' should be your default

Greg Sabino Mullane · June 30, 2012

You shall not pass! Preventing SQL injection

Marina Lohova · June 14, 2012

Detecting Postgres SQL Injection

Greg Sabino Mullane · June 10, 2012

UTOSC Recap

Josh Tolley · May 10, 2012

Integrating Propel ORM

Terry Grant · April 18, 2012

The Mystery of The Zombie Postgres Row

Greg Sabino Mullane · March 14, 2012

Tracking down PostgreSQL XYZ error: tablespace, database, and relfilnode

Greg Sabino Mullane · February 14, 2012

RailsAdmin Import: Part 2

Steph Skardal · February 1, 2012

Protecting and auditing your secure PostgreSQL data

Greg Sabino Mullane · January 30, 2012

Interchange loops using DBI Slice

Richard Templet · January 13, 2012

Some great press for College District

Ron Phipps · January 5, 2012

Interchange Search Caching with “Permanent More”

Mark Johnson · January 2, 2012

Finding PostgreSQL temporary_file problems with tail_n_mail

Greg Sabino Mullane · November 10, 2011

Viewing schema changes over time with check_postgres

Greg Sabino Mullane · October 5, 2011

A comparison of JasperSoft iReport and Pentaho Reporting

Josh Tolley · October 2, 2011

PostgreSQL Serializable and Repeatable Read Switcheroo

Greg Sabino Mullane · September 28, 2011

Bucardo PostgreSQL replication to other tables with customname

Greg Sabino Mullane · September 5, 2011

PostgreSQL log analysis / PGSI

Greg Sabino Mullane · August 19, 2011

Changing postgresql.conf from a script

Greg Sabino Mullane · August 10, 2011

Announcing pg_blockinfo!

David Christensen · July 14, 2011

DBD::Pg UTF-8 for PostgreSQL server_encoding

Greg Sabino Mullane · June 20, 2011

MongoDB replication from Postgres using Bucardo

Greg Sabino Mullane · June 12, 2011

Bucardo multi-master for PostgreSQL

Greg Sabino Mullane · June 6, 2011

Postgres Bug Tracking - Help Wanted!

Greg Sabino Mullane · May 29, 2011

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

Page 1 of 2 • Next page

Popular Tags


Archive


Search our blog