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

Accessing Databases by using a Filesystem

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for Christopher Brown Christopher Brown
December 10, 2011
Programming
2
120

Accessing Databases by using a Filesystem

Avatar for Christopher Brown

Christopher Brown

December 10, 2011
Tweet

More Decks by Christopher Brown

See All by Christopher Brown
Crucible
Avatar for Christopher Brown xoebus
0
260
Concourse
Avatar for Christopher Brown xoebus
0
130
Final Project Presentation - Database Filesystem
Avatar for Christopher Brown xoebus
2
290
Database Visualisation
Avatar for Christopher Brown xoebus
2
130
Why on earth is git super awesome?
Avatar for Christopher Brown xoebus
4
250

Other Decks in Programming

See All in Programming
登壇資料を作る時に意識していること #登壇資料_findy
Avatar for konifar konifar
4
1.1k
高速開発のためのコード整理術
Avatar for sutetotanuki sutetotanuki
1
400
CSC307 Lecture 04
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
0
660
CSC307 Lecture 01
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
0
690
Vibe Coding - AI 驅動的軟體開發
Avatar for Micky Li mickyp100
0
170
AI巻き込み型コードレビューのススメ
Avatar for Nealle nealle
1
180
AIフル活用時代だからこそ学んでおきたい働き方の心得
Avatar for shinoyu shinoyu
0
130
【卒業研究】会話ログ分析によるユーザーごとの関心に応じた話題提案手法
Avatar for MomokoShirakawa momok47
0
200
CSC307 Lecture 09
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
1
830
開発者から情シスまで - 多様なユーザー層に届けるAPI提供戦略 / Postman API Night Okinawa 2026 Winter
Avatar for tasshi tasshi
0
200
Patterns of Patterns
Avatar for Denys Poltorak denyspoltorak
0
1.4k
AI前提で考えるiOSアプリのモダナイズ設計
Avatar for 野瀬田　裕樹 yuukiw00w
0
230

Featured

See All Featured
Statistics for Hackers
Avatar for Jake VanderPlas jakevdp
799
230k
The Organizational Zoo: Understanding Human Behavior Agility Through Metaphoric Constructive Conversations (based on the works of Arthur Shelley, Ph.D)
Avatar for Dr. Kim W Petersen kimpetersen
PRO
0
240
The Anti-SEO Checklist Checklist. Pubcon Cyber Week
Avatar for Ryan Jones ryanjones
0
56
What does AI have to do with Human Rights?
Avatar for Per Axbom axbom
PRO
0
2k
Odyssey Design
Avatar for Ryan Kendrick rkendrick25
PRO
1
490
Helping Users Find Their Own Way: Creating Modern Search Experiences
Avatar for Dan Newman danielanewman
31
3.1k
[SF Ruby Conf 2025] Rails X
Avatar for Vladimir Dementyev palkan
1
750
Lightning Talk: Beautiful Slides for Beginners
Avatar for Ines Montani inesmontani
PRO
1
440
Speed Design
Avatar for Sergey Chernyshev sergeychernyshev
33
1.5k
Embracing the Ebb and Flow
Avatar for Simon Collison colly
88
5k
BBQ
Avatar for Matthew Crist matthewcrist
89
10k
Java REST API Framework Comparison - PWX 2021
Avatar for Matt Raible mraible
34
9.1k

Transcript

  1. Chris Brown Databases Accessing Filesystem by using a

  2. Recap

  3. Database Filesystem

  4. Files & Folders

  5. Excel

  6. Progress

  7. Reading from a Database

  8. Reading from a Database ✓

  9. Writing to a Database

  10. Writing to a Database ✓

  11. Querying the Database

  12. Querying the Database ?

  13. Problems

  14. How can we query the database?

  15. None
  16. None

  17. SQL

  18. SQL

  19. SQL Complicated

  20. SQL Complicated Different Dialects

  21. SQL Complicated Different Dialects Not-user Friendly

  22. Relational Algebra

  23. SQL + Pig Latin

  24. SQueaL

  25. Relational Algebra → SQL

  26. 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])

  27. SELECT "users"."mark" FROM "users" INNER JOIN "grades" ON "users"."id" =

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

  28. Easily Sequential-able

  29. Demo

  30. Next Steps

  31. Start Writing Report

  32. Finish next stage of programming

  33. Questions? http://github.com/xoebus/fuseql http://github.com/xoebus/squeal http://github.com/xoebus/bacon