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

Accessing Databases by using a Filesystem

Avatar for Christopher Brown Christopher Brown
December 10, 2011
Programming
130
2

Accessing Databases by using a Filesystem

Avatar for Christopher Brown

Christopher Brown

December 10, 2011

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
ハーネスエンジニアリングとは？
Avatar for kinopee kinopeee
13
7k
Kingdom of the Machine
Avatar for yui-knk yui_knk
2
1.5k
My daily life on Ruby
Avatar for Akira Matsuda a_matsuda
3
370
AI時代のエンジニアリングの原則 / Engineering Principles in the AI ​​Era
Avatar for haru860 haru860
0
1.2k
ついに来た！本格的なマルチクラウド時代の Google Cloud
Avatar for maroon1st maroon1st
0
430
Spec-Driven Development with AI Agents (Workshop, May 2026)
Avatar for Anton Arhipov antonarhipov
3
350
WebAssembly を読み込むベストプラクティス 2026年春版 / Best Practices for Loading WebAssembly (Spring 2026)
Avatar for petamoriken / 森建 petamoriken
5
1.1k
書籍「ユーザーストーリーマッピング」が私のバイブル
Avatar for asumikam asumikam
4
490
PHPでバイナリをパースして理解するASN.1
Avatar for muno92 muno92
PRO
0
460
SREに優しいTerraform構成 modulesとstateの組み方
Avatar for hiyanger hiyanger
2
170
UaaL×Androidアプリのメモリ計測 — Memory Profilerの先へ
Avatar for Ryosuke Shimizu (RIO) rio432
0
160
Lightning-Fast Method Calls with Ruby 4.1 ZJIT / RubyKaigi 2026
Avatar for Takashi Kokubun k0kubun
3
3k

Featured

See All Featured
SEO Brein meetup: CTRL+C is not how to scale international SEO
Avatar for Linda Hogenes lindahogenes
1
2.6k
Leveraging LLMs for student feedback in introductory data science courses - posit::conf(2025)
Avatar for Mine Cetinkaya-Rundel minecr
1
250
Docker and Python
Avatar for Tania Allard trallard
47
3.8k
4 Signs Your Business is Dying
Avatar for Josh Pigford shpigford
187
22k
A brief & incomplete history of 
UX Design for the World Wide Web: 1989–2019
Avatar for Jason CranfordTeague jct
2
370
The Cost Of JavaScript in 2023
Avatar for Addy Osmani addyosmani
55
9.9k
The World Runs on Bad Software
Avatar for Brandon Keepers bkeepers
PRO
72
12k
The agentic SEO stack - context over prompts
Avatar for schlessera schlessera
0
780
Evolving SEO for Evolving Search Engines
Avatar for Ryan Jones ryanjones
0
190
CSS Pre-Processors: Stylus, Less & Sass
Avatar for Bermon Painter bermonpainter
360
30k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
35
2.4k
How to Think Like a Performance Engineer
Avatar for Harry Roberts csswizardry
28
2.6k

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