dalton.calford at gmail.com
Thu Apr 11 15:31:58 EDT 2019
In order to explain what I need the utility for, is as a front end to a
highly normalized warehouse Temporal Graph database.
That probably means nothing to you, but, lets assume it does for the time
For a simple example, lets say we are dealing with addresses, 2.6 billion
addresses, along with geo location.
The database does not contain nulls, data tuple width is variable based
upon a recursive multi-parent relationship.
Language/Locale information is part of the data structure
The client connects to a local embedded database which only is used for
work que's and caching and it in turn will connect to the middle tiers for
data synchronization/load balancing
Authentication is a round robin authkey token passed between the various
layers over an encrypted database to database channel.
(no, this is not star trek technobabble, it is actually a 10000' summary of
For discussions sake, lets agree upon some terms.
*Viewers* is not natural to me as I never heard the term used before this
discussion. Lets use a different term
*DataPanel :- *This is the ultimate goal.
Ok, in order to explain what is going on, lets begin with a description of
a data warehouse problem.
A simple address.
An address has multiple elements, almost all of them defined identically -
a text string. Depending upon your location on the planet, the details
are very different. You could have street numbers or a building number
within a block. You can have rural or municipal addresses etc. Not all
address fields are needed for every address, and you do not want a single
null (undefined data) in the database.
So, in order to handle this, each address has a unique id, this is the
master link. That master link is also linked to a definition of fields
that comprise this particular address. So, the first address is [street
number][street name] while the second is [plot number][rural road
number][municipality]. So two addresses, in the same table, with totally
different columns. You can add columns to the addresses on the fly, you
can even self populate the columns (surface them) based upon postal code.
Now, this is a full discussion on its own, but, it makes data very easy to
For example, lets say, you have 100 addresses, each address is in one city,
that city is in a state and that state is in a country.
Each one of those addresses would have a pointer to the city, which has a
pointer to the state, which has a pointer to the country.
So, you only ever have the country entered once in the database (with a
list of how it is used in various languages), same with state and city.
This cuts the total size of the database enormously.
In order to handle a situation like this, you need a series of embedded
hmmm, I am thinking this may be very boring for the majority of people on
this list, perhaps there is a better list than 'using livecode' for this
On Thu, 11 Apr 2019 at 14:58, Richard Gaskin via use-livecode <
use-livecode at lists.runrev.com> wrote:
> Dalton Calford wrote:
> [lots of valuable stuff bookmarked but not quoted here only for brevity]
> > But, if you are still with me, I am willing to explain what I use, how
> > I use it, how it is used in many different applications and languages
> > and why.
> > I can provide specifications, tests and other aspects. I am not
> > asking for you to do the work, but, if you are willing to work with
> > me, as I learn the in's and out's of livecode, I am sure we can come
> > up with something.
> I like that collaborative spirit. This helpful community is quite good
> that way.
> Maybe the simplest starting point would be a real-world example of
> immediate interest: what are you building that needs Viewers?
> Richard Gaskin
> Fourth World Systems
> Software Design and Development for the Desktop, Mobile, and the Web
> Ambassador at FourthWorld.com http://www.FourthWorld.com
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the Use-livecode