^LIF5BS:  (under construction; ~15% complete) 

1. ^LIF5LC:  Intro

   1. ^LIF5R7:  This to be the leading repository for table definition & constructs used on JotHere.com.
   2. ^LIF5ST:  It aims to include the following:
      1. ^LIF5TA:  Component definitions, including
         1. ^LIF5XT:  Columns
         2. ^LIF5V7:  CSS code
      2. ^LIF5TK:  Table definitions (which are chiefly collections of the above)
      3. ^LIF605:  It draws upon & (may become the future home of) my other leading table work including
         1. ^LIF62A:  term_etal_LF7LKL
         2. ^LIF6AE: =6AE: KM37RH/_self_KY9VY8/history_KY9V40/L02F67.ods
         3. ^LIF7RW:  KM37RH/style_KMW0XW/template/table/_KZQ0N7.htm
   3. ^LIF5YP:  It is quite possible because of the extent of coverage this will need to be broken into sub-posts.

2. ^LIF7T1:  Backend-Technology options (for tables)
   

   1. ^LIFEYM:  comparison table
      

      	LIF80C:	LIFF0J:	LIFXDV:	LIFJJF:	LIFSR7:	LIGRWX:	LIF89D:	LIGQSB:	LIGQQT:	LIF8SF:	LIF81R:	LIF8SP:	LIF85A: LIF85A	LIF8XS:	LIF8XK:  LIF8XK
      ID + Link(s)	description
      LIF8W3:	col header1	use on	use on	synergy with	data	data	code	code	code	display	display	edit	edit	edit	edit
      LIF801:	col header2	1.JotHere.com	notable sites		expressiveness	portability	capabilities	cleanliness	portability	in full	in full	in full	in full	snippet	snippet
      LIF8UU:	col header3	2011.03.21		HTML						tools	max size	tools	max size	tools	max size
      LIF80J: XHTML table-tag or similar CSS	XHTML table-tag, or similar CSS	heavy		identical	high; dynamic nest-able types & somewhat extensible.	medium for computation (revert to XML), high for viewing IF in the format one needs	LIJB08:  minimal or 0			web browser	100s of rows, .4MB example	MS Expression Web	LIJAXT:  ~100 rows * ~15 columns	none?
      LIFF3E:	Google Docs Spreadsheet	considering		"just" display live in iFrame			medium (JavaScript)			web browser		web browser
      LIF82T:	spreadsheet as .odt	only in background, as 6AE		export to XHTML but not well-supported			medium			OO Calc	same as editing	OO Calc	LIJC03:  ~1000 rows of say 15 columns, as 6AE
      LIF8D5: LIF8D5	XML DB as eXist or MarkLogic	LIGUKH: =LIGUKH: starting to try to move to it, likely on 2.JotHere.com	"O'Reilly Media uses MarkLogic Server to power its ground-breaking SafariU custom publishing application." said 2007.04 (2,3); I also recall hearing Safari Books Online (as a whole) heard this by an XQuery presenter at a 2007.01 SoCalCodeCampp; other MarkLogic users & here.	top (XHTML is  a subset); XRX is also notable, esp w/ GS[XSLTForms] and  XQIB (fr here)	Among highest available. Fully dynamic, nest-able, & extensible types, all which most. Some troublesome arbitrariness as (store as an attribute value or a tag value).	highest. The leading format	high; [LIGRQJ:  GS[XML DB spatial] finds some as in eXist; MarkLogic offers.] [LIGRRV: pivoting appears ~as easy as could be, easier than SQL, so easy it's not worth mention; but GS[XForms pivot table] found none.] [LIGRS8: Cached- & lazy-computation of queries? GS[cached views XML] shows academic work on that; still probable given NN]	seems very high (using leader  XQuery). (nest-able?) ops take & return core powerful data-type (XML).	seems high/ immediate			oXygen XML editors		XQuery, may interfaces	[LIGRNN: =NN:  MarkLogic std up to 40GB & ~"100s TB via cloud"] [LIGROU: ~"110MB" as of "February 2006" .]
      LIFJGP:	additional DB in XML vs. SQL	Since we can start fresh, seems best to start with XML DB, the better choice (perhaps given time) if support for it continues to grow.		Simulate XInclude & XQuery it in PHP suggests XML is #1 for inter-op, so useful to simulate it (as perhaps when one's not lucky enough to start w/ an XML DB?)	Seemingly all SQL DBs output to XML for portability. XML much more expressive now & offers greater potential if properly supported.
      LIF83E:	SQL DB as MySQL	(beyond WordPress,) considering strongly		not natural but well-supported	medium: required structure powerful when it near-exactly fits but constraining when it doesn't or when partially fits. Typically requires programmer (formal schema edits) to extend (unless variable-field extensions used, which are possible but non-standard & not-well supported). Limited static types usually (unless say SQLite). Data NOT readily nest-able unless one builds nesting structures which then easily complicate code. Text, even XML, is not typically  parsed & indexed in any way by default except for full-text search, unless XML support added. Ops take & return tables mostly.	medium-high (as structure is constraining) to (medium due to regular exceptions). Exceptions: a field is dynamically typed in SQLite, not in other SQL.	highest (including OLAP ). [LIGRTT: Query from SQL shows XQuery seems somewhat more expressive but that doesn't get into high-end SQL.]	seems medium to high	seems requires translation in most cases, esp. given stored-procedure syntax & needed extensions are not standard		?		?	SQL Update, many interfaces, incl. MySQL Workbench	~100GB here(search for MySQL) suggested by here

      ^LIF7TN:  As an example reading this table, from it one can see tables < ~100 rows * ~15 columns which require minimal or 0 calculations can be done as an XHTML table-tag or similar CSS.

3. ^LIJB3V:  (JotHere table) to capture change (~10% complete)

   1. ^LIJB7O:  Introduction

      1. ^LIJB5C:  Systematically & completely capturing change/actions, for recording them (history) and (to a lesser degree) planning them, has been a profound interest of mine since ~1995.
      2.  ^LIJB82:  This section
         1. ^LIJBMH:  references & overviews & compares my work on the subject (past & present)
         2. ^LIJBHD:  presents some of my recent developments in this area, including
            1. ^LIJBHV:  serves as templating for such tables (what a use of a table can point to so the reader can know how to use & interpret it, plus defines for it a template & CSS code)
         3. ^LIJBK6:  holds further research on the topic.
         4. ^LIJBBA:  Has target areas of to document the changes (past & future)
            1. ^LIJBQ8:  of
               1. ^LIJBC6:  Any article/post/document, which I generalize as section (since sections can endlessly nested)
               2. ^LIJBD7:  IT system administration operations including maintenance to websites and a computers.
               3. ^LIJBES:  Versioning file-systems especially VCS
            2. ^LIJBQL:  as need by
               1. ^LIJBQW:  this site (JotHere.com) & its users
               2. ^LIJBR6:  but ideally it could be for anyone, too.

   2. ^LIBUFR:  action/change table (under construction)

      LIBUQB:

      LIBXD8:

      LIBUSV:

      LIBVZB:

      LIBWFZ:

      LIBW56:

      LIBVK2:

      LIBZKO:

      ID + Link(s)

      (link(s) situation just prior to start, giving enough detail to recreate)

      plan name

      description (including JavaScript, else English defining it using -ing verbs) Planned Actual

      Starting When: Planned Actual

      Dur­ation Planned Actual

      Ending When: Planned Actual

      (link(s) to) Further: Planned Actual

      Reasons including inspiration & preparation

      in effect: "was", "is", "will-be", or blank "Likelihood" (defaults to 100%)

      :

4. ^LIH4I5:  (table) Column definition table

   ID + Link(s)	Parent(s)	Definition	Importance	Column CSS
   LI3922:  Li_Vert		Of ol & ul, sets the top & bottom margin to be 0 (instead of the default of 1)	LI3DEP:  more often than not, I find this additional space wasteful & unhelpful, especially in a table cell but not just. LI3DGM:  This default setting 0 is used in WordPress and seemingly many other popular websites. LI3DRN:  this already is the default setting for ol & ul nested directly in another ol or ul.	/*LI3D40: */ol,ul,.Li_Vert_LI3D40{/* LI3D8Y: */margin-top:0; margin-bottom:0;/* */}
   LI39G6: CSS statement(s)		A collection of CSS statements. In particular here I define a class CSS_statements_LI39IH which is used as follows: LI3A5Q:  applied to a div, the div serving as easy way to demarcate and select the CSS statements. LI3A70:  Iff the CSS is to be included inline, the div is proceeded by <style type="text/css">…</style> were the contents of that is set to be the ASCII-only contents of the div every time after the div contents have been edited.	LI3ACC:  High, as it's used LI3ADG:  to define all the CSS used in this page LI3AEG:  ideally to define all the CSS on the site 1.JotHere.com and ideally other sites.	/*LI39IH: (div)*/.CSS_statements_LI39IH{/* LI3AV7: don't use say font-family:monospace; despite that's the convention for code as it wastes space (being monospace) and is not as pretty, and I want code to look prettier especially when now it's included along with HTML and can include full HTML, plus this encourages writing more comments. LI39VK: */background:aqua;/* -might be too highlighting & intense, but works for now. */}
   LI3GIN: named UID link		A named link (a-tag) to a universal ID anchor; example: "named UID link"	LI3GLY:  Highest as it's used all references here.  LI3HIT:  As with any HTML link, it's good to create a nicely named link at the destination in advance: then to create a nicely named reference to the destination, one just copy that nicely named link. LI3HTY: Also because the anchor is a global unique ID, generally many good things are possible. LI3HI3:  In short I find this essential, key, & indispensible.
   LI3EMK: ID + Link(s)		In a table, contains the universal ID for the row plus any named UID links to it/here (each also giving a name to it) each separated by a space. If the first row of column headings also contains this kind of value, this also applies to them, too, even though/if it's not listed to the left/right of them.	LI3G9C:  High as it's used for all tables, to name the rows & reference the rows & columns LI3GAR:  For each table, for every data row, and optionally for every column (including the ID + Link(s) itself), it allows a globally unique (universal ID) be given, along with a link to it plus name(s) to it. LI3HVO:  all the advantages from using a named UID link LI3IFQ:  See The only row or column without IDs are the header rows	/*LI3EYT: (col)*/.ID_n_Links_LI3EYT{/* LI3F0N: */width:4em;/* */}
   LI3LKQ: Parent(s)  categories		named UID link(s), separated by space, to immediate parent concept(s). Think parent section in an outline.	LI3LOC:  High. Used a lot here. See compared to an outline.	/*LI3MSH: (col)*/.Parents_LI3MSH{/* LI3MUJ: */width:3em;/* */}
   LI3KE0: Definition		Definition. This was also " & Description" so some cells may still have description text as well.		/*LI3KKP: (col)*/.Definition_LI3KKP{/* LI3KM8: */width:18em;/* */}
   LI1JBB: Importance		Importance. Note this could include usage if that's what establishes the importance, as usage often does.		/*LI38M6: (col)*/.Importance_LI1JBB{/* LI38RI: */width:20em;/* */}
   LI36Z9:  Column CSS		CSS statement(s) to define the column LI39CZ:  Use this entry's value for Column CSS as a starter template for other table values. LI398U:  Uses CSS statements LI3B8B:  The name of each CSS class defined: LI3BNM:  Begins with the name of the overall-concept/row (with punctuation removed & whitespace replaced with "_") for easy human understanding & lookup. LI3BCQ:  ends with "_" followed by the universal ID of the first statement which defines it, NOT the universal ID of the row/overall-concept being defined, as Reasons U4.	LI37QL:  Medium LI37R5:  every column needs to be defined fixed-width for scalable performance: for, at least in MS Expression Web 4 (and possibly in other WYSIWYG editors), at least without this, every keystroke inserted in the document wrongfully gets increasingly slow (to the point of impractical), even when not entering into a table, probably because the editor is wrongfully immediately re-computing what the column widths should be (and of all tables, even when not even changing a table). LI3842:  It would be nice to color-code columns.	/*LI37EI: (col)*/.Column_CSS_LI36Z9{/* LI37GE: */width:12em;/* */}

5. ^LIGVAZ:  Section Change Table (in order)

   			LIGUY0:
   ID + Link(s)	(Starting setting/environment), else attribute	How modifying	When: Planned Actual	Starting Reason including inspiration & preparation	Results	Ender: Planned Actual
   LIH4KM:	relevant dimension attribute table	added column definitions, including: [LIH4RY: RY many (as Li_Vert & ID + Link(s)) which would apply fairly universally]
   LIF5M0:	title exists not.	set to "JotHere.com table"	now	To gather table constructs for JotHere.	done immediately	none none
   LIF4TE:  TE	post exists not.	set to http://2.loverules.info/368	now now	usual	done immediately	none none
   			now	usual
   LIF505:	draft source exists not.	set to 368[JotHere.com_table]_LIF505.htm	now now	usual	done immediately	none none
   LIGTJR:	draft source's Intro	added.	none finished yesterday			none none
   LIGTPJ:	draft source's section Backend-Technology options (for tables)	added	none in progress; ~80%	usual	done immediately	none none
   LIGU0H:  0H	TE	save draft	now ending 22 March, 2011 @ 1:27	good recordkeeping: going to sleep		some 0H
   LIH4EC: LIH4EC	to draft source's Column definition table from all-of RY.	create, moving content	a few days ago now; in progress.	Need these to be in a more central location as they are universal	moved; need to update links	none none
   LIJCOY:	top-level section (JotHere table) to capture change	created and added intro. Included action/change table (which was elsewhere). That & rest still under construction	now ended now.	per the docs' directive.	done	additons none
   LIGTSV:  SV	0H	publish draft	today ; LIJG54:  posting:	Want to put "I now work full-time with WordPress (MySQL plus its own PHP framework) and we're starting a move to XML DB (XQuery) per http://1.JotHere.com/368#LIGUKH ,but it's good to keep abreast w/ other technologies as this and hang with fellow techies." on  LIF8D5 reference in comment on http://meetup.com/oc-php/events/16330189/	done immediately	none none
   	source's content	(template row; copy & paste it then edit to suit)	now	usual	done immediately	none none

6. Copyright © 2011 by http://JotHere.com with all rights reserved.

Section JotHere.com table end