Multi-user stack question
stephenREVOLUTION at barncard.com
Sat Dec 9 12:43:01 EST 2006
I've had many false starts with client/server databases in Xtalks
since the early 90's. All of them had to talk through ODBC which was
horrible. We bought an SQL database called Butler that almost worked,
but crashed all the time. Eventually we (like everyone else) ended up
I started using MySQL 3 years ago to automate stuff on some websites
and it all came back to me. For my current project I looked at
everything out there but had already gotten familiar with mySQL, so
what the hell.
First I checked out what Rev could do with its built in commands.
Sarah's MSQL stacks at
got me started with that, and it worked beautifully, but the commands
in native rev require a bit of housekeeping and other work - it
looked and acted strangely when I would try to do my own code in it.
And the builder stuff didn't really work very well. I just wanted to
send the MYSQL commands out and get data back!
Then I got Trevor's library, tried a couple of things, had an AHA
moment, and it's all worked really well from here. I rely on it
greatly. It abstracts the more complex revDB calls into much more
If the data exchanged between the users in your app is important, I
urge you to try some kind of client server architecture for major
speed, performance, and security. I highly recommend a high quality
server - it will solve all problems of
where to put the data
how to get it back
how to quickly find, process, sort, collate and format
how to control access, especially simultaneous access
how to index, garbage collect, etc.
If you use anything but a database, you'll have to handle all of that yourself!
So yes, a database is highly recommended. Then one can attack the
unique problem of programming the data and the interface and not
worry about storage!
Although a single user versions of MySQL are available, it should be
noted that professional use of mySQL is NOT free, and that perhapse
even more Rev-friendly (and much more sophisticated) products are out
there such at Valentina, who offer a nice office package with server
and 5 deployments for a very reasonable price. And Valentina is
faster than mySQL with more features, and reads standard SQL syntax
with many more features.
Oh, and Trevor's library will work with Valentina as well.
contact Trevor Devore for further details about his lib. Trevor had
the lib up online but they changed domain names and the old link
doesn't work anymore.
you can see a leftover page explaining how to use it, however this is
for an earlier version - don't use this version 1.4.5 --
>Thanks for responding!
>How do I get RunRev to be multi-user? (w/o using a DB)
>I started using mysql with Navicat to test and I found myself
>putting hours into figuring it out. If I could right a 100% RunRev
>app for everyone on my team that would be great. But, if I have to
>use a database to get the multi-user feature, in your opinion, which
>DB is the easiest to get going (windows based but I can run the db
>on mac if needed).
s a n f r a n c i s c o
- - - - - - - - - - - -
More information about the Use-livecode