Recent searches

No recent searches

Search options

Only available when logged in.
fosstodon.org is one of the many independent Mastodon servers you can use to participate in the fediverse.
Fosstodon is an invite only Mastodon instance that is open to those who are interested in technology; particularly free & open source software. If you wish to join, contact us for an invite.

Administered by:

Server stats:

8.8K
active users

fosstodon.org: AboutStatusProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.4.2

#databasetips

0 posts0 participants0 posts today
pgEdge Distributed PostgreSQL<p>Every Tuesday at 11:00am ET, join the pgEdge team for <a href="https://mastodon.social/tags/TechTuesday" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TechTuesday</span></a> — all about mastering Distributed <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> high availability, and edge-ready database solutions. Whether you’re scaling apps or seeking zero downtime, these sessions are packed with hands-on insights, real-world demos, and live Q&amp;A with the experts.</p><p>Don’t miss out! Learn more here: <a href="https://hubs.la/Q03qbnT70" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">hubs.la/Q03qbnT70</span><span class="invisible"></span></a></p><p>Join us on Tuesday at 11am ET here: <a href="https://hubs.la/Q03qbltY0" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">hubs.la/Q03qbltY0</span><span class="invisible"></span></a></p><p><a href="https://mastodon.social/tags/pgEdge" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>pgEdge</span></a> <a href="https://mastodon.social/tags/EdgeComputing" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>EdgeComputing</span></a> <a href="https://mastodon.social/tags/OpenSource" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>OpenSource</span></a> <a href="https://mastodon.social/tags/WebDev" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>WebDev</span></a> <a href="https://mastodon.social/tags/DatabaseTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseTips</span></a></p>
Doug Ortiz<p>🐘 PostgreSQL Pro Tip: Meta-commands can transform your data import workflow!</p><p>Just shared a new tutorial from my "Master Meta-Commands in PostgreSQL" course focusing on importing data into tables with minimal effort.</p><p>Learn how to import data with and leverage PostgreSQL's meta-commands for data migration.</p><p>Watch and level up: <a href="https://link.illustris.org/importdataintotables" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">link.illustris.org/importdatai</span><span class="invisible">ntotables</span></a><br><a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> <a href="https://mastodon.social/tags/DatabaseTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseTips</span></a> <a href="https://mastodon.social/tags/DataImport" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataImport</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/LinkedInLearning" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>LinkedInLearning</span></a></p>
Doug Ortiz<p>Did you know PostgreSQL has its own built-in full-text search engine? 🔎📝</p><p>-- Create a tsvector column with GIN index<br>ALTER TABLE articles ADD COLUMN search_vector tsvector;<br>CREATE INDEX articles_search_idx ON articles USING GIN (search_vector);</p><p>UPDATE articles SET search_vector = <br>to_tsvector('english', title || ' ' || content);</p><p>-- Search<br>SELECT title FROM articles <br>WHERE search_vector @@ to_tsquery('english', 'postgresql &amp; search');</p><p><a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> <a href="https://mastodon.social/tags/FullTextSearch" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>FullTextSearch</span></a> <a href="https://mastodon.social/tags/DatabaseTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseTips</span></a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Performance</span></a></p>
Izoate<p>Getting MySQL Error 1175 when trying to update or delete? That’s Safe Update Mode kicking in. Learn how to disable it safely and run your queries smoothly.</p><p>Read the full guide: <a href="https://www.izoate.com/blog/how-to-fix-mysql-error-1175-disable-safe-update-mode-mysql/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">izoate.com/blog/how-to-fix-mys</span><span class="invisible">ql-error-1175-disable-safe-update-mode-mysql/</span></a></p><p><a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQL</span></a> <a href="https://mastodon.social/tags/Error1175" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Error1175</span></a> <a href="https://mastodon.social/tags/WebDev" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>WebDev</span></a> <a href="https://mastodon.social/tags/DatabaseTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseTips</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/DevTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DevTips</span></a> <a href="https://mastodon.social/tags/SafeUpdateMode" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SafeUpdateMode</span></a> <a href="https://mastodon.social/tags/MySQLTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MySQLTips</span></a> <a href="https://mastodon.social/tags/izoate" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>izoate</span></a> <a href="https://mastodon.social/tags/tech" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>tech</span></a> <a href="https://mastodon.social/tags/technology" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>technology</span></a> <a href="https://mastodon.social/tags/howto" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>howto</span></a></p>
N-gated Hacker News<p>🚀 Wow, who knew <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> could be <a href="https://mastodon.social/tags/fast" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>fast</span></a> if you just, you know, used it correctly? 🤯 Apparently, the secret sauce is all about "calculating" and "storing" things beforehand—mind-blowing! 😂 Thanks for the <a href="https://mastodon.social/tags/groundbreaking" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>groundbreaking</span></a> revelation that doing things right makes them work better. 🏆<br><a href="https://blog.vectorchord.ai/postgresql-full-text-search-fast-when-done-right-debunking-the-slow-myth" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">blog.vectorchord.ai/postgresql</span><span class="invisible">-full-text-search-fast-when-done-right-debunking-the-slow-myth</span></a> <a href="https://mastodon.social/tags/Calculating" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Calculating</span></a> <a href="https://mastodon.social/tags/Storing" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>Storing</span></a> <a href="https://mastodon.social/tags/DatabaseTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseTips</span></a> <a href="https://mastodon.social/tags/HackerNews" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>HackerNews</span></a> <a href="https://mastodon.social/tags/ngated" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>ngated</span></a></p>
Doug Ortiz<p>Do You Know These Secret PostgreSQL Meta Commands? 🔍</p><p>Meta commands (starting with ) are PostgreSQL's hidden power tools for DBAs and developers!</p><p>These backslash commands let you explore database objects, get help, format output, and manage connections - all without writing complex SQL queries.</p><p>Learn how to access these productivity boosters: <a href="https://link.illustris.org/how2accessmetacommands" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">link.illustris.org/how2accessm</span><span class="invisible">etacommands</span></a><br><a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>PostgreSQL</span></a> <a href="https://mastodon.social/tags/DatabaseTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseTips</span></a> <a href="https://mastodon.social/tags/MetaCommands" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>MetaCommands</span></a> <a href="https://mastodon.social/tags/DBAdmin" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DBAdmin</span></a></p>
zartom<p>Convert DB2 Timestamps to UTC: A Practical Guide<br>Master DB2 Timestamp to UTC conversion for data integrity! Learn reliable techniques &amp; overcome common pitfalls. Efficiently manage time-sensitive data. <a href="https://mastodon.social/tags/DB2Tips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DB2Tips</span></a> <a href="https://mastodon.social/tags/UTCConversion" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>UTCConversion</span></a> <a href="https://mastodon.social/tags/DatabaseTips" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DatabaseTips</span></a> <a href="https://mastodon.social/tags/TimeZones" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>TimeZones</span></a> <a href="https://mastodon.social/tags/DataIntegrity" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>DataIntegrity</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>SQL</span></a><br><a href="https://tech-champion.com/database/db2luw/convert-db2-timestamps-to-utc-a-practical-guide/" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/convert-db2-timestamps-to-utc-a-practical-guide/</span></a></p>
TrendingLive feeds
About