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
130
Why on earth is git super awesome?
xoebus
4
240
Other Decks in Programming
See All in Programming
TypeScriptでライブラリとの依存を限定的にする方法
tutinoko
3
740
Jakarta EE meets AI
ivargrimstad
0
850
Realtime API 入門
riofujimon
0
150
Missing parts when designing and implementing Android UI
ericksli
0
250
flutterkaigi_2024.pdf
kyoheig3
0
210
イマのCSSでできる インタラクション最前線 + CSS最新情報
clockmaker
5
3.1k
cmp.Or に感動した
otakakot
3
280
どうして僕の作ったクラスが手続き型と言われなきゃいけないんですか
akikogoto
1
130
CSC509 Lecture 11
javiergs
PRO
0
180
Kaigi on Rails 2024 〜運営の裏側〜
krpk1900
1
270
Hotwire or React? ~アフタートーク・本編に含めなかった話~ / Hotwire or React? after talk
harunatsujita
1
120
WebフロントエンドにおけるGraphQL(あるいはバックエンドのAPI)との向き合い方 / #241106_plk_frontend
izumin5210
4
1.4k
Featured
See All Featured
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
250
21k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
soudai
169
50k
The Power of CSS Pseudo Elements
geoffreycrofte
73
5.3k
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
danielanewman
226
22k
Building a Scalable Design System with Sketch
lauravandoore
459
33k
Let's Do A Bunch of Simple Stuff to Make Websites Faster
chriscoyier
506
140k
Side Projects
sachag
452
42k
Site-Speed That Sticks
csswizardry
0
41
Dealing with People You Can't Stand - Big Design 2015
cassininazir
364
24k
個人開発の失敗を避けるイケてる考え方 / tips for indie hackers
panda_program
93
17k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
tammyeverts
47
2.1k
Principles of Awesome APIs and How to Build Them.
keavy
126
17k
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