Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Accessing Databases by using a Filesystem

Sponsored · SiteGround - Reliable hosting with speed, security, and support you can count on. →
Avatar for Christopher Brown Christopher Brown
December 10, 2011
Programming
130
2

Accessing Databases by using a Filesystem

Avatar for Christopher Brown

Christopher Brown

December 10, 2011

More Decks by Christopher Brown

See All by Christopher Brown
Crucible
Avatar for Christopher Brown xoebus
0
270
Concourse
Avatar for Christopher Brown xoebus
0
130
Final Project Presentation - Database Filesystem
Avatar for Christopher Brown xoebus
2
290
Database Visualisation
Avatar for Christopher Brown xoebus
2
140
Why on earth is git super awesome?
Avatar for Christopher Brown xoebus
4
260

Other Decks in Programming

See All in Programming
レビュー履歴をAIに食わせて、 Compose移行を加速するs
Avatar for Yuki Shiho shihochan
0
270
異なる設計思想のフレームワークを経験して得た学び
Avatar for amekuhideki amekuhideki
2
1.5k
数年滞っていたダークモード対応をおよそ2週間で完了させる
Avatar for Kazuki Chigita chigichan24
0
690
Intent as Code
Avatar for Shoppingjaws shoppingjaws
0
130
信頼性の目標を誰も求めてない
Avatar for Shuma shubox
0
490
標準パッケージに uuid が追加された 背景から見る Go らしい意思決定 / go_127_uuid_decision
Avatar for convto convto
4
2.8k
週末にAI-DLCを本気で回したら$1,600溶けた
Avatar for Atsushi Shimizu hbashimizu
0
130
AIに既存システムを理解させる技術　～レガシーを見捨てないハーネスエンジニアリング入門～
Avatar for Ochtum ochtum
0
210
書籍「プロフェッショナルAI駆動開発」紹介スライド
Avatar for Juntaro Matsumoto juntaromatsumoto
0
1.1k
AI時代に学ぶ 好きなルール 嫌いなルール Linter編
Avatar for Shota Nemoto shorty5121
0
880
Building an Out-of-Order CPU
Avatar for Latte72 latte72
1
720
AIを上手に使っていこうとしたら越境せざるを得なくなった話 〜実践1年で見えた境界を越えなければならない理由と進め方〜 / Crossing borders with AI
Avatar for TomoyaKitaura tomoyakitaura
4
1.1k

Featured

See All Featured
[Rails World 2023 - Day 1 Closing Keynote] - The Magic of Rails
Avatar for Eileen M. Uchitelle eileencodes
38
3k
How to train your dragon (web standard)
Avatar for Monica Dinculescu notwaldorf
97
6.8k
Producing Creativity
Avatar for Steve Smith orderedlist
PRO
348
41k
Practical Tips for Bootstrapping Information Extraction Pipelines
Avatar for Matthew Honnibal honnibal
25
2.1k
Lightning Talk: Beautiful Slides for Beginners
Avatar for Ines Montani inesmontani
PRO
2
680
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
Avatar for Dan Newman danielanewman
230
23k
XXLCSS - How to scale CSS and keep your sanity
Avatar for Zaharenia Atzitzikaki sugarenia
249
1.3M
Designing for Performance
Avatar for Lara Hogan lara
611
70k
Easily Structure & Communicate Ideas using Wireframe
Avatar for Afnizar Nur Ghifari afnizarnur
194
17k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
Avatar for Rebecca Miller-Webster rmw
35
3.8k
Breaking role norms: Why Content Design is so much more than writing copy - Taylor Woolridge
Avatar for UX Y'all uxyall
1
400
ラッコキーワード サービス紹介資料
Avatar for ラッコ株式会社 rakko
1
4.8M

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