Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Accessing Databases by using a Filesystem
Search
Christopher Brown
December 10, 2011
Programming
2
120
Accessing Databases by using a Filesystem
Christopher Brown
December 10, 2011
Tweet
Share
More Decks by Christopher Brown
See All by Christopher Brown
Crucible
xoebus
0
260
Concourse
xoebus
0
130
Final Project Presentation - Database Filesystem
xoebus
2
280
Database Visualisation
xoebus
2
130
Why on earth is git super awesome?
xoebus
4
250
Other Decks in Programming
See All in Programming
iOSエンジニア向けの英語学習アプリを作る!
yukawashouhei
0
190
Server Side Kotlin Meetup vol.16: 内部動作を理解して ハイパフォーマンスなサーバサイド Kotlin アプリケーションを書こう
ternbusty
3
180
Flutterで分数(Fraction)を表示する方法
koukimiura
0
130
Range on Rails ―「多重範囲型」という新たな選択肢が、複雑ロジックを劇的にシンプルにしたワケ
rizap_tech
0
120
CSC305 Lecture 04
javiergs
PRO
0
270
アメ車でサンノゼを走ってきたよ!
s_shimotori
0
220
育てるアーキテクチャ:戦い抜くPythonマイクロサービスの設計と進化戦略
fujidomoe
1
170
オープンソースソフトウェアへの解像度🔬
utam0k
15
2.8k
組込みだけじゃない!TinyGo で始める無料クラウド開発入門
otakakot
0
240
TFLintカスタムプラグインで始める Terraformコード品質管理
bells17
2
160
CSC509 Lecture 03
javiergs
PRO
0
330
CI_CD「健康診断」のススメ。現場でのボトルネック特定から、健康診断を通じた組織的な改善手法
teamlab
PRO
0
210
Featured
See All Featured
Automating Front-end Workflow
addyosmani
1371
200k
StorybookのUI Testing Handbookを読んだ
zakiyama
31
6.2k
Mobile First: as difficult as doing things right
swwweet
224
10k
Bootstrapping a Software Product
garrettdimon
PRO
307
110k
Raft: Consensus for Rubyists
vanstee
139
7.1k
Making Projects Easy
brettharned
119
6.4k
Templates, Plugins, & Blocks: Oh My! Creating the theme that thinks of everything
marktimemedia
31
2.5k
Unsuck your backbone
ammeep
671
58k
Why You Should Never Use an ORM
jnunemaker
PRO
59
9.6k
The Pragmatic Product Professional
lauravandoore
36
6.9k
Designing for Performance
lara
610
69k
No one is an island. Learnings from fostering a developers community.
thoeni
21
3.5k
Transcript
Chris Brown Databases Accessing Filesystem by using a
Recap
Database Filesystem
Files & Folders
Excel
Progress
Reading from a Database
Reading from a Database ✓
Writing to a Database
Writing to a Database ✓
Querying the Database
Querying the Database ?
Problems
How can we query the database?
None
None
SQL
SQL
SQL Complicated
SQL Complicated Different Dialects
SQL Complicated Different Dialects Not-user Friendly
Relational Algebra
SQL + Pig Latin
SQueaL
Relational Algebra → SQL
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])
SELECT "users"."mark" FROM "users" INNER JOIN "grades" ON "users"."id" =
"grades"."user_id" WHERE "users"."name" = 'Chris Brown' LIMIT 1
Easily Sequential-able
Demo
Next Steps
Start Writing Report
Finish next stage of programming
Questions? http://github.com/xoebus/fuseql http://github.com/xoebus/squeal http://github.com/xoebus/bacon