Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

Connecting the Dots: Graph Databases and Laravel

Sponsored · Your Podcast. Everywhere. Effortlessly. Share. Educate. Inspire. Entertain. You do you. We'll handle the rest. →
Avatar for Keith Damiani Keith Damiani
July 23, 2019
Programming
3.8k
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
Verilogで学ぶCPU自作入門
Avatar for uyuki uyuki234
8
4.1k
AI時代のコードレビューは人に向けるな、仕組みに向けろ
Avatar for meijin texmeijin
5
3.6k
速く作れる。その次は、速く確かめられる開発へ 〜AIネイティブ開発を支える、Shift Down〜 / Can build fast. Next, moving to development where we can verify fast.
Avatar for r-kagaya rkaga
8
5.7k
ジョジョの世界をXRで再現する
Avatar for mofurune mofurune
0
150
【加筆修正版】Laravel のアプリケーションをどこにデプロイするか #phpcon_ehime
Avatar for akase244 akase244
0
150
GemmaをJevのように使ってみる / Use Gemma like Jev
Avatar for Naoki Kishida kishida
5
760
[ハンズオン]AIへの指示だけで「五目並べ」を作ってみよう
Avatar for Satoshi Kaneyasu satoshi256kbyte
1
370
AWS CDKのカスタムリソースでContinuum（旧Security Agent）を実装した話 | Implementing Continuum (formerly Security Agent) via AWS CDK Custom Resource
Avatar for アキキー | Akihisa Ikeda akihisaikeda
2
150
プロダクトコードからライブラリの境界を見つける
Avatar for elmetal elmetal
PRO
0
110
AWSに止められる覚悟してますか？
Avatar for モリゾー morizo_1984
2
530
AIに “答え“を書かせるのを やめてみた
Avatar for akari ___akari11
0
120
Java 27新機能 / Java 27 new features
Avatar for Naoki Kishida kishida
2
220

Featured

See All Featured
<Decoding/> the Language of Devs - We Love SEO 2024
Avatar for Nikki Halliwell nikkihalliwell
1
350
Producing Creativity
Avatar for Steve Smith orderedlist
PRO
348
41k
A Tale of Four Properties
Avatar for Chris Coyier chriscoyier
163
24k
What's in a price? How to price your products and services
Avatar for Michael Herold michaelherold
247
13k
Fantastic passwords and where to find them - at NoRuKo
Avatar for Phil Nash philnash
53
4k
How to optimise 3,500 product descriptions for ecommerce in one day using ChatGPT
Avatar for Katarina Dahlin katarinadahlin
PRO
3
3.9k
Into the Great Unknown - MozCon
Avatar for Noah Learner thekraken
41
2.8k
The browser strikes back
Avatar for Jono Alderson jonoalderson
0
1.8k
Noah Learner - AI + Me: how we built a GSC Bulk Export data pipeline
Avatar for Tech SEO Connect techseoconnect
PRO
0
450
The Art of Delivering Value - GDevCon NA Keynote
Avatar for David Neal reverentgeek
16
2.2k
How to Get Subject Matter Experts Bought In and Actively Contributing to SEO & PR Initiatives.
Avatar for Liv Day livdayseo
0
210
How to build a perfect <img>
Avatar for Jono Alderson jonoalderson
1
6.1k

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