MVC (was Text database using custom properties)

[Dave LeYanna]

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 at 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 at 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