blog.databasepatterns.com
Database Patterns: Quick Links
http://blog.databasepatterns.com/p/quick-links.html
A little Postgres. A little Spring. 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. 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 . Trees and Paths using WITH RECURSIVE in PostgreSQL. View my complete profile.
karenpadir.wordpress.com
“Opportunity is missed by most people because it is dressed in overalls and looks like work.” Thomas Edison | Fresh Tracks
https://karenpadir.wordpress.com/2010/05/20/“opportunity-is-missed-by-most-people-because-it-is-dressed-in-overalls-and-looks-like-work-”-thomas-edison
Karen Tegan Padir's Weblog. Opportunity is missed by most people because it is dressed in overalls and looks like work. Thomas Edison. May 20, 2010 in Uncategorized. And we have been hard at work since my last post. Demand for Postgres has been overwhelming. I said in my first blog,. We will only be limited by capacity, not opportunity. Upon reflection, that seems like an incredible grasp of the obvious. They even gave away some cool Sun Microsystems Logo collector’s items! Today, EnterpriseDB and NTT.
joshwilliams.name
Blog « '– – Josh
http://joshwilliams.name/blog
Skip to content ↓. 039;– – Josh. How to be mean to developers. On Sep.03, 2010, under PostgreSQL. Maybe you work at one of those large corporations that has a dedicated DBA staff, separate from the development team. Or maybe you’re lucky and just get to read about it on thedailywtf.com. Well if you ever feel the need to get back at them, here’s a few things you can try. Quoted identifiers let you name your objects anything you want, even if they don’t look like a normal object name…. Then again, if this ...
joshwilliams.name
projectmanagement « '– – Josh
http://joshwilliams.name/tag/projectmanagement
Skip to content ↓. 039;– – Josh. Building a Better Data Center Move. On Feb.22, 2010, under Project Management. Or, Four Things I Learned As A Project Manager. The underlying concept of the move was a phased pipelined approach, where in as any Equipment Group X is being pulled from the rack, Group Y is in transit, and Group Z is being installed. In other words about the time something was done installing the next set of gear would be arriving. How to be mean to developers. All entries, chronologically.
joshwilliams.name
learnfrommymistakes « '– – Josh
http://joshwilliams.name/tag/learnfrommymistakes
Skip to content ↓. 039;– – Josh. Building a Better Data Center Move. On Feb.22, 2010, under Project Management. Or, Four Things I Learned As A Project Manager. The underlying concept of the move was a phased pipelined approach, where in as any Equipment Group X is being pulled from the rack, Group Y is in transit, and Group Z is being installed. In other words about the time something was done installing the next set of gear would be arriving. How to be mean to developers. All entries, chronologically.
adpgtech.blogspot.com
Andrew Dunstan's PostgreSQL and Technical blog: March 2015
http://adpgtech.blogspot.com/2015_03_01_archive.html
Andrew Dunstan's PostgreSQL and Technical blog. Monday, March 30, 2015. Testing patches with a couple of commands using a buildfarm animal. For f in root/[RH]* ; do br=`basename $f` perl ./run build.pl - from-source=`pwd`/$f/pgsql - config=jacana.conf - verbose $br done. After it was all done and everything worked, I cleaned up the git repositories so they were ready for more buildfarm runs:. For f in root/[RH]* ; do pushd $f/pgsql git reset - hard git clean -dfxq popd done. Wednesday, March 4, 2015.
depesz.com
select * from depesz; » Blog Archive » How to remove backups?
https://www.depesz.com/2010/04/04/how-to-remove-backups
How to remove backups? April 4th, 2010 by depesz Tags: backup. If yes - maybe you can help me. Question from title sounds weird to you? It's just a ‘rm backup filename'? Well I really wish it was so simple in some cases. One of the servers I'm looking into, there is interesting situation:. Quite busy database server (2k tps is the low point of the day). Daily backups, each sized at about 100GB. Backups stored on ext3 filesystem with default options. Create 15 1GB files with irrelevant content. Done & /tm...
pyrseas.wordpress.com
Feature Matrix | Taming Serpents and Pachyderms
https://pyrseas.wordpress.com/feature-matrix
Taming Serpents and Pachyderms. This indicates the Postgres data definition language features supported by each Pyrseas release. Pyrseas supports Postgres versions 9.0, 9.1, 9.2, 9.3, 9.4 and 9.5. Some of the DDL features are only available in later Postgres versions. Pyrseas can be used with Python 2.6 or 2.7 and starting in version 0.5 with Python 3.2, 3.3, 3.4 or 3.5. 8211; CHECK CONSTRAINT. 8211; PRIMARY KEY. 8211; FOREIGN KEY. 8211; UNIQUE CONSTRAINT. 8211; base type. The Future of Pyrseas: Part 3.
depesz.com
select * from depesz; » Blog Archive » my thoughts on getting random row
https://www.depesz.com/index.php/2007/09/16/my-thoughts-on-getting-random-row
My thoughts on getting random row. September 16th, 2007 by depesz Tags: postgresql. If yes - maybe you can help me. This topic has been written about by many smart people – from the recent past, by greg sabino mullane. They show 4 different approaches:. All these approaches have their benefits and drawbacks, but i'd like to show another one (polish readers saw the approach already in january 2007, but this time i will make the code more robust). First, let's discuss existing methods:. Basically – g...
SOCIAL ENGAGEMENT