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

Connecting the Dots: Graph Databases and Laravel

Avatar for Keith Damiani Keith Damiani
July 23, 2019
Programming
3.7k
2

Connecting the Dots: Graph Databases and Laravel

Presented at Laracon US 2019

Avatar for Keith Damiani

Keith Damiani

July 23, 2019

Other Decks in Programming

See All in Programming
in-process GraphQL のすすめ #ginzajs
Avatar for izumin5210 izumin5210
4
1.4k
変わらないものが、変わるものを決める — 意図駆動開発 × イベントソーシング × イミュータブル | What Doesn't Change Decides What Can — IDD × Event Sourcing × Immutability
Avatar for Tomohisa Takaoka tomohisa
0
1.8k
Japan Community Day at Kubecon + CloudNativeCon Japan 2026: Learning Container Privilege Control by Building My Own Low-Level Container Runtime
Avatar for ternbusty ternbusty
1
170
運用ダッシュボードの設計を誰も教えてくれないのだけど みなさんどうしてるんですか？ - チームに監視するという文化を根付かせるための第一歩を踏みたい -
Avatar for Satoshi Kaneyasu satoshi256kbyte
1
140
Flow は今どうなっているか
Avatar for mizdra mizdra
PRO
0
670
実装をデザインガイドラインに追従させるための取り組み / 260731-dip-mosh-design-system
Avatar for dachi dachi023
0
7k
MySQLとPostgreSQLって何が違うの？
Avatar for 赤神青空 akagami
0
120
自動化したのに回らない テスト運用の壁 ―AI時代の品質責任と生産性
Avatar for Masahiko Funaki(舟木 将彦) mfunaki
0
360
FDEが実現するAI駆動経営の現在地
Avatar for ryuta sakamoto gonta
2
290
S3 を使うアプリケーションをローカル完結で動かすことに全力を注いでみた / Running S3 Apps Offline
Avatar for Daisuke Garaike contour_gara
0
570
AI Engineeringは、AIプロダクトだけのものか？ 〜AIがソフトウェアを作る時代の新しい当たり前〜 / No AI in your product. AI Engineering in your development.
Avatar for r-kagaya rkaga
5
500
Built Our Own Background Agent at LayerX
Avatar for LayerX layerx
PRO
10
5.9k

Featured

See All Featured
Intergalactic Javascript Robots from Outer Space
Avatar for Vicent Martí tanoku
273
27k
Paper Plane
Avatar for Katie Cordina Lindsey katiecoart
PRO
2
53k
End of SEO as We Know It (SMX Advanced Version)
Avatar for Michael King ipullrank
3
4.4k
Six Lessons from altMBA
Avatar for Skipper Chong Warson skipperchong
29
4.5k
Technical Leadership for Architectural Decision Making
Avatar for Kenny Baas-Schwegler baasie
3
520
The Illustrated Children's Guide to Kubernetes
Avatar for Chris Short chrisshort
51
53k
Navigating the moral maze — ethical principles for Al-driven product design
Avatar for Skipper Chong Warson skipperchong
2
500
Build The Right Thing And Hit Your Dates
Avatar for Maggie C. maggiecrowley
39
3.4k
Information Architects: The Missing Link in Design Systems
Avatar for Michelle Chin soysaucechin
1
1.1k
Leadership Guide Workshop - DevTernity 2021
Avatar for David Neal reverentgeek
1
340
Build your cross-platform service in a week with App Engine
Avatar for Jose L jlugia
234
19k
DBのスキルで生き残る技術 - AI時代におけるテーブル設計の勘所
Avatar for soudai sone soudai
PRO
68
57k

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