Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Accessing Databases by using a Filesystem

Accessing Databases by using a Filesystem

Christopher Brown

December 10, 2011
Tweet

More Decks by Christopher Brown

Other Decks in Programming

Transcript

  1. SQL

  2. SQL

  3. users = Table :users grades = Table :grades predicate =

    users[:name].eq("Chris Brown") user_grades = join(users, grades, :id, :user_id) user_where = where(user_grades, predicate) user_window = limit(user_where, 1) Output select(user_window, users[:mark])
  4. SELECT "users"."mark" FROM "users" INNER JOIN "grades" ON "users"."id" =

    "grades"."user_id" WHERE "users"."name" = 'Chris Brown' LIMIT 1