HackerNews VN bot<p>Chuyển đổi từ Postgres sang ClickHouse? 🤔 Bài viết này chia sẻ các mẹo mô hình hóa dữ liệu để giúp bạn tận dụng tối đa ClickHouse. Tìm hiểu cách tối ưu hóa cho cơ sở dữ liệu hướng cột (column-oriented database) nhé!<br><a href="https://mastodon.maobui.com/tags/Postgres" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Postgres</span></a> <a href="https://mastodon.maobui.com/tags/ClickHouse" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ClickHouse</span></a> <a href="https://mastodon.maobui.com/tags/DataModeling" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataModeling</span></a> <a href="https://mastodon.maobui.com/tags/Database" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Database</span></a> <a href="https://mastodon.maobui.com/tags/C%C6%A1S%E1%BB%9FD%E1%BB%AFLi%E1%BB%87u" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CơSởDữLiệu</span></a> <a href="https://mastodon.maobui.com/tags/M%C3%B4H%C3%ACnhH%C3%B3aD%E1%BB%AFLi%E1%BB%87u" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MôHìnhHóaDữLiệu</span></a></p><p><a href="https://clickhouse.com/blog/postgres-to-clickhouse-data-modeling-tips-v2" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">clickhouse.com/blog/postgres-t</span><span class="invisible">o-clickhouse-data-modeling-tips-v2</span></a></p>
veganism.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
Veganism Social is a welcoming space on the internet for vegans to connect and engage with the broader decentralized social media community.
Administered by:
Server stats:
291active users
veganism.social: About · Status · Profiles directory · Privacy policy
Mastodon: About · Get the app · Keyboard shortcuts · View source code · v4.4.0-alpha.5
#DataModeling
0 posts · 0 participants · 0 posts today
Europe Says<p><a href="https://www.europesays.com/2127429/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="">europesays.com/2127429/</span><span class="invisible"></span></a> Sharing data could enhance nat cat models, experts say <a href="https://pubeurope.com/tags/ClimateChange" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ClimateChange</span></a> <a href="https://pubeurope.com/tags/Data" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Data</span></a> <a href="https://pubeurope.com/tags/DataModeling" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataModeling</span></a> <a href="https://pubeurope.com/tags/NaturalDisasters" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NaturalDisasters</span></a> <a href="https://pubeurope.com/tags/PredictiveModeling" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PredictiveModeling</span></a> <a href="https://pubeurope.com/tags/WeatherAndClimateChangeRisk" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>WeatherAndClimateChangeRisk</span></a></p>
Victor Nava<p><a href="https://bijaiv.com/tags/DynamoDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DynamoDB</span></a> <a href="https://bijaiv.com/tags/NoSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>NoSQL</span></a> <a href="https://bijaiv.com/tags/Serverless" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Serverless</span></a> <a href="https://bijaiv.com/tags/AWS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>AWS</span></a> <a href="https://bijaiv.com/tags/DatabaseDesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseDesign</span></a> <a href="https://bijaiv.com/tags/SingleTableDesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SingleTableDesign</span></a> <a href="https://bijaiv.com/tags/TechBlog" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TechBlog</span></a> <a href="https://bijaiv.com/tags/CloudComputing" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>CloudComputing</span></a> <a href="https://bijaiv.com/tags/DataModeling" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataModeling</span></a> <a href="https://bijaiv.com/tags/SoftwareArchitecture" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SoftwareArchitecture</span></a> <a href="https://bijaiv.com/tags/WebDevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>WebDevelopment</span></a> <a href="https://bijaiv.com/tags/DevCommunity" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DevCommunity</span></a> <a href="https://bijaiv.com/tags/ScalableApps" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ScalableApps</span></a></p><p><a href="https://victornava.dev/2025/05/27/non-relational-databases-single-table-or-multi-table/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">victornava.dev/2025/05/27/non-</span><span class="invisible">relational-databases-single-table-or-multi-table/</span></a></p>
Preston Maness ☭<p><span class="h-card" translate="no"><a href="https://expressional.social/@LinusWeidickFrische" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>LinusWeidickFrische</span></a></span> <span class="h-card" translate="no"><a href="https://en.osm.town/@MapAmore" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>MapAmore</span></a></span> </p><p>[Fair warning: I am speaking in an confident tone below; however, my accumulated knowledge of the data modeling philosophy behind OSM has largely occurred via osmosis, as I have slowly contributed and read more and more. I have not had formal, foundational education/training on the matter, so what follows might actually be somewhat scatterbrained.]</p><p>Presumably, the `_ref` bit was intended as an indicator of a "reference" value for the aforementioned `crossing`. E.g., `crossing_ref=zebra` where `crossing_ref` is the key, and `zebra` is the value, of the tag. In today's tag schema though, such tag keys are "flat" or "flattened," when they could instead be scoped/namespaced with colons: `crossing:markings=zebra` (presumably, one could have done `crossing:ref=zebra` as well, though `ref` has less meaning than `crossing`).</p><p>However, <a href="https://tenforward.social/tags/osm" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>osm</span></a> eventually coalesced around a tree structure for their tag keys, with branches indicated by the colon (`:`) character and its subsequent string, and values for the last descendant/child node encoded as the tag's value. (I mean, the tags *might* be more general? Maybe there are cyclic graphs? But so far I haven't seen them (or at least, have not recognized them as such)). In theory, the underscore character (`_`) could have served the purpose of indicating branches as well, but... the English language uses spaces; tags cannot have spaces; underscores come closest to indicating spaces; ergo, use underscores as spaces and not as an indicator for a branch.</p><p>Incidentally, this approach also permitted: </p><p>1. namespacing of tags. E.g., one could namespace/scope specific tags so as to organize data. E.g., `us:tx:tarrant` could indicate the anything following (perhaps, `:parcel` to indicate a parcel number) relates to Tarrant county, in the state of Texas, in the United States.<br>2. having specific "branches" contain common semantic intent regardless of where in a tag's key tree they fall, such as `:height`. I.e., `building:height` or `antenna:height` or `building:antenna:height`.</p><p><a href="https://tenforward.social/tags/OpenStreetMap" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenStreetMap</span></a> <a href="https://tenforward.social/tags/osm" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>osm</span></a> <a href="https://tenforward.social/tags/DataModeling" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataModeling</span></a></p>
Henrik Schönemann<p><a href="https://fedihum.org/tags/Introduction" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Introduction</span></a> (2025-04-30)</p><p>I'm a <a href="https://fedihum.org/tags/Histodon" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Histodon</span></a> based in Berlin (Humboldt-University) doing <a href="https://fedihum.org/tags/DigitalHumanities" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DigitalHumanities</span></a>.<br>Toots and boosts in English and German.</p><p>Initiated <span class="h-card" translate="no"><a href="https://fedihum.org/@SafeguardingResearch" class="u-url mention" rel="nofollow noopener" target="_blank">@<span>SafeguardingResearch</span></a></span> on 2025-01-15<br><a href="https://safeguar.de" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">safeguar.de</span><span class="invisible"></span></a></p><p><a href="https://fedihum.org/tags/AntiFascist" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>AntiFascist</span></a>, <a href="https://fedihum.org/tags/queer" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>queer</span></a> and pro <a href="https://fedihum.org/tags/OpenData" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenData</span></a> and <a href="https://fedihum.org/tags/OpenAccess" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenAccess</span></a>:<br>“Sharing isn’t immoral — it’s a moral imperative”<br>Aaron Swartz<br><a href="https://openbehavioralscience.org/manifesto/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">openbehavioralscience.org/mani</span><span class="invisible">festo/</span></a></p><p>My interests include <a href="https://fedihum.org/tags/GIS" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>GIS</span></a>, <a href="https://fedihum.org/tags/SemanticWeb" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SemanticWeb</span></a> / <a href="https://fedihum.org/tags/LOD" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>LOD</span></a>, <a href="https://fedihum.org/tags/DataModeling" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataModeling</span></a> & <a href="https://fedihum.org/tags/OntologyDesign" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OntologyDesign</span></a> — <br>'We have nothing to lose but our inexperience!'</p>
VegansExploreLive feeds
Mastodon is the best way to keep up with what's happening.
Follow anyone across the fediverse and see it all in chronological order. No algorithms, ads, or clickbait in sight.
Create accountLoginDrag & drop to upload