Re: Seattle PostgreSQL Day

The intro one sounds very useful.

My business partner Noah Glusenkamp and/or I can probably talk about PostGIS and/or the Postgres geocoder.

Julie
--
Julie Goldberg
Principal
Empower Engine

(206) 632-7647
julie(at)empowerengine(dot)com

On Oct 30, 2013, at 7:32 AM, Basil Bourque <basil(dot)bourque(dot)lists(at)pobox(dot)com> wrote:

>
> On Oct 23, 2013, at 08:52, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
>> Are there any others that would be willing to give a talk?
>
> I would be happy to do any or all of the following talks.
>
>
> ----| Intro to Postgres |----------------
>
> [I'll be using Mac OS X.]
> • Quick orientation to what is Postgres and what makes it different
> • How to obtain and install
> • Structured for security (new Unix user 'postgres' with password)
> • Date files stored separately in area owned by 'postgres' user
> • pgAdmin
> - Basic features
> - Show default database
> - Create new database
> - Create tables and columns
> - Primary key
> - Create a few records
> - Query
> - Update rows
> - Foreign Key & Join
> - Other GUI tools available, but pgAdmin is good enough to get started with Postgres.
> • psql command line tool (very quick, to create awareness but not really show anything useful)
> • pgdump for backups (very quick)
> • Documentation (very quick)
>
>
> ----| UUID, Universal Unique Identifier |----------------
>
> • What are they (128-bit value, not text, but shown as hex string)
> • Explain just how huge a range of numbers 128-bits provides.
> • A standard (ISO and IETF)
> • Commonly used for variety of purposes (show use in email message, iPhone app id, etc.)
> • Pros and cons of using as a Primary Key rather than a serial number or a natural key
> • Types (date+time+MAC, random, and so on)
> • Generate a UUID by command line ('uuidgen')
> • Native type in Postgres
> • Explain what extensions are in Postgres (plugins)
> • Install UUID extension
> • Generate UUID with SELECT statement
> • Use UUID as Primary Key
> • Create a table and rows, show UUID in action.
> • Explain bridging to Java & JDBC via "setObject" & "getObject". Show quick Java code demo if time allows.
>
> ----| Build a Database-backed Web App with Vaadin + Postgres |-----------------------
> • Purpose: Actually build a working web app backed by a database, all during the demo.
> • Quick demo and overview of Vaadin:
> - Produce business-class desktop-style apps. Almost makes you forget you're using a web app.
> - *Not* yet-another-web-app-framework
> - Server-side app engine
> - Pure Java (on the server, but no Java or Applet on the client)
> - No templating
> - No HTML, no CSS, no JavaScript, no DOM, no AJAX. (Vaadin handles all that automagically, not you & me)
> • JDBC for connecting to Postgres
> - Write some SQL to be executed by JDBC.
> • Old "Table" widget in Vaadin
> - Demo by showing data contained in Postgres
> • New "Grid" widget
> - Demo by showing data contained in Postgres
> • Detail form
> - Display and update row in Postgres
>
>
> ----| Show and Tell: App for Tracking Medical Encyclopedia Articles |-----------------------
>
> • Explain simple business problem:
> - Tracking a couple thousand encyclopedia articles of Traditional Chinese Medicine being published in an iOS app.
> - Each article has assigned phrases (symptoms, diagnoses, and such) used for lookups.
> • Explain table structure
> - Show table structure diagram
> - Basically a Many-to-Many of "Article" to "Phrase" with a bridge table between them, "Assignment".
> - Phrases have simple child table, "Variations" of wording.
> - Launch pgAdmin (and quick orientation)
> - Show some SQL joins in pgAdmin of parent-child using "Phrase" and "Variation" tables.
> - Show more complicated Many-to-Many joins of "Article" ↔ "Variation" ↔ "Phrase".
> • Show finished Vaadin app
> - Create and edit records
> - Drag-and-drop to assign phrases to articles.
>
>
> --Basil Bourque
>
>
>
>
> --
> Sent via seapug mailing list (seapug(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/seapug