[ANN] Text-file DBs

[Paul Looney]

David, Sri, Robert, Bruce, Matt,

Sorry you can’t come tonight. I understand that little "distance problem”.

The presentation will not be recorded. It is hard enough preparing all of the material without spending a couple days deciding what to wear. ;-)

I have been working on a small book (originally 12 pages, now over 80 pages and growing) tentatively titled “Accelerated Data Processing with LiveCode” - based on my 30+ years experience with data processing and decade with Revolution/Rev/LiveCode. There are still two chapters to finish. The last of these is on Text File DBs. I hope to finish it by the end of the year. It will be released under the Creative Commons license and free for downloading.

Here are the chapters (let me know if I missed something, I almost forgot to have a chapter on CSV - a subject about which I have strong feelings):

I.     Have the computer time the process
II.    Indicate that the process is still in process
III.   Lock Screen - or don’t
IV.   Lock Messages - or don’t
V.    Move data to be processed from fields to variables
VI.   Fields, Variables, and Custom Properties
VII.  Filter data before other processing
VIII. Calculate fixed variables once per repeat loop
IX.   Use “Put” instead of “Get and Put” where appropriate
X.    Use multiple single filters - not compound filters
XI.   Use “Repeat for…” instead of “Repeat with i = …”
XII.  Sorts: “forwards”, “backwards”, & “sideways”
XIII. Choosing Delimiters (CSV must die!)
XIV. A word about Arrays, Keys, and Record IDs
XV.  Cards, Relational Databases, and Text Files
XVI. “SQL” & Relational Databases
XVII. Using “Text File” Databases

Each chapter has many code samples.
The Text File chapter will show, step by step, how to create the text file, itself - with code samples for both the server and the clients. I’ve been working on that chapter for a month but still don’t know how big it will be - other than “as big as it needs to be” - there is no publisher dictating chapter or book length.

I appreciate your interest.

Paul Looney



> On Nov 5, 2015, at 9:12 AM, David Bovill <david at viral.academy> wrote:
> 
> Paul I'd love to see the presentation - would be great if you could record
> it or we could arrange to do it as an online session with people from the
> list?
> 
> On 3 November 2015 at 05:02, Paul Looney <simplsol at aol.com> wrote:
> 
>> This coming Thursday evening, Nov. 5th, I will doing a presentation on
>> Text-file Databases at the So. Cal. LUG meeting. If you have wondered
>> whether there is some data processing option between the limits of
>> card-file databases and complexity of SQL RDBMS, come and find out. I will
>> show how to build a multi-user, client/server database management system -
>> entirely in LiveCode.
>> 
>> The monthly meeting <http://forums.livecode.com/viewtopic.php?f=50&t=25476>
>> is held at Dupar’s in Pasadena. The food is good and the gang is great.
>> 
>> Paul Looney
>> 
>> 
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode