# <!-- METAHEADER
# –––––––––––––––––––––––––––––––––––––––––––––––––– -->
"*": "https://raw.githubusercontent.com/wefindx/schema/master/intent/oo-item.yaml"
# <!-- HEADER
# –––––––––––––––––––––––––––––––––––––––––––––––––– -->
"base:title": "0oo - Synchronize Postgresql databases"
"og:title": "Synchronize Postgresql databases"
"og:description": "I am thinking of writing some program to synchronize Postgres databases. I would issue a COPY TO command on every table with a version greater than column check and then transfer it to other nodes and the same happens in reverse. CSV has parsers in many languages so it could be written in any language. Conflicts can be resolved by having a policy where the winning version is marked active."
"og:image": "https://avatars0.githubusercontent.com/u/28134655"
"og:url": "/intent/180001/"
"base:css": "/static/css/bootstrap.min.9c25540d6272.css"
"base:extra-css": "/static/css/base.57997aeac1df.css"
"base:favicon": "/static/favicon.acaa334f0136.ico"
"base:body_class": ""
"layout:logo": "/static/0oo.8d2a8bbef612.svg"
"layout:index": "/"
"layout:menu": "/menu/"
"layout:categories": "/intents/"
"layout:ideas": "/methods/"
"layout:projects": "/projects/"
"layout:users": "/users/"
"layout:about": "/about/"
"layout:help": "/help/"
"layout:bug_report": "https://github.com/wefindx/0oo"
"layout:login": "/accounts/login/"
"layout:light-off": "/darken/?darken=true"
"layout:set-multilingual": "/mulang/?mulang=true"
"layout:lang": "语言"
"layout:set-language-post-action": "/i18n/setlang/"
"layout:csrf-token": "NwEtSM4zdbapcEPvjKPYJK2J1uroQokKR9eUF5hyg4EjrdgbKrzNd9H52BU6FLJ5"
"layout:input-next": "/intent/180001/"
"layout:languages": [{"code": "ja", "is-active": "false", "name": "日本語"}, {"code": "lt", "is-active": "false", "name": "Lietuviškai"}, {"code": "zh-hans", "is-active": "true", "name": "简体中文"}, {"code": "en", "is-active": "false", "name": "English"}, {"code": "ru", "is-active": "false", "name": "Русский"}, {"code": "oo", "is-active": "false", "name": "O;o,"}]
# <!-- TOPIC
# –––––––––––––––––––––––––––––––––––––––––––––––––– -->
"item:parent:intents": [{"title": "Distributed data storage", "url": "/intent/74001/"}]
"item:title": "Synchronize Postgresql databases"
"item:votes": 0
"item:add-vote": "#addnote"
"item:intent": "/intent/180001/?l=cn"
"item:base-administration": false
"item:body": |
    I am thinking of writing some program to synchronize Postgres databases.
    I would issue a COPY TO command on every table with a version greater than column check and then transfer it to other nodes and the same happens in reverse.
    CSV has parsers in many languages so it could be written in any language.
    Conflicts can be resolved by having a policy where the winning version is marked active.
"item:permalink": "/intent/180001/?l=cn"
"item:source-date": ""
"item:owner": "chronological"
"item:ownerlink": "/user/198/chronological"
"item:created": "2022-07-27T18:54:38.957607"
"item:intent:child:add": "/admin/hlog/intent/add/?parent=180001"
# <!-- LINKS
# –––––––––––––––––––––––––––––––––––––––––––––––––– -->
"item:method:items":
"item:method:add": "/admin/hlog/method/add/?parent=180001"
"item:comment:add": "/intents/addnote?parent=180001"
"item:comment:add:csrf_token": "NwEtSM4zdbapcEPvjKPYJK2J1uroQokKR9eUF5hyg4EjrdgbKrzNd9H52BU6FLJ5"
"item:comment:form": |
    <li> <textarea name="text" cols="40" rows="10" id="addnote" class="comment-textarea" required>
    </textarea></li>
    <li><label for="id_vote">投票：</label> <select name="vote" id="id_vote">
      <option value="-1">[−]</option>
      <option value="0" selected>-</option>
      <option value="1">[+]</option>
    </select></li>
    <li><label for="id_crawl">安静地：</label> <input type="checkbox" name="crawl" onchange="handleSilently(this)" id="id_crawl"></li>
    <li><label for="id_has_questions">概念：</label> <input type="checkbox" name="has_questions" id="id_has_questions"> <span class="helptext">标记评论提出新问题。</span></li>
    <li><label for="id_has_ideas">想法：</label> <input type="checkbox" name="has_ideas" id="id_has_ideas"> <span class="helptext">标记评论有潜在解决方案。</span></li>
    <li><label for="id_has_facts">事实：</label> <input type="checkbox" name="has_facts" id="id_has_facts"> <span class="helptext">标记评论有助于推理的事实。</span></li>
    <a href="/accounts/login/">请，<i><u>登录</u></i>。</a>
# <!-- COMMENTS
# –––––––––––––––––––––––––––––––––––––––––––––––––– -->
"item:comment:items":
"base:js": "/static/js/base.c7357c06cc89.js"