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
What Not To Do With Databases
Search
Tim Perry
November 11, 2014
Programming
0
27k
What Not To Do With Databases
Tim Perry
November 11, 2014
Tweet
Share
More Decks by Tim Perry
See All by Tim Perry
IoT Hackathon
pimterry
0
340
Build Your Own TTN Gateway with Resin.io and RAK Wireless
pimterry
0
25k
The Cambrian Explosion of IoT
pimterry
0
24k
Modern Easy IoT with Docker & Resin.io
pimterry
1
380
Provision, Manage & Monitor Gateways in Production with Resin.io
pimterry
0
23k
Optimizing Docker for IoT with Multi-Stage Builds
pimterry
0
29k
Hardware Hacking for JS Developers
pimterry
1
25k
HTTPS is Not Enough
pimterry
0
26k
Promises Are So Passé
pimterry
0
26k
Other Decks in Programming
See All in Programming
「手軽で便利」に潜む罠。 Popover API を WCAG 2.2の視点で安全に使うには
taitotnk
0
870
パッケージ設計の黒魔術/Kyoto.go#63
lufia
3
440
より安全で効率的な Go コードへ: Protocol Buffers Opaque API の導入
shwatanap
2
770
「待たせ上手」なスケルトンスクリーン、 そのUXの裏側
teamlab
PRO
0
570
奥深くて厄介な「改行」と仲良くなる20分
oguemon
1
570
さようなら Date。 ようこそTemporal! 3年間先行利用して得られた知見の共有
8beeeaaat
3
1.5k
Processing Gem ベースの、2D レトロゲームエンジンの開発
tokujiros
2
130
AI時代のUIはどこへ行く?
yusukebe
18
9.1k
Navigating Dependency Injection with Metro
zacsweers
3
3.5k
複雑なフォームに立ち向かう Next.js の技術選定
macchiitaka
2
240
テストカバレッジ100%を10年続けて得られた学びと品質
mottyzzz
2
610
Ruby Parser progress report 2025
yui_knk
1
460
Featured
See All Featured
Evolution of real-time – Irina Nazarova, EuRuKo, 2024
irinanazarova
8
930
How To Stay Up To Date on Web Technology
chriscoyier
790
250k
Rails Girls Zürich Keynote
gr2m
95
14k
Reflections from 52 weeks, 52 projects
jeffersonlam
352
21k
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
61k
A Tale of Four Properties
chriscoyier
160
23k
A designer walks into a library…
pauljervisheath
207
24k
The Invisible Side of Design
smashingmag
301
51k
How GitHub (no longer) Works
holman
315
140k
Raft: Consensus for Rubyists
vanstee
140
7.1k
Optimizing for Happiness
mojombo
379
70k
Imperfection Machines: The Place of Print at Facebook
scottboms
268
13k
Transcript
None
None
None
None
None
None
None
None
CREATE TABLE Employee ( id int primary key, name varchar(255)
not null, manager_id int );
SELECT m.name FROM Employee e INNER JOIN Employee m ON
e.manager_id = m.id WHERE e.id = 100;
WITH RecursiveCte AS ( SELECT e.id, e.name FROM Employee e
WHERE parent_id = 100 UNION ALL SELECT e.id, e.name FROM Employee e INNER JOIN RecursiveCte rcte ON e.parent_id = rcte.id ) SELECT Name FROM RecursiveCte;
None
MATCH (e { id: 100 })-[:MANAGED_BY]->(m) RETURN m.name;
MATCH (m { id: 100 })<-[:MANAGED_BY*]-(e) RETURN e.name;
MATCH (m { id: 100 })<-[:MANAGED_BY*]-(e) RETURN e.name;
None
None
None
None
None
None
None
None
None
None
None
None
None