Re: [ANN] Text-file DBs

[Paul Looney]

Kay,

I do mention the different ways different OSes handle the CR/LF/CRLF. Going 
further than that is definitely beyond the scope of the work - and, to be 
honest, beyond my ability.

I can see where Unicode (non-ASCII characters) would be important to users of 
non-Roman languages (BTW, one of my favorite professors was James Heisig, SVD 
who wrote the series of books “Remembering Kanji”, volumes 1 to 3). I firmly 
believe that a database should contain as little “formatting" as possible - its 
purpose is to contain “data”. For our very much “Western”/“Roman” data we need 
nothing beyond ASCII - with only three formatting characters. There is no 
intrinsic reason that a text-file could not support Unicode data - but, for our 
use, that would make it much larger: slower to open, slower to search, slower 
to save, slower to copy, etc. 

I will release the current work under a Creative Commons license - so wiser and 
more knowledgeable people can edit and add to it. Your suggestion would be a 
nice addition.

Chapter XVIII in the current work will be “Using Sockets to communicate with 
Text Files”.

Paul Looney




> On Nov 6, 2015, at 3:51 PM, Kay C Lan  wrote:
> 
> On Fri, Nov 6, 2015 at 1:57 AM, Paul Looney  wrote:
> 
>> 
>> 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):
>> 
>> Paul,
> 
> I don't wish to 'add the straw' on what clearly is a very large
> undertaking, but from a recent thread here I would suggest a topic on
> unicode and char sets. For anyone new to DBs, not just LC + DBs,
> understanding what char set an old DB is using, or what char set to create
> a new DB in and how to handle all the situations in between is a hurdle
> that has to be crossed particularly if their intended stack is to be
> cross-platform. Maybe:
> 
> XVIII. Handling Cross-Platform and non-ASCII characters
> 
> Good luck and look forward to it's completion.
> ___
> use-livecode mailing list
> use-livecode@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [ANN] Text-file DBs

[Kay C Lan]

On Fri, Nov 6, 2015 at 1:57 AM, Paul Looney  wrote:

>
> 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):
>
> Paul,

I don't wish to 'add the straw' on what clearly is a very large
undertaking, but from a recent thread here I would suggest a topic on
unicode and char sets. For anyone new to DBs, not just LC + DBs,
understanding what char set an old DB is using, or what char set to create
a new DB in and how to handle all the situations in between is a hurdle
that has to be crossed particularly if their intended stack is to be
cross-platform. Maybe:

XVIII. Handling Cross-Platform and non-ASCII characters

Good luck and look forward to it's completion.
___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [ANN] Text-file DBs

[Bob Sneidar]

The link to the library is no longer viable. 

Bob S


> On Nov 5, 2015, at 15:42 , Alejandro Tejada  wrote:
> 
> Hi Paul
> 
> After reading your post, I just remember Serendipity Library:
> http://lists.runrev.com/pipermail/use-livecode/2002-September/007745.html
> 
> Do you used this library released by Rob Cozens?
> 
> Al

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [ANN] Text-file DBs

[David Bovill]

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  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 
> is held at Dupar’s in Pasadena. The food is good and the gang is great.
>
> Paul Looney
>
>
> ___
> use-livecode mailing list
> use-livecode@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [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  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  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 
>> is held at Dupar’s in Pasadena. The food is good and the gang is great.
>> 
>> Paul Looney
>> 
>> 
>> ___
>> use-livecode mailing list
>> use-livecode@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [ANN] Text-file DBs

[Matt Maier]

I can bring my webcam in case it's useful.

On Thu, Nov 5, 2015 at 9:12 AM, David Bovill  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  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=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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [ANN] Text-file DBs

[Sri]

Robert Brenstein wrote
> ... Do you have any files that you can share?

+1
By any chance, you can record and throw it on YouTube?
Something I'd really like to attend. Only 2500 miles away!

Regards,
Sri




--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/ANN-Text-file-DBs-tp4698379p4698484.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [ANN] Text-file DBs

[David Bovill]

Thanks Paul - I'd be really interested in helping / proof reading / asking
stupid questions :)

On 5 November 2015 at 17:57, Paul Looney  wrote:

> 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  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  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=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@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [ANN] Text-file DBs

[Alejandro Tejada]

Hi Paul

After reading your post, I just remember Serendipity Library:
http://lists.runrev.com/pipermail/use-livecode/2002-September/007745.html

Do you used this library released by Rob Cozens?

Al



--
View this message in context: 
http://runtime-revolution.278305.n4.nabble.com/ANN-Text-file-DBs-tp4698379p4698515.html
Sent from the Revolution - User mailing list archive at Nabble.com.

___
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [ANN] Text-file DBs

[Paul Looney]

Alejandro,

No, we do not use SDB. We looked at it a decade ago and decided to go a 
different route.

Paul Looney


> On Nov 5, 2015, at 3:42 PM, Alejandro Tejada  wrote:
> 
> Hi Paul
> 
> After reading your post, I just remember Serendipity Library:
> http://lists.runrev.com/pipermail/use-livecode/2002-September/007745.html
> 
> Do you used this library released by Rob Cozens?
> 
> Al
> 
> 
> 
> --
> View this message in context: 
> http://runtime-revolution.278305.n4.nabble.com/ANN-Text-file-DBs-tp4698379p4698515.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
> 
> ___
> use-livecode mailing list
> use-livecode@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Re: [ANN] Text-file DBs

[Robert Brenstein]

I wish I could come. I am tasked to build exactly such a thing for 
the department. Do you have any files that you can share?


RObert

On 02.11.2015 at 21:02 Uhr -0800 Paul Looney apparently 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 
 is held at 
Dupar's in Pasadena. The food is good and the gang is great.


Paul Looney


___
use-livecode mailing list
use-livecode@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode