Mastodon

Kingsley Uyi IdehenThe 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.Read more in my latest newsletter!<a href="https://www.linkedin.com/pulse/whats-model-context-protocol-why-important-kingsley-uyi-idehen-zy8ue" target="_blank" rel="nofollow noopener" translate="no">https://www.linkedin.com/pulse/whats-model-context-protocol-why-important-kingsley-uyi-idehen-zy8ue</a><a href="https://mastodon.social/tags/MCP" class="mention hashtag" rel="tag">#MCP</a> <a href="https://mastodon.social/tags/ODBC" class="mention hashtag" rel="tag">#ODBC</a> <a href="https://mastodon.social/tags/SPARQL" class="mention hashtag" rel="tag">#SPARQL</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="tag">#SQL</a> <a href="https://mastodon.social/tags/LinkedData" class="mention hashtag" rel="tag">#LinkedData</a> <a href="https://mastodon.social/tags/DBMS" class="mention hashtag" rel="tag">#DBMS</a> <a href="https://mastodon.social/tags/DataConnectivity" class="mention hashtag" rel="tag">#DataConnectivity</a> <a href="https://mastodon.social/tags/AI" class="mention hashtag" rel="tag">#AI</a> <a href="https://mastodon.social/tags/GenAI" class="mention hashtag" rel="tag">#GenAI</a> <a href="https://mastodon.social/tags/Agentic" class="mention hashtag" rel="tag">#Agentic</a>

Christian M. Grube 🐧🦫 DBeaver 25.0.1 releasedFree multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports any database which has JDBC driver (which basically means - ANY database)<a href="https://social.tchncs.de/tags/adminlife" class="mention hashtag" rel="nofollow noopener" target="_blank">#adminlife</a> <a href="https://social.tchncs.de/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> <a href="https://social.tchncs.de/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#opensource</a> <a href="https://github.com/dbeaver/dbeaver/releases/tag/25.0.1" rel="nofollow noopener" translate="no" target="_blank">https://github.com/dbeaver/dbeaver/releases/tag/25.0.1</a>

Juan BitsCuando declaras índices en una tabla se nota y cuando no, también se nota <a href="https://mastodon.mx/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> <a href="https://mastodon.mx/tags/devs" class="mention hashtag" rel="nofollow noopener" target="_blank">#devs</a>

OrientDBHere: <a href="https://orientdb.dev/news/orientdb-development-stats-2024/" rel="nofollow noopener" translate="no" target="_blank">https://orientdb.dev/news/orientdb-development-stats-2024/</a> are some development statistics of the work happen on OrientDB in 2024, have a good read <a href="https://fosstodon.org/tags/nosql" class="mention hashtag" rel="nofollow noopener" target="_blank">#nosql</a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://fosstodon.org/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> <a href="https://fosstodon.org/tags/graphdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#graphdb</a> <a href="https://fosstodon.org/tags/OrientDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#OrientDB</a>

zartomDatabase Deadlocks: Understanding and Preventing Conflicts in Different DBMS 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="tag">#DatabaseDeadlocks</a> <a href="https://mastodon.social/tags/DBMS" class="mention hashtag" rel="tag">#DBMS</a> <a href="https://mastodon.social/tags/DeadlockPrevention" class="mention hashtag" rel="tag">#DeadlockPrevention</a> <a href="https://mastodon.social/tags/ConcurrencyControl" class="mention hashtag" rel="tag">#ConcurrencyControl</a> <a href="https://mastodon.social/tags/SQL" class="mention hashtag" rel="tag">#SQL</a> <a href="https://mastodon.social/tags/DatabasePerformance" class="mention hashtag" rel="tag">#DatabasePerformance</a><a href="https://tech-champion.com/application-support/database-deadlocks-understanding-and-preventing-conflicts-in-different-dbms" target="_blank" rel="nofollow noopener" translate="no">https://tech-champion.com/application-support/database-deadlocks-understanding-and-preventing-conflicts-in-different-dbms</a>...

OrientDBOrientDB 3.2.38 patch release is out, it fixes mostly backward compatibility bugs and distributed issues, more on the release post <a href="https://github.com/orientechnologies/orientdb/releases/tag/3.2.38" rel="nofollow noopener" translate="no" target="_blank">https://github.com/orientechnologies/orientdb/releases/tag/3.2.38</a> <a href="https://fosstodon.org/tags/nosql" class="mention hashtag" rel="nofollow noopener" target="_blank">#nosql</a> <a href="https://fosstodon.org/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#databases</a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://fosstodon.org/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> <a href="https://fosstodon.org/tags/graphdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#graphdb</a> <a href="https://fosstodon.org/tags/OrientDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#OrientDB</a>

Alaric Snell-PymOk, a question for <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://fosstodon.org/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</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...

Christian M. Grube 🐧Dbeaver 24.3.4 releasedFree multi-platform database tool for developers, SQL programmers, database administrators and analysts. Supports any database which has JDBC driver (which basically means - ANY database). <a href="https://social.tchncs.de/tags/adminlife" class="mention hashtag" rel="nofollow noopener" target="_blank">#adminlife</a> <a href="https://social.tchncs.de/tags/opensource" class="mention hashtag" rel="nofollow noopener" target="_blank">#opensource</a> <a href="https://social.tchncs.de/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> <a href="https://github.com/dbeaver/dbeaver/releases/tag/24.3.4" rel="nofollow noopener" translate="no" target="_blank">https://github.com/dbeaver/dbeaver/releases/tag/24.3.4</a>

Zuri (he/him) 🕐 CETWhen using a <a href="https://mastodon.online/tags/MySQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#MySQL</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)?Scenario: I want to set the value in pre-existing columns to true, but in all subsequent rows to false by default.<a href="https://mastodon.online/tags/amCoding" class="mention hashtag" rel="nofollow noopener" target="_blank">#amCoding</a> <a href="https://mastodon.online/tags/amProgramming" class="mention hashtag" rel="nofollow noopener" target="_blank">#amProgramming</a> <a href="https://mastodon.online/tags/softwareDevelopment" class="mention hashtag" rel="nofollow noopener" target="_blank">#softwareDevelopment</a> <a href="https://mastodon.online/tags/softwareEngineering" class="mention hashtag" rel="nofollow noopener" target="_blank">#softwareEngineering</a> <a href="https://mastodon.online/tags/databaseEngineering" class="mention hashtag" rel="nofollow noopener" target="_blank">#databaseEngineering</a> <a href="https://mastodon.online/tags/databaseArchitecture" class="mention hashtag" rel="nofollow noopener" target="_blank">#databaseArchitecture</a> <a href="https://mastodon.online/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> <a href="https://mastodon.online/tags/SQL" class="mention hashtag" rel="nofollow noopener" target="_blank">#SQL</a>

OrientDBOrientDB 3.2.37 released with mostly improvements in the query scripts, read more at <a href="https://github.com/orientechnologies/orientdb/releases/tag/3.2.37" rel="nofollow noopener" translate="no" target="_blank">https://github.com/orientechnologies/orientdb/releases/tag/3.2.37</a><a href="https://fosstodon.org/tags/nosql" class="mention hashtag" rel="nofollow noopener" target="_blank">#nosql</a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://fosstodon.org/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> <a href="https://fosstodon.org/tags/graphdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#graphdb</a> <a href="https://fosstodon.org/tags/OrientDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#OrientDB</a>

GripNews🌗 PostgreSQL 是 2024 年的年度資料庫管理系統 ➤ PostgreSQL 在 2024 年勇奪年度資料庫管理系統，穩坐市場地位 ✤ <a href="https://db-engines.com/en/blog_post/109" target="_blank" rel="nofollow noopener" translate="no">https://db-engines.com/en/blog_post/109</a> PostgreSQL 在 DB-Engines 的排名中連續第二年獲得年度資料庫管理系統殊榮，並已經五次獲得此獎項。Snowflake 排名第二，Microsoft 排名第三。PostgreSQL 在過去一年中成為最受歡迎的資料庫管理系統，超越其他 423 個監控系統。 + PostgreSQL 的成功連續蟬聯 DBMS 年度冠軍，顯示其在資料庫管理系統市場上的卓越地位。 + Snowflake 和 Microsoft 分居次席和季軍，彰顯了在這競爭激烈的市場中的激烈角逐。 <a href="https://mastodon.social/tags/PostgreSQL" class="mention hashtag" rel="tag">#PostgreSQL</a> <a href="https://mastodon.social/tags/%E8%B3%87%E6%96%99%E5%BA%AB%E7%AE%A1%E7%90%86%E7%B3%BB%E7%B5%B1" class="mention hashtag" rel="tag">#資料庫管理系統</a> <a href="https://mastodon.social/tags/DBMS" class="mention hashtag" rel="tag">#DBMS</a>

persy_rsJust relased a new minor of persy 1.6.0 relative release notes here: <a href="https://persy.rs/posts/persy-1.6.html" rel="nofollow noopener" translate="no" target="_blank">https://persy.rs/posts/persy-1.6.html</a><a href="https://fosstodon.org/tags/storage" class="mention hashtag" rel="nofollow noopener" target="_blank">#storage</a> <a href="https://fosstodon.org/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://fosstodon.org/tags/rust" class="mention hashtag" rel="nofollow noopener" target="_blank">#rust</a>

OrientDBSmall update on the work in progress of OrientDB for the next version <a href="https://orientdb.dev/news/orientdb-first-changes-done/" rel="nofollow noopener" translate="no" target="_blank">https://orientdb.dev/news/orientdb-first-changes-done/</a> <a href="https://fosstodon.org/tags/graphdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#graphdb</a> <a href="https://fosstodon.org/tags/Databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#Databases</a> <a href="https://fosstodon.org/tags/nosql" class="mention hashtag" rel="nofollow noopener" target="_blank">#nosql</a> <a href="https://fosstodon.org/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> <a href="https://fosstodon.org/tags/OrientDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#OrientDB</a>

:rss: Hacker NewsSQLite: How it works, by Richard Hipp (2024) [video] <a href="https://www.youtube.com/watch?v=ZSKLA81tBis" rel="nofollow noopener" translate="no" target="_blank">https://www.youtube.com/watch?v=ZSKLA81tBis</a> <a href="https://rss-mstdn.studiofreesia.com/tags/ycombinator" class="mention hashtag" rel="nofollow noopener" target="_blank">#ycombinator</a> <a href="https://rss-mstdn.studiofreesia.com/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> <a href="https://rss-mstdn.studiofreesia.com/tags/databases" class="mention hashtag" rel="nofollow noopener" target="_blank">#databases</a> <a href="https://rss-mstdn.studiofreesia.com/tags/datenbanken" class="mention hashtag" rel="nofollow noopener" target="_blank">#datenbanken</a>

Anoncheg<a href="https://techhub.social/tags/dailyreport" class="mention hashtag" rel="nofollow noopener" target="_blank">#dailyreport</a> <a href="https://techhub.social/tags/emacs" class="mention hashtag" rel="nofollow noopener" target="_blank">#emacs</a> <a href="https://techhub.social/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://techhub.social/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> I found good magazine osp.ru and been reading about types of databases by version of Stonebraker/Pavlo. They think that relational SQL will absorb other types. Thematic chatbots that will clarify the request and form an action are promising. Cloud DBMS and lakehouse are actively growing absorbing for ex. API Pandas DataFrame.Article about Business trend: *Composable Enterprise* - platforms, marketplaces, ecosystems, API-economic. Focus on wide-profile and multifunctional specialists. Flat structure. Agile and modularity give 20-30% boost. Clouds and microservices.I enhanced Dired, Outline, Org and Tab key in Emacs. - I wrote an article about Tab key configuration for EmacsWiki site. - in Dired I added ability to compare windows with diff-buffers - in Org I enhanced navigation up and down with catchng error from org-next-item and using org-forward-element. - I released two packages to MELPA.I hear from everywhere about unemployment in IT. 蠡

OrientDBOrientDB 3.2.36 is out with stability and performance improvement, read more on the release notes <a href="https://github.com/orientechnologies/orientdb/releases/tag/3.2.36" rel="nofollow noopener" translate="no" target="_blank">https://github.com/orientechnologies/orientdb/releases/tag/3.2.36</a><a href="https://fosstodon.org/tags/nosql" class="mention hashtag" rel="nofollow noopener" target="_blank">#nosql</a> <a href="https://fosstodon.org/tags/database" class="mention hashtag" rel="nofollow noopener" target="_blank">#database</a> <a href="https://fosstodon.org/tags/dbms" class="mention hashtag" rel="nofollow noopener" target="_blank">#dbms</a> <a href="https://fosstodon.org/tags/graph" class="mention hashtag" rel="nofollow noopener" target="_blank">#graph</a> <a href="https://fosstodon.org/tags/graphdb" class="mention hashtag" rel="nofollow noopener" target="_blank">#graphdb</a> <a href="https://fosstodon.org/tags/OrientDB" class="mention hashtag" rel="nofollow noopener" target="_blank">#OrientDB</a>

Kingsley Uyi Idehen<a href="https://bsky.brid.gy/hashtag/ODBC" rel="nofollow noopener" target="_blank">#ODBC</a> described using a Linked Open Data driven page: <a href="https://bsky.brid.gy/hashtag/LinkedData" rel="nofollow noopener" target="_blank">#LinkedData</a> <a href="https://bsky.brid.gy/hashtag/BigData" rel="nofollow noopener" target="_blank">#BigData</a> <a href="https://bsky.brid.gy/hashtag/RDBMS" rel="nofollow noopener" target="_blank">#RDBMS</a> <a href="https://bsky.brid.gy/hashtag/DBMS" rel="nofollow noopener" target="_blank">#DBMS</a> <a href="https://bsky.brid.gy/hashtag/SemanticWeb" rel="nofollow noopener" target="_blank">#SemanticWeb</a>

Kingsley Uyi IdehenMisused term of the day "Document Database". Every <a href="https://bsky.brid.gy/hashtag/DBMS" rel="nofollow noopener" target="_blank">#DBMS</a> <a href="https://bsky.brid.gy/hashtag/RDBMS" rel="nofollow noopener" target="_blank">#RDBMS</a> manages Database Documents that contain relations (sets of tuples). <a href="https://bsky.brid.gy/hashtag/CIO" rel="nofollow noopener" target="_blank">#CIO</a>

Recent searches

Search options

Administered by:

Server stats:

#dbms