On Mar 23, 2004, at 1:43 AM, Bruce Robertson wrote:
There is nothing that prevents you from using that approach with
Filemaker
also if you want to; or you could use the easier native record locking
options.
I don't quite understand how you lock a record without knowing what
record
you're
On Mar 23, 2004, at 11:59 AM, Rick Harrison wrote:
All you would need to do would be to create extra fields in your
MySQL database, something like:
RECORD_LOCKS
lockedBy: yennieb
lockTime: 278236472
damnn... and I never thought of that... we could make a stack to handle
this automatically...
Various hand-crafted MySQL record locking schemes are discussed in most
MySQL books.
(pssst. the reason some people subscribe to lists like these is to
avoid having to buy books.)
j.
___
use-revolution mailing list
[EMAIL PROTECTED]
I don't believe MySQL has any built-in record locking functionality-
that's the bad news. The good news is that even if it did, it would be
about the same amount of work in the simple case.
Suppose you were to write a front-end in Revolution, and had no
control over the back-end (other than
On Mar 23, 2004, at 11:15 AM, Bruce Robertson wrote:
This is very useful information, thank you for sharing it with us.
What happened to the Unlimited Version?
Server feature are now strictly in Server, and there are 2 versions.
Server
7 and Server 7 Advanced. Advanced has the web publishing
I installed the cgi-engine (Rev 2.0 for Linux) in the cgi-bin of my server
provider (Linux/apache) an it work great ... then i tryedtoconnectto a
mysql-database after having
- uploaded the database-driver (dbmysql.so from the Linux folder) to the
server
- set the permission of the file
FileMaker doesn't seem to understand the concept of record locking when
multiple users on the internet are trying to access the same record
at the exact same time.
And you do? MySQL does? I don't think so.
The internet is stateless. If you want to build a custom record locking
solution for
On Mar 23, 2004, at 12:19 AM, Bruce Robertson wrote:
And you do? MySQL does? I don't think so.
The internet is stateless. If you want to build a custom record locking
solution for web transactions, you can do it and you will face the same
issues in any system. It only takes a very simple
Worth noting that for a web app, if you are going to lock records then
those locks must timeout after a while- otherwise someone can leave
something locked forever, and there is no way for you to detect for
sure that they are gone.
And you do? MySQL does? I don't think so.
The internet is
On Mar 23, 2002, at 12:37 AM, Brian Yennie wrote:
Worth noting that for a web app, if you are going to lock records then
those locks must timeout after a while- otherwise someone can leave
something locked forever, and there is no way for you to detect for
sure that they are gone.
yes... I
On Mar 23, 2004, at 12:19 AM, Bruce Robertson wrote:
And you do? MySQL does? I don't think so.
The internet is stateless. If you want to build a custom record locking
solution for web transactions, you can do it and you will face the same
issues in any system. It only takes a very simple
And you do?
I don't think you have to be insulting if you want to disagree, or you
have
anything positive to add. Why do you think people are starting to not
ask their important questions on this list? Its a bad trend.
MySQL does? I don't think so.
Someone told me MySQL handled it, I'm open to
Someone told me MySQL handled it, I'm open to the suggestion that
the information may be incorrect. That's why I was asking the
question.
Many people have been trying to move away from FileMaker Pro to MySQL
because of these issues and multi-threaded issues. A decent database
should handle
And you do?
I don't think you have to be insulting if you want to disagree, or you
have anything positive to add. Why do you think people are starting
to not ask their important questions on this list? Its a bad trend.
Is it a better trend to not understand a product or technology and yet
Richard, can you describe what you mean by custom property arrays... Jim
on 3/17/04 5:33 PM, Richard Gaskin wrote:
I get much more mileage out of Rev for the UI, using any of the database
interfaces provided. And more often than not I'm working with data sets
small enough that just stashing
When I go to http://www.mysql.com/downloads/index.html
I don't see the adjectives Classic or Pro on the free download. I do
see words like SAP for the MaxDB version which I recognize as high end DB
stuff that lead me to think that the version of MySQL available there is
capable of handing
Hi there,
I really appreciate everyone's responses as to which Databases they
like to use
with Revolution and why.
Unfortunately for me if I'm going to migrate from FileMaker Pro to
MySQL I have my
work cut out for me for a long time as I have a lot of time invested in
FileMaker. I keep
Richard Harrison wrote:
Unfortunately for me if I'm going to migrate from FileMaker Pro to MySQL
I have my
work cut out for me for a long time as I have a lot of time invested in
FileMaker. I keep
hoping that FileMaker will get its act together when the time comes
that I'm ready to deploy my
On Mar 20, 2004, at 4:22 PM, Richard Gaskin wrote:
Richard Harrison wrote:
...
If anyone has an easy solution to this please let me know.
There's a FileMaker to MySQL migration kit:
http://www.fmpromigrator.com/
I beleive it was even made with Rev.
--
Richard Gaskin
Thanks for the URL!
Rick
On Wed, 17 Mar 2004 13:33:55 -0800, Richard Gaskin
[EMAIL PROTECTED] wrote:
[snip]
Only one menu can be
modified, scripts are tiggered by very few events, and it has little if
any support for native controls.
Is script-tiggering a kind of bouncing? Something Scott Rossi should be
interested
--- paolo [EMAIL PROTECTED] wrote:
I want to connect to a MySQL database from the
revolution engine posted on
the CGI-BIN folder of my server provider
(linux/apache).
I guess I need the MySQL library for linux ...
but... where can I find it?
I found the
libmysql.dll for windows ...
--- John Dixon [EMAIL PROTECTED] wrote:
I am interested to know what database people are
using with Revolution.
What seems to be the favourite and for what
reason... Are you using MySQL,
Postgres or Valentina, for example... What prompted
your choice ? Are
you using databases in a
Jan... I went looking at the MySQL home page to check it out. What's the
real difference between the Classic and Pro versions. The only explanation
I could find was very jargon heavy... Jim
on 3/17/04 8:47 AM, Jan Schenkel wrote:
--- John Dixon [EMAIL PROTECTED] wrote:
I am interested to
--- jbv [EMAIL PROTECTED] wrote:
Jan,
I just read the message you posted on the Rev list :
In your (GUI) Revolution directory you'll find all
the
database drivers for Linux in :
/components/global
environment/database_drivers/linux/
You'll find the revdb library for Linux here :
--- Jim Carwardine
[EMAIL PROTECTED] wrote:
Jan... I went looking at the MySQL home page to
check it out. What's the
real difference between the Classic and Pro
versions. The only explanation
I could find was very jargon heavy... Jim
If I interpret it right, the 'Classic' version is the
PROTECTED]
Sent: Wednesday, March 17, 2004 9:04 AM
To: Revolution Listserve
Subject: Re: Database Experience
When I think of a transaction I think of updating data to the database.
Does this mean that the Classic version only supports queries, but can
support multiple user queries, where Pro supports
--- Jim Carwardine
[EMAIL PROTECTED] wrote:
When I think of a transaction I think of updating
data to the database.
Does this mean that the Classic version only
supports queries, but can
support multiple user queries, where Pro supports
multiple user updates as
well? Jim
A transaction
--- Richard Harrison [EMAIL PROTECTED]
wrote:
I see a lot of people talking about MySQL, what
about FileMaker Pro?
Especially the new version 7?
Are there reasons that people aren't using FileMaker
Pro? Isn't it
quick enough or does it not interface well with
Revolution? Isn't it
--- jbv [EMAIL PROTECTED] wrote:
Actually, my whole Linux Postgresql will be
installed
for me by my ISP on a dedicated server.
So, can I assume that the right drivers will be
installed at
the right place, and that all I have to do is
install the Linux
Rev-cgi engine, and then make a call
command, and can be rolled
back by another specific command. Of course in a general sense you are
correct.
-Original Message-
From: Jim Carwardine [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 17, 2004 9:04 AM
To: Revolution Listserve
Subject: Re: Database Experience
When I
Yes, that plus Richard's comments were very helpful... I now clearly
understand. (See my comments to Richard) Thanks... Jim
on 3/17/04 11:56 AM, Jan Schenkel wrote:
--- Jim Carwardine
[EMAIL PROTECTED] wrote:
When I think of a transaction I think of updating
data to the database.
Does
In fact, I do have another question. If I read the Rev docs correctly,
unlike HC, in an interactive app, Rev will not update data held in a
standalone but will update data held in a second Rev file (or other text or
SQL file). If I update pictures to a button icon or modify a custom
property of
--- Richard Harrison [EMAIL PROTECTED]
wrote:
I see a lot of people talking about MySQL, what
about FileMaker Pro?
Especially the new version 7?
Are there reasons that people aren't using FileMaker
Pro? Isn't it
quick enough or does it not interface well with
Revolution? Isn't it
...what about FileMaker Pro? Especially the new version 7?
FMPO v7.0 is indeed a great upgrade, and while I'll continue to use it
internally I still can't use it for client projects.
When I get a new project for which a database would be the solution, I
inclue FMP in an evaluation matrix and
Hi John,
I am interested to know what database people are using with Revolution.
What seems to be the favourite and for what reason... Are you using MySQL,
Postgres or Valentina, for example...
I use Serendipity Database--Binary, or SDB.
What prompted your choice ?
I had used a HyperTalk
My need right now is not a server/shared DB, but just being able to
sync data gathered at different times into a desktop DB so it can be
searched, sorted, and printed. Windows/Mac and Palm/PocketPC
On Mar 15, 2004, at 10:27 PM, Andre Garzia wrote:
On Mar 16, 2004, at 2:57 AM, John Tenny wrote:
John,
Any information on this would be appreciated for an article on database use
that I am working on.
I gathered some additional thoughts from private posts to send you
off-list; but I no longer have your original message or private
eAddress:
Date: Wed, 25 Jun 2003 09:13:25 -0700
To: Tuviah
I am interested to know what database people are using with Revolution too.
I want to connect to a MySQL database from the revolution engine posted on
the CGI-BIN folder of my server provider (linux/apache).
I guess I need the MySQL library for linux ... but... where can I find it?
I found
I am interested to know what database people are using with Revolution.
What seems to be the favourite and for what reason... Are you using MySQL,
Postgres or Valentina, for example... What prompted your choice ? Are
you using databases in a personal or commercial capacity ?
Any information on
On Mar 15, 2004, at 4:47 PM, John Dixon wrote:
I am interested to know what database people are using with Revolution.
,,,
Rather than posting your replies to the list, if you would reply to me
offlist... That'll keep a lot of people happy.
Kind regards,
John Dixon
I'd be interested in
On 16/03/2004, at 8:47, John Dixon [EMAIL PROTECTED] wrote:
I am interested to know what database people are using with Revolution.
What seems to be the favourite and for what reason... Are you using
MySQL,
Postgres or Valentina, for example...
Valentina
What prompted your choice ?
Speed
In genaral I work with PostgreSQL on a mac g3 400 power book , No
problem except that Postgres is a pain in the neck, command line .
Other then that not to complain it doesn't ask for much , just for SQL
, but thats about it once its up , its up and flying
RunRuv + Postgres =much faster
Rick,
I asked for replies offlist because I did not want to get flamed for asking
for information to be posted to the list that some (many?) might regard as
being way off topic... But if people wish to reply with their opinions to
the list, who am I to argue about it.
Regards,
John Dixon
On
I'd also suggest that RR should have a native driver for OpenBase. a
commercial db. Its fast , stable, very easy to use and install, very
nice GUI (no command line necessary), portable ( cross platt.), many
years on the market , bundles good as a commercial package. and
inexpensive.
hershrev
On Mar 15, 2004, at 6:36 PM, John Dixon wrote:
Rick,
I asked for replies offlist because I did not want to get flamed for
asking
for information to be posted to the list that some (many?) might
regard as
being way off topic... But if people wish to reply with their opinions
to
the list, who
I am interested to know what database people are using with Revolution.
Interesting question and worth posting to the list as it will be
fascinating to see what people use.
I have tested MySQL and found it to be good for multi-user purposes,
but for single user data access, I prefer to use
And what's been the experience with importing data from PDAs into Rev,
in some database format? How y'all doin' that?
John
Peace,
John
John L. Tenny, Ph.D.
Flowing Thought Educational Solutions
eCOVE: The Observation Toolkit Software
www.flowing-thought.com
[EMAIL PROTECTED]
On Mar 16, 2004, at 2:57 AM, John Tenny wrote:
And what's been the experience with importing data from PDAs into Rev,
in some database format? How y'all doin' that?
John
Thats tricky depends on the plataform... but you could play like
this, is you PDA connected to the internet and able to
48 matches
Mail list logo