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
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
280
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
iOSエンジニア向けの英語学習アプリを作る！
Avatar for yukawashouhei yukawashouhei
0
190
Server Side Kotlin Meetup vol.16: 内部動作を理解して ハイパフォーマンスなサーバサイド Kotlin アプリケーションを書こう
Avatar for ternbusty ternbusty
3
180
Flutterで分数(Fraction)を表示する方法
Avatar for kouki.miura koukimiura
0
130
Range on Rails ―「多重範囲型」という新たな選択肢が、複雑ロジックを劇的にシンプルにしたワケ
Avatar for RIZAPテクノロジーズ rizap_tech
0
120
CSC305 Lecture 04
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
0
270
アメ車でサンノゼを走ってきたよ！
Avatar for Shigure Shimotori s_shimotori
0
220
育てるアーキテクチャ：戦い抜くPythonマイクロサービスの設計と進化戦略
Avatar for fujidomoe fujidomoe
1
170
オープンソースソフトウェアへの解像度🔬
Avatar for うたもく utam0k
15
2.8k
組込みだけじゃない！TinyGo で始める無料クラウド開発入門
Avatar for Kotaro Otaka otakakot
0
240
TFLintカスタムプラグインで始める Terraformコード品質管理
Avatar for bells17 bells17
2
160
CSC509 Lecture 03
Avatar for Javier Gonzalez-Sanchez javiergs
PRO
0
330
CI_CD「健康診断」のススメ。現場でのボトルネック特定から、健康診断を通じた組織的な改善手法
Avatar for teamLab teamlab
PRO
0
210

Featured

See All Featured
Automating Front-end Workflow
Avatar for Addy Osmani addyosmani
1371
200k
StorybookのUI Testing Handbookを読んだ
Avatar for Shingo Yamazaki zakiyama
31
6.2k
Mobile First: as difficult as doing things right
Avatar for Swwweet swwweet
224
10k
Bootstrapping a Software Product
Avatar for Garrett Dimon garrettdimon
PRO
307
110k
Raft: Consensus for Rubyists
Avatar for Patrick Van Stee vanstee
139
7.1k
Making Projects Easy
Avatar for Brett Harned brettharned
119
6.4k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
Avatar for Michelle Schulp Hunt marktimemedia
31
2.5k
Unsuck your backbone
Avatar for Amy Palamountain ammeep
671
58k
Why You Should Never Use an ORM
Avatar for John Nunemaker jnunemaker
PRO
59
9.6k
The Pragmatic Product Professional
Avatar for Laura Van Doore lauravandoore
36
6.9k
Designing for Performance
Avatar for Lara Hogan lara
610
69k
No one is an island. Learnings from fostering a developers community.
Avatar for Antonio thoeni
21
3.5k

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