This month's topic is "Data Visualization and Exploration Techniques Using R and Postgres" with PSU's Dr Christopher Monsere.

Full details: http://pugs.postgresql.org/node/1669

Normally, Gabrielle ensures that we have thoughtful and informative presentations. Unfortunately for you, I -- Melissa -- am guest-hosting this month.

What I'll come up with is anyone's guess, but BYOB is strongly recommended. Muahahaha.

Oh, and we may also talk about Postgres or something. And we'll join those folks at the Lucky Lab afterwards.

Jonathan Leto will be talking about "PL/Parrot and PL/Perl6 - Parrots and Butterflies in your Database".

Beer afterwards at the SE Lucky Lab.

Brian Kurle will be giving a talk about his experiences on architecting and developing a middleware system for Decagon Devices that collects data from remote devices via GSM and provides aggregated data via the web to users with PostgreSQL as the central database.

Looking forward to seeing everyone there....and of course, drinks at the Lucky Lab (http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterward.

Join the Portland PostgreSQL Users' Group for our monthly meeting!

When: 7pm Thursday, May 20 Where: FreeGeek Who: Melissa Hollingsworth What: Normalization!

Drinks afterward at the SE Lucky Lab.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 18 Mar, 2010 Who: you! What: PostgreSQL 9.0alpha testing party

Drinks afterward at the SE Lucky Lab.

Over Normalization from a developers point of view.

Ben Hengst works for Powells.com and has been involved in some in house restructuring, mostly centered around moving to a very vertical structure. This talk will revolve around what works and what doesn't, code and people problems that have been encountered and how to dig your self out.

Looking forward to seeing everyone there....and of course, drinks at the Lucky Lab (http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards.

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 17 Sept, 2009 Who: David Wheeler What: Unit Test Your Database!

Drinks afterward at the SE Lucky Lab.

Join the Portland PostgreSQL Users' Group for our monthly meeting!

Where: FreeGeek When: 7pm 20 August, 2009 Who: Jim Cser What: Metro simulation database

Drinks afterward at the SE Lucky Lab.

PostgreSQL Users' Group monthly meeting. Followed by refreshments at the Lucky Lab.

Topic: Visual Planner Presenter: Tom Raney, PSU Where: FreeGeek, 1731 SE 10th Avenue, Portland, OR When: 7pm, September 18, 2008

Tom Raney will be presenting the Visual Planner, a GUI tool written in Java that enables the user to peek inside the PostgreSQL planner's decision making process. The tool shows all plans that were evaluated including the plan that was picked for execution. Tom worked on this during Google Summer of Code, and credits Dr. Len Shapiro, a professor at Portland State University and PDXPUG regular, as a great help.

Tom showed off his tool during OSCON and has gotten some feedback from community members on it. He's working up a test example that should appeal to DBAs, and I'll link directly to the source code once he's got it ready.

This work also involves a patch to PostgreSQL, which should be available soon!

After the meeting, retire to the Lucky Lab for refreshments!

See web link for details.

Advanced signup is required.

Portland Postgres Users Group. See link for details.

Portland Postgres Users Group. See link for details.

See link for details.

See PDXPUG blog (linked) for details.

See PDXPUG blog (linked) for details.

Sqitch information is at http://sqitch.org/

Speaker: Alex Theodore

As a CTO I saw everything that went into and came out of the web development process, from the "client needs" to the source-controlled code. But being skilled in database development showed me time and time again that databases (and their architecture) were often sidelined treated as after-thoughts and often times served as little more than flexible storage spaces. Yet, their contents were the very essence of value for the process/client/company being served. This strange inversion of priorities led me to develop a way of looking at databases as "outside" the application and ultimately to interacting with them as API's. In my talk I'll be presenting this concept and showing with simple rules and examples how it can be done.

Bio:

I was the product and technology founder of Fracture.me and CTO up until 2018 where I developed the manufacturing processes and ERP software that powered our production process. That got me deeply involved in database work, especially with architecture and process design and optimization. Now I work part time as a database consultant and part time building modern, minimalistic furniture for my new (small) company MillFinish.com.

Learn about the considerations in planning for disaster recovery in order to maintain business continuity. There are solutions available that can help you achieve your backup and recovery objectives by taking advantage of PostgreSQL features, such as point-in-time recovery, and help implement retention policies.

Also learn how to take advantage of PostgreSQL’s replication features to keep your database highly-available, and the basic cluster architectures to consider to keep a PostgreSQL cluster up and running.

Mark works at 2ndQuadrant as a consultant for English Speaking Territories, based out of Oregon. He is a Contributor to PostgreSQL, co-organizer of the Portland PostgreSQL User Group, and serves as a Director and Treasurer for the United States PostgreSQL Association.

We will present the latest test results comparing where we are with 9.6devel to the 9.5 branch. Additionally, there will also be data to illustrate the gaps that Postgres may attempt to close between other open source column store database solution using DBT-3 (a synthetic ad-hoc decision support workload).

Mark leads the 2ndQuadrant performance practice as a Performance Consultant for English Speaking Territories, based out of Oregon in the USA.

(You can RSVP on our meetup group, if you like: http://www.meetup.com/PDXPUG-Portland-PostgreSQL-Users-Group/)

Portland Postgres Users Group See website for details.

Portland Postgres Users Group See website for details.

Portland Postgres Users Group See website for details.

Portland Postgres Users Group See website for details.

Portland Postgres Users Group See website for details.

Portland Postgres Users Group

In this presentation we will grapple with the un-joinable itself, and see if we may not join it after all. The presentation explores the record linking problem (entity resolution) in the context of PostgreSQL. This problem generally arises when you have multiple data sources (or duplicates) without a reliable key to resolve multiple records to the same entity. First the problem is explored, then a general approach to developing a solution is presented, and finally there will be some pro tips.

Note that for this particular meeting, we will meet on the ground floor Board Room instead of the Iovation offices.