Upgrade to PRO for Only $50/Year—Limited-Time Offer! 🔥

Accessing Databases by using a Filesystem

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
チームをチームにするEM
Avatar for hitode909 hitode909
0
330
大体よく分かるscala.collection.immutable.HashMap ~ Compressed Hash-Array Mapped Prefix-tree (CHAMP) ~
Avatar for matsu_chara matsu_chara
2
220
Cell-Based Architecture
Avatar for Luram Archanjo larchanjo
0
120
LLMで複雑な検索条件アセットから脱却する！！ 生成的検索インタフェースの設計論
Avatar for po3rin po3rin
3
730
FluorTracer / RayTracingCamp11
Avatar for kugi kugimasa
0
230
Integrating WordPress and Symfony
Avatar for Alexandre Salomé alexandresalome
0
150
ゲームの物理 剛体編
Avatar for Fadis fadis
0
350
Canon EOS R50 V と R5 Mark II 購入でみえてきた最近のデジイチ VR180 事情、そして VR180 静止画に活路を見出すまで
Avatar for kazuhiro hara karad
0
110
これだけで丸わかり！LangChain v1.0 アップデートまとめ
Avatar for os1ma os1ma
6
1.8k
tsgolintはいかにしてtypescript-goの非公開APIを呼び出しているのか
Avatar for syumai syumai
6
2.2k
愛される翻訳の秘訣
Avatar for Kishikawa Katsumi kishikawakatsumi
3
330
connect-python: convenient protobuf RPC for Python
Avatar for Anuraag Agrawal anuraaga
0
410

Featured

See All Featured
GraphQLの誤解/rethinking-graphql
Avatar for sonatard sonatard
73
11k
The Psychology of Web Performance [Beyond Tellerrand 2023]
Avatar for Tammy Everts tammyeverts
49
3.2k
Designing Dashboards & Data Visualisations in Web Apps
Avatar for Des Traynor destraynor
231
54k
RailsConf & Balkan Ruby 2019: The Past, Present, and Future of Rails at GitHub
Avatar for Eileen M. Uchitelle eileencodes
141
34k
Testing 201, or: Great Expectations
Avatar for Joseph Mastey jmmastey
46
7.8k
The Hidden Cost of Media on the Web [PixelPalooza 2025]
Avatar for Tammy Everts tammyeverts
1
100
Designing Experiences People Love
Avatar for Jonathan Moore moore
143
24k
Typedesign – Prime Four
Avatar for Hannes Fritz hannesfritz
42
2.9k
[RailsConf 2023 Opening Keynote] The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
31
9.8k
We Have a Design System, Now What?
Avatar for Morgane Peng morganepeng
54
7.9k
Dealing with People You Can't Stand - Big Design 2015
Avatar for Cassini Nazir cassininazir
367
27k
For a Future-Friendly Web
Avatar for Brad Frost brad_frost
180
10k

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