🤖robot.villas
PostsTagsStatsStatusAbout

© 2025 - 2026 Nat Welch. All rights reserved.

#sql

258 posts

  • @hackernews The Query Transformation Pipeline #HackerNews #Tech #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/hackernews/posts/22359438

    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/hackernews/posts/22359438

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

    Oct 6, 2026
  • @dba_stackexchange Why can't I declare a foreign key relationship with `pg_type`? #Database #SQL #PostgreSQL

    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/22414500

    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/22414500

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

    Oct 6, 2026
  • @dba_stackexchange Support for the Cassandra tool #Database #Cassandra #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/22414520

    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/22414520

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

    Oct 6, 2026
  • @dba_stackexchange How to keep a high-growth payments MySQL master small while retaining full history: is a replica with sql_log_bin=0 partition purges a sound design, #Database #MySQL #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/22451982

    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/22451982

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

    Oct 6, 2026
  • @dba_stackexchange Do long-running queries on the secondary of a secondary availability group prevent ghost cleanup on the global primary? #Database #SQL #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/22414527

    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/22414527

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

    Oct 5, 2026
  • @dba_stackexchange Does trace flag 9559 impact the redo target of a distributed availability group's secondary availability group? #Database #SQL #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/22414536

    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/22414536

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

    Oct 4, 2026
  • @lobsters Join Ordering, Part 1: The Shape of the Search Space #Databases #SQL #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/lobsters/posts/22350684

    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/lobsters/posts/22350684

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

    Sep 30, 2026
  • @lobsters Two Kinds of SQL Query Builders #Databases #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/lobsters/posts/22349872

    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/lobsters/posts/22349872

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

    Sep 29, 2026
  • @hackernews QueryBrew: System-Agnostic SQL-to-SQL Query Optimization [pdf] #HackerNews #Tech #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/hackernews/posts/22328289

    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/hackernews/posts/22328289

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

    Sep 11, 2026
  • @clickhouse_blog AI Functions in ClickHouse: Upgrade your SQL to the AI age #ClickHouse #AI #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/clickhouse_blog/posts/22411100

    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/clickhouse_blog/posts/22411100

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

    Sep 11, 2026
  • @clickhouse_blog Pipelined SQL in ClickHouse 26.8 #Database #Analytics #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/clickhouse_blog/posts/22411200

    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/clickhouse_blog/posts/22411200

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

    Sep 4, 2026
  • @hackernews Keenable SELECT: an agent that searches the web in SQL #HackerNews #Tech #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/hackernews/posts/22314557

    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/hackernews/posts/22314557

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

    Sep 1, 2026
  • @lobsters A Better SQL in 11 Lines of Code #SQL #Databases #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/lobsters/posts/22312722

    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/lobsters/posts/22312722

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

    Aug 31, 2026
  • @hackernews A better SQL in 11 lines of code #HackerNews #Tech #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/hackernews/posts/22311494

    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/hackernews/posts/22311494

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

    Aug 29, 2026
  • @philipp_salvisbergs_blog Implicit Outer Joins in Join-to-One: Feature or Flaw? #SQL #Oracle #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/philipp_salvisbergs_blog/posts/22454687

    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/philipp_salvisbergs_blog/posts/22454687

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

    Aug 29, 2026
  • @hackernews LeanDB a strongly Typed SQL front end #HackerNews #Tech #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/hackernews/posts/22313296

    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/hackernews/posts/22313296

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

    Aug 27, 2026
  • @lobsters Solving the 1+N query problem #Databases #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/lobsters/posts/22305604

    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/lobsters/posts/22305604

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

    Aug 25, 2026
  • @philipp_salvisbergs_blog The Checkbox That Disables TLS #Database #Security #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/philipp_salvisbergs_blog/posts/22454696

    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/philipp_salvisbergs_blog/posts/22454696

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

    Aug 23, 2026
  • @hackernews DuckDB V2 PEG-based SQL parser #HackerNews #Tech #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/hackernews/posts/22302129

    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/hackernews/posts/22302129

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

    Aug 21, 2026
  • @lobsters Things I want in a modern relational query language #Databases #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/lobsters/posts/22298964

    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/lobsters/posts/22298964

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

    Aug 19, 2026
  • @lobsters Creating CSS with SQL #CSS #SQL #WebDev

    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/lobsters/posts/22298094

    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/lobsters/posts/22298094

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

    Aug 18, 2026
  • @data_methods Tracing a DuckDB SQL Query #Data #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/data_methods/posts/22413956

    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/data_methods/posts/22413956

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

    Aug 15, 2026
  • @lobsters Modeling State Transitions in Postgres #Postgres #Databases #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/lobsters/posts/22287534

    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/lobsters/posts/22287534

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

    Aug 11, 2026
  • @veit_heller Simple Sudoku Solvers SII, EVI: SQL #Programming #SQL #Algorithms

    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/veit_heller/posts/22326091

    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/veit_heller/posts/22326091

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

    Aug 11, 2026
  • @dba_stackexchange Query Store transaction preventing restoring 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/dba_stackexchange/posts/22414557

    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/22414557

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

    Aug 5, 2026
  • @alonso_network Easily do SQL-Only Dev in Node #NodeJS #SQL #DevTools

    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/alonso_network/posts/22399969

    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/alonso_network/posts/22399969

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

    Aug 5, 2026
  • @data_methods Why I Decided to Give dbt Another Look #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/data_methods/posts/22413974

    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/data_methods/posts/22413974

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

    Jul 27, 2026
  • @philipp_salvisbergs_blog The Return of SQLcl's SCRIPT Command #SQL #Oracle #Developer

    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/philipp_salvisbergs_blog/posts/22454707

    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/philipp_salvisbergs_blog/posts/22454707

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

    Jul 25, 2026
  • @data_methods Notes On Semantic Model Refinement #Data #Analytics #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/data_methods/posts/22413980

    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/data_methods/posts/22413980

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

    Jul 23, 2026
  • @hackernews Show HN: I implemented a neural network in SQL #HackerNews #Tech #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/hackernews/posts/22258493

    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/hackernews/posts/22258493

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

    Jul 13, 2026
  • @unix_linux_community What is Open SQL gateway? #Database #SQL #SysAdmin

    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/unix_linux_community/posts/22448732

    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/unix_linux_community/posts/22448732

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

    Jul 8, 2026
  • @lobsters Backstage access: an unauthenticated SQL injection in Front Gate Tickets #Security #SQL #Vulnerability

    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/lobsters/posts/22250860

    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/lobsters/posts/22250860

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

    Jul 6, 2026
  • @hackernews Ray Tracer in SQL #HackerNews #Tech #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/hackernews/posts/22245782

    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/hackernews/posts/22245782

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

    Jul 1, 2026
  • @hackernews What ORMs have taught me: just learn SQL (2014) #HackerNews #Tech #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/hackernews/posts/22248983

    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/hackernews/posts/22248983

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

    Jul 1, 2026
  • @data_methods How Debezium Works #DataEngineering #Databases #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/data_methods/posts/22414000

    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/data_methods/posts/22414000

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

    Jun 30, 2026
  • @lobsters Waiting for SQL:202y: Stockholm (BMA) meeting report #SQL #Databases #OpenSource

    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/lobsters/posts/22244110

    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/lobsters/posts/22244110

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

    Jun 30, 2026
  • @lobsters Structured Primary Keys #Databases #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/lobsters/posts/22239069

    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/lobsters/posts/22239069

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

    Jun 25, 2026
  • @hackernews Show HN: Bun-sqlgen - Type-safe raw SQL for Bun, no ORM #HackerNews #Tech #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/hackernews/posts/22236124

    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/hackernews/posts/22236124

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

    Jun 23, 2026
  • @hackernews Show HN: Graphical SQL Builder and Debugger #HackerNews #Tech #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/hackernews/posts/22237010

    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/hackernews/posts/22237010

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

    Jun 22, 2026
  • @lobsters ERD Generator from SQL #Databases #SQL #DeveloperTools

    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/lobsters/posts/22228210

    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/lobsters/posts/22228210

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

    Jun 14, 2026
« NewerOlder »