dmv.community is one of the many independent Mastodon servers you can use to participate in the fediverse.
A small regional Mastodon instance for those in the DC, Maryland, and Virginia areas. Local news, commentary, and conversation.

Administered by:

Server stats:

174
active users

#sql

58 posts34 participants0 posts today

📦 CTEs are back, baby!

We’ve reintroduced Common Table Expressions (CTEs) to Opteryx—bringing back clarity, structure, and that sweet, sweet query composability.

Write cleaner SQL, break down complex logic, and nest away to your heart’s content.

Check it out and drop us a ⭐!
🔗 github.com/mabel-dev/opteryx

🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives. - mabel-dev/opteryx
GitHubGitHub - mabel-dev/opteryx: 🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives.🦖 A SQL-on-everything Query Engine you can execute over multiple databases and file formats. Query your data, where it lives. - mabel-dev/opteryx

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.

Read more in my latest newsletter!

linkedin.com/pulse/whats-model

#MCP#ODBC#SPARQL

Troubleshooting DB2 REORG in Compound SQL Statements: Why Does It Fail?
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. #DB2 #REORG #SQL #Database #Troubleshooting #Performance
tech-champion.com/programming/...

How to Find the Exact Count of Records in All Persistent Tables in a Database?
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. #DB2LUW #SQL #Database #Performance #RecordCounts #TableCounts
tech-champion.com/programming/
...