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!

Topic: Extreme Database Makeover: RT
Speakers: Jeff Davis, Mark Wong, David Wheeler
When: Tuesday, February 26, 2008, 6:30pm
Where: Cubespace, 622 SE Grand Avenue, Portland, OR 97214

(In association with Code-n-Splode http://pdx.codensplode.org/)

Come join us for a little fun with RT. Jeff Davis recently went through an implementation of RT and had a few suggestions for their database schema. David Wheeler and Mark Wong promised to come help "refactor".

There is a .dot representation of their schema out on the web, and I figured I/we could print this out, and maybe bring in a few sheets of paper to document our changes.

If anyone has a printer and a few moments to volunteer, I'd appreciate help with the printing.

At the end of the meeting, we'd like to pass on some of our suggestions to the good folks at Best Practical.

Afterward, we'll seek refreshments at the Side Door Pub!