Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
digitalcourage.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
Diese Instanz wird betrieben von Digitalcourage e.V. für die Allgemeinheit. Damit wir das nachhaltig tun können, erheben wir einen jährlichen Vorausbeitrag von 1€/Monat per SEPA-Lastschrifteinzug.

Administered by:

Server stats:

860
active users

digitalcourage.social: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.6

#DWH

0 posts0 participants0 posts today
Anoncheg<p>Part1: <a href="https://techhub.social/tags/dailyreport" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dailyreport</span></a> <a href="https://techhub.social/tags/powerbi" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>powerbi</span></a> <a href="https://techhub.social/tags/datawarehouse" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>datawarehouse</span></a> <a href="https://techhub.social/tags/dwh" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dwh</span></a> <a href="https://techhub.social/tags/postgresql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgresql</span></a><br> <a href="https://techhub.social/tags/python" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>python</span></a><br>At this week I installed PowerBI and connect it to remote<br> PostgreSQL.<br>I asked AI to compare open-source data sources for<br> PowerBI and compare them by:<br>- Ease of Setup on Linux: SQLite &gt; PostgreSQL &gt; MySQL &gt;<br> Redis &gt; MongoDB<br>- Performance:<br> + For large datasets: MongoDB &gt; PostgreSQL &gt; MySQL &gt;<br> Redis &gt; SQLite.<br> + For real-time operations: Redis &gt; MongoDB &gt; MySQL &gt;<br> PostgreSQL &gt; SQLite.</p><p>For PostgreSQL I prepare data in Python script that use:<br>- pandas - for coverting types to datetime and numeric<br>- sqlalchemy - for simplifying type converstion<br>- asyncpg - sqlalchemy backend to connect to PostgreSQL</p>
ваят<p>“It’s possible that the Deepwater Horizon disaster caused more damage than nature can clean up.”</p><p><a href="https://mstdn.social/tags/DeepwaterHorizon" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DeepwaterHorizon</span></a> <a href="https://mstdn.social/tags/DWH" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DWH</span></a> <a href="https://mstdn.social/tags/Macondo" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Macondo</span></a></p><p><a href="https://hakaimagazine.com/news/the-deepwater-horizons-very-unhappy-anniversary/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">hakaimagazine.com/news/the-dee</span><span class="invisible">pwater-horizons-very-unhappy-anniversary/</span></a></p>
ExploreLive feeds
About