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.

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