This topic is 1867 days old. Please don't post here. Open a new topic instead.
How to Build FileMaker Web Apps for High Traffic using MySQL Backend and 360Works MirrorSync
Why Sync FileMaker and MySQL?
FileMaker is the best tool for rapid application development, but it is not the most reliable or scalable option for high traffic web sites. MySQL provides that reliability and scalability, but can't compare to FileMaker for development productivity and user friendliness.
360Works MirrorSync bridges this gap, letting you use each tool for its best purpose. Quickly create layouts, scripts, and schema in FileMaker Pro, test and refine them, then use MirrorSync to publish all your record data to MySQL and keep both databases in sync moving forward. You can use industry-standard tools and frameworks (or hire from a vast talent pool) to create highly reliable and scalable web apps.
In the event that FileMaker Server is down or rebooted for any reason (such as software upgrades), your MySQL web app will continue running and serving users. MirrorSync will detect when FileMaker Server comes back online and bring both databases back in sync.
This video, narrated by Junior Perez of 360Works, takes you on a step-by-step walk-through of how to sync between FileMaker Server and MySQL. Junior demonstrates how to start with a completely empty MySQL Server, create the database and tables, and set up an auto-scheduled sync to run every 60 seconds. The process is the same for any other JDBC-compatible database such as SQL Server, Oracle, or PostgreSQL. The license price for syncing one FileMaker Server with any one of these databases is $1,800, with discounts available for educational and non-profit organizations.
If you would like to involve 360Works in configuring your sync, or in creating a web application backed by MySQL, please contact us for consulting and development assistance.
Read More on MirrorSync or Download Now!
360Works MirrorSync Stay updated with 360Works
360Works 25 Year Anniversary and New Portfolio Offer
We are celebrating 25 years in business! Thank you for your support. If you are using a FileMaker plug-in or two from 360Works, we encourage you to try the 360Works Portfolio Bundle to receive all products.
Now through next week enjoy a 25% off sale on our Portfolio Bundle!
You already receive 75% off the entire suite of plug-ins with the Portfolio Bundle deal being offered at $1,995, and with our 25th Anniversary Offer you get an additional 25% off, making your final cost only $1,496.25!
Use code: 360is25 at checkout. (Online orders only, discounts cannot be combined, new portfolio)
This offer is for new Portfolio Bundle purchases only and will be on now, through next week, ending Friday, April 9, 2021.
Already own a product or two from 360Works? You can apply your licenses to receive credit for select products upon checkout of the Portfolio Bundle.
New Website Design
Have you noticed the new look of our website? Be sure to stop by and take a look: https://www.360works.com/products/
New Product Updates
We recently released a new major version of the 360Works Email Plugin, to include OAuth support for Gmail and Office 365. Additionally, we released a new major version of our FileMaker Server offsite backup, 360Works SafetyNet, with improvements for increased safety, reliability, speed, ease of management and lower cost.
Case Study: MirrorSync in Africa for Promasidor
Learn how FileMaker synchronization happens across the continent of Africa using 360Works MirrorSync in a solution for Promasidor Food and Beverage with experience shared from Technology Professional, Serge De Pauw at Promasidor. Read the story.
We are relatively new to MirrorSync (6.12). We can have a system which is syncing with no issues. We create a new record on the FMS in a table that is synced to the Spoke (iPad). After the iPad syncs and receives the new record, the next time the iPad tries to sync, they receive an error that there is a Duplicate ID...
On researching the issue, whenever we create a single record on the Hub, 2 records with the same ID are created on the Spoke with the same ID.
This effectively breaks the sync and needs remediation by the user of the iPad by the deletion of one of the records.
As you may know we have a great Optimize command for DynaPDF. You can use it on PDF documents in both FileMaker and Xojo plugins. Over time the command got more and more powerful and we like to write here about some of the features.
In general the function rebuilds the content stream of all pages, templates, patterns, annotations, and form fields. This may remove errors in the content stream and produce a consistent document.
When you specify the flags, the default flag value (0) just rebuilds the content stream and fixes errors. You may specify "InMemory" to have changes made in a way, that the PDF is in memory and not flushed to the current output. Normally you may not notice the difference, but if you like to continue writing to the PDF, the memory flag is needed.
The Optimize function can reduce the file size of PDF files. You can pass the ScaleImages flag and then all images are checked. You can define a minimum and target resolution for images. All pictures with at least the minimum resolution are checked. This avoids that we look on icons for example and only process pictures with a significant resolution. DynaPDF scales the images down to the target resolution and compresses them with the compression algorithm you specify, usually JPEG. If the final picture is smaller in size, we store it, otherwise we keep the original image. The reason is that often one bit tiff images can be smaller than a reduced resolution JPEG file.
You can pass flag SkipMaskedImages to skip masked images as JPEG compression may not work well with pictures, where a specific color is used to mark transparency. The check whether new picture is smaller than original image can be disabled via NoImageSizeCheck flag.
If you like to get images compressed with JBIG2, you can use CompressWithJBIG2 flag. This can drastically reduce the file size since JBIG2 compression achieves much higher compression rates than any other 1 bit image filter that PDF supports. The JBIG2 compression filter in DynaPDF is lossless, that means the original image quality will be preserved. Great to combine with ConvertGrayTo1Bit flag discussed below.
The names for links in the PDF may often have names from the original content. For example our documentation uses the function names there as link names. But this can be optimized with the NewLinkNames flag and rename the internal link names with a running counter. This saves a few bytes for each link, which can sum up with thousands of link names.
Some drawing paths have an no-op operator on the end. Instead of defining a path and not using it, we can remove the definition. This usually happens in a lot of tools to create PDFs, as paths are defined automatically. e.g. you may have a rectangle to group items on the layout and the rectangle is not visible as it has no stroke and no fill. The resulting path is there, but has no output.
If you pass FlattenLayers flag, all the layers may get flattened and non visible layers may get removed. As some layers may have content behind other layers, the invisible paths check above may kick in and remove content.
See also FlattenAnnots and FlattenForm functions.
The PDF may contain additional things, which can safely be removed. This includes private data from applications like Indesign or Adobe Illustrator. Those store details for editing of the PDF with the PDF as a BLOB. We can skip this data and get a smaller PDF size. Usually a PDF viewer will ignore any item it doesn't understand.
We can remove thumbnails embedded in the pictures as those will be generated in the viewer if needed. Same for alternative representations of images. For example an application may include a CMYK and a RGB representation and we can remove one (the one marked as alternative).
Convert to colorspace
Beside optimization, we can do some extra operations like converting colors to other color spaces. This includes converting to grayscale, RGB or CMYK. If you like to convert a PDF to grayscale, converting colors here may be useful. Otherwise if you have to send a PDF to a printer, you can convert to CMYK. Usually you don't need this as the printer will raster the PDF in CMYK color space. Converting CMYK content to RGB may reduce size as images have only 3 instead of 4 color spaces.
The flag ConvertAllColors allows to convert separation, DeviceN and NChannel color spaces to RGB/CMYK colors. This usually means you loose color information as the alternative colors will be used and those are specified in RGB, CMYK or LAB color spaces. For example a printer may have cyan, magenta, yellow, black and a special colors like gold and silver colors. An area marked with a Device color like gold will be printed with the gold ink to produce the shiny effect on the paper. Replacing those colors with their alternative CMYK color will remove that and the color is then printer with a mixture of yellow.
Finally the flag ConvertGrayTo1Bit can be used to convert colors to black and white. For this you can pass UseOtsuFilter flag to request to use Otsu filter.
Convert Text to Outlines
Recently added in the last weeks, DynaPDF can now convert text to outlines. This removes fonts and text information from the PDF and leaves the content as vector graphics. You can still read it as human, but a computer needs OCR to get back text.
Optionally you can pass ConvNonEmbFontsOnly flag to limit the conversion of text to outlines only for non embedded files. This way a PDF referencing fonts on your computer can convert those to outlines. Great to email your PDF to printer shop, where they don't have the required font and you can still get your PDF printed well.
Annotations and form fields are not affected by the conversion. In order to consider these objects too it is possible to flatten all annotations and form fields before calling Optimize. See FlattenAnnots and FlattenForm functions.
The flags above can be combined in various ways. In general Optimize should be called at the end of your PDF processing just before outputting the PDF document. Our plugin may render preview and close the PDF file.
To use the Optimize function, you need a DynaPDF license with Pro or Enterprise level. Starter or Lite versions are not enough.
Without a license key you can test this feature and see how it works.
For more details, please check the DynaPDF manual on the Optimize function. For FileMaker specific notes, please check DynaPDF.Optimize function in our documentation. For Xojo specific things, please check Optimize function in DynaPDFMBS class.
Check also DuplicateCheck flag for SetImportFlags2 function to enable duplication check. This helps to reduce the file size as duplicate font, image, templates and extended graphics state are replaced with references to first one.
Please do not hesitate to contact us with your questions.
I updated my SwiftFM repo for the FileMaker 19 Data API.
Notable improvements include support for the new `validateSession()`, and moving the server `message` into the completion block. So now you can access the message in the closure, where it's more helpful. Better examples as well. Give it a ⭐️ on GitHub if you find it useful. Thanks! 😘