Viewing 0 current events matching “postgresql” by Date.

Sort By: Date Event Name, Location , Default
No events were found.

Viewing 84 past events matching “postgresql” by Date.

Sort By: Date Event Name, Location , Default
Sunday
Jul 20, 2008
OSCON PostgreSQL Day

What: All-day PostgreSQL one-track mini-conference When: Sunday, July 20th, 9am to 5pm, possible party afterwards Who: PDXPUG will select speakers Where: Portland Convention Center, Portland, Oregon

Website
Thursday
Sep 18, 2008
PDXPUG
Free Geek

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!

Website
Friday
Oct 10, 2008
PostgreSQL Conference West
through Portland State University Native American Student & Community Center

Join us for the second annual PostgreSQL Conference West! Scheduled to begin October 10 and go through the weekend, West being held at Portland State University is going to be the destination for learning, fun and general education about PostgreSQL.

Website
Thursday
Nov 20, 2008
PostgreSQL: Randal + Smalltalk
Free Geek

While many people may know Randal Schwartz of Stonehenge Consulting (http://www.stonehenge.com/) from his talks and papers on Perl, he is also quite knowledgeable about Smalltalk and will be giving a talk on Smalltalk and Postgres integration.

We will be meeting Thursday, November 20th, at FreeGeek at 7:00pm - 1731 SE 10th Avenue, Portland, OR.

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

Website
Thursday
Jan 8, 2009
PostgreSQL Portland Performance Practice Project (P5) - Series Overview
Portland State University Fourth Avenue Building (FAB)

PostgreSQL Portland Performance Practice Project (P5)

Sponsored by the Computer Science Department, Portland State University

This series will consist of 5 to 6 presentations aimed at PostgreSQL database users who wish to learn more about tuning their systems for performance. Attendees will learn how to generate and interpret operating system (Linux) and database statistics, and the effects of some system tuning techniques. This involves studying the well known Online Transaction Processing (OLTP) benchmark called TPC-C ( www.tpc.org ). TPC-C was developed by a committee, representing all major players in the database marketplace, to be representative of typical online enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate how each tuning technique affects their performance. We will use an open source package that the speaker has developed, called DBT-2, which many DBAs have found useful.

Mark Wong has an MS in Computer Science from OGI and several years of experience developing and executing various database systems benchmarks. Most relevant to this series are his years spent at the OSDL developing and using a fair-use derivative of the TPC-C benchmark to characterize system performance of open source software. He now works at HP StorageWorks on their NAS products.

2nd THURSDAY OF EACH MONTH, BEGINNING JANUARY 8, 7:00 PM PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE, FOURTH AVENUE BUILDING – ROOM 86-01

Website
Thursday
Feb 12, 2009
PostgreSQL Portland Performance Practice Project (P5)
Portland State University Fourth Avenue Building (FAB)

2nd THURSDAY OF EACH MONTH, BEGINNING JANUARY 8, 7:00 PM PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE, FOURTH AVENUE BUILDING – ROOM 86-01

See website for more details.

Website
Thursday
Feb 19, 2009
PDXPUG: PostgreSQL Data Visualization
Free Geek

Monthly meeting of the Portland PostgreSQL Users' Group.

Ed Borasky will be speaking about Data Visualization.

Beers after at the Lucky Lab on Hawthorne.

Website
Thursday
Mar 12, 2009
PostgreSQL Portland Performance Practice Project (P5)
Portland State University Fourth Avenue Building (FAB)

Sponsored by the Computer Science Department, Portland State University

This series will consist of 5 to 6 presentations aimed at PostgreSQL database users who wish to learn more about tuning their systems for performance. Attendees will learn how to generate and interpret operating system (Linux) and database statistics, and the effects of some system tuning techniques. This involves studying the well known Online Transaction Processing (OLTP) benchmark called TPC-C ( www.tpc.org ). TPC-C was developed by a committee, representing all major players in the database marketplace, to be representative of typical online enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate how each tuning technique affects their performance. We will use an open source package that the speaker has developed, called DBT-2, which many DBAs have found useful.

PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE, FOURTH AVENUE BUILDING – ROOM 86-01

Website
Thursday
Mar 19, 2009
PDXPUG: eXtreme Database Makeover 2: PORTAL
Free Geek

Monthly meeting of the Portland PostgreSQL Users' Group.

Kristin Tufte will be speaking about the Portland Transportation Archive Listing (PORTAL) database schema.

Beers after at the Lucky Lab on Hawthorne.

Website
Thursday
Apr 9, 2009
PostgreSQL Portland Performance Practice Project (P5) - Linux Filesystems
Portland State University Fourth Avenue Building (FAB)

PostgreSQL Portland Performance Practice Project (P5)

Sponsored by the Computer Science Department, Portland State University

This series will consist of 5 to 6 presentations aimed at PostgreSQL database users who wish to learn more about tuning their systems for performance. Attendees will learn how to generate and interpret operating system (Linux) and database statistics, and the effects of some system tuning techniques. This involves studying the well known Online Transaction Processing (OLTP) benchmark called TPC-C ( www.tpc.org ). TPC-C was developed by a committee, representing all major players in the database marketplace, to be representative of typical online enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate how each tuning technique affects their performance. We will use an open source package that the speaker has developed, called DBT-2, which many DBAs have found useful.

Mark Wong has an MS in Computer Science from OGI and several years of experience developing and executing various database systems benchmarks. Most relevant to this series are his years spent at the OSDL developing and using a fair-use derivative of the TPC-C benchmark to characterize system performance of open source software.

2nd THURSDAY OF EACH MONTH, BEGINNING JANUARY 8, 7:00 PM PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE, FOURTH AVENUE BUILDING – ROOM 86-01

Website
Thursday
Apr 16, 2009
PDXPUG - MySQL war stories: Tales from the Crater
Free Geek

Monthly meeting of the Portland PostgreSQL Users' Group.

Chris May will be speaking.

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

Website
Thursday
May 14, 2009
PostgreSQL Portland Performance Practice Project (P5)
Portland State University Fourth Avenue Building (FAB)

This session will survey a few PostgreSQL tuning parameters and their effects on the OLTP workload DBT-2.

--

PostgreSQL Portland Performance Practice Project (P5)

Sponsored by the Computer Science Department, Portland State University

This series will consist of 5 to 6 presentations aimed at PostgreSQL database users who wish to learn more about tuning their systems for performance. Attendees will learn how to generate and interpret operating system (Linux) and database statistics, and the effects of some system tuning techniques. This involves studying the well known Online Transaction Processing (OLTP) benchmark called TPC-C ( www.tpc.org ). TPC-C was developed by a committee, representing all major players in the database marketplace, to be representative of typical online enterprise databases. TPC-C consists of a precisely defined schema and 19 queries. We will review the schema and queries and demonstrate how each tuning technique affects their performance. We will use an open source package that the speaker has developed, called DBT-2, which many DBAs have found useful.

Mark Wong has an MS in Computer Science from OGI and several years of experience developing and executing various database systems benchmarks. Most relevant to this series are his years spent at the OSDL developing and using a fair-use derivative of the TPC-C benchmark to characterize system performance of open source software.

2nd THURSDAY OF EACH MONTH, BEGINNING JANUARY 8, 7:00 PM PORTLAND STATE UNIVERSITY, 1900 SW 4th AVENUE, FOURTH AVENUE BUILDING – ROOM 86-01

Website
Thursday
May 21, 2009
PDXPUG: Introductory Database Education at PSU
Free Geek

by Len Shapiro

Abstract: I'll survey how I teach the introductory database course at PSU. My goal for the talk is to elicit suggestions for how I could do a better job. The theme of the course is "transforming data into Information". I use a 200 Meg database, hosted on PostgreSQL, instead of the one-slide databases used in typical intro courses, to illustrate the principles of the course. The database is Federal Elections Commission data re donations to candidates, so queries often reflect real questions about the real data.

Bio: Len Shapiro has been a professor at PSU for 23 years. His research interests are primarily in query processing.

Website
Thursday
Jul 16, 2009
PDXPUG - PostGIS and the Census Data
Free Geek

Webb Sprague will be speaking about PostGIS and the Census Data at the next PDXPUG meeting at FreeGeek (at 7:00pm - 1731 SE 10th Avenue, Portland, OR).

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

More details from Webb:

If anyone is wondering about specifics, I will describe how I recently created a "crosswalk" table that correlates census tracts in 1980 with census tracts in 2000 in the Portland region (well, Washington, Multnomah, and Clackamas counties), so that we could see poverty trends over the last 25 years.

I used PostGIS, Census naming conventions ("FIPS codes"), and lots of outer joins. So if you like that sort of thing, I would love to hear your comments tomorrow!

Website
Thursday
Aug 20, 2009
PDXPUG
Free Geek

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.

Website
Thursday
Sep 17, 2009
PDXPUG
Free Geek

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.

Website
Thursday
Oct 15, 2009
PDXPUG: Bucardo replication with tiny little goats
Free Geek

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 15 Oct, 2009 Who: Selena Deckelmann What: Bucardo: Replication with tiny little goats

Drinks afterward at the SE Lucky Lab.

Website
Thursday
Nov 19, 2009
PDXPUG: November meeting: Materialized Views
Free Geek

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 19 Nov, 2009 Who: Dan Colish What: Materialized Views (with cupcakes)

Drinks afterward at the SE Lucky Lab.

Website
Thursday
Jan 21, 2010
PDXPUG - Portland PostgreSQL Users Group: OBAMA!
Free Geek

The Portland PostgreSQL Users Group (PDXPUG)

John Naylor will be talking about his experience in Florida as a data manager for President Obama's 2008 campaign. He will discuss the role of data in political campaigns, and also refactor some data warehouse queries. Donuts and bacon provided.

Refreshments will be partaken at the Lucky Labrador Pub in SE Portland afterward.

Website
Thursday
Feb 18, 2010
PDXPUG
Free Geek

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.

Website
Thursday
Mar 18, 2010
PDXPUG
Free Geek

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.

Website
Thursday
May 20, 2010
PDXPUG
Free Geek

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.

Website
Thursday
Jun 17, 2010
PDXPUG (Portland PostgreSQL Users' Group)
Free Geek

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

When: 7pm Thursday, May 20 Where: FreeGeek Who: Mark & gabrielle What: What's new in 9.0

Drinks afterward at the SE Lucky Lab.

Website
Saturday
Jul 10, 2010
Dev Nation
Ace Hotel

In early 2009, several developers from Relevance and Viget Labs got together and starting talking about technical conferences. As we discussed our past experiences at regional, national, and international events, we began to realize something: large conferences are wonderful for a lot of things, but we wanted something that met a different set of goals. We came up with Developer Day, which was designed to:

  • Build lasting relationships among local peers
  • Bridge distinct technical communities

After a year of Developer Days, however, we decided a new look was in order, and thus was born DevNation. We've still got the same ideals, but we feel that the DevNation name better reflects that vision (and it's easier to Google!)

Relationships

The general pattern for a large conference runs something like this: you fly to a city, go to the event, have a great time, meet lots of great people, and fly home. More often than not, you don't see those people again until the next big conference, and that's a problem. We wanted our event to be different, so it's intentionally local. Speakers and attendees are overwhelmingly local to the conference, so when you meet someone doing something cool, you can connect with them a week later for lunch without a problem.

Technology-Agnostic

Sure, there are events that draw a wide range of developers (e.g., OSCON), but even then people tend to segregate; the Pythonists go to their sessions, the Rubyists to theirs, and the PHP devs to theirs. By having only one track, we give everyone the opportunity to see what's happening in other communities.

Website
Thursday
Sep 16, 2010
All about PostGIS (at Portland PostgreSQL Users Group)
Free Geek

Location-based services are all the rage these days, and almost everyone has a latitude and longitude or two stashed away in a numeric column somewhere. But, there is so much more to it than just a point. Once relegated to government and academia, geographic information systems are becoming increasingly visible. With the PostGIS extension, PostgreSQL is a first-class geodatabase and an incredible platform for working with spatial data, but what is PostGIS and why would one use it? And beyond PostGIS there are a dizzying array of tools to load, visualize and interact with the wonderful geospatial information in your database. This talk will cover GIS and PostGIS basics and provide an introduction to geodatabases and spatial queries.

--

Edwin Knuth spent quite some time as a sysadmin and web developer before going back to school to study Environmental Science at the University of Alaska Southeast. He quickly became fascinated with Geographic Information Systems and realized that GIS was just a really neat database application. In Alaska, Edwin worked on several unique projects, including building bat detectors and using PostGIS to manage a wireless sensor network on the Juneau Icefield. He has lived in Portland for the past year and loves it very much.

Then a trip to the Lucky Lab after.

Website
Thursday
Oct 21, 2010
PDXPUG: Postgres + node.js
Free Geek

PDXPUG monthly meeting.

Where: FreeGeek When: 7pm 21 Oct, 2010 Who: Aurynn Shaw What: PostgreSQL and node.js

Postgres and Node.js, a powerful event-driven programming environment paired with our favourite open-source database, now together in the same great package! Aurynn will be going over the node.js environment, how it differs from other programming environments, and how to use postgres with node.

Aurynn Shaw is Lead Userspace Developer at Command Prompt, Inc. She has come all the way from another country to present this talk, so don't miss it!

Beer afterwards at the Lucky Lab.

See you there!

Website
Thursday
Nov 18, 2010
PDXPUG
Free Geek Website
Thursday
Jan 20, 2011
PDXPUG (Postgresql)
Free Geek Website
Thursday
Feb 17, 2011
PDXPUG: Managing Terabytes
Free Geek

Selena Deckelmann will be talking about managing terabyte instances of PostgreSQL.

This will be a preview of her MySQL Users Conference talk:

http://en.oreilly.com/mysql2011/public/schedule/detail/17195

Size can creep up on you. Some day you may wake up to a multi-terabyte Postgres system handling over 3000 tps staring you down. Learn the best ways to manage these systems as they grow, and find out what new features in 9.0 have made life easier for administrators and application developers working with big data.

This talk will lead you through solutions to problems Postgres faces when it gets big: backups, transaction wraparound, bloat, huge catalogs and upgrades. You need to monitor the right things, find the gems in DBA-friendly database functions and catalog tables, and know the right places to look to spot problems early. We’ll also go over monitoring best practices and open source tools to get the job done.

Working with multiple versions of Postgres back to version 8.2 will be included, and as well as tips on making the most out of new features in 9.0. War stories will be taken from real-world work with Emma, an email marketing company with a few large databases.

Website
Thursday
Mar 17, 2011
PDXPUG: PostgreSQL Logging
Free Geek

See http://pugs.postgresql.org/node/1660 for talk description.

Website
Thursday
Apr 21, 2011
PDXPUG: Distributing Extensions on PGXN
Free Geek

This month's meeting marks the fourth installment in our "Founders Series"..

When: 7-9pm Thu Apr 21, 2011 Where: FreeGeek Who: David Wheeler What: Distributing Extensions on PGXN

So you've solved a common problem in PostgreSQL, a serious pain point that lots of other people could take advantage of. You want to open-source the code, and would like to package it up and distribute it where people can find it, read its docs, and download and install it.

The newest destination for distributing PostgreSQL extensions is PGXN, the PostgreSQL Extension network. PGXN offers a central index of PostgreSQL extensions and their documentation, making it easy for people to find an install extensions.

How do you optimize your extension distribution for maximum PGXN exposure? By careful packaging, thorough documentation, and simple installation. Join me for an overview of how best to achieve that — including how to build extensions compatible with PostgreSQL 9.1's improved extension support.

David Wheeler is an associate at PGExperts, and is responsible for PGXN, the PostgreSQL Extension Network) and pgTAP. He's into testing and extension distribution.

Beer afterwards at the Lucky Lab. See you there!

Website
Sunday
Jul 24, 2011
PgDay at OSCON
Oregon Convention Center

Coming to OSCON? Be sure to come a day early and join us for another PgDay! This summer marks PDXPUG's 5th anniversary, and we want to see your smiling face! We will be celebrating at Gotham Tavern after the day of sessions. Sign up for sessions and afterparty here: http://bit.ly/f1F2Mz .

Yes, it's ok to show up just for the afternoon (or the party) if your flight arrives on Sunday.

We'd like a $30 donation to SPI for the sessions, but don't let lack of funds deter you from attending.

Website
Thursday
Aug 18, 2011
PDXPUG: Lessons from managing way too many databases at Facebook
Free Geek

Rob Wultsch, a recent addition to Facebook's Database Operations team, will compare and contrast the Facebook deployment with his previous work with another large deployment of open source databases. In this db-agnostic talk, he'll go over: the bizarre becoming ordinary, the many types of infrastructure that do not scale and what does and does not work when building a DBA team.

Before joining Facebook, Rob worked for a very large hosting company as a database administrator and a newspaper as a web developer. In his free time he enjoys riding his motorcycle and bicycle and fantasizes about moving to Portland.

As always, beer afterwards at the Lucky Lab. See you there!

Website
Thursday
Sep 15, 2011
PDXPUG: Practical PostgreSQL Performance
Free Geek

When: 7-9pm Thu Sep 15, 2011 Where: FreeGeek Who: Joshua Drake What: Practical PostgreSQL Performance

This presentation provides down tot earth performance advice.

Joshua D. Drake (JD) is lead consultant at Command Prompt, Inc. and President of PgUS.

Beer afterwards at the Lucky Lab. See you there!

Website
Thursday
Oct 20, 2011
PDXPUG: Upgrading PostGIS
Iovation

When: 7-9pm Thu Oct 20, 2011 Where: Iovation Who: Brent Dombrowski What: Upgrading PostGIS from 8.something to 9.0

See PDXPUG blog (linked) for details.

Website
Thursday
Nov 17, 2011
PDXPUG: collectd and Postgres
Free Geek

See PDXPUG blog (linked) for details.

Website
Thursday
Jan 19, 2012
PDXPUG: Database Tracking
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Feb 16, 2012
PDXPUG: Locks, etc
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Mar 15, 2012
PDXPUG: NoSQL for People Living Under a Rock
Iovation

See PDXPUG blog (linked) for details. Also, "beware the Ides of March", &c.

Website
Thursday
Apr 19, 2012
PDXPUG: Data Near Here
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
May 17, 2012
PDXPUG: Replication Without Tears
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Jun 21, 2012
PDXPUG: Databases from Android
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Aug 16, 2012
PDXPUG: Vertically Scaling Postgres
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Sep 20, 2012
PDXPUG: Sqitch
Iovation

See PDXPUG blog (linked) for details.

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

Website
Thursday
Nov 15, 2012
PDXPUG: Sqitch
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Jan 10, 2013
Portland Perl Mongers – Sane Database Change Management with Sqitch
Free Geek

speaker: David Wheeler

SQL change management is hard. Most “migration”-style implementations require opaque naming conventions, prefer DSLs that cover a fraction of SQL, and require duplication of code for simple changes to existing functions. Such does not have to be. And now it’s not

Introducing Sqitch, simple SQL change management that doesn’t suck. Sqitch doesn’t care what programming language your app is written in. It has no opinions as to what database to use or what its schema should look like. And it doesn’t require sequentially-named migration scripts or the use of any DSL other than SQL. Sqitch lets you to write SQL migration scripts that target your database, and provides a simple, unintrusive interface for specifying dependencies, so that it can run things in the proper order.

So come to this talk to learn all about Sqitch: How it works, where to get it, and how to get the most out of managing database deployments.

David Wheeler is Senior Data Architect at iovation and an associate at PGExperts. He is responsible, among other things, for PGXN, pgTAP, DesignScene, and way too many CPAN modules. He lives in Portland unless he’s traveling with his family.

As usual, the meeting will be followed by social hour at the Lucky Lab Brew Pub.

Website
Thursday
Jan 17, 2013
PDXPUG: PostgreSQL in the Cloud
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Feb 21, 2013
PDXPUG: Dawn of a New Backup Era
Iovation

See PDXPUG blog (linked) for details.

Website
Thursday
Mar 21, 2013
PDXPUG: Autovacuum and You
Iovation

Autovacuum’s like a Roomba, right? You just turn it on and it does all the work for you. Well, not quite – for one, your pets can’t ride around on it – and occasionally it may get stuck in a (figurative) corner. In this talk, we’ll discuss vacuum, analyze, and their daemonic counterparts: how to adjust them to perform appropriately*, and perhaps more importantly, what the heck are they actually doing?

This is a beginner-to-intermediate level talk, but you will learn something new about vacuuming, regardless.** –

Gabrielle Roth is a consultant with EnterpriseDB. She specializes in network, database, and system monitoring, as well as abusing SQL.

After-meeting beer location: Huber’s, the oldest bar in Portland. See you there!

Website
Thursday
Apr 18, 2013
PDXPUG: Extreme Database Makeover
Iovation

See link for details.

Website
Thursday
May 16, 2013
PDXPUG: Lightning Talks
Iovation

See link for details.

Website
Thursday
Jun 20, 2013
PDXPUG: Lightning Talks
Iovation

See link for details.

Website
Wednesday
Jul 24, 2013
PDXPUG: July meeting
Emma

We have some special out-of-town guests here for OSCON, so we're having a special meeting for July. Details will be posted on the pdxpug website: http://wp.me/p25MlK-4r

Note that this is not our regular meeting time, day, or location!

Website
Thursday
Aug 15, 2013
PDXPUG: YAMS Aren't Sweet Potatoes
Iovation

See link for details.

Website
Thursday
Sep 19, 2013
PDXPUG: JSON
Iovation

See link for details.

Website
Thursday
Oct 17, 2013
PDXPUG: UrbanFootprint
Iovation

Portland Postgres Users Group. See link for details.

Website
Thursday
Nov 21, 2013
PDXPUG: Aquameta
Iovation

Portland Postgres Users Group. See link for details.

Website
Thursday
Jan 16, 2014
PDXPUG: January meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
Thursday
Feb 20, 2014
PDXPUG: February meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
Monday
Feb 24, 2014
Rentrak Hackathon
Rentrak - Downtown

The Rentrak Hackathon is a gathering of laptops and laughter. Classically, we all sit in a square and type words onto a keyboard that then get turned into a "computerized program". It's a good chance to work on your personal projects, learn what your peers are up to (computer-wise), figure out what the best programming language is, and/or say the words "I don't have anything to work on" or "I forgot my laptop". This event is very informal, and there is no specific project we'll be focusing our efforts on.

Food and refreshments are served. RSVPing to [email protected] is appreciated, but not required.

Come check out Rentrak's new downtown office. Everyone is welcome to join us!

Website
Thursday
Mar 20, 2014
PDXPUG: March meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
MaptimeStJohns
Anna Bannanas Cafe, St Johns

Tonight at MaptimeStJohns, we will review some compiled leaflet maps using several of the leaflet pluggins. We will go through some live custom examples using humangeo's dvf pluggin, we will use postgis and output geojson, geocsv and topojson to add to our leaflet maps, and also discuss some temporal mapping tools.

Bring your laptop with leaflet installed and a webserver available. Have a server scripting language such as php or python and postgressql/postgis installed. If you don't have a laptop, come anyway and you will be able to see these tools in action, as well as receive any materials handed out at the meetup. Bring a flash drive so you can take a copy of the data home.

LET'S GET TOGETHER AND MAP AT MAPTIMESTJOHNS!

Website
Monday
Mar 24, 2014
Rentrak Hackathon
Rentrak - Downtown

The Rentrak Hackathon is a gathering of laptops and laughter. Classically, we all sit in a square and type words onto a keyboard that then get turned into a "computerized program". It's a good chance to work on your personal projects, learn what your peers are up to (computer-wise), figure out what the best programming language is, and/or say the words "I don't have anything to work on" or "I forgot my laptop". This event is very informal, and there is no specific project we'll be focusing our efforts on.

Food and refreshments are served. RSVPing to [email protected] is appreciated, but not required.

Come check out Rentrak's new downtown office. Everyone is welcome to join us!

Website
Thursday
Apr 17, 2014
PDXPUG: April meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
Monday
Apr 28, 2014
Rentrak Hackathon
Rentrak - Downtown

The Rentrak Hackathon is a gathering of laptops and laughter. Classically, we all sit in a square and type words onto a keyboard that then get turned into a "computerized program". It's a good chance to work on your personal projects, learn what your peers are up to (computer-wise), figure out what the best programming language is, and/or say the words "I don't have anything to work on" or "I forgot my laptop". This event is very informal, and there is no specific project we'll be focusing our efforts on.

Food and refreshments are served. RSVPing to [email protected] is appreciated, but not required.

Come check out Rentrak's new downtown office. Everyone is welcome to join us!

Website
Monday
May 12, 2014
FutureTalk with Selena Deckelmann
New Relic

What Beginners Teach Us

Check out our pre-event Q&A with Selena on the New Relic blog.

Open source as an idea has won. Linux dominates developer servers, open source tools are ubiquitous and being an open source developer rocks. And yet, we talk frequently about how to find new contributors, how to increase the number of people who participate and share code with us, how to improve the skills of the junior developers and hire them as fast as we can.

Selena has spent a considerable amount of time teaching absolute beginners how to program in Python, how to use the command-line and how to use revision control. These beginners succeed and fail in open source in both familiar and surprising ways. In this talk, she will share lessons from their experiences to help us create a more inclusive and welcoming future for open source software. Further, she will provide insights into the code review process, and how learning how to give code review (not just receive code review) is critical to becoming an expert developer.

This is the 7th event in a series of free monthly FutureTalks from disruptive Developers, innovative Technologists and world-changing Creatives. Networking begins at 5:30, with free food and drinks. The presentation will begin right at 6p.

Please RSVP via Eventbrite HERE

Selena is a major contributor to PostgreSQL and a data architect at Mozilla. She's been involved with free and open source software since 1995 and began running conferences for PostgreSQL in 2007. She founded Open Source Bridge, Postgres Open and speaks internationally about open source, databases and community. She is an advisor to the Ada Initiative, an organization dedicated to increasing the participation of women in open source and technology communities.

You can find her on Twitter @selenamarie and on her blog at chesnok.com

› FutureTalk is brought to you by New Relic in collaboration with TAO

Thursday
May 15, 2014
PDXPUG: May meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
Thursday
Jun 19, 2014
PDXPUG: June meeting
Iovation

Portland Postgres Users Group. See link for details.

Website
Tuesday
Jul 22, 2014
PDXPUG: July meeting: OSCON BoF

Portland Postgres Users Group. See link for details.

Note that this is not our regular meeting time or place!

Website
Thursday
Aug 21, 2014
PDXPUG: August meeting

Portland Postgres Users Group. See link for details.

Website
Saturday
Sep 6, 2014
PostgreSQL Day
PSU Maseeh Engineering Building

Saturday, September 6th, is PostgreSQL Day, co-hosted by the Portland Postgres Users Group (PDXPUG) and Portland State University. Attendance is free, but RSVP is required (link below)

Place: Portland State University, Engineering Building, Room EB 102, 1930 SW 4th Avenue, Portland, Oregon 97201.

Registration: Space is limited, please RSVP!

RSVP here: https://www.eventbrite.com/e/portland-postgresql-users-group-pdxpug-day-2014-tickets-11916561757

Food: Light snacks & beverages provided. Breakfast and lunch is on your own; food carts are nearby.

Presentations: Organizers are looking for presenters for PostgreSQL Day. Talks should be about 45 minutes in length, and about any of the following topics:

PostgreSQL administration and performance Case studies of interesting uses of PostgreSQL and PostGIS Interesting applications built on PostGIS or PostgreSQL Database and/or geographic application development Database-related DevOps SQL and stored procedure programming New Postgres/PostGIS features and hacking Postgres/PostGIS

Organizers will also be taking lightning talks of 5 minutes each, on similar topics. Email your talk proposal to Mark Wong at markwkm -at- postgresql.org.

Website
Thursday
Sep 18, 2014
PDXPUG: September meeting
Iovation

Portland Postgres Users Group. See link for details.

When: 7-9pm Thu Sep 18, 2014 Where: Iovation Who: Jay Riddle What: Using Postgresql to enable Google like Search

Jay’s been experimenting with Pg’s full text search capabilities. At our next meeting, he’ll cover the following: * Brief intro on why Google like search capabilities are fun. * Introduce Postgresql full text abilities. Discuss at a high level why a full text index may be a bit heavier than a normal index. * Look at possible solutions for use cases where the data you want to index is spread across multiple columns and multiple tables.

Jay Riddle is a database administrator at Viewpoint software.

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Elevators open at 6:45 and building security closes access to the floor at 7:30.

The building is on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots.

See you there!

Website
Wednesday
Sep 24, 2014
PDX Python Presentation Night
Urban Airship Inc

Come join us for Pythonic talks!

All levels are welcome! Talk levels vary from beginner to advanced.

This month:

  • Omnibus Database Machine: How to NoSQL in Postgres with Django by Aleck Landgraf and Gavin McQuillan

And pizza from Building Energy!

Join us afterward at Rogue on NW 14th & Flanders to continue the discussion over a beverage.

RSVP at Meetup

Join us on our python.org mailing list and in #pdxpython on Freenode. All are welcome!

Website
Thursday
Oct 16, 2014
PDXPUG: October meeting
Iovation

What: PgOpen Recap (gabrielle, Mark, John M); New Relic Instrumentation of Pg Queries (Andrew)

Please note the new earlier meeting time! We’ll try this over the winter.

Two topics this month: PgOpen attendees will discuss highlights of that conference, and Andrew will talk about some New Relic-y stuff.

Our meeting will be held at Iovation, on the 32nd floor of the US Bancorp Tower at 111 SW 5th (5th & Oak). It’s right on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots. No bikes in the office, sorry!

Elevators open at 5:45 and building security closes access to the floor at 6:30.

Website
Thursday
Nov 20, 2014
PDXPUG: November meeting
Iovation

See website for details.

Website
Monday
Nov 24, 2014
Rentrak Hackathon
Rentrak - Downtown

The Rentrak Hackathon is a gathering of laptops and laughter. Classically, we all sit in a square and type words onto a keyboard that then get turned into a "computerized program". It's a good chance to work on your personal projects, learn what your peers are up to (computer-wise), figure out what the best programming language is, and/or say the words "I don't have anything to work on" or "I forgot my laptop". This event is very informal, and there is no specific project we'll be focusing our efforts on.

Food and refreshments are served. RSVPing to [email protected] is appreciated, but not required.

Come check out Rentrak's new downtown office. Everyone is welcome to join us!

Website
Thursday
Dec 4, 2014
PDXPUG: December lab night
Renewable Funding

See website for details.

Website
Tuesday
Dec 30, 2014
Programming OS Web Spatio-temporal Mapping Visiualizations
Anna Bananas, St Johns

Programming OS Web Spatio-temporal Mapping Visiualizations: Tues, Dec 30, 7:00pm, Anna Bananas St Johns, 8716 N. Lombard, Portland, Oregon (back room). This month we will work with OpenStreetMap Data. We will use JOSM to edit OSM data and learn to download OSM data for use in our web visualizations.

NOTE: we have a new time ... we will begin at 7pm and go to 9pm. If you are late, come anyway. We will be in the back room mapping away :)

Website
Thursday
Jan 15, 2015
PDXPUG: January meeting
Iovation

When: 6-8pm Thu Jan 15, 2015 Where: Iovation Who: Gabrielle Roth What: RDS Postgres

Amazon integrated Postgres into their general Relational Database Services (RDS) offerings July 1, 2014. RDS offers automatic failover, scalability, and easy configuration, plus Amazon handles all the patching and upgrades for you! Their SDK supports many languages and includes a robust CLI, if you want to automate management of your deployments. They also support several popular Postgres extensions.

Of course, since it’s a managed service, you can’t do everything you might expect or want to. In this talk, I’ll discuss the fun, the quirky, and the downright maddening features I’ve discovered working with production RDS deployments. Come find out what it’s like to use RDS Postgres day-to-day.

The building is on the Green & Yellow Max lines. Underground bike parking is available in the parking garage; outdoors all around the block in the usual spots.

We’ll go to Huber’s for after-meeting socializing.

See you there!

Website
Thursday
Feb 19, 2015
PDXPUG: February meeting
Iovation

When: 6-8pm Thu Feb 19, 2015
Where: Iovation
Who: David Kerr
What: Using Bucardo to Migrate your Pg database to RDS with minimal downtime

As a followup to January’s RDS discussion, Dave Kerr works through strategies to move your existing Postgres database into RDS.

Using Bucardo and Master/Master Replication we can achieve a migration to RDS with minimal or no downtime.

Dave will show some tools and techniques so help facilitate this transition as well as go over the idiosyncrasies of using Bucardo with RDS.

Website
Thursday
Mar 19, 2015
PDXPUG: March meeting
Iovation Website
Thursday
Apr 16, 2015
PDXPUG: April meeting
Iovation Website
Thursday
May 21, 2015
PDXPUG: May meeting
Iovation Website
Thursday
Jul 20
PostgreSQL 10 Beta
Iovation 111 SW 5th Ave suite 3200 (big pink)

PostgreSQL 10 is now out in beta. We called it 10 because this release is going to blow your socks off. Josh Berkus will demonstrate several of the new features in this version, including built-in logical replication, native partitioning, additional query parallelism, JSON full-text search, and more. He'll also explain some of the issues you're likely to encounter upgrading to Version X.

Josh Berkus recently retired from the PostgreSQL Core Team and is currently working for Redhat as the Project Atomic Community Lead.

— If you have a job posting or event you would like me to announce at the meeting, please send it along. The deadline for inclusion is 5pm the day before the meeting.

Website