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
開発生産性を上げるための生成AI活用術
starfish719
1
130
iOSDC.pdf
chronos2500
2
650
iOSエンジニア向けの英語学習アプリを作る!
yukawashouhei
0
170
Web技術を最大限活用してRAW画像を現像する / Developing RAW Images on the Web
ssssota
2
1.1k
Model Pollution
hschwentner
1
180
CSC305 Lecture 04
javiergs
PRO
0
230
開発者への寄付をアプリ内課金として実装する時の気の使いどころ
ski
0
340
defer f()とdefer fの挙動を 誤解していた話
kogamochiduki
2
160
iOSエンジニア向けの英語学習アプリを作る!
yukawashouhei
0
150
エンジニアとして高みを目指す、 利益を生み出す設計の考え方 / design-for-profit
minodriven
23
11k
ソフトウェア設計の実践的な考え方
masuda220
PRO
2
220
Чего вы не знали о строках в Python – Василий Рябов, PythoNN
sobolevn
0
150
Featured
See All Featured
Code Reviewing Like a Champion
maltzj
525
40k
Side Projects
sachag
455
43k
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
marcduiker
32
2.2k
Bash Introduction
62gerente
615
210k
Unsuck your backbone
ammeep
671
58k
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
eileencodes
36
2.5k
What's in a price? How to price your products and services
michaelherold
246
12k
Building Flexible Design Systems
yeseniaperezcruz
329
39k
Product Roadmaps are Hard
iamctodd
PRO
54
11k
Agile that works and the tools we love
rasmusluckow
331
21k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
34
6.1k
Writing Fast Ruby
sferik
629
62k
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