phpc.social is one of the many independent Mastodon servers you can use to participate in the fediverse.
A server for PHP programmers & friends. Join us for discussions on the PHP programming language, frameworks, packages, tools, open source, tech, life, and more.

Administered by:

Server stats:

800
active users

#database

12 posts12 participants0 posts today
Linuxiac<p>Valkey 8.1 in-memory data store is here with boosts in performance, lower latency, enhanced observability, and more.<br><a href="https://linuxiac.com/valkey-8-1-in-memory-data-store-unleashes-10-faster-throughput/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">linuxiac.com/valkey-8-1-in-mem</span><span class="invisible">ory-data-store-unleashes-10-faster-throughput/</span></a></p><p><a href="https://mastodon.social/tags/valkey" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>valkey</span></a> <a href="https://mastodon.social/tags/redis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>redis</span></a> <a href="https://mastodon.social/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mastodon.social/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a></p>
Gea-Suan Lin<p>Django 5.2 支援 composite primary key</p><p>看到 Django 5.2 的公告,裡面列出了比較重大的改變,其中一個注意到的是支援 Composite (Compound) Primary Key 了:「Django 5.2 released」,完整的 release notes 則是在「Django 5.2 release notes」這邊可以看到。 就是因為這些 ORM library 不支援 compsite primary key,所以才會有 best (?) practice 要求每個表格都要有 primary key,而且是單一欄位... 大家應該都習以為常了,怎麼會突然在 2025 年才想要支援? …</p><p><a href="https://blog.gslin.org/archives/2025/04/04/12331/django-5-2-%e6%94%af%e6%8f%b4-composite-primary-key/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">blog.gslin.org/archives/2025/0</span><span class="invisible">4/04/12331/django-5-2-%e6%94%af%e6%8f%b4-composite-primary-key/</span></a></p><p><a href="https://abpe.org/tags/composite" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>composite</span></a> <a href="https://abpe.org/tags/compound" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>compound</span></a> <a href="https://abpe.org/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://abpe.org/tags/db" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>db</span></a> <a href="https://abpe.org/tags/django" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>django</span></a> <a href="https://abpe.org/tags/library" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>library</span></a> <a href="https://abpe.org/tags/orm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>orm</span></a> <a href="https://abpe.org/tags/pk" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>pk</span></a> <a href="https://abpe.org/tags/PrimaryKey" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PrimaryKey</span></a> <a href="https://abpe.org/tags/rdbms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rdbms</span></a></p>
Orhun Parmaksız 👾<p>What do you call MongoDB in a terminal?</p><p>🍃 **tongo** — A TUI for navigating and manipulating MongoDB.</p><p>🔥 Supports fuzzy search, multiple sessions, customizations &amp; more!</p><p>🦀 Written in Rust &amp; built with <span class="h-card" translate="no"><a href="https://fosstodon.org/@ratatui_rs" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>ratatui_rs</span></a></span></p><p>⭐ GitHub: <a href="https://github.com/drewzemke/tongo" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">github.com/drewzemke/tongo</span><span class="invisible"></span></a></p><p><a href="https://fosstodon.org/tags/rustlang" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>rustlang</span></a> <a href="https://fosstodon.org/tags/ratatui" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ratatui</span></a> <a href="https://fosstodon.org/tags/tui" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tui</span></a> <a href="https://fosstodon.org/tags/mongodb" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mongodb</span></a> <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/administration" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>administration</span></a> <a href="https://fosstodon.org/tags/terminal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>terminal</span></a> <a href="https://fosstodon.org/tags/commandline" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>commandline</span></a></p>
Sarah Conway<p>Hey <a href="https://infosec.exchange/tags/Montreal" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Montreal</span></a>, did you know Postgres Extensions Day is coming May 12? </p><p>Anyone working with PostgreSQL or who is interested in extension development can benefit from this event. Sign up for free, here: <a href="https://pgext.day" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">pgext.day</span><span class="invisible"></span></a></p><p>Questions? Get in touch with <span class="h-card" translate="no"><a href="https://discuss.systems/@yrashk" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>yrashk</span></a></span></p><p><a href="https://infosec.exchange/tags/devcommunity" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>devcommunity</span></a> <a href="https://infosec.exchange/tags/canada" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>canada</span></a> <a href="https://infosec.exchange/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://infosec.exchange/tags/data" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>data</span></a> <a href="https://infosec.exchange/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://infosec.exchange/tags/foss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>foss</span></a> <a href="https://infosec.exchange/tags/oss" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>oss</span></a> <a href="https://infosec.exchange/tags/opensource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>opensource</span></a> <a href="https://infosec.exchange/tags/techevent" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>techevent</span></a> <a href="https://infosec.exchange/tags/hacker" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>hacker</span></a> <a href="https://infosec.exchange/tags/coder" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>coder</span></a> <a href="https://infosec.exchange/tags/applicationdeveloper" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>applicationdeveloper</span></a> <a href="https://infosec.exchange/tags/dev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dev</span></a> <a href="https://infosec.exchange/tags/developer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>developer</span></a> <a href="https://infosec.exchange/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a></p>
Elegant Joy Digital<p>Do you, like me, LOVE SQL?? </p><p>I'm not kidding.</p><p>Check out the SQL murder mystery!<br>It's a fun way to exercise your SQL skills.</p><p><a href="https://mystery.knightlab.com/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">mystery.knightlab.com/</span><span class="invisible"></span></a></p><p>NO SPOILERS - yes, I know who did it.</p><p><a href="https://mastodon.online/tags/womenintech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>womenintech</span></a> <a href="https://mastodon.online/tags/sql" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>sql</span></a> <a href="https://mastodon.online/tags/mystery" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mystery</span></a> <a href="https://mastodon.online/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a></p>
🔘 G◍M◍◍T 🔘<p>💡 MCP: lo standard che collega modelli AI e dati in tempo reale</p><p><a href="https://gomoot.com/mcp-lo-standard-che-collega-modelli-ai-e-dati-in-tempo-reale/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">gomoot.com/mcp-lo-standard-che</span><span class="invisible">-collega-modelli-ai-e-dati-in-tempo-reale/</span></a></p><p><a href="https://mastodon.uno/tags/anthropic" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>anthropic</span></a> <a href="https://mastodon.uno/tags/blog" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>blog</span></a> <a href="https://mastodon.uno/tags/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mastodon.uno/tags/dati" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>dati</span></a> <a href="https://mastodon.uno/tags/llm" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>llm</span></a> <a href="https://mastodon.uno/tags/mcp" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>mcp</span></a> <a href="https://mastodon.uno/tags/news" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>news</span></a> <a href="https://mastodon.uno/tags/openai" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>openai</span></a> <a href="https://mastodon.uno/tags/picks" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>picks</span></a> <a href="https://mastodon.uno/tags/server" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>server</span></a> <a href="https://mastodon.uno/tags/tech" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tech</span></a> <a href="https://mastodon.uno/tags/tecnologia" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>tecnologia</span></a></p>
Michel Lind :fedora: :debian:<p>Bless your transactions by committing them with "amen" in <span class="h-card" translate="no"><a href="https://fosstodon.org/@mariadb" class="u-url mention" rel="nofollow noopener noreferrer" target="_blank">@<span>mariadb</span></a></span> </p><p><a href="https://mariadb.org/amen-statement-for-committing-transactions/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">mariadb.org/amen-statement-for</span><span class="invisible">-committing-transactions/</span></a></p><p><a href="https://hachyderm.io/tags/AprilFools" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>AprilFools</span></a> <br><a href="https://hachyderm.io/tags/MariaDB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MariaDB</span></a> <br><a href="https://hachyderm.io/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <br><a href="https://hachyderm.io/tags/Transaction" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Transaction</span></a></p>
InfoQ<p>Ever wondered how to compute a function across multiple parties without revealing their inputs?</p><p>This technique can be used to split secrets among parties, perform logical operations, or count votes in a way that ensures data privacy is preserved.</p><p>Read the <a href="https://techhub.social/tags/InfoQ" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>InfoQ</span></a> article to learn more: <a href="https://bit.ly/4cx8sAV" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">bit.ly/4cx8sAV</span><span class="invisible"></span></a> </p><p><a href="https://techhub.social/tags/BigData" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>BigData</span></a> <a href="https://techhub.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://techhub.social/tags/DataPrivacy" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataPrivacy</span></a> <a href="https://techhub.social/tags/SecureCoding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SecureCoding</span></a> <a href="https://techhub.social/tags/Algorithms" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Algorithms</span></a></p>
James Gayfer<p>Is it a code smell for a table in Postgres to have mutually exclusive foreign keys?</p><p>For example, table A has foreign keys to table B and C, but there's a constraint in place where only one of those foreign keys can be populated.</p><p>My gut says I should be creating separate tables for these, as I'm effectively trying to tie a single table to multiple domain models (that happen to share the same fields).</p><p><a href="https://fosstodon.org/tags/postgres" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>postgres</span></a> <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/databases" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>databases</span></a></p>
Truls<p>I am a (relational) database guy and have been for decades. </p><p>When I read "feature drop" it sounds to me, as if something was removed, not added. </p><p><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/database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>database</span></a> <a href="https://mastodon.social/tags/wording" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>wording</span></a> <a href="https://mastodon.social/tags/featureDrop" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>featureDrop</span></a></p>
Pierre Zemb<p>👀 Wondering what’s hot in <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/research" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>research</span></a>? Ryan Marcus analyzed citation growth to rank the 20 fastest-rising papers!</p><p><a href="https://rmarcus.info/blog/2025/03/28/hottest-db-topics.html" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">rmarcus.info/blog/2025/03/28/h</span><span class="invisible">ottest-db-topics.html</span></a></p>
.:\dGh/:.<p>Found the antichrist on myself.</p><p><a href="https://mastodon.social/tags/PHP" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>PHP</span></a> <a href="https://mastodon.social/tags/Laravel" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Laravel</span></a> <a href="https://mastodon.social/tags/EloquentORM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>EloquentORM</span></a> <a href="https://mastodon.social/tags/ORM" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>ORM</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/DB" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.social/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a> <a href="https://mastodon.social/tags/Code" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Code</span></a> <a href="https://mastodon.social/tags/SoftwareDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SoftwareDevelopment</span></a> <a href="https://mastodon.social/tags/Software" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Software</span></a> <a href="https://mastodon.social/tags/WebDevelopment" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WebDevelopment</span></a> <a href="https://mastodon.social/tags/WebDev" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>WebDev</span></a></p>
Simon Dassow<p>Oh, this is cool: <a href="https://diy-synths.snnkv.com" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="">diy-synths.snnkv.com</span><span class="invisible"></span></a></p><p><a href="https://masto.ai/tags/DIY" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DIY</span></a> <a href="https://masto.ai/tags/OpenSource" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OpenSource</span></a> <a href="https://masto.ai/tags/Synthesizer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Synthesizer</span></a> <a href="https://masto.ai/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a></p>
zartom<p>Troubleshooting DB2 REORG in Compound SQL Statements: Why Does It Fail?<br>Troubleshooting DB2 REORG compound statements. Learn the difference between compiled and inlined compound SQL blocks in DB2 LUW to avoid errors and optimize database reorganization. Key takeaways include best practices, error handling, and performance considerations. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/REORG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>REORG</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/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/Troubleshooting" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Troubleshooting</span></a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Performance</span></a><br><a href="https://tech-champion.com/programming/troubleshooting-db2-reorg-in-compound-sql-statements-why-doe" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/programming/</span><span class="invisible">troubleshooting-db2-reorg-in-compound-sql-statements-why-doe</span></a>...</p>
zartom<p>How to Overcome the Listagg Limit of 4000 Characters<br>Overcome the LISTAGG limit in SQL for large datasets! Strategies like chunking and recursive CTEs help manage massive concatenated strings. Learn practical solutions for efficient SQL queries. <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/LISTAGG" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LISTAGG</span></a> <a href="https://mastodon.social/tags/StringConcatenation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>StringConcatenation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQLQueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLQueries</span></a> <a href="https://mastodon.social/tags/LargeDatasets" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>LargeDatasets</span></a><br><a href="https://tech-champion.com/database/how-to-overcome-the-listagg-limit-of-4000-characters/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/how</span><span class="invisible">-to-overcome-the-listagg-limit-of-4000-characters/</span></a><br>...</p>
zartom<p>How to Find the Exact Count of Records in All Persistent Tables in a Database?<br>Finding accurate Total persistent table records in DB2 LUW can be tricky. Standard methods aren't always precise, especially in high-transaction environments. Learn alternative, efficient techniques to get accurate counts. <a href="https://mastodon.social/tags/DB2LUW" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2LUW</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/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/Performance" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Performance</span></a> <a href="https://mastodon.social/tags/RecordCounts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>RecordCounts</span></a> <a href="https://mastodon.social/tags/TableCounts" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>TableCounts</span></a><br><a href="https://tech-champion.com/programming/how-to-find-the-exact-count-of-records-in-all-persistent-tables-in-a-database/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/programming/</span><span class="invisible">how-to-find-the-exact-count-of-records-in-all-persistent-tables-in-a-database/</span></a><br>...</p>
zartom<p>DB2 for i Date Comparison: A Guide to Efficient Date Handling<br>Master DB2 for i Date Comparison! Learn efficient techniques for accurate &amp; reliable date handling in your DB2 applications. Improve query efficiency &amp; avoid common pitfalls. <a href="https://mastodon.social/tags/DB2" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DB2</span></a> <a href="https://mastodon.social/tags/DateComparison" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DateComparison</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</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/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a> <a href="https://mastodon.social/tags/iSeries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>iSeries</span></a><br><a href="https://tech-champion.com/database/db2luw/db2-for-i-date-comparison-a-guide-to-efficient-date-handling/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/db2</span><span class="invisible">luw/db2-for-i-date-comparison-a-guide-to-efficient-date-handling/</span></a><br>...</p>
zartom<p>How to Change Column Collation in MySQL<br>Need to change column collation in MySQL? Our guide covers updating single columns, tables, and databases for better character support. Learn SQL commands &amp; automation tips! <a href="https://mastodon.social/tags/MySQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>MySQL</span></a> <a href="https://mastodon.social/tags/Collation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Collation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</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/CharacterSet" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>CharacterSet</span></a> <a href="https://mastodon.social/tags/UTF8MB4" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>UTF8MB4</span></a><br><a href="https://tech-champion.com/database/mysql/how-to-change-column-collation-in-mysql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/mys</span><span class="invisible">ql/how-to-change-column-collation-in-mysql/</span></a><br>...</p>
zartom<p>Find the Oldest Even-Numbered Patient Visit Using SQL<br>Learn to extract the Oldest Even Visit SQL record! This tutorial covers various SQL techniques, including CTEs and subqueries, to efficiently retrieve this data. Optimize your queries for speed and handle missing data. <a href="https://mastodon.social/tags/SQLqueries" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLqueries</span></a> <a href="https://mastodon.social/tags/DataAnalysis" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DataAnalysis</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/OldestRecord" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>OldestRecord</span></a> <a href="https://mastodon.social/tags/EvenVisit" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>EvenVisit</span></a> <a href="https://mastodon.social/tags/Coding" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Coding</span></a><br><a href="https://tech-champion.com/database/sql-server/find-the-oldest-even-numbered-patient-visit-using-sql/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/database/sql</span><span class="invisible">-server/find-the-oldest-even-numbered-patient-visit-using-sql/</span></a><br>...</p>
zartom<p>SQL Server String Aggregation: SQL Server 2016 vs. 2017<br>Master SQL Server String Aggregation across versions (2016+). Learn dynamic SQL, best practices, &amp;amp; secure techniques to prevent SQL injection. <a href="https://mastodon.social/tags/SQLServer" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLServer</span></a> <a href="https://mastodon.social/tags/DynamicSQL" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>DynamicSQL</span></a> <a href="https://mastodon.social/tags/StringAggregation" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>StringAggregation</span></a> <a href="https://mastodon.social/tags/Database" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Database</span></a> <a href="https://mastodon.social/tags/SQLInjection" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>SQLInjection</span></a> <a href="https://mastodon.social/tags/Programming" class="mention hashtag" rel="nofollow noopener noreferrer" target="_blank">#<span>Programming</span></a><br><a href="https://tech-champion.com/general/sql-server-string-aggregation-sql-server-2016-vs-2017/" rel="nofollow noopener noreferrer" translate="no" target="_blank"><span class="invisible">https://</span><span class="ellipsis">tech-champion.com/general/sql-</span><span class="invisible">server-string-aggregation-sql-server-2016-vs-2017/</span></a><br>...</p>