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
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
3. #FileMakerDevCon © 2019 FileMaker, Inc. Who am I? Steve Winter
4. #FileMakerDevCon © 2019 FileMaker, Inc. Who am I? Steve Winter
5. #FileMakerDevCon © 2019 FileMaker, Inc. Who am I? Steve Winter
6. #FileMakerDevCon © 2019 FileMaker, Inc. Who am I? Steve Winter
7. #FileMakerDevCon © 2019 FileMaker, Inc. Last year
8. #FileMakerDevCon © 2019 FileMaker, Inc. This year Disclaimer: it wasn’t a tweet it was an email, but this looks better!
9. #FileMakerDevCon © 2019 FileMaker, Inc. Sorry Joel SALES PITCH!
10. #FileMakerDevCon © 2019 FileMaker, Inc. In my defence, I’m ‘selling’: • An idea • Free open source software (FOSS)
11. #FileMakerDevCon © 2019 FileMaker, Inc. Database So what’s this big idea? Browser Internet Web Server Code
12. #FileMakerDevCon © 2019 FileMaker, Inc. Database So what’s this big idea? Browser Internet Web Server Controller
13. #FileMakerDevCon © 2019 FileMaker, Inc. Database So what’s this big idea? Browser Internet Web Server Controller
14. #FileMakerDevCon © 2019 FileMaker, Inc. Database So what’s this big idea? Browser Internet Web Server Controller Model
15. #FileMakerDevCon © 2019 FileMaker, Inc. Database So what’s this big idea? Browser Internet Web Server Controller Model Driver
16. #FileMakerDevCon © 2019 FileMaker, Inc. Database So what’s this big idea? Browser Internet Web Server Controller Model Driver
17. #FileMakerDevCon © 2019 FileMaker, Inc. Database So what’s this big idea? Browser Internet Web Server Controller Model Driver
18. #FileMakerDevCon © 2019 FileMaker, Inc. Database So what’s this big idea? Browser Internet Web Server Controller Model Other Driver
19. #FileMakerDevCon © 2019 FileMaker, Inc. Database So what’s this big idea? Browser Internet Web Server Controller Model XML
20. #FileMakerDevCon © 2019 FileMaker, Inc. Database So what’s this big idea? Browser Internet Web Server Controller Model PHP
21. #FileMakerDevCon © 2019 FileMaker, Inc. Database So what’s this big idea? Browser Internet Web Server Controller Model Data API
22. #FileMakerDevCon © 2019 FileMaker, Inc. Demo Oh yes it can!
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
24. #FileMakerDevCon © 2019 FileMaker, Inc. Attendance model (entity)
25. #FileMakerDevCon © 2019 FileMaker, Inc. Attendance model (entity)
26. #FileMakerDevCon © 2019 FileMaker, Inc. Attendance model (entity)
27. #FileMakerDevCon © 2019 FileMaker, Inc. Attendance layout
28. #FileMakerDevCon © 2019 FileMaker, Inc. Attendance model (entity)
29. #FileMakerDevCon © 2019 FileMaker, Inc. Attendance model (entity)
30. #FileMakerDevCon © 2019 FileMaker, Inc. Course model (entity)
31. #FileMakerDevCon © 2019 FileMaker, Inc. For sale - another free thing • FM Layout to entity
 https://github.com/matatirosolutions/doctrine-filemaker-driver
32. #FileMakerDevCon © 2019 FileMaker, Inc. But why? • Speeds up development • Decouples app from the database • Uses industry recognised components and processes
33. #FileMakerDevCon © 2019 FileMaker, Inc. Questions?
34. © 2019 FileMaker, Inc. FILEMAKER DEVCON 2019 AUGUST 5-8 | ORLANDO, FL Database Abstraction CWP04 Steve Winter Matatiro Solutions @steveWinterNZ