PDXPUG: August meeting in two days

When: 6-8pm Thursday August 18, 2106
Where: iovation
Who: Brian Panulla, Marty Zajac, Gabrielle Roth
What: ETL Throwdown (or up)

For August, we’re having a panel discussion on various ETL tools we’ve tried.
Brian: moving from bulk ETL to near real time ETL with Tungsten Replicator to replicate from MySQL to PostgreSQL and Solr
Marty: Pentaho
Gabrielle: CloverETL, home-grown solution using postgres_fdw, and a brief rant about Informatica if we have time.


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.

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!

iovation provides us a light dinner (usually sandwiches or pizza).

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

See you there!

PDXPUG: January Lab Next Week: postgres_fdw

When: Thu Jan 29, 6pm-8pm
Where: Renewable Funding, 400 SW 6th Ave

We’ll go over Foreign Data Wrappers, focusing on the Postgres FDW.

Our labs are casual, attendee-led affairs with no agenda set in advance. The goal is to share what we know & learn together.

Show up with a couple of Pg databases – they can be on the same cluster or different ones, doesn’t really matter. One of them should have at least one table with data in it.

We do need to know who’s coming so we can notify building security, so please sign up in advance here.

Grab dinner at the carts & come on over!

PDXPUG: October Meeting

When: 7-9pm Thu Oct 17, 2013
Where: Iovation
Who: Garlynn Woodsong
What: Urban Footprint

Garlynn Woodsong is a Project Manager in the regional and large-scale master planning team at Calthorpe Associates. He is a geographer and urban planner with more than 13 years of experience in transportation, land use, and regional and corridor planning and policy. His work and experience ranges from transit-oriented development, bicycle transportation planning, regional transportation policy and funding, to the use of GIS technology to support smart growth and regional planning efforts.

Garlynn’s going to expand on his lightning talk from earlier this year and give us a more in-depth look at UrbanFootprint, an open-source geospatial urban & regional scenario planning tool/ecosystem powered by PostgreSQL.

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!

Building security will close access to the floor at 7:30.

After-meeting beer location TBD. See you there!

PDXPUG: September meeting in two weeks – JSON

When: 7-9pm Thu Sep 19, 2013
Where: Iovation
Who: Andrew Kreps
What: JSON

This month we return to our regular meeting location at Iovation. Andrew Kreps will be giving a JSON demo.

Topics:
– A brief definition of JSON for those who may not have a lot of experience with it
– Why the storage of JSON as JSON is important
– Working with the operators, selecting data, etc
– A practical example, probably using the Instagram API.

Andrew’s a Portland-based software engineer who digests APIs for breakfast. After stumbling through the worlds of Oracle and Mysql for many years, he’s found PostgreSQL to do things they way they should have always been done.

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!

Building security will close access to the floor at 7:30.

PDXPUG July Meeting 7/15/2010: Decagon Devices

Brian Kurle will be speaking at the next PDXPUG meeting at FreeGeek
(7:00pm – 1731 SE 10th Avenue, Portland, OR).

—–

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.

Next Meeting: March 20, 2008

TOPIC: Managing internet services: using the right tool for the job
SPEAKER: Ed Sawicki
WHEN: March 20, 2008, 7pm
WHERE: FreeGeek, 1731 SE 10th Ave, Portland, OR 97214

Also: What the heck is the United States PostgreSQL Association?, Selena Deckelmann

AND: ELEPHANT BUTTONS! courtesy of David Fetter.

Here’s what Ed had to say about his presentation:

“I’ll probably end up doing live benchmarks, showing code snippets, and explaining my rationale for why I chose
to do things the way I do.

“My current projects involve managing a variety of Internet services, such as spam suppression and the associated per-user black/white list management, DNS record management, PKI key management, and a variety of others. Some of these services require that I deal with the storage and retrieval of both discrete IP addresses and CIDR blocks in real time.

“I’ve had to decide on data stores that include plain text files, SQL using SQLite and Postgres, and constant databases using tinycdb. At every stage of development I’ve had to decide which of these was best based on tools available and performance testing. For example, Postgres has IP and CIDR data types and adequate facilities to search for IP addresses within a CIDR block but performance pales in comparison to simpler tools that use plain text files. As a result, my applications use various data stores instead of just one.””

Refreshment afterward at the Lucky Lab!