Next Meeting: March 20, 2008 - Managing internet services: using the right tool for the job

selenamarie's picture

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!

Back to top