🤖robot.villas
PostsTagsStatsStatusAbout

© 2025 - 2026 Nat Welch. All rights reserved.

#sql

258 posts

  • @dev_community WINDOW FUNCTIONS,JOINS,SUBQUERIES AND CTEs #SQL #Database #Tutorial

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22723523

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22723523

    Don't have an account? Find a server at joinmastodon.org

    Oct 21, 2026
  • @dev_community Views vs Materialized Views In PostgreSQL #Database #PostgreSQL #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22722348

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22722348

    Don't have an account? Find a server at joinmastodon.org

    Oct 21, 2026
  • @dba_stackexchange Error from trigger that adds an entry into a table once another table gets a new entry #Database #SQL #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22715926

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22715926

    Don't have an account? Find a server at joinmastodon.org

    Oct 21, 2026
  • @dba_stackexchange information associated with resource contention on concurrence processes in sql server #SQL #Database #Performance

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22713430

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22713430

    Don't have an account? Find a server at joinmastodon.org

    Oct 21, 2026
  • @status_cafe stupied 😇 when i learn to fully utilize sql, it will be over... #Tech #Programming #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/status_cafe/posts/22710274

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/status_cafe/posts/22710274

    Don't have an account? Find a server at joinmastodon.org

    Oct 21, 2026
  • @dev_community Batch Deploying GBase Database with a Response File #Database #DevOps #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22706540

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22706540

    Don't have an account? Find a server at joinmastodon.org

    Oct 21, 2026
  • @planetscale_blog I don't trust ON DELETE CASCADE #Database #Postgres #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/planetscale_blog/posts/22720657

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/planetscale_blog/posts/22720657

    Don't have an account? Find a server at joinmastodon.org

    Oct 21, 2026
  • @dev_community Mastering SQL: Window Functions, Joins, Common Table Expressions (CTEs), and Subqueries Using a Hospital Database #SQL #Database #DataScience

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22703932

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22703932

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @dev_community JOINS ,CTES and Subqueries in SQL #SQL #Database #Tutorial

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22697177

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22697177

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @dev_community Database Optimization: Beyond the Basics #Database #Performance #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22694789

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22694789

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @stack_exchange_hot_questions How can I get the object name from the resource? - dba.stackexchange.com #Database #SQL #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/stack_exchange_hot_questions/posts/22705565

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/stack_exchange_hot_questions/posts/22705565

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @dba_stackexchange How can I get the object name from the resource? #Database #SQL #Tech

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22692294

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22692294

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @aws_builder_center Query SCADA and Your Lakehouse in One SQL Engine #CloudComputing #DataEngineering #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/aws_builder_center/posts/22695627

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/aws_builder_center/posts/22695627

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @dev_community SQL Joins, CTEs, Subqueries, and Window Functions: A Practical Guide #SQL #Database #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22687353

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22687353

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @dev_community load data infile optionally enclosed by not working as expected #Database #SQL #DevCommunity

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22686500

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22686500

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @dba_stackexchange Sync data tables between tables in different Postgres schema #PostgreSQL #Database #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22684090

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22684090

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @dev_community SQL Injection: When User Input Becomes a Database Command #CyberSecurity #Database #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22681742

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22681742

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @server_fault How to repair a corrupted SQL database? #Database #SQL #Troubleshooting

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/server_fault/posts/22681134

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/server_fault/posts/22681134

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @habr_ru Текучесть кадров персонала по журналу смен: считаем на SQL, когда никто не увольняется #SQL #Analytics #HR

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/habr_ru/posts/22679504

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/habr_ru/posts/22679504

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @dba_stackexchange GridDB TQL string comparison does not match expected results for values with trailing spaces #Database #SQL #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22679181

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22679181

    Don't have an account? Find a server at joinmastodon.org

    Oct 20, 2026
  • @dev_community JOINS, WINDOW FUNCTIONS, CTEs AND SUBQUERIES #SQL #Database #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22660649

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22660649

    Don't have an account? Find a server at joinmastodon.org

    Oct 19, 2026
  • @atomic_spin How to Run SQL Server Outside Docker Sandboxes #Database #DevOps #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/atomic_spin/posts/22657120

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/atomic_spin/posts/22657120

    Don't have an account? Find a server at joinmastodon.org

    Oct 19, 2026
  • @habr_ru От SQL-запроса до результата -- в одном окне. Обзор на dbt-модуль в SubQuery #DataEngineering #SQL #Analytics

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/habr_ru/posts/22653336

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/habr_ru/posts/22653336

    Don't have an account? Find a server at joinmastodon.org

    Oct 19, 2026
  • @dba_stackexchange Disk space size not reflecting correctly in Marklogic 12 admin page #Database #SQL #Tech

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22652126

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dba_stackexchange/posts/22652126

    Don't have an account? Find a server at joinmastodon.org

    Oct 19, 2026
  • @dev_community SQL FUNCTIONS, CTEs AND SUB-QUERIES EXPLAINED #SQL #Database #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22650363

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22650363

    Don't have an account? Find a server at joinmastodon.org

    Oct 19, 2026
  • @dev_community Find Departments with an Average Salary Above the Company Average #DataAnalysis #SQL #CareerDevelopment

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22649347

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22649347

    Don't have an account? Find a server at joinmastodon.org

    Oct 19, 2026
  • @dev_community An Instant ADD COLUMN Waiting on One Slow SELECT Blocks Every Query Behind It #Postgres #Database #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22648851

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22648851

    Don't have an account? Find a server at joinmastodon.org

    Oct 19, 2026
  • @dev_community How to get correct SQL from AI: give it the schema, the dialect, and EXPLAIN #AI #SQL #Database

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22648617

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22648617

    Don't have an account? Find a server at joinmastodon.org

    Oct 19, 2026
  • @dev_community Advanced SQL in Healthcare Analytics: A Comprehensive Technical Guide Using Our Hospital Dataset #SQL #DataScience #Healthcare

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22643987

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22643987

    Don't have an account? Find a server at joinmastodon.org

    Oct 18, 2026
  • @habr_ru SQL, NoSQL, NewSQL, Distributed SQL: как читать архитектуру СУБД #Database #SQL #Tech

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/habr_ru/posts/22637540

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/habr_ru/posts/22637540

    Don't have an account? Find a server at joinmastodon.org

    Oct 18, 2026
  • @dev_community Window Functions, Joins, Common Table Expressions (CTEs), and Subqueries in SQL. #SQL #Database #Programming

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22636860

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22636860

    Don't have an account? Find a server at joinmastodon.org

    Oct 18, 2026
  • @dev_community A Practical Guide to SQL Joins, Subqueries, CTEs, and Window Functions. #SQL #Database #DataScience

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22634198

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22634198

    Don't have an account? Find a server at joinmastodon.org

    Oct 18, 2026
  • @dev_community SQL Window Functions, Joins, CTEs and Subqueries: A Practical Guide Using a Hospital Dataset #SQL #Database #DataScience

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22633630

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22633630

    Don't have an account? Find a server at joinmastodon.org

    Oct 18, 2026
  • @dev_community Follow one row: what ClickHouse does with your INSERT #Database #DataEngineering #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22628698

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22628698

    Don't have an account? Find a server at joinmastodon.org

    Oct 18, 2026
  • @dev_community Joins In SQL #SQL #Database #Tutorial

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22624263

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22624263

    Don't have an account? Find a server at joinmastodon.org

    Oct 17, 2026
  • @dev_community SQL Server Interview Questions for Senior Developers in 2026 -- Execution Plans, Indexing, Locking & Parameter Sniffing (Deep Answers) #SQL #Database #Interview

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22621375

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22621375

    Don't have an account? Find a server at joinmastodon.org

    Oct 17, 2026
  • @dev_community Column Selection Is Not an Index: Two Different Ways to Reduce Database Work #Database #Performance #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22619408

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22619408

    Don't have an account? Find a server at joinmastodon.org

    Oct 17, 2026
  • @dev_community SQL for Hospital Data Analysis: Window Functions, Joins, CTEs, and Subqueries #SQL #DataAnalysis #Tutorial

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22619053

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22619053

    Don't have an account? Find a server at joinmastodon.org

    Oct 17, 2026
  • @dev_community SQL Injection Prevention: Developer's Security Checklist #Security #WebDev #SQL

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22614296

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22614296

    Don't have an account? Find a server at joinmastodon.org

    Oct 17, 2026
  • @dev_community Business reports in a Uniface service - year comparison, cash forecast and sales funnel with plain SQL #SoftwareDevelopment #SQL #BusinessIntelligence

    Boost from your server

    Enter the server your account is on. The post opens there so you can boost it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22609638

    Don't have an account? Find a server at joinmastodon.org

    Favorite from your server

    Enter the server your account is on. The post opens there so you can favorite it.

    or
    Or paste this post's address into your app's search:https://robot.villas/users/dev_community/posts/22609638

    Don't have an account? Find a server at joinmastodon.org

    Oct 17, 2026
Older »