PDA

View Full Version : Filemaker Pro 9 released



stewiesno1
12th July 2007, 10:41 AM
Apple has announced Filemaker Pro 9 .A cross platform database app that leaves some of the others for dead when it comes to usability. One of the big issues has always been how it can relate to MYSQL and MS SQL server databases. This new version provides a slew of new functions to improve this compatibility.

Straight from the Apple splash screen...
"FileMaker today announced the immediate availability of FileMaker Pro 9, a major new version of the company’s award-winning database application for Windows and Mac OS X. Offering more than 30 ease-of-use breakthroughs — including live connections to SQL data and an innovative PHP site assistant — FileMaker Pro 9 makes it easier to create, automate, and share databases, as well as to generate reports. With versions designed for end users and database developers, the new product line consists of FileMaker Pro 9, FileMaker Pro 9 Advanced, FileMaker Server 9, and FileMaker Server 9 Advanced."

Link ...
http://www.filemaker.com/mac/

Now I'm no database monkey but I know a couple of people whose liveliehoods depend on databases within medium sized organisations who have used the other apps and who now use FM Pro wherever possible They could not believe the difference.
Stewie

Macca with a Mac
16th July 2007, 11:04 PM
I'm a recent switcher and I've found that database apps for the Mac are sadly lacking. It seems like Filemaker is the only way to go.

I tried using Access under Crossover but couldn't get it running. NeoOffice has a database app in it but it seems buggy and importing requires jumping through hoops. Doesn't seem to be able to export either which is bloody useless.

Have heard MySQL runs on the Mac but the geek factor is too high for me. So I guess I'll have to lay down the bucks on a copy of Filemaker.

Of course I could use Parallels to run M$ Access and the all-up cost would be cheaper than buying Filemaker but that would mean I'd have to buy a copy of XP and I'd feel so dirty...

SyncMan
17th July 2007, 04:54 AM
Have heard MySQL runs on the Mac but the geek factor is too high for me. So I guess I'll have to lay down the bucks on a copy of Filemaker.

HaHa, one of the most amazing things that people don't get it this...

MySQL (http://en.wikipedia.org/wiki/MySQL) is a Query Language (SQL (http://en.wikipedia.org/wiki/Sql)) tied to a mini database, available on Mac and very popular on ISP systems for many useful things. In fact many important useful things.

You could use PostgreSQL (http://en.wikipedia.org/wiki/PostgreSQL), but it is less popular than MySQL.

MySQL & PostgreSQL are NOT IDEs (http://en.wikipedia.org/wiki/Integrated_development_environment), however there a GUI friendly interface apps to say MySQL. ie Navicat and CocaMySQL.

However Filemaker (http://en.wikipedia.org/wiki/Filemaker_Pro) is a full blown IDE (http://en.wikipedia.org/wiki/Integrated_development_environment), and has a database tied into it, and is very powerful for office type environments. (As are the other Filemaker products such as their server.)

I really don't know how people can suggest one over the other, they are really two different beasts, with the common word of database.

However, in reality the two need to work together, maybe merge, hence on that front there are things that are happening, such as, but not limited to...

FileMaker cosies up to SQL (http://www.filemaker.com/company/newsroom/news/index.html)

Connect to External SQL Data Sources with FileMaker (http://www.filemaker.com/products/fmp/sql.html)

FileMaker PHP Web Publishing (http://www.filemaker.com/products/fms/php.html)

Prior to FMP 9, there was another app that offered to link FMP to MySQL/PHP.

Slowly FMP gets better a being a proper database, one that matches features that I knew were around decades ago.

Mikey D
17th July 2007, 08:39 AM
Some of the guys here had the pre-release developer version, they're pretty happy with it apparently. That it's now got proper access for SQL tables makes things heaps easier IMHO. :)

SyncMan
17th July 2007, 09:29 AM
FileMaker PHP Web Publishing (http://www.filemaker.com/products/fms/php.html)

I should note this solution needs the server product :(

Currawong
17th July 2007, 02:12 PM
I've been wanting to write my own Filemaker DB that pulls data from a MySQL DB for years. It would save me considerable hassle when managing various web sites.

vid
16th December 2007, 06:01 PM
Rather than start a new thread I though I'd just tack on to this one as someone may know the answer if they are Filemaker savvy.

I have been using Filemaker since version 3 and have had version 6 since it came out.
My question is would it be an advantage for me to upgrade to the latest version?

I really don't think I use it properly (or anywhere near what it is potentially capable of)
I just use it for cataloging our product ranges , it has various fields to sort by department/category/supplier etc, but I don't use (or even understand) much of the relational aspects, (except for a field that relates to image files) so I guess I only use it as a FLAT database.

Thanks for any help

SyncMan
17th December 2007, 06:37 AM
I really don't think I use it properly (or anywhere near what it is potentially capable of)
I just use it for cataloging our product ranges , it has various fields to sort by department/category/supplier etc, but I don't use (or even understand) much of the relational aspects, (except for a field that relates to image files) so I guess I only use it as a FLAT database.

Maybe Bento might be more your cup of tea...

http://www.filemaker.com.au/

However requires Leopard.


I have been using Filemaker since version 3 and have had version 6 since it came out.
My question is would it be an advantage for me to upgrade to the latest version?

Also you will still need to buy the new version outright, so no upgrade...

http://www.filemaker.com.au/products/fmp/features.html?homepage=current_upgrade

http://www.filemaker.com.au/purchase/store/buying_faq.html

If you are using FileMaker 6, 5.5, 5.0, 4.1, 4.0 or earlier versions, you could be getting so much more done in so much less time with FileMaker Pro 9. See the Version Comparison Chart. Licensed users of FileMaker 6 and earlier versions are not eligible for the upgrade price and must pay full price.

stewiesno1
17th December 2007, 09:29 AM
The good thing about Filemaker is that it can be as simple as you like or as complex ( meaning wide ranging ) as you want. True some of the functions and setting them up can take a fair bit of effort if you are not a database whiz but you can customise it just how you like it and you can expand its functions as your business grows.
Take a gander over at Apples site and find some of the tutorials there to help you.
If all you are using it for at present is the straight database function then version 6 will do you fine as long as it is compatible with your OS and machine. The later versions ,like most software ,do have some great functions though. Just do a comparison between versions.

Stewie

Edit : Oops , I meant go to www.filemaker.com.au not Apple.If you go to here...
http://www.filemaker.com.au/products/fmp/features.html?homepage=current_upgrade
and click on the pdf icon about two thirds of the way down on the right hand side ; that will give you a comparison between versions.

vid
17th December 2007, 01:23 PM
I've had a look at the comparison chart and I think I wouldn't really gain much from upgrading, I guess I am also concerned that down the track new operating systems might not support older versions.

Venom71
17th December 2007, 01:54 PM
Bad advice given - so I removed it.

AUSMUG
17th December 2007, 03:07 PM
FileMaker has stated that no versions from 8.5 or earlier is compatible with Leopard. They said they will be releasing a patch for version 8.5 this month to make it Leopard compatible but have no plans of making patches available for earlier versions.

They actually only released an upgrade to version 9 to make it compatible with Leopard earlier this month. What upsets me is that FileMaker Server 9 Advanced is still incompatible with Leopard and FileMaker has been unable to supply any time frame other than some time next year. Not real crash hot for a $4000+ program.

Filemaker is a great product but the pricing is over the top for what you get, incompatibilities & bugs always seem to show up after OS upgrades and basic hardware requirements just keep getting higher and higher.

What sucks also is that the Windows requirements are much lower and stability has traditionally been better in the Windows versions. I really don't get this from a company that is an Apple subsidiary.

I've been a FileMaker user since version 3 and currently use FileMaker 9, FileMaker 9 Advanced and FileMaker 9 Server Advanced as well as an old FileMaker 7 Advanced Server for some older clients and am a member of their developers program. I also use MySQL & PHP and use a middle ware program Lasso which can work with FileMaker, MySQL plus a range of other databases.

I personally think before making a decision people should really consider why they need a database solution (desktop use, quick development, sharing within work groups or for distribution on the net etc) before making a choice on what is the best solution. Also keep in mind the skill levels of the users and administrators of any new database system as well as development costs/time and ongoing upgrade costs.

Each database has its own pros and cons and before making a decision some kind of feasibility study just makes good sense.

vid
17th December 2007, 06:40 PM
FileMaker has stated that no versions from 8.5 or earlier is compatible with Leopard. They said they will be releasing a patch for version 8.5 this month to make it Leopard compatible but have no plans of making patches available for earlier versions.

Looks like I'll be sticking with Panther for a while longer then!