[FX.php List] Using MySQL

Dale Bengston dbengston at tds.net
Sun May 23 12:01:20 MDT 2010


Hi Jonathan,

Short answer: yes. Using MySQL is different. Most of us probably got here by web-enabling portions of FileMaker client-server installations. Switching to MySQL means you're a web developer now, not a FileMaker developer doing web work. It's a different mindset. MySQL is designed to be a web back-end. You can use an admin tool (I use Navicat on the Mac) to modify schema, but a true web user interface must be built for most functions. 

Truth be told, I'd rather build a web UI for the functions you mention than do it with FMP layouts. I have *never* cottoned to building layouts in FMP. It always feels like MacDraw circa 1985. Slow and clunky and imprecise. (Maybe it's because I've used QuarkXPress and InDesign professionally for years, and I am spoiled.) Besides, most of the admin stuff is common to all my solutions, so a very big portion of it gets recycled from project to project. Once I got it built, it's the gift that keeps on giving.

If you'd like to stick with the FileMaker UI for admin, you could look at using ODBC to log into your MySQL web tables with FileMaker. That might be a good interim step.


Hope this helps,
Dale


On May 23, 2010, at 10:02 AM, Jonathan Schwartz wrote:

> Hi Folks,
> 
> I just did my first foray into completely replacing FMP with MySQL on a small online project. In this case the data is rather static. It's remarkable, at least at this point, the trivial nature of changing over php code from using  FMP to MySQL.
> 
> A reality check please...Since MySQL doesn't have the end user client like FileMaker Pro, doesn't this mean that projects now MUST include a complete, robust end user interface to allow users (authorized client staff) to interact with data in all the ways that FileMaker provides natively? There would need to be Query, Sort, Detail, List, Add, Edit, Delete, Validation, Calculations, etc for every table...the stuff we allow end users to do natively in FMP.
> 
> That seems like a huge task, several levels of magnitude more than the basic web publishing.
> 
> Interested how FielMaker CWP developers view this.
> 
> Thanks
> 
> Jonathan
> 
> 
> -- 
> Jonathan Schwartz
> Exit 445 Group
> jonathan at exit445.com
> http://www.exit445.com
> 415-370-5011
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list



More information about the FX.php_List mailing list