Tweet
Tweet

Slide 1

Slide 1 text

© 2019 FileMaker, Inc. FILEMAKER DEVCON 2019 AUGUST 5-8 | ORLANDO, FL Database Abstraction CWP04 Steve Winter Matatiro Solutions @steveWinterNZ

Slide 2

Slide 2 text

#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

Slide 3

Slide 3 text

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

Slide 4

Slide 4 text

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

Slide 5

Slide 5 text

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

Slide 6

Slide 6 text

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

Slide 7

Slide 7 text

#FileMakerDevCon © 2019 FileMaker, Inc. Last year

Slide 8

Slide 8 text

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

Slide 9

Slide 9 text

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

Slide 10

Slide 10 text

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

Slide 11

Slide 11 text

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

Slide 12

Slide 12 text

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

Slide 13

Slide 13 text

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

Slide 14

Slide 14 text

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

Slide 15

Slide 15 text

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

Slide 16

Slide 16 text

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

Slide 17

Slide 17 text

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

Slide 18

Slide 18 text

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

Slide 19

Slide 19 text

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

Slide 20

Slide 20 text

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

Slide 21

Slide 21 text

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

Slide 22

Slide 22 text

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

Slide 23

Slide 23 text

#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

Slide 24

Slide 24 text

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

Slide 25

Slide 25 text

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

Slide 26

Slide 26 text

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

Slide 27

Slide 27 text

#FileMakerDevCon © 2019 FileMaker, Inc. Attendance layout

Slide 28

Slide 28 text

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

Slide 29

Slide 29 text

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

Slide 30

Slide 30 text

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

Slide 31

Slide 31 text

#FileMakerDevCon © 2019 FileMaker, Inc. For sale - another free thing • FM Layout to entity
 https://github.com/matatirosolutions/doctrine-filemaker-driver

Slide 32

Slide 32 text

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

Slide 33

Slide 33 text

#FileMakerDevCon © 2019 FileMaker, Inc. Questions?

Slide 34

Slide 34 text

© 2019 FileMaker, Inc. FILEMAKER DEVCON 2019 AUGUST 5-8 | ORLANDO, FL Database Abstraction CWP04 Steve Winter Matatiro Solutions @steveWinterNZ