On 4 dec 2009, at 09:54, Tim Worman wrote: > Mark: > > Yeah, you can use any ODBC data source to use the import functionality and > script steps. However, FileMaker Pro 10 now has the ability to transparently > use tables from an external data source as though they were internal tables. > But it can only do this with SQL Server, Oracle, and MySQL. > > I may try to use the import angle but I'd really rather not have data moving > back and forth that can change after the import. The newer functionality is > very cool. > > Tim Worman > UCLA GSE&IS >
That was also available in Filemaker 9. I have sent Filemaker a request to also support postgresql in such a a way, but it seems that is not on their priority list. Too much attention for another platform might be counterproductive, I assume. It still is possible too import the data from postgresql 9 or any other database that supports ODBC, but there is no live connection possible as with MSSQl, Oracle and MySQL. Postgresql (WebObjects) might suffer from the Novell problem: nobody complained about it, as everybody did with WindowsNT, so new potential customers never knew it existed. I'll write the postgresql list they should screw up something major, so to get free publicity. And I'll bring down the iTunes store by downloading all the free iPhone apps available. That will teach them to rely on unfashionable technology. > > > On Dec 4, 2009, at 12:49 AM, Mark Wardle wrote: > >> Hi Tim, >> >> I have accessed PostgreSQL using Filemaker before using ODBC using >> "Actual" drivers. >> >> Caveat: I only used this with 8.0 and 8.5 using ODBC to import all >> data for subsequent processing rather than accessing data "live". I >> gather Filemaker 9.0 can use an external data source in joins, but >> have no idea whether it would support PostgreSQL using these ODBC >> drivers... worth a look though. >> >> Best wishes, >> >> Mark >> >> >> >> 2009/12/3 Tim Worman <li...@thetimmy.com>: >>> I'm also staring down a future with MySQL - for a much different reason. >>> Our school has a lot of institutional knowledge of FileMaker Pro. I'm >>> moving towards WO as the editing mechanism and leveraging that >>> institutional knowledge for users' report writing needs. FMP only supports >>> 3 databases for transparently including external ODBC data sources - and >>> MySQL is the only option for us. >>> >>> Up to now I've been using OpenBase and been extremely pleased with it but >>> FileMaker's got me by the short and curlies. I have been following Kieran's >>> support of MySQL and I'm glad to see others see similar benefits. >>> >>> Tim Worman >>> UCLA GSE&IS >>> >>> On Dec 3, 2009, at 3:20 PM, Mike Schrag wrote: >>> >>>> Also, full disclosure -- i DO use Postgresql and I think it's a great >>>> database, but I always feel a little queasy when I do a deployment with PG >>>> without clustering support. There's always the feeling of "i sure hope >>>> this doesn't screw me." FrontBase has clustering, but has an obnoxious bug >>>> with clustered sequences which basically requires that you use guid pks, >>>> which none of our stuff does, so it's pretty likely MySQL is in my future. >>>> >>>> ms >>>> >>>> On Dec 3, 2009, at 6:18 PM, Mike Schrag wrote: >>>> >>>>> Caveat here -- I don't use MySQL (yet) for anything real. InnoDB is >>>>> acid, though. I agree that you should never run a myisam mysql for most >>>>> normal systems and that it's strange that this is the default, but the >>>>> fact is that you CAN set it to innodb, and it's a perfectly capable (if >>>>> not VERY capable) database. >>>>> >>>>> Soooooo -- I'm calling this out as FUD. Search google for "postgresql >>>>> corruption" and you'll get plenty of matches, too: >>>>> Results 1 - 10 of about 164,000 for postgresql corruption. >>>>> Results 1 - 10 of about 12,700 for mysql innodb corruption. >>>>> >>>>> There are quite a few huge systems that are running on MySQL. And the >>>>> simple fact that you can cluster it actually makes it far more resilient >>>>> than postgresql. Go try to setup a fault tolerant deployment of PG. Have >>>>> fun and let me know when you're done. >>>>> >>>>> ms >>>>> >>>>> On Dec 3, 2009, at 6:10 PM, Miguel Arroz wrote: >>>>> >>>>>> Hi! >>>>>> >>>>>> There is nothing "specifically" wrong about using MySQL as a database >>>>>> for WO. What's wrong is using MySQL at all! ;) >>>>>> >>>>>> Essentially, it sucks. The first concern of MySQL authors is speed, and >>>>>> only then correctioness. This may be seen my the existence of InnoDB >>>>>> itself. First, speeeeeed. A few years later, yeah, this actually might >>>>>> be usable in something else than a blog if we actually add ACID >>>>>> properties to it! >>>>>> >>>>>> In my Univ, the IT team who deals with the central systems moved >>>>>> everything they could from mysql to PostgreSQL. Among other reasons, >>>>>> once in a while a MySQL table corrupted itself. PostgreSQL is much more >>>>>> robust. >>>>>> >>>>>> As always in software engineering, everything is a compromise. There may >>>>>> be a few situations where MySQL is dramatically faster than PostgreSQL, >>>>>> and the inverse is also true, it depends on the usage and the DB >>>>>> architecture. This to say that you should use what better suits your >>>>>> needs. But what I would not expect is MySQL to... you know... work! ;) >>>>>> >>>>>> Yours >>>>>> >>>>>> Miguel Arroz >>>>>> >>>>>> On 2009/12/03, at 22:58, Kieran Kelleher wrote: >>>>>> >>>>>>> Miguel, anyone, please enlighten me as to what specifically is wrong >>>>>>> with using MySQL InnoDB as a database for WO because I have not seen >>>>>>> any problem, but then I have not used PostgreSQL or FrontBase either - >>>>>>> so maybe I don't see a problem that I should be concerned about. >>>>>>> >>>>>>> -Kieran >>>>>>> >>>>>>> On Dec 3, 2009, at 5:41 PM, Miguel Arroz wrote: >>>>>>> >>>>>>>> Hi! >>>>>>>> >>>>>>>> On 2009/12/03, at 22:32, Kieran Kelleher wrote: >>>>>>>> >>>>>>>>>>> I create new OSCs for most background tasks. The one thing is that >>>>>>>>>>> I dispose() on it at the end of the task .... and the dispose() is >>>>>>>>>>> only useful if you use ERXJDBCAdaptor is used since the regular WO >>>>>>>>>>> 5.3 jdbc adaptor opens two connections for every OSC and leaves the >>>>>>>>>>> stupid things open forever. ERXJDBCAdaptor only opens one db >>>>>>>>>>> connection and releases it when u call dispose() IIRC. >>>>>>>>>> >>>>>>>>>> Dude! >>>>>>>>>> <http://terminalapp.net/webobjects-postgresql-and-db-growing-and-growing/> >>>>>>>>>> ;) >>>>>>>>> >>>>>>>>> Dude! www.mysql.com - innodb (or cluster NDB) .... doesn't "grow and >>>>>>>>> grow" (and it is not a "toy", no matter what Chuck says ;-) ) >>>>>>>> >>>>>>>> No, it's a disaster! ;) >>>>>>>> >>>>>>>> The "growing" is a side effect of leaving the transaction opening that >>>>>>>> happens on PostgreSQL due to its architecture, but the point is the >>>>>>>> same, do what I say there to avoid the dumb connection. :) >>>>>>>> >>>>>>>> Yours >>>>>>>> >>>>>>>> Miguel Arroz >>>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Do not post admin requests to the list. They will be ignored. >>>>>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>>>>>> Help/Unsubscribe/Update your Subscription: >>>>>>> http://lists.apple.com/mailman/options/webobjects-dev/arroz%40guiamac.com >>>>>>> >>>>>>> This email sent to ar...@guiamac.com >>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Do not post admin requests to the list. They will be ignored. >>>>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>>>>> Help/Unsubscribe/Update your Subscription: >>>>>> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com >>>>>> >>>>>> This email sent to msch...@mdimension.com >>>>> >>>>> >>>>> _______________________________________________ >>>>> Do not post admin requests to the list. They will be ignored. >>>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>>>> Help/Unsubscribe/Update your Subscription: >>>>> http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com >>>>> >>>>> This email sent to msch...@mdimension.com >>>> >>>> >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>>> Help/Unsubscribe/Update your Subscription: >>>> http://lists.apple.com/mailman/options/webobjects-dev/lists%40thetimmy.com >>>> >>>> This email sent to li...@thetimmy.com >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) >>> Help/Unsubscribe/Update your Subscription: >>> http://lists.apple.com/mailman/options/webobjects-dev/mark%40wardle.org >>> >>> This email sent to m...@wardle.org >>> >>> >> >> >> >> -- >> Dr. Mark Wardle >> Specialist registrar, Neurology >> Cardiff, UK > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/johan%40netsense.nl > > This email sent to jo...@netsense.nl Regards, Johan Henselmans http://www.netsense.nl Tel: +31-20-6267538 Fax: +31-20-6279159 _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
