# <!-- 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": "P04tgsDCqvwtP2PYfGYzds3hqeOxmTuOz6lMoCqJoTpIKmG7A8NqgZEyWlCfrvhl"
"layout:input-next": "/intent/180001/"
"layout:languages": [{"code": "ja", "is-active": "true", "name": "日本語"}, {"code": "lt", "is-active": "false", "name": "Lietuviškai"}, {"code": "zh-hans", "is-active": "false", "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=ja"
"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=ja"
"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": "P04tgsDCqvwtP2PYfGYzds3hqeOxmTuOz6lMoCqJoTpIKmG7A8NqgZEyWlCfrvhl"
"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/"><u>ログイン</u>してください。</a>
# <!-- COMMENTS
# –––––––––––––––––––––––––––––––––––––––––––––––––– -->
"item:comment:items":
"base:js": "/static/js/base.c7357c06cc89.js"