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
110
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
250
Concourse
xoebus
0
120
Final Project Presentation - Database Filesystem
xoebus
2
270
Database Visualisation
xoebus
2
120
Why on earth is git super awesome?
xoebus
4
240
Other Decks in Programming
See All in Programming
CSC509 Lecture 08
javiergs
PRO
0
110
Jakarta Concurrencyによる並行処理プログラミングの始め方 (JJUG CCC 2024 Fall)
tnagao7
1
250
レガシーシステムにどう立ち向かうか 複雑さと理想と現実/vs-legacy
suzukihoge
7
1.1k
Java ジェネリクス入門 2024
nagise
0
640
プロジェクト新規参入者のリードタイム短縮の観点から見る、品質の高いコードとアーキテクチャを保つメリット
d_endo
1
1k
ECSのサービス間通信 4つの方法を比較する 〜Canary,Blue/Greenも添えて〜
tkikuc
11
2.3k
ピラミッド、アイスクリームコーン、SMURF: 自動テストの最適バランスを求めて / Pyramid Ice-Cream-Cone and SMURF
twada
PRO
10
1.1k
Honoの来た道とこれから
yusukebe
19
3.1k
gopls を改造したら開発生産性が高まった
satorunooshie
8
260
Piniaの現状と今後
waka292
5
1.5k
go.mod、DockerfileやCI設定に分散しがちなGoのバージョンをまとめて管理する / Go Connect #3
arthur1
10
2.4k
qmuntal/stateless のススメ
sgash708
0
120
Featured
See All Featured
How to train your dragon (web standard)
notwaldorf
88
5.7k
How GitHub (no longer) Works
holman
311
140k
Documentation Writing (for coders)
carmenintech
65
4.4k
Optimizing for Happiness
mojombo
376
69k
The Power of CSS Pseudo Elements
geoffreycrofte
72
5.3k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
226
22k
A Modern Web Designer's Workflow
chriscoyier
693
190k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
505
140k
Designing for Performance
lara
604
68k
GitHub's CSS Performance
jonrohan
1030
460k
Fantastic passwords and where to find them - at NoRuKo
philnash
50
2.8k
How To Stay Up To Date on Web Technology
chriscoyier
788
250k
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