Re: Text database using custom properties
Brian, I'm no expert on these subjects, but I offer a couple of observations from my experience: - You'd probably want to save an optimized, plain text version of each memo, indexed to the styled-text memo, to speed up the search. - both the 'find' and 'offset' commands are very fast, even on long texts. - Could you read the text in from an external file, say, into a variable, then do the search. Reading in external files is also very fast. - If you plan on doing complex searches you might be better off in a SQL environment. Devin On Dec 9, 2005, at 3:44 AM, 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 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 10, 000 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 Devin Asay Humanities Technology and Research Support Center Brigham Young University ___ 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
Re: Text database using custom properties
I would be interested in seeing more details about how you managed to set up MVC architecture in Rev, which lacks object orientation and therefore seems to me to defy the ability to do so. But I'm willing and eager to learn. I'm a HUGE fan of MVC. On 12/12/05, David Bovill <[EMAIL PROTECTED]> wrote: 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. -- ~~ Dan Shafer, Information Product Consultant and Author http://www.shafermedia.com Get my book, "Revolution: Software at the Speed of Thought" >From http://www.shafermediastore.com/tech_main.html ___ 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
Re: Text database using custom properties
To: "How to use Revolution" Subject: Re: Text database using custom properties Dom <[EMAIL PROTECTED]> wrote: Take also a look to VoodooPad... there is free "Lite" version, but the interesting features belong only to the full version... I forgot a link: http://www.flyingmeat.com/voodoopad/ Hmmm Looks like my first RR project WikiRev, due for exposure in a couple of days, as soon as I finish using it to write its own docs. Also looks like my own WikiWriter at http://hytext.com/ww which is Windows-only but inspired my efforts to work on a cross-platform version in RR. Great minds, parallel thoughts Jerry Muelver ___ 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
Re: Text database using custom properties
On 12/12/05 6:29 AM, "Dom" <[EMAIL PROTECTED]> wrote: > The puzzling thing, is that after testing note taking apps, I always > return after a time to plain text notes (sorted by gross categories and > dates -- year, month) > Agreed. I use a very large, single document that I open in BBEdit. This allows Find All and a variable format for anything I want to enter. Fast, simple, copy-paste web page order confirmations, cr cd purchases, shipping info, my tennis buddies list is in one paragraph, etc. Doesn't do graphics, but can store a link to a pdf or jpg, etc. I start with the premise that databases are excellent at hiding information. Of course, they are excellent at retrieving and organizing stuff, but that is not what I usually need. They also require structure, and that is rarely what I need :-) Jim Ault Las Vegas > Jim Ault <[EMAIL PROTECTED]> wrote: > >> Well, depending on how much this is a labor of love vs need-to-get-it- >> running-soon, you might check out NoteTaker. Dan Shafer recommended it and >> I decided very quickly to buy it. >> www.aquaminds.com >> >> Very powerful, and does automatic indexing on >> Categories, Date, Documents, Email addresses, last changed, numbers, >> priority, Proper Words, Text, Web Sites. > > Take also a look to VoodooPad... there is free "Lite" version, but the > interesting features belong only to the full version... > >> >> Each entry in the outline can even display an active web page of the link it >> contains. >> >> But if you are like most of us... >> building your own is what appeals to you :-) > > Same thinking about VoodooPad... I reached the limit with the full > version, but not yet decided to buy it... why not writing a similar > thing in Rev??? > > But I am not so fluent in Rev ;-> > Although I wrote years ago something equivalent in HyperCard... > > The puzzling thing, is that after testing note taking apps, I always > return after a time to plain text notes (sorted by gross categories and > dates -- year, month) ___ 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
RE: Text database using custom properties
I wrote a task-oriented to-do list program, which I use for notes, links, and to keep track of everything I do for work. It is free, of course, and can be found at www.WorkMage.com. The actual tasks/notes app, which will appear when Work Mage self-installs is called Task Mage. You guys are welcome to treat it as public domain, and use any or all parts of it as you need. You guys might like it - and it is written in Rev - it is intuitive for me (but then, I wrote it) - hopefully it is intuitive for others. Cheers, Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dom Sent: Monday, December 12, 2005 9:29 AM To: How to use Revolution Subject: Re: Text database using custom properties Jim Ault <[EMAIL PROTECTED]> wrote: > Well, depending on how much this is a labor of love vs need-to-get-it- > running-soon, you might check out NoteTaker. Dan Shafer recommended it and > I decided very quickly to buy it. > www.aquaminds.com > > Very powerful, and does automatic indexing on > Categories, Date, Documents, Email addresses, last changed, numbers, > priority, Proper Words, Text, Web Sites. Take also a look to VoodooPad... there is free "Lite" version, but the interesting features belong only to the full version... > > Each entry in the outline can even display an active web page of the link it > contains. > > But if you are like most of us... > building your own is what appeals to you :-) Same thinking about VoodooPad... I reached the limit with the full version, but not yet decided to buy it... why not writing a similar thing in Rev??? But I am not so fluent in Rev ;-> Although I wrote years ago something equivalent in HyperCard... The puzzling thing, is that after testing note taking apps, I always return after a time to plain text notes (sorted by gross categories and dates -- year, month) ___ 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
Re: Text database using custom properties
Dom <[EMAIL PROTECTED]> wrote: > Take also a look to VoodooPad... there is free "Lite" version, but the > interesting features belong only to the full version... I forgot a link: http://www.flyingmeat.com/voodoopad/ -- Revolutionario ___ 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
Re: Text database using custom properties
Jim Ault <[EMAIL PROTECTED]> wrote: > Well, depending on how much this is a labor of love vs need-to-get-it- > running-soon, you might check out NoteTaker. Dan Shafer recommended it and > I decided very quickly to buy it. > www.aquaminds.com > > Very powerful, and does automatic indexing on > Categories, Date, Documents, Email addresses, last changed, numbers, > priority, Proper Words, Text, Web Sites. Take also a look to VoodooPad... there is free "Lite" version, but the interesting features belong only to the full version... > > Each entry in the outline can even display an active web page of the link it > contains. > > But if you are like most of us... > building your own is what appeals to you :-) Same thinking about VoodooPad... I reached the limit with the full version, but not yet decided to buy it... why not writing a similar thing in Rev??? But I am not so fluent in Rev ;-> Although I wrote years ago something equivalent in HyperCard... The puzzling thing, is that after testing note taking apps, I always return after a time to plain text notes (sorted by gross categories and dates -- year, month) ___ 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
Re: Text database using custom properties
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, 1 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
Re: Text database using custom properties
Brian, Your approach sounds good. We have been doing something similar. We started with HyperCard stacks with tens of thousands, and hundreds of thousands, of records. Converting them to Rev stacks bloated them significantly; 2 meg. HC stacks ballooned to almost 8 meg. Using a text file for the data required less than 2 meg. Going to custom properties will (in our experience) increase speed of access to the data 3 to 10 times. CPs will also help you avoid one limit in Rev: lines in fields can not be more than approx. 65k (normally not an issue, but a significant one when using lines to display database records. Paul Looney -Original Message- From: Brian Alleyne <[EMAIL PROTECTED]> To: use-revolution@lists.runrev.com Sent: Sat, 10 Dec 2005 00:13:52 + Subject: Text database using custom properties 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, 1 memos. Any advice is welcome. best regards, Brian ___ use-revolution mailing list [EMAIL PROTECTED] 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
Re: Text database using custom properties
On 12/9/05 4:13 PM, "Brian Alleyne" <[EMAIL PROTECTED]> wrote: > I am building a note and outline manager in rev. > Any advice is welcome. (the entire quoted below) Well, depending on how much this is a labor of love vs need-to-get-it- running-soon, you might check out NoteTaker. Dan Shafer recommended it and I decided very quickly to buy it. www.aquaminds.com Very powerful, and does automatic indexing on Categories, Date, Documents, Email addresses, last changed, numbers, priority, Proper Words, Text, Web Sites. Each entry in the outline can even display an active web page of the link it contains. But if you are like most of us... building your own is what appeals to you :-) Jim Ault Las Vegas > 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, 1 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
RE: Text database using custom properties
I wrote a program that does some of the things you are talking about. It stores data in custom properties of a couple of buttons, and then autosaves each memo (or in my case each task) to a separate file whenever you change from one task to another. It works real well, and is pretty much instantaneous. Rev seems to process data in custom properties quite quickly. Even for 10,000 memos, I bet your performance will be acceptable. I would suggest that all of your memos be saved in their own file. This means you can program it to autosave each memo when you are done with it. Let me know if you want to check out the program, and I can give you a link. It's got a ton of coding in it, so I might have to tell you where to look in the scripts to find out how to do particular things. Cheers, Jonathan -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brian Alleyne Sent: Friday, December 09, 2005 7:14 PM To: use-revolution@lists.runrev.com Subject: Text database using custom properties 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, 1 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
