Create accountLogin

Recent searches

No recent searches

Search options

Only available when logged in.
bolha.us is one of the many independent Mastodon servers you can use to participate in the fediverse.
We're a Brazilian IT Community. We love IT/DevOps/Cloud, but we also love to talk about life, the universe, and more. | Nós somos uma comunidade de TI Brasileira, gostamos de Dev/DevOps/Cloud e mais!

Administered by:

Server stats:

254
active users

bolha.us: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.3.7

#dbms

0 posts0 participants0 posts today
Kingsley Uyi Idehen<p>This week’s edition of my <span class="h-card" translate="no"><a href="https://mastodon.social/@linkedin" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>linkedin</span></a></span> newsletter shines a light on the impact of the Model Context Protocol (MCP) across multiple computing eras—leading right up to today.</p><p>We’ve arrived at a moment where loose coupling principles are cool (and super useful) again.</p><p>Naturally, there are some live demo nuggets in the post to help bring it all to life:</p><p>🔗 <a href="https://www.linkedin.com/pulse/model-context-protocol-bridging-generational-computing-idehen-qdtce/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">linkedin.com/pulse/model-conte</span><span class="invisible">xt-protocol-bridging-generational-computing-idehen-qdtce/</span></a></p><p><a href="https://mastodon.social/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> <a href="https://mastodon.social/tags/GenAI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GenAI</span></a> <a href="https://mastodon.social/tags/MCP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MCP</span></a> <a href="https://mastodon.social/tags/KnowledgeGraph" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>KnowledgeGraph</span></a> <a href="https://mastodon.social/tags/LinkedData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LinkedData</span></a> <a href="https://mastodon.social/tags/SemanticWeb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SemanticWeb</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/SPARQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SPARQL</span></a> <a href="https://mastodon.social/tags/DBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DBMS</span></a> <a href="https://mastodon.social/tags/DataConnectivity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataConnectivity</span></a></p>
Kingsley Uyi Idehen<p>The Model Context Protocol acts as a universal translator between LLMs and data sources, eliminating complex platform-specific requirements. Our new open source MCP server for ODBC (mcp-odbc-server) enables seamless integration of any ODBC-accessible data into RAG pipelines.</p><p>Read more in my latest newsletter!</p><p><a href="https://www.linkedin.com/pulse/whats-model-context-protocol-why-important-kingsley-uyi-idehen-zy8ue" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">linkedin.com/pulse/whats-model</span><span class="invisible">-context-protocol-why-important-kingsley-uyi-idehen-zy8ue</span></a></p><p><a href="https://mastodon.social/tags/MCP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MCP</span></a> <a href="https://mastodon.social/tags/ODBC" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ODBC</span></a> <a href="https://mastodon.social/tags/SPARQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SPARQL</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/LinkedData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LinkedData</span></a> <a href="https://mastodon.social/tags/DBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DBMS</span></a> <a href="https://mastodon.social/tags/DataConnectivity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataConnectivity</span></a> <a href="https://mastodon.social/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a> <a href="https://mastodon.social/tags/GenAI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GenAI</span></a> <a href="https://mastodon.social/tags/Agentic" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Agentic</span></a></p>
zartom<p>Database Deadlocks: Understanding and Preventing Conflicts in Different DBMS<br>Database deadlocks can cripple your database performance! Learn how they happen and how to prevent them in various DBMS. Strategies for avoiding these conflicts are crucial for a smooth-running database. <a href="https://mastodon.social/tags/DatabaseDeadlocks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DatabaseDeadlocks</span></a> <a href="https://mastodon.social/tags/DBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DBMS</span></a> <a href="https://mastodon.social/tags/DeadlockPrevention" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DeadlockPrevention</span></a> <a href="https://mastodon.social/tags/ConcurrencyControl" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ConcurrencyControl</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/DatabasePerformance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DatabasePerformance</span></a></p><p><a href="https://tech-champion.com/application-support/database-deadlocks-understanding-and-preventing-conflicts-in-different-dbms" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/application-</span><span class="invisible">support/database-deadlocks-understanding-and-preventing-conflicts-in-different-dbms</span></a>...</p>
zartom<p>Database Deadlocks: Understanding and Preventing Conflicts in Different DBMS<br>Database deadlocks can cripple your database performance! Learn how they happen and how to prevent them in various DBMS. Strategies for avoiding these conflicts are crucial for a smooth-running database. <a href="https://mastodon.social/tags/DatabaseDeadlocks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DatabaseDeadlocks</span></a> <a href="https://mastodon.social/tags/DBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DBMS</span></a> <a href="https://mastodon.social/tags/DeadlockPrevention" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DeadlockPrevention</span></a> <a href="https://mastodon.social/tags/ConcurrencyControl" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ConcurrencyControl</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/DatabasePerformance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DatabasePerformance</span></a></p><p><a href="https://tech-champion.com/application-support/database-deadlocks-understanding-and-preventing-conflicts-in-different-dbms" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/application-</span><span class="invisible">support/database-deadlocks-understanding-and-preventing-conflicts-in-different-dbms</span></a>...</p>
zartom<p>Database Deadlocks: Understanding and Preventing Conflicts in Different DBMS<br>Database deadlocks can cripple your database performance! Learn how they happen and how to prevent them in various DBMS. Strategies for avoiding these conflicts are crucial for a smooth-running database. <a href="https://mastodon.social/tags/DatabaseDeadlocks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DatabaseDeadlocks</span></a> <a href="https://mastodon.social/tags/DBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DBMS</span></a> <a href="https://mastodon.social/tags/DeadlockPrevention" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DeadlockPrevention</span></a> <a href="https://mastodon.social/tags/ConcurrencyControl" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ConcurrencyControl</span></a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a> <a href="https://mastodon.social/tags/DatabasePerformance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DatabasePerformance</span></a></p><p><a href="https://tech-champion.com/application-support/database-deadlocks-understanding-and-preventing-conflicts-in-different-dbms" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/application-</span><span class="invisible">support/database-deadlocks-understanding-and-preventing-conflicts-in-different-dbms</span></a>...</p>
Alaric Snell-Pym<p>Ok, a question for <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://fosstodon.org/tags/dbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dbms</span></a> nerds. Many years ago I worked on a join order optimizer that used a heuristic formula to estimate the number of rows produced by an equijoin, based on the number of rows in the two tables being joined and the number of distinct values in the join keys. This formula came from an academic paper, but I can't remember what the formula was or find the paper. Does this ring a bell for anyone? Boosts appreciated...</p>
Christian M. Grube 🐧<p>Dbeaver 24.3.4 released</p><p>Free multi-platform database tool for developers, SQL programmers, database administrators and analysts.<br>Supports any database which has JDBC driver (which basically means - ANY database). </p><p><a href="https://social.tchncs.de/tags/adminlife" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>adminlife</span></a> <a href="https://social.tchncs.de/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <a href="https://social.tchncs.de/tags/dbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dbms</span></a> <br><a href="https://github.com/dbeaver/dbeaver/releases/tag/24.3.4" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">github.com/dbeaver/dbeaver/rel</span><span class="invisible">eases/tag/24.3.4</span></a></p>
Zuri (he/him) 🕐 CET<p>When using a <a href="https://mastodon.online/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a> database, is it possible in one go, when adding a new column to an existing table, to use one default value for existing columns (initial migration, so to speak), but another for every new row going forward (real default)?</p><p>Scenario: I want to set the value in pre-existing columns to true, but in all subsequent rows to false by default.</p><p><a href="https://mastodon.online/tags/amCoding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>amCoding</span></a> <a href="https://mastodon.online/tags/amProgramming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>amProgramming</span></a> <a href="https://mastodon.online/tags/softwareDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>softwareDevelopment</span></a> <a href="https://mastodon.online/tags/softwareEngineering" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>softwareEngineering</span></a> <a href="https://mastodon.online/tags/databaseEngineering" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databaseEngineering</span></a> <a href="https://mastodon.online/tags/databaseArchitecture" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databaseArchitecture</span></a> <a href="https://mastodon.online/tags/dbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dbms</span></a> <a href="https://mastodon.online/tags/SQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQL</span></a></p>
:rss: Hacker News<p>SQLite: How it works, by Richard Hipp (2024) [video]<br><a href="https://www.youtube.com/watch?v=ZSKLA81tBis" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://www.</span><span class="ellipsis">youtube.com/watch?v=ZSKLA81tBi</span><span class="invisible">s</span></a><br><a href="https://rss-mstdn.studiofreesia.com/tags/ycombinator" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ycombinator</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/dbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dbms</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databases</span></a> <a href="https://rss-mstdn.studiofreesia.com/tags/datenbanken" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>datenbanken</span></a></p>
Kingsley Uyi Idehen<p><a href="https://mastodon.social/tags/introduction" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>introduction</span></a> <br>I am an open data access (<a href="https://mastodon.social/tags/ODBC" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ODBC</span></a>, <a href="https://mastodon.social/tags/JDBC" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>JDBC</span></a>, and <a href="https://mastodon.social/tags/HTTP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>HTTP</span></a>), integration (<a href="https://mastodon.social/tags/DataVirtualization" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataVirtualization</span></a>), and data management (<a href="https://mastodon.social/tags/DBMS" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DBMS</span></a> and/or <a href="https://mastodon.social/tags/KnowledgeGraph" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>KnowledgeGraph</span></a>) technologist, enthusiast, and entrepreneur. </p><p>I am passionate about open standards for <a href="https://mastodon.social/tags/GenAI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>GenAI</span></a>, <a href="https://mastodon.social/tags/AI" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AI</span></a>, <a href="https://mastodon.social/tags/Identity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Identity</span></a> <a href="https://mastodon.social/tags/Authenticity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Authenticity</span></a>, <a href="https://mastodon.social/tags/SocialMedia" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SocialMedia</span></a> (<a href="https://mastodon.social/tags/ActivityPub" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ActivityPub</span></a> &amp; <a href="https://mastodon.social/tags/ActivityStreams" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ActivityStreams</span></a>), and data de-silo-fication initiatives (e.g. <a href="https://mastodon.social/tags/SemanticWeb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SemanticWeb</span></a>, <a href="https://mastodon.social/tags/LODCloud" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LODCloud</span></a>, <a href="https://mastodon.social/tags/LinkedData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LinkedData</span></a>, <a href="https://mastodon.social/tags/RWW" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RWW</span></a>, and <a href="https://mastodon.social/tags/SmallData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SmallData</span></a>).</p><p>I don't like any kind of silo!</p>
ExploreLive feeds
About