Code like song
I
lluminated Computing
sql
Temporal Ops (2024)
Another reason to use generate_series for time series queries (2015)
Lateral Join Alternatives (2015)
Too Many Outer Joins (2015)
Postgres LATERAL JOIN (2015)
Rails acts_as_list with Soft Delete (2014)
Postgres CTE for Threaded Comments (2014)
Rules for Rails Migrations (2013)
Fun Postgres Puzzle (2013)
Histograms in Postgres with Window Functions (2012)
db_leftovers gets CHECK constraints (2012)
Postgres string_agg Function (2012)
Paul A. Jungwirth
Blog
Email
Portfolio
Resume
Github
Stack Overflow
Code
Postgres temporal keys
Postgres range_agg
Postgres aggs_for_arrays
Multiclock (Rust)
Tech Notes
. . . more
Writing
Benchmarking Temporal Foreign Keys
Benchbase Documentation
PDXPUG Talk: Benchbase and Temporal Foreign Keys
Temporal Ops
. . . Archive
. . . Tags
Talks
Papers We Love: Temporal Alignment
Benchbase for Postgres Temporal Foreign Keys
Hacking Postgres: the Exec Phase
Progress Adding SQL:2011 Valid Time to Postgres
Temporal Databases: Theory and Postgres
A Rails Timezone Strategy
Rails and SQL
Async Programming in iOS
Errors in Node.js
Wharton Web Intro
PennApps jQuery Intro