Jun 032015

NPBXS5:   “intro & overall”

  1. NPBXSE:  “The “terms of use” of {this post & its comments, including the privacy & confidentiality of it plus all knowledge obtained from it} is JotHere’s standard Terms of Use except:
    1. NPBXSP:   none.
  2.   “post image” TBA
  3.   NPBXTC:  “post name history in reverse start-order”
    1. NPBXZM:  now originally to next: “SQL stumbling points, by DestinyArchitect
    2. NPE1M3:  “per post name, add post to categories”
      1. NPE1MM:  ‘SQL NPE1F6
      2. NPE1MU:  ‘DestinyArchitect creation N0L9VW’
  4. NPBY5E:  recursion
    1. NPBYKP:  overall
      1.  NPBYKU:  on http://en.wikipedia.org/wiki/SQL page-find ‘recur’
    2. NPBY8U:  ‘gets all ancestors of an item’
      1. NPBYB1:  http://stackoverflow.com/questions/16749095/sql-recursive-function-that-gets-all-ancestors-of-an-item
      2. NPBYCK:  (for predecessors) http://stackoverflow.com/questions/3916597/sql-server-recursive-query?lq=1
    3. NPBYF2:  ~‘gets all children’
      1. NPBYG7:   http://stackoverflow.com/questions/20215744/how-to-create-a-mysql-hierarchical-recursive-query
    4. NPBY5S:  by maker
      1. NPBY73:  in SQLite
        1. NPBYO6: NPBYO6: GS(sqlite recursive query)
        2. NPBY7U:  https://www.sqlite.org/lang_with.html —NPBYO6 find 1
          1. NPBYP7:  on quick look, looks like good support.
      2. NPBZKU:  in WordPress Pods
        1. NPBZLM:  GS(wordpress pods recursive)
  5. “motivation”
  6.  “success of this”
  7. “author(s) background (on the topic)”

  8. “post edits overall history table, by increasing start-time”
    “entry ID” “action” “why” “word cnt”  “ver #” “s#” “date (typ fr earliest ID)”
    1. NPBXO7:   ‘{post.status.snapshot: date ’20150602Tue1123pst‘; after ID’ minutes 1~‘; revision ’1‘; words ’222~‘; version ’0~‘; as ’stuff to record & ideally share‘, do ’“now {via “Copy to a new draft”, so of {then latest post template used by author, so /4658#KOLWCZ}, so of then its latest saved version, so with last entry “/4658#NOMI95: ..”} created {this here post, so” http://1.JotHere.com/4707 “} then cut {all its content not to be reused here, so the content just applying to the template, so all the posts’ fully stated points including their KCGUIDs}.”‘}’..
    2. NPBXX3:  adding intial content
    3. NPE1PT:  ‘{post.status.snapshot: date ’20150603Wed1444pst‘; after ID’ minutes 0~‘; revision ’1‘; words ’292‘; version0.2~‘; as ’need to restart Chrome‘, do ’save & 1st publish‘}’.