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

Connecting the Dots: Graph Databases and Laravel

21857d592f37798b624043522d0c2125?s=47 Keith Damiani
July 23, 2019
Programming
2
2.3k

Connecting the Dots: Graph Databases and Laravel

Presented at Laracon US 2019

21857d592f37798b624043522d0c2125?s=128

Keith Damiani

July 23, 2019
Tweet

Other Decks in Programming

See All in Programming
Gitlab CIでMRを自動生成する
1a2f29252240936c0ac4db4edab36d41?s=48 forcia_dev_pr
0
120
JSのウェブフレームワークで高速なルーターを実装する方法
6e34bfefc3edbe746ac7a71ca6635309?s=48 usualoma
1
1.9k
Value and Record Types
575ca492bac55e895d0e1c86f7d709fe?s=48 hschwentner
0
550
Cybozu GoogleI/O 2022 LT会 - Input for all screens
15bf72ac0417f0aab38b6f0ab084d605?s=48 jaewgwon
0
360
GoogleI/O2022 LT報告会資料
2bd3b8c3550384ab61d671b673c119bb?s=48 shinsukefujita1126
0
370
開発速度を5倍早くするVSCodeの拡張機能を作った
D7da604883d0056673358ed111aa9ec3?s=48 purp1eeeee
2
160
A Philosophy of Software Design 後半
D76231a2114896dfcc7b79ac69558b79?s=48 yosuke_furukawa
PRO
10
2.8k
実践エクストリームプログラミング / Extreme Programming in Practice
00cbada6669966805d91061d5a234d3b?s=48 enk
1
550
Get Ready for Jakarta EE 10
B489790e1a844284d7cd1fa2cd6e021f?s=48 ivargrimstad
0
830
「混ぜるな危険」を推進する設計
8ec2b967e38f000eb63ae345cd7c58e6?s=48 minodriven
7
2k
Meet Swift Regex
0b26590a0a8b0f1da140ed5de9b68379?s=48 usamik26
0
360
Node.jsデザインパターンを読んで
3d06fa4b3230d37a8d940405cc4abcc6?s=48 mmmommm
0
2.8k

Featured

See All Featured
"I'm Feeling Lucky" - Building Great Search Experiences for Today's Users (#IAC19)
3d4519fd34b76fb265fc0237f3792bd4?s=48 danielanewman
212
20k
Typedesign – Prime Four
A0517b08532aec8ab2aae3f65d40ad86?s=48 hannesfritz
34
1.4k
Support Driven Design
1519587b1a0febb658c36c94f6272b0d?s=48 roundedbygravity
86
8.5k
Java REST API Framework Comparison - PWX 2021
72a2082c6a4dd79ad68befb3db911616?s=48 mraible
PRO
11
4.7k
Design by the Numbers
027d1ebf66cc039a0bd3b55eeadbe75d?s=48 sachag
271
17k
KATA
E9221b172e78e888355fa2fe4541b595?s=48 mclloyd
7
8.7k
Bootstrapping a Software Product
A9179349dd2bdc67f377719f56d85656?s=48 garrettdimon
296
110k
ReactJS: Keep Simple. Everything can be a component!
Af6a12710770ad9a7cfd08c97efd40d3?s=48 pedronauck
655
120k
A Modern Web Designer's Workflow
8081b26e05bb4354f7d65ffc34cbbd67?s=48 chriscoyier
689
180k
Documentation Writing (for coders)
61857dafbd287b3027c4dcea9008ad3c?s=48 carmenhchung
48
2.6k
Keith and Marios Guide to Fast Websites
E14f55d3f939977cecbf51b64ff6f861?s=48 keithpitt
404
21k
What the flash - Photography Introduction
5ce91fa49a613cbc3e20d5f96856473f?s=48 edds
62
10k

Transcript

  1. Graph Databases and Laravel DOTS the CONNECTING LARACON US 2019

    KEITH DAMIANI

  2. Graph Databases and Laravel KEITH DAMIANI DOTS the CONNECTING LARACON

    US 2019
  3. None
  4. None
  5. None

  6. Graph Databases and Laravel KEITH DAMIANI DOTS the CONNECTING LARACON

    US 2019
  7. None

  8. KEITH DAMIANI PRINCIPAL PROGRAMMER !

  9. None
  10. None
  11. None
  12. None
  13. None
  14. None
  15. None
  16. None

  17. "

  18. What is a graph database? CONNECTING THE DOTS

  19. What is a graph database? CONNECTING THE DOTS

  20. What is a graph database? CONNECTING THE DOTS

  21. What is a graph database? CONNECTING THE DOTS

  22. What is a graph database? CONNECTING THE DOTS Graph DBs

    vs. relational DBs Use cases Writing queries Laravel graph DBs

  23. What is a graph database? CONNECTING THE DOTS

  24. What is a graph database? CONNECTING THE DOTS © JACK

    MCDADE

  25. © JACK MCDADE

  26. None
  27. None

  28. Nodes "VERTICES"

  29. Nodes "VERTICES" "EDGES" Relationships

  30. Nodes "VERTICES" "EDGES" Relationships

  31. Keith's Family Tree

  32. Keith's Family Tree Keith

  33. WAIT A MINUTE

  34. WAIT A MINUTE RELATIONAL DATABASES

  35. WAIT A MINUTE RELATIONAL DATABASES “ ”

  36. L 14th St./8th Ave. Union Square 6th Ave. Washington Square

    Houston St. 1st Ave. L L K B B K B B

  37. stations id name 1 14th St./8th Ave. 2 6th Ave.

    3 Union Square 4 1st Ave. 5 Washington Square 6 Houston St. lines id name 1 3 2 4 3 5 4 L 5 B 6 K line_station id station_id line_id connected_to 1 3 4 2 2 4 4 7 3 5 5 4 4 5 6 8 5 6 5 6 6 6 6 9

  38. stations id name 1 14th St./8th Ave. 2 6th Ave.

    3 Union Square 4 1st Ave. 5 Washington Square 6 Houston St. lines id name 1 3 2 4 3 5 4 L 5 B 6 K line_station id station_id line_id connected_to 1 3 4 2 2 4 4 7 3 5 5 4 4 5 6 8 5 6 5 6 6 6 6 9

  39. L 14th St./8th Ave. Union Square 6th Ave. Washington Square

    Houston St. 1st Ave. L L K B B K B B

  40. 1735 KALININGRAD

  41. KÖNIGSBERG

  42. © HISTORIC CITIES RESEARCH PROJECT / OZGUR TUFECKI

  43. © HISTORIC CITIES RESEARCH PROJECT / OZGUR TUFECKI

  44. © HISTORIC CITIES RESEARCH PROJECT / OZGUR TUFECKI No sweat,

    
 I got this.

  45. © HISTORIC CITIES RESEARCH PROJECT / OZGUR TUFECKI No sweat,

    
 I got this. e 2.718281828459045

  46. © HISTORIC CITIES RESEARCH PROJECT / OZGUR TUFECKI

  47. None
  48. None

  49. JOINS

  50. JOINS

  51. L 14th St./8th Ave. Union Square 6th Ave. Washington Square

    Houston St. 1st Ave. L L K B B K B B
  52. None

  53. What is a graph database? CONNECTING THE DOTS Graph DBs

    vs. relational DBs Use cases

  54. Highly-connected data THE NATURE OF YOUR DATA Hierarchical/tree-shaped

  55. FRIEND-OF-A-FRIEND QUERY Depth Relational DB Neo4j Graph DB Records 2

    0.02 0.01 2500 3 30 0.17 110,000 4 1,544 1.36 600,000 5 Unfinished 2.13 800,000 PERFORMANCE, IN SECONDS

  56. Highly-connected data THE NATURE OF YOUR DATA Hierarchical/tree-shaped Many-to-many and/or

    polymorphic Schema-less

  57. Social networks COMMON USE CASES Real-time product recommendations Social +

    Recommendation

  58. Social networks COMMON USE CASES Real-time product recommendations Would you

    like to 
 Join my Professional Network? Social + Recommendation

  59. Social networks COMMON USE CASES Real-time product recommendations Social +

    Recommendation Geospatial Geospatial + Recommendation

  60. Digital asset management COMMON USE CASES (MORE!) Textual analysis /

    search PageRank search Financial / fraud detection Public policy / journalism
  61. None

  62. Disconnected data BAD FITS Bulk data scans Aggregating across nodes

    When write speed is paramount BLOBs / large amounts of text
  63. None

  64. NEO4J.COM

  65. OrientDB Apache TinkerPop Amazon Neptune JanusGraph ArangoDB

  66. CYPHER

  67. CYPHER ( )-[ ]->( )

  68. CYPHER ( )-[ ]->( ) MATCH RETURN

  69. CYPHER MATCH (me:User {name: 'Me'})

  70. (DEMO TIME!)

  71. What is a graph database? CONNECTING THE DOTS Graph DBs

    vs. relational DBs Use cases Writing queries Laravel graph DBs

  72. NeoEloquent THREE OPTIONS FOR LARAVEL

  73. NeoEloquent THREE OPTIONS FOR LARAVEL

  74. NeoEloquent THREE OPTIONS FOR LARAVEL GraphAware neo4j-php-client

  75. NeoEloquent THREE OPTIONS FOR LARAVEL GraphAware neo4j-php-client

  76. NeoEloquent THREE OPTIONS FOR LARAVEL GraphAware neo4j-php-client ¯\_(ツ)_/¯

  77. Vapor Laravel

  78. Neo4Laravel

  79. Larapals.com

  80. ! @keithdamiani keithdamiani.com