#sql

@hackernews Show HN: Graphical SQL Builder and Debugger #HackerNews #Tech #SQL

@lobsters ERD Generator from SQL #Databases #SQL #DeveloperTools

@simon_willison Mapping SQLite result columns back to their source `table.column` #Database #SQL #OpenSource

@lobsters Handling graphs with SQL/PGQ in PostgreSQL #Databases #PostgreSQL #SQL

@hackernews Learn SQL Once, Use It for 30 Years #HackerNews #Tech #SQL

@hackernews SQL patterns I use to catch transaction fraud #HackerNews #Tech #SQL

@lobsters Welcome to ORDER BY jungle #Databases #SQL #Programming

@lobsters SQL: Incorrect by Construction #Databases #SQL #Programming

@lobsters SQL's ORDER BY Has Come a Long Way #SQL #Databases #Programming

@hackernews SQL: Incorrect by Construction #HackerNews #Tech #SQL

@lobsters Quack: The DuckDB Client-Server Protocol #Databases #SQL #OpenSource

@thomas_larock The Long Way 'Round #DataEngineering #Analytics #SQL

@java_sql_and_jooq Simplifying ANTI JOIN with jOOQ Syntax #Java #SQL #Programming

@java_sql_and_jooq Why JOIN USING Can Lead to Errors in SQL #SQL #Database #Programming

@lobsters ggsql: A grammar of graphics for SQL #SQL #DataViz #OpenSource

@hackernews ggsql: A Grammar of Graphics for SQL #HackerNews #Tech #SQL

@simon_willison SQL functions in Google Sheets to fetch data from Datasette #SQL #Datasette #OpenSource

@microsoft_python Write SQL Your Way: Dual Parameter Style Benefits in mssql-python #Python #SQL #Database

@data_methods Building a Clean API on Top of Texas Railroad Commission Permit Data #DataEngineering #API #SQL

@data_methods Querying 160 GB of Parquet Files with DuckDB in 15 Minutes #DataEngineering #SQL #Analytics

@data_methods DuckPond: Building a Self-Hosted Multi-Tenant Query Layer with DuckDB, DuckLake, FastAPI, and React #DataEngineering #SQL #OpenSource

@ben_congdon TIL: SQLite's 'WITHOUT ROWID' #Database #SQL #DevTools

@data_methods Testing Out Time Travel With DuckLake #DataEngineering #SQL #Analytics

@jim_fishers_blog The migration SQL should go in the table #Database #SQL #WebDev

@data_methods SQL Anti-Patterns You Should Avoid #SQL #Data #Programming

@dba_stackexchange How to clean the pg_wal folder when it is not done automatically? #PostgreSQL #Database #SQL

@mongodb_blog MongoDB SQL Interface: Now Available for Enterprise Advanced #Database #SQL #BigData

@scattered_thoughts SQL needed structure #Database #SQL #Programming

@willcodefor_beer Useful Postgres commands #Postgres #Database #SQL

@willcodefor_beer Using generate_series to avoid gaps in data in Postgres #Postgres #Database #SQL

@mark_story SQLServer 2022 + PHP with Docker #PHP #Docker #SQL

@pganalyze_blog Postgres vs. SQL Server: B-Tree Index Differences & the Benefit of Deduplication #Postgres #Database #SQL

@java_sql_and_jooq When SQL Meets Lambda Expressions #SQL #Java #Programming

@java_sql_and_jooq Think About SQL MERGE in Terms of a RIGHT JOIN #SQL #Database #Programming

@java_sql_and_jooq jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more #Java #SQL #Database

@pganalyze_blog Replacing Oracle Hints: Best Practices with pg_hint_plan on PostgreSQL #Postgres #Database #SQL

@roland_boumans_blog DuckDB Bag of Tricks: Reading JSON, Data Type Detection, and Query Performance #DuckDB #SQL #DataEngineering

@geshans_blog How to Upsert Data in Postgres Using INSERT ON CONFLICT UPDATE #Postgres #Database #SQL

@use_the_index_luke Index Usage For EXTRACT(YEAR FROM ...), YEAR(...) etc. #Database #SQL #Performance

@roland_boumans_blog DuckDB bag of tricks: Processing PGN chess games with DuckDB - Extracting Tagpairs with Regular Expressions (5/6) #DuckDB #SQL #Analytics