~/talk

How Akiban Implemented a New Database Compatible with the PostgreSQL Protocol

Talkat Postgres Open 2012 · 2012-09-17..09-19· [databases]
links:none on file
slides:none on file

Akiban Server is built from scratch and exposes SQL plus a REST API and chooses the PostgreSQL wire protocol so existing drivers work. Implementation is a Java network server that parses messages, maps Postgres types, and returns either row sets or nested JSON/protobuf result sets conveyed as blobs over the protocol. Engineering used Wireshark to debug, stress tests hit tens of thousands of concurrent threads, Intel hosts with 1TB RAM machines hold several terabytes of data, and the kernel is being open sourced and does scale.

AI-written summary · about

  1. 0:00Start
  2. 3:33Table Grouping
  3. 20:53The Array Data Type
  4. 31:26Data Independence
  5. 36:46Wireshark
  6. 37:48How Do You Return an Object from a Relational Database
  7. 42:51Use Case
  8. 48:15Table Groups
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.