Re: Revolution, MySQL vs FileMaker - PostgreSQL for OSX

2006-10-04 Thread Luis
I had seen that before, but the install is still via the shell, whereas the other one is the more familiar OS X install. Cheers, Luis. Hershel Fisch wrote: On 9/28/06 11:47 AM, Luis [EMAIL PROTECTED] wrote: Lookee what I found!

Re: Revolution, MySQL vs FileMaker - PostgreSQL for OSX

2006-10-03 Thread Hershel Fisch
On 9/28/06 11:47 AM, Luis [EMAIL PROTECTED] wrote: Lookee what I found! http://web.mac.com/dru_satori/iWeb/PostgreSQLforMac/Welcome.html Cheers, Luis. Check this out as well, http://www.entropy.ch/software/macosx/welcome.html ___ use-revolution

Re: Revolution, MySQL vs FileMaker

2006-10-02 Thread Dan Shafer
Bill, As someone who has in fact used FileMaker to create a full-blown application (though not of the standalone variety) on several occasions, I can attest to at least much of what you say. My experience is all FMPro 5.5 and earlier, so it is seriously outdated, but I always found FM to be

Re: Revolution, MySQL vs FileMaker

2006-10-02 Thread Javier Miranda V.
Bill, thank you for the honest and accurate description of the differences between RR and FM Pro and the detail concerning the capabilities of FM Pro. I specially like the idea of the Robot commanded via RR. Saludos, Javier Miranda V.

Re: Revolution, MySQL vs FileMaker

2006-10-02 Thread Bill Marriott
Dan, Thanks for your comments! To be honest, I let FileMaker Pro gather dust on my shelf during the 4.0 - 6.0 years because that point you describe of hitting the wall came all too early. However, version 7.0 of FileMaker truly re-invigorated the product. And, version 8.5 (the current release)

Re: Revolution, MySQL vs FileMaker

2006-10-01 Thread Bill Marriott
Javier, I was on vacation the last week, so I'm coming into your thread a bit late. I'm not surprised that you received a lot of pro-Rev advice... it IS a Revolution list, after all! However, I don't believe it's a clear-cut answer. The strength of Rev is in the total control you have over

Re: Revolution, MySQL vs FileMaker

2006-09-29 Thread Ruslan Zasukhin
On 9/29/06 3:44 AM, Josh Mellicker [EMAIL PROTECTED] wrote: Hi Josh, 3. If you include one or more of the MySQL drivers in your non-GPL application (so that your application can run with MySQL), you need a commercial license for the driver(s) in question. The MySQL drivers currently include

Re: Revolution, MySQL vs FileMaker

2006-09-29 Thread Luis
True, but in that instance I'd push it all over an encrypted channel. Especially so if it's an externally hosted database. Cheers, Luis. Josh Mellicker wrote: On Sep 28, 2006, at 1:26 AM, Luis wrote: Hiya, You have to be careful with some providers, quite a few of them will not allow

Re: Revolution, MySQL vs FileMaker

2006-09-29 Thread Javier Miranda V.
One more on the subject: Why not install FM Pro Server and then access it via ODBC with Standalones in the client machines? Does it work? I have been able to connect to MySQL with RR's Query Builder but I couldn't do the same to connect to FM Pro with ODBC, I have the drivers and the ODBC

Re: Revolution, MySQL vs FileMaker

2006-09-29 Thread Stephen Barncard
all new Dreamhost MySQL connections are v5.0 or greater. They dumped 4.x over a half year ago. * This is why you can note that even host providers do not switch to 5.0 actively. -- stephen barncard s a n f r a n c i s c o - - - - - - - - - - - -

RE: Revolution, MySQL vs FileMaker

2006-09-29 Thread Lynn Fredricks
all new Dreamhost MySQL connections are v5.0 or greater. They dumped 4.x over a half year ago. * This is why you can note that even host providers do not switch to 5.0 actively. I share Stephen's enthusiasm for DreamHost. Several Rev users have gotten RevCGIs to run there. Also, they

RE: Revolution, MySQL vs FileMaker

2006-09-29 Thread Lynn Fredricks
3. If you include one or more of the MySQL drivers in your non-GPL application (so that your application can run with MySQL), you need a commercial license for the driver(s) in question. The MySQL drivers currently include an ODBC driver, a JDBC driver and the C language library. Does

RE: Revolution, MySQL vs FileMaker

2006-09-29 Thread Stephen Barncard
I'm not sure if I have this right. Rev includes some MySQL drivers with the package. But we can't distribute an application built using those drivers without some kind of license with MySQL inc.? is that right? I have two reads on MySQL licensing; I have a certain bias because of my

Re: Revolution, MySQL vs FileMaker

2006-09-29 Thread Ken Ray
On 9/29/06 4:45 PM, Stephen Barncard [EMAIL PROTECTED] wrote: I'm not sure if I have this right. Rev includes some MySQL drivers with the package. But we can't distribute an application built using those drivers without some kind of license with MySQL inc.? is that right? Sort of... you

RE: Revolution, MySQL vs FileMaker

2006-09-29 Thread Robert Brenstein
I'm not sure if I have this right. Rev includes some MySQL drivers with the package. But we can't distribute an application built using those drivers without some kind of license with MySQL inc.? is that right? Probably yes, although I am not qualified to give legal advice :) The

Re: Revolution, MySQL vs FileMaker

2006-09-29 Thread Ruslan Zasukhin
On 9/30/06 1:04 AM, Ken Ray [EMAIL PROTECTED] wrote: On 9/29/06 4:45 PM, Stephen Barncard [EMAIL PROTECTED] wrote: I'm not sure if I have this right. Rev includes some MySQL drivers with the package. But we can't distribute an application built using those drivers without some kind of

Re: Revolution, MySQL vs FileMaker

2006-09-29 Thread Stephen Barncard
- P.S. (sorry for kind of advertise, which I consider as information): yes, I need to know this. Ruslan, I've gone a long way into my project. I have questions: 1. Does Valentina run the main MySQL syntax as is, or is it very different. 2. Is there a tool like CocoaMySQL (macintosh)

Re: Revolution, MySQL vs FileMaker

2006-09-29 Thread Ken Ray
On 9/29/06 6:12 PM, Ruslan Zasukhin [EMAIL PROTECTED] wrote: In general there are (IMHO) two free uses of mySQL: (1) distributing a fully GPL-compliant application, and (2) accessing a mySQL DB at an ISP via browser-based input (or the equivalent), so that the drivers and database are fully

RE: Revolution, MySQL vs FileMaker

2006-09-29 Thread Lynn Fredricks
D) Note, that commercial license do not say that IF you use driver but store db on some ISP host you get it for free. Commercial license says: IF your non-GPL app uses driver - you must pay. Point. Yes, this is how dreamhost lets you have all those nice apps - like Ken said, you don't lay

RE: Revolution, MySQL vs FileMaker

2006-09-29 Thread Lynn Fredricks
In general there are (IMHO) two free uses of mySQL: (1) distributing a fully GPL-compliant application, and (2) accessing a mySQL DB at an ISP via browser-based input (or the equivalent), so that the drivers and database are fully in the hands of the ISP and there's nothing for you to

RE: Revolution, MySQL vs FileMaker

2006-09-29 Thread Lynn Fredricks
Note that the license is usually negotiated with the customer, so it may end up being one, two, or all of the above, depending. MySQL AB, although they are (as I think Lynn put it) profiting on the confusion of the licensing arrangements, they are also quite flexible in their licensing

Re: Revolution, MySQL vs FileMaker

2006-09-28 Thread Luis
Hiya, You have to be careful with some providers, quite a few of them will not allow remote connections, only local access (such as using php on the server) to server the data. Cheers, Luis. Ken Ray wrote: On 9/27/06 11:06 PM, Josh Mellicker [EMAIL PROTECTED] wrote: With my library,

Re: Revolution, MySQL vs FileMaker

2006-09-28 Thread Rick Harrison
Hi there, Postgres is FREE. MySQL is not. If you read the license carefully this becomes very clear. I would never recommend giving some other company control of my company's database. You have no idea what they might do with the information, and you can't say for sure that you are really

Re: Revolution, MySQL vs FileMaker

2006-09-28 Thread Luis
I didn't think it needed an External. Looking at revOpenDatabase it looks like the support is 'native' (I think that's what I also saw in the features of Rev Studio on the RunRev site). Cheers, Luis. Richard Gaskin wrote: Ruslan Zasukhin wrote: But SQLLite external for Revolution is sold

Re: Revolution, MySQL vs FileMaker - PostgreSQL for OSX

2006-09-28 Thread Luis
Lookee what I found! http://web.mac.com/dru_satori/iWeb/PostgreSQLforMac/Welcome.html Cheers, Luis. Rick Harrison wrote: Hi there, Postgres is FREE. MySQL is not. If you read the license carefully this becomes very clear. I would never recommend giving some other company control of my

Re: Revolution, MySQL vs FileMaker

2006-09-28 Thread Richard Gaskin
Luis wrote: Richard Gaskin wrote: Ruslan Zasukhin wrote: But SQLLite external for Revolution is sold it seems for $150 How much is the Valentina external for Revolution? I didn't think it needed an External. Looking at revOpenDatabase it looks like the support is 'native' (I think that's

Re: Revolution, MySQL vs FileMaker

2006-09-28 Thread Luis
Ah! I see them now, in Externals/Database Drivers. Cheers, Luis. Richard Gaskin wrote: Luis wrote: Richard Gaskin wrote: Ruslan Zasukhin wrote: But SQLLite external for Revolution is sold it seems for $150 How much is the Valentina external for Revolution? I didn't think it needed an

Re: Revolution, MySQL vs FileMaker

2006-09-28 Thread Stephen Barncard
I know Dreamhost allows remote use - with a connection to a single IP, verified at the server. That can be the Wan side of a router and will work for all users in a LAN. By the way I just put the latest BETA Mac version of MySQL 5.1.1 on my Powerbook so I can develop without being connected

Re: Revolution, MySQL vs FileMaker

2006-09-28 Thread Klaus Major
Hi Richard, Luis wrote: Richard Gaskin wrote: Ruslan Zasukhin wrote: But SQLLite external for Revolution is sold it seems for $150 How much is the Valentina external for Revolution? I didn't think it needed an External. Looking at revOpenDatabase it looks like the support is 'native' (I

Re: Revolution, MySQL vs FileMaker

2006-09-28 Thread Ruslan Zasukhin
On 9/28/06 6:58 PM, Richard Gaskin [EMAIL PROTECTED] wrote: Hi Luis, Hi Richard, I didn't think it needed an External. Looking at revOpenDatabase it looks like the support is 'native' (I think that's what I also saw in the features of Rev Studio on the RunRev site). The Rev engine has no

Re: Revolution, MySQL vs FileMaker

2006-09-28 Thread Josh Mellicker
On Sep 28, 2006, at 1:26 AM, Luis wrote: Hiya, You have to be careful with some providers, quite a few of them will not allow remote connections, only local access (such as using php on the server) to server the data. Cheers, Luis. If your site has cPanel, there is a section where

Re: Revolution, MySQL vs FileMaker

2006-09-28 Thread Josh Mellicker
On Sep 27, 2006, at 10:09 PM, Ken Ray wrote: Hey Josh! If you really want to go wild, you can create a frontScript that has a mouseUp handler that executes updateMe so that the fields and popup menus don't need any script at all! Ken, I DO really want to go wild! :D

Re: Revolution, MySQL vs FileMaker

2006-09-28 Thread Josh Mellicker
On Sep 28, 2006, at 8:42 AM, Rick Harrison wrote: Hi there, Postgres is FREE. MySQL is not. If you read the license carefully this becomes very clear. Here's what I found on http://www.mysql.com/company/legal/licensing/ commercial-license.html: 1. If you include the MySQL server with

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Dan Shafer
Javier, Keep in mind that MySQL is not free for commercial applications and that the licensing involved is at least confusing (at least it was to me and I have a law degree!). That said, the Rev solution can look any number of ways. Perhaps the most common usage is to design a Revolution

Re: Revolution, MySQL vs FileMaker - Part II

2006-09-27 Thread Luis
Hiya, Any ideas what the storage capacity is for Valentina? I did a little research on FM Pro, apparently it can handle a few Terabytes (although I only managed to test it with a 3GB database, performance not being too bad). I've been curious about Valentina, especially the fact that you can

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Luis
Hiya again, If you do decide to go the browser route you could also try Dataface http://fas.sfu.ca/dataface/ Check out the video demo. Cheers, Luis. Dan Shafer wrote: Javier, Keep in mind that MySQL is not free for commercial applications and that the licensing involved is at least

Re: Revolution, MySQL vs FileMaker - Part II

2006-09-27 Thread Ruslan Zasukhin
On 9/27/06 11:23 AM, Luis [EMAIL PROTECTED] wrote: Hi Luis, Any ideas what the storage capacity is for Valentina? I did a little research on FM Pro, apparently it can handle a few Terabytes (although I only managed to test it with a 3GB database, performance not being too bad). Well,

Re: Revolution, MySQL vs FileMaker - Part II

2006-09-27 Thread Luis
Hiya, Thanks for the info. I have been looking at the site, off and on, and it looks like I might be investing in it, although I need to get over the initial learning Revolution hurdle... Cheers, Luis. Ruslan Zasukhin wrote: On 9/27/06 11:23 AM, Luis [EMAIL PROTECTED] wrote: Hi Luis,

Re: Revolution, MySQL vs FileMaker - Part II

2006-09-27 Thread Ruslan Zasukhin
On 9/27/06 1:01 PM, Luis [EMAIL PROTECTED] wrote: Hi Luis, Thanks for the info. I have been looking at the site, off and on, and it looks like I might be investing in it, although I need to get over the initial learning Revolution hurdle... Actually you can at first download and play with

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Stephen Barncard
Dan said: Javier, Keep in mind that MySQL is not free for commercial applications and that the licensing involved is at least confusing (at least it was to me and I have a law degree!). I should follow up to say that, yes if you want to host your own MYSQL server there are fees involved,

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Luis
Aside from the usual suspects there are two others that I know of: SQLite http://www.sqlite.org/whentouse.html Firebird http://www.firebirdsql.org/ Decisions, decisions... Insofar as I can tell both of these are free to use for whatever. Cheers, Luis. Stephen Barncard wrote: Dan

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Ruslan Zasukhin
On 9/27/06 3:37 PM, Luis [EMAIL PROTECTED] wrote: Aside from the usual suspects there are two others that I know of: SQLite http://www.sqlite.org/whentouse.html Firebird http://www.firebirdsql.org/ Decisions, decisions... Insofar as I can tell both of these are free to use for

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Richard Gaskin
Ruslan Zasukhin wrote: But SQLLite external for Revolution is sold it seems for $150 How much is the Valentina external for Revolution? -- Richard Gaskin Managing Editor, revJournal ___ Rev tips, tutorials and more:

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Luis
Well, there's plenty of wrappers and drivers for SQLite: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers And Firebird also has a few drivers. Sure, the 'integration' is not there, I was suggesting them as options. I for one found the earlier Firebird hard to deal with, but still

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Dar Scott
On Sep 27, 2006, at 6:49 AM, Ruslan Zasukhin wrote: FireBird - it seems there is no way to use with Rev. One might guess ODBC or a custom external might allow use. Dar Scott ___ use-revolution mailing list use-revolution@lists.runrev.com Please

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Chipp Walters
And besides, isn't SQLite already embedded into OS X in CoreData? Might be an idea to latch onto that. Yes, SQLite is embedded into OSX, but there's not a ready connector for Rev to access it. We (Altuit) makes such a connector, complete with embedded database, and Ruslan is correct, it sells

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Javier Miranda V.
Uhmmm! I really shake the list with my inquiry, not bad for my first post!, In vegeance you give me a lot of homework. Thank you very much, it seems that the effort would be well compensated, the question now is which way to follow, continue using FM via Instant Publish although aminorates

Re: Revolution, MySQL vs FileMaker - Part II

2006-09-27 Thread Hershel Fisch
On 9/26/06 8:21 PM, Luis [EMAIL PROTECTED] wrote: Ooops! Forgot: FM Pro allows you to create standalone DB front-ends for the clients to access the data, so if you want a 'rich' client experience that could be the way to go (again, limited to 5 connections for an FM Pro 'server'). I don't

Re: Revolution, MySQL vs FileMaker - Part II

2006-09-27 Thread Robert Sneidar
The happy client will be the one who gets what he wants in a timely manner without a lot of fuss. Valentina is extremely fast. So is a jet plane. Filemaker gets up and running quickly without the steep learning curve. So does a Volkswagen. I would not like to fly a jet plane back and forth

Re: Revolution, MySQL vs FileMaker - Part II

2006-09-27 Thread Ruslan Zasukhin
On 9/28/06 1:58 AM, Robert Sneidar [EMAIL PROTECTED] wrote: The happy client will be the one who gets what he wants in a timely manner without a lot of fuss. Valentina is extremely fast. So is a jet plane. Filemaker gets up and running quickly without the steep learning curve. So does a

Re: Revolution, MySQL vs FileMaker - Part II

2006-09-27 Thread Luis
Yep, does. This was on FM Pro 8. Cheers, Luis. On 27 Sep 2006, at 23:33, Hershel Fisch wrote: On 9/26/06 8:21 PM, Luis [EMAIL PROTECTED] wrote: Ooops! Forgot: FM Pro allows you to create standalone DB front-ends for the clients to access the data, so if you want a 'rich' client experience

Re: Revolution, MySQL vs FileMaker - Part II

2006-09-27 Thread Luis
On 28 Sep 2006, at 0:34, Ruslan Zasukhin wrote: On 9/28/06 1:58 AM, Robert Sneidar [EMAIL PROTECTED] wrote: The happy client will be the one who gets what he wants in a timely manner without a lot of fuss. Valentina is extremely fast. So is a jet plane. Filemaker gets up and running quickly

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Josh Mellicker
I am writing a fairly heavy-duty application in Rev that interfaces with a MySQL database on our server in Texas. Five people have been using this app (Rev standalones) heavily day and night for 6 weeks, our company has been running on it, and despite the stream of expected (and some

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Ken Ray
On 9/27/06 11:06 PM, Josh Mellicker [EMAIL PROTECTED] wrote: With my library, each field and popup menu has a script like: ON mouseUp updateMe END mouseUp That's it! the updateMe handler gets information about what to update, and what format, from custom properties attached to the

Re: Revolution, MySQL vs FileMaker

2006-09-27 Thread Stephen Barncard
This sounds a little bit like the database objects project Trevor Devore is working on. At 21:06 -0700 9/27/06, Josh Mellicker wrote: Until I got my custom MySQL library written and decided on a simple way to map Rev controls with database elements it was very time-consuming, now I can

Revolution, MySQL vs FileMaker

2006-09-26 Thread Javier Miranda V.
While not trying to initiate a war , I would like to know if the process of migrating from FileMaker to a Revolution/MySQL will compensate the effort. Here is situation: I'm in the final stages of building an Application for Document Management using FileMaker, it works fine, presenting a

Re: Revolution, MySQL vs FileMaker

2006-09-26 Thread Luis
Insofar as I can remember FM Pro allows 5 connections to a client running the database, so a client can effectively be a limited 'server'. You don't need a a copy of FM on every client box, you can use a browser to get at the data (on FM Server and even in the above scenario) although some

Re: Revolution, MySQL vs FileMaker - Part II

2006-09-26 Thread Luis
Ooops! Forgot: FM Pro allows you to create standalone DB front-ends for the clients to access the data, so if you want a 'rich' client experience that could be the way to go (again, limited to 5 connections for an FM Pro 'server'). Cheers, Luis. On 27 Sep 2006, at 1:19, Luis wrote:

Re: Revolution, MySQL vs FileMaker - Part II

2006-09-26 Thread Ruslan Zasukhin
On 9/27/06 3:21 AM, Luis [EMAIL PROTECTED] wrote: Hi Javier, Hi Luis, Ooops! Forgot: FM Pro allows you to create standalone DB front-ends for the clients to access the data, so if you want a 'rich' client experience that could be the way to go (again, limited to 5 connections for an FM Pro