3 Replies Latest reply on Feb 10, 2016 4:01 AM by beverly

    Filemaker Front End MySQL Back End


      Morning All


      I am just mulling over the theory of moving my database content to MySQL and I have a question that i have not been able to find an answer to, any help would be appreciated.


      If you store what is known as container data, e.g. jpegs, pdfs, video files etc in the MySQL database, how would they be displayed on the Filemaker front end? Would the user;


      - Still be able to see the Jpeg images.

      - be able to read pdfs within filemaker.

      - be able to play videos and audio within Filemaker.




      Any help would be greatly appreciated.




      Many Thanks





        • 1. Re: Filemaker Front End MySQL Back End

          I don't think you can store data such as this in MySQL.

          Well you may be able to store Binary data in SQL but filemaker won't see them as container fields.

          Unless Im wrong this is a big reason to not move to Mysql.

          We could talk all day about this but after many years of head wrecking I settle to the point:

          Only move to SQL back end if you have a good reason to...

          Other than this you are only making a lot of extra work for yourself and there doesn't seem any point in meeting trouble half ways.


          I think its best to interact for Mysql for certain tasks.

          E.g I have a client with a mysql based website and I use my FM system to push some product updates to the website, clean and simple.


          Honestly nobody will thank you for the extra bother, not clients anyway as they don't care as long as it works.


          Hope it helps.

          • 2. Re: Filemaker Front End MySQL Back End

            If you are thinking of storing NO data in FM and all the data in MySQL, then that may be a bad idea.  That's not what the ESS feature is about.


            If you don't have the book already, get the FTS Advanced book from the FileMaker Inc website and check chapter 9 (integration).  It has a great list of gotcha's, of things that behave differently when you use ESS data vs native FM data.

            Only make your decision after you reviewed that.

            • 3. Re: Filemaker Front End MySQL Back End

              I would not do this (use FM as front end). I integrate FM and other SQL sources, as needed, but only if needed.


              However, you may consider a URI reference to images (stored where both MySQL and FileMaker can see the image) and the URI (http://...) would be TEXT in a field/column. FM can display in webviewer. MySQL would need a web interface to link to the image.


              Base64 is image encoded as TEXT which can be stored in either database, but would need to be decoded back to be "image".


              Neither of this may be optimal. See Wim's answer.

              Database Skills, FileMaker Pro Training | FileMaker