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

FileMaker DevCon CWP Group

FileMaker DevCon CWP Group

As has happened each year for the last 13 years Joel Shapiro of JS FMP hosted a Custom Web Publishing User Group at FileMaker DevCon.

A number of us presented various things we’ve been working on over the past year.

At last year’s session I’d talked about “Steve’s top ten things to make you a better developer”. This year I focused only on one of those – data abstraction.

Steve Winter

August 05, 2019
Tweet

More Decks by Steve Winter

Other Decks in Technology

Transcript

  1. © 2019 FileMaker, Inc.
    FILEMAKER DEVCON 2019

    AUGUST 5-8 | ORLANDO, FL
    Database Abstraction
    CWP04
    Steve Winter
    Matatiro Solutions

    @steveWinterNZ

    View Slide

  2. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    - One of those people the CBP don’t like

    - FileMaker, web application and software developer >20 years!

    - Run Matatiro Solutions

    - Regular DevCon speaker
    Who am I?
    Steve Winter

    View Slide

  3. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Who am I?
    Steve Winter

    View Slide

  4. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Who am I?
    Steve Winter

    View Slide

  5. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Who am I?
    Steve Winter

    View Slide

  6. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Who am I?
    Steve Winter

    View Slide

  7. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Last year

    View Slide

  8. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    This year
    Disclaimer: it wasn’t a tweet it was an email, but this looks better!

    View Slide

  9. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Sorry Joel
    SALES PITCH!

    View Slide

  10. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    In my defence, I’m ‘selling’:
    • An idea
    • Free open source software (FOSS)

    View Slide

  11. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Database
    So what’s this big idea?
    Browser Internet Web Server
    Code

    View Slide

  12. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Database
    So what’s this big idea?
    Browser Internet Web Server
    Controller

    View Slide

  13. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Database
    So what’s this big idea?
    Browser Internet Web Server
    Controller

    View Slide

  14. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Database
    So what’s this big idea?
    Browser Internet Web Server
    Controller
    Model

    View Slide

  15. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Database
    So what’s this big idea?
    Browser Internet Web Server
    Controller
    Model
    Driver

    View Slide

  16. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Database
    So what’s this big idea?
    Browser Internet Web Server
    Controller
    Model
    Driver

    View Slide

  17. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Database
    So what’s this big idea?
    Browser Internet Web Server
    Controller
    Model
    Driver

    View Slide

  18. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Database
    So what’s this big idea?
    Browser Internet Web Server
    Controller
    Model
    Other
    Driver

    View Slide

  19. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Database
    So what’s this big idea?
    Browser Internet Web Server
    Controller
    Model
    XML

    View Slide

  20. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Database
    So what’s this big idea?
    Browser Internet Web Server
    Controller
    Model
    PHP

    View Slide

  21. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Database
    So what’s this big idea?
    Browser Internet Web Server
    Controller
    Model
    Data API

    View Slide

  22. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Demo
    Oh yes it can!

    View Slide

  23. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    About this app - built entirely on FOSS
    • Symfony PHP framework

    https://symfony.com
    • Doctrine DBAL / ORM

    https://doctrine.org
    • CWP Doctrine driver

    https://github.com/matatirosolutions/doctrine-filemaker-driver
    • DAPI Doctrine driver

    https://github.com/matatirosolutions/doctrine-filemaker-driver

    View Slide

  24. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Attendance model (entity)

    View Slide

  25. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Attendance model (entity)

    View Slide

  26. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Attendance model (entity)

    View Slide

  27. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Attendance layout

    View Slide

  28. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Attendance model (entity)

    View Slide

  29. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Attendance model (entity)

    View Slide

  30. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Course model (entity)

    View Slide

  31. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    For sale - another free thing
    • FM Layout to entity

    https://github.com/matatirosolutions/doctrine-filemaker-driver

    View Slide

  32. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    But why?
    • Speeds up development
    • Decouples app from the database
    • Uses industry recognised components and processes

    View Slide

  33. #FileMakerDevCon
    © 2019 FileMaker, Inc.
    Questions?

    View Slide

  34. © 2019 FileMaker, Inc.
    FILEMAKER DEVCON 2019

    AUGUST 5-8 | ORLANDO, FL
    Database Abstraction
    CWP04
    Steve Winter
    Matatiro Solutions

    @steveWinterNZ

    View Slide