Mar 232011
2+.JotHere.com LZTI48, ‘this site's documentation for its users’, JotHere.com, table (information) NQBSYC Add comments
LIF5BS: (under construction; ~15% complete)
-
LIF5LC: Intro
- LIF5R7: This to be the leading repository for table definition & constructs used on JotHere.com.
- LIF5ST: It aims to include the following:
- LIF5YP: It is quite possible because of the extent of coverage this will need to be broken into sub-posts.
-
LIF7T1: Backend-Technology options (for tables)
- 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.
- LIFEYM: comparison table
-
LIJB3V: (JotHere table) to capture change (~10% complete)
-
LIJB7O: Introduction
- 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.
- LIJB82: This section
- LIJBMH: references & overviews & compares my work on the subject (past & present)
- LIJBHD: presents some of my recent developments in this area, including
- 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)
- LIJBK6: holds further research on the topic.
- LIJBBA: Has target areas of to document the changes (past & future)
-
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 Duration 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%) :
-
-
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.
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 /*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
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. LI3KE0: Definition Definition. This was also " & Description" so some cells may still have description text as well. LI1JBB: Importance Importance. Note this could include usage if that's what establishes the importance, as usage often does. 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.
-
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 -
Copyright © 2011 by http://JotHere.com with all rights reserved.
Section JotHere.com table end
[…] w/ WordPress (its own PHP framework w/ MySQL) &we're starting a move2 XML DB (XQuery) per http://1.JotHere.com/368#LIGUKH ,but it's good to keep abreast w/ other technologies as this & hang w/ fellow techies […]