David;
I read a little about the benefits of using MVC but I had a little
trouble mapping that paradigm to Rev. One of the major issues wasn't
really Rev related but really needed to be thought through and I came up
blank and confused. I want to store as much business logic as I could in
the main storage platform which is PostgreSQL as stored procedures and
triggers. I also want the flexibility to use SQLite on the desktop so I
have to be able to have it in the controller????
How do I use Rev, local desktop SQLite and PostgreSQL and PostgreSQL
stored procedures and triggers?
I just thought that you may have worked this kind of thing out.
I really would like to use MVC if I can because I am on the brink of a
LARGE project that needs to last a long time and go through a lot of
contortions by many different programmers over it's lifetime. We are a
non-profit and I am "converting" an old FoxPro for DOS system that was
started in the 80s (and still runs in a DOS window... on a 50 user
network with some data access provided to 5 other offices across the state.
Dave
David Bovill wrote:
I think it should work fine - have not stress tested the approach yet
- but it is what I use (custom properties linking the index to the
structured text files).
I have just started using an MVC (model view controller) architecture
for all my Rev apps - which has been a lot of work figuring out how
best to do it. What this allows you to do is change the way you store
your data very easily - so you can opt for using custom properties as
your data model, text files, or a database. So far i am quite
impressed how the MVC architecture helps structure your work -
especially if you are looking at creating generic components.
On 10 Dec 2005, at 01:13, Brian Alleyne wrote:
Hi all
I am building a note and outline manager in rev. I've worked out my
user interface, but before going further I wanted to seek some
advice on text handling before working on the data engine.
I will store memo fields of various lengths, these would have
styled text, and would be typed in or imported in html or rtf form
from other applications. Some of these memo fields could run to 50
or 60 pages of text. I will need to quickly search for any word or
string in these memo fields. I expect to store potentially thousands
of these memo fields.
I was thinking of creating a data stack and storing the memo fields
as custom properties - in essence using rev as my database. I've
read Dan Shafer and Richard Gaskin on this, and if I understand
them, it seems as if this is a reasonable way to go.
In sum, is rev good for a freetext database with thousands of memos
or should I be looking at something like Valentina?
I am worried about the performance hit on searching when my database
grows to say, 10000 memos.
Any advice is welcome.
best regards,
Brian
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
--
Dave LeYanna
Director IS
Right to Life of Michigan
www.rtl.org
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution