https://wiki.openmod-initiative.org/index.php?action=history&feed=atom&title=Talk%3ADatabaseRulesTalk:DatabaseRules - Revision history2026-04-15T03:34:44ZRevision history for this page on the wikiMediaWiki 1.19.7https://wiki.openmod-initiative.org/index.php?title=Talk:DatabaseRules&diff=7475&oldid=prevIngmar Schlecht: <nice-discussions-summary>2016-12-05T12:11:27Z<p><nice-discussions-summary></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 12:11, 5 December 2016</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 3:</td>
<td colspan="2" class="diff-lineno">Line 3:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==Data Referencing - Invalid JSON==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==Data Referencing - Invalid JSON==</div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The JSON conversion does not support control characters like line breaks.<br/>Especially the "Instructions for proper use" usually have a longer text that must be cleaned to a "one-liner".<br/>see [http://stackoverflow.com/questions/25871477/postgresql-text-to-json-conversion http://stackoverflow.com/questions/25871477/postgresql-text-to-json-conversion]<span class="userid-227 comment-signature" timestamp="20160718143007">[[User:Ludwig Schneider|Ludwig Schneider]]  18 July 2016, 16:30 (CEST)</span></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>The JSON conversion does not support control characters like line breaks.<br/>Especially the "Instructions for proper use" usually have a longer text that must be cleaned to a "one-liner".<br/>see [http://stackoverflow.com/questions/25871477/postgresql-text-to-json-conversion http://stackoverflow.com/questions/25871477/postgresql-text-to-json-conversion]<span class="userid-227 comment-signature" timestamp="20160718143007">[[User:Ludwig Schneider|Ludwig Schneider]]  18 July 2016, 16:30 (CEST)</span></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">==JSON structure==</ins></div></td></tr>
<tr><td colspan="2"> </td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div><ins style="color: red; font-weight: bold; text-decoration: none;">Just a short question:<br/>did you invent the structure of the JSON yourself or did you lean towards an established standard? I don't think it's a good idea to create your own standard there, so if you find something suitable, I would go for something established.<br/>The JSON Table Schema standard of the Open Knowledge looks similar: http://specs.frictionlessdata.io/json-table-schema/<br/>Another point: When making up example email addresses, try to use @example.com as, as that is what the domain is there for according to RFC 2606.<br/>cheers<br/>Ingmar <span class="userid-5 comment-signature" timestamp="20161205121127">[[User:Ingmar Schlecht|Ingmar Schlecht]]  5 December 2016, 13:11 (CET)</span></ins></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><span class="NiceDiscussions END"></span></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><span class="NiceDiscussions END"></span></div></div></td></tr>
</table>Ingmar Schlechthttps://wiki.openmod-initiative.org/index.php?title=Talk:DatabaseRules&diff=5620&oldid=prevLudwig Schneider: <nice-discussions-summary>2016-07-18T14:56:52Z<p><nice-discussions-summary></p>
<table class='diff diff-contentalign-left'>
<col class='diff-marker' />
<col class='diff-content' />
<col class='diff-marker' />
<col class='diff-content' />
<tr valign='top'>
<td colspan='2' style="background-color: white; color:black;">← Older revision</td>
<td colspan='2' style="background-color: white; color:black;">Revision as of 14:56, 18 July 2016</td>
</tr><tr><td colspan="2" class="diff-lineno">Line 2:</td>
<td colspan="2" class="diff-lineno">Line 2:</td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==Data Referencing - Invalid JSON==</div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div>==Data Referencing - Invalid JSON==</div></td></tr>
<tr><td class='diff-marker'>−</td><td style="background: #ffa; color:black; font-size: smaller;"><div>The JSON conversion does not support control characters like line breaks.<br/>Especially the "Instructions for proper use" usually have a longer text that must be cleaned to a "<del class="diffchange diffchange-inline">oneliner</del>".<br/>see http://stackoverflow.com/questions/25871477/postgresql-text-to-json-conversion <span class="userid-227 comment-signature" timestamp="20160718143007">[[User:Ludwig Schneider|Ludwig Schneider]]  18 July 2016, 16:30 (CEST)</span></div></td><td class='diff-marker'>+</td><td style="background: #cfc; color:black; font-size: smaller;"><div>The JSON conversion does not support control characters like line breaks.<br/>Especially the "Instructions for proper use" usually have a longer text that must be cleaned to a "<ins class="diffchange diffchange-inline">one-liner</ins>".<br/>see <ins class="diffchange diffchange-inline">[http://stackoverflow.com/questions/25871477/postgresql-text-to-json-conversion </ins>http://stackoverflow.com/questions/25871477/postgresql-text-to-json-conversion<ins class="diffchange diffchange-inline">]</ins><span class="userid-227 comment-signature" timestamp="20160718143007">[[User:Ludwig Schneider|Ludwig Schneider]]  18 July 2016, 16:30 (CEST)</span></div></td></tr>
<tr><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><span class="NiceDiscussions END"></span></div></div></td><td class='diff-marker'> </td><td style="background: #eee; color:black; font-size: smaller;"><div><span class="NiceDiscussions END"></span></div></div></td></tr>
</table>Ludwig Schneiderhttps://wiki.openmod-initiative.org/index.php?title=Talk:DatabaseRules&diff=5617&oldid=prevLudwig Schneider: <nice-discussions-summary>2016-07-18T14:30:07Z<p><nice-discussions-summary></p>
<p><b>New page</b></p><div><div class="NiceDiscussions START"><br />
<br />
==Data Referencing - Invalid JSON==<br />
The JSON conversion does not support control characters like line breaks.<br/>Especially the "Instructions for proper use" usually have a longer text that must be cleaned to a "oneliner".<br/>see http://stackoverflow.com/questions/25871477/postgresql-text-to-json-conversion <span class="userid-227 comment-signature" timestamp="20160718143007">[[User:Ludwig Schneider|Ludwig Schneider]] 18 July 2016, 16:30 (CEST)</span><br />
<span class="NiceDiscussions END"></span></div></div>Ludwig Schneider