PureBasic Forums - English

Just wondering if anyone here has any experience with Filemaker databases and what your thoughts about it may be?

I ask this as I have just had a nasty experience with 1 of these in a place where I was working & I apparently bumped a modem power cord out of its socket which has managed to apparently corrupt this database....

(Here is a little info I found relating to them on a forum on stack overflow - The FileMaker Server service "prefers" being stopped using the Admin Console (though the Admin Console may sometimes be unable to stop it either). If the FileMaker Server service stops any other way (including power loss, via the management console, or even a normal system shutdown) then some of your databases may become corrupt. Same if a client crashes during an operation, or if the network connection is lost suddenly. The solution for a power loss is to write a batch script to try and automate the shutdown, and then buy a UPS and program it to execute your script before the juice runs out. And hope it works. Otherwise backup hourly using the built-in scheduler. Aside: SQL server doesn't have this problem because it can roll back uncommitted transactions.)

I used to develop in FileMaker but moved away from it after a botched FileMaker Update. FileMaker uses a proprietary database format and if you can't run FileMaker, you can't access your data. The bad update crashed the current version and prevented reinstalling the previous. FileMaker (Apple) refused to help unless I bought a service contract. The referred me to the "Forums" so other people could try to guess how to fix the problem. The real problems came from my customers that I had developed database solutions for. Even though they had data backups, they could not get the program to run unless they had a full system backup with the previous version.

useful information for me melmitts707. Ty.