What's the most sophisticated query you've written to solve a real-world problem? How did it take advantage of PostgreSQL's capabilities?

#SQL #Postgres #PostgreSQL #OpenSource #Database #SQLquery #Development

【決定版】TypeScriptのSQLタグ付きテンプレートリテラルで10種類のSQLiteドライバー全部試す

はじめに TypeScriptのSQLタグ付きテンプレートリテラルを数行で書けて超絶便利だったので、10種類のSQLiteドライバーで試した結果を紹介します。 SQLタグ付きテンプレートリテラル 今回の記事で何回も登場しますが、先にSQLタグ付きテンプレートリテラルだけ紹介します。 type SqlBinding = null | number | string; type SqlQuery = { query: string; bindings: SqlBinding[]; };…

SQL Query to find members of an Active Directory Security Group | https://techygeekshome.info/sql-query-active-directory-group-members/?fsp_sid=10201 | #Guide #SystemCenter #ActiveDirectory #Guide #Microsoft #Query #SQL #SQLQuery #ActiveDirectory #SecurityGroup #BlueskyPlatform #DatabaseManagement #

I've found the ParseResult structure returned from pg_query::parse() to be fairly tedious to navigate and use. I've now created my own structures, the top level called SqlQuery, and a function to convert a ParseResult to a SqlQuery.

The SQL IN operator is a powerful comparison tool used in WHERE clauses to filter results based on a list of values. Let’s Explore Deeply.

madesimplemssql.com/sql-in-opera...

#dbms #Database #sqldatabase #sqldba #DBA #DBAProgram #madesimplemssql #SQLDBA #coding #backend #sqlquery #sql_help

Frameworks are great productivity boosters but sometimes you just need a light weight thing to map SQL results to an object.

Jdbi is great for this jdbi.org 👇

How can I check the version and edition of SQL Server installed? via PlanetPowerShell #SQLServer #DatabaseManagement #DataAnalysis #SQLQuery

#SQLQuery

🔔 Nouvel article ! 🔔
🆕 Avoir le temps d'exécution détaillé d'une requête SQL

https://blog.shevarezo.fr/post/2024/09/12/temps-execution-requete-sql

#mariadb #mysql #sql #query #sqlquery #dba

Life of a #SQLQuery. Excellent improvements with 1. #Optimizer with #AdaptiveQueryExecution 2. #ExecutionEngine with re-written C+ and ~10X faster (#JVM #Presto) 3. #Caching with fast store 4. #AuxiliaryDataStructure: #DataSkipping with #DeltaLake transactionlog #dataaisummit