#sql

@roland_boumans_blog DuckDB bag of tricks: Processing PGN chess games with DuckDB - An Introduction to PGN (1/6) #DuckDB #Chess #SQL

@roland_boumans_blog DuckDB Bag of Tricks: First Splash #DuckDB #Analytics #SQL

@nerderati How to differentiate between empty strings and NULL values in the psql CLI #Database #SQL #Programming

@zwischenzugs At 50 Years Old, Is SQL Becoming a Niche Skill? #SQL #Databases #Tech

@java_sql_and_jooq Emulating SQL FILTER with Oracle JSON Aggregate Functions #SQL #JSON #Oracle

@container_solutions_blog At 50 Years Old, Is SQL Becoming a Niche Skill? #SQL #Programming #Tech

@roland_boumans_blog SAP HANA Trick: DISTINCT STRING_AGG #SQL #Analytics #Database

@scattered_thoughts Unexplanations: sql is syntactic sugar for relational algebra #Databases #Programming #SQL

@java_sql_and_jooq Getting Top 1 Values Per Group in Oracle #SQL #Oracle #Database

@scattered_thoughts Unexplanations: query optimization works because sql is declarative #SQL #Databases #Programming

@java_sql_and_jooq An Efficient Way to Check for Existence of Multiple Values in SQL #SQL #Database #Programming

@pganalyze_blog Introducing pg_query for Postgres 16 - Parsing SQL/JSON, Windows support, PL/pgSQL parse mode & more #Postgres #Database #SQL

@java_sql_and_jooq A Hidden Benefit of Implicit Joins: Join Elimination #Java #SQL #Database

@java_sql_and_jooq jOOQ 3.19's new Explicit and Implicit to-many path joins #Java #SQL #jOOQ

@java_sql_and_jooq Workaround for MySQL's "can't specify target table for update in FROM clause" Error #SQL #MySQL #Database

@graphite Call site attribution: how to pinpoint rogue SQL queries throttling database performance #Database #Performance #SQL

@java_sql_and_jooq Maven Coordinates of the most popular JDBC Drivers #Java #Maven #SQL

@java_sql_and_jooq To DAO or not to DAO #Java #Database #SQL

@java_sql_and_jooq JDBC Connection URLs of the Most Popular RDBMS #Java #SQL #Database

@fuma_nama Item Sorting in SQL #SQL #Database #Programming

@java_sql_and_jooq How to Pass a Table Valued Parameter to a T-SQL Function with jOOQ #Java #SQL #Database

@java_sql_and_jooq How to Turn a List of Flat Elements into a Hierarchy in Java, SQL, or jOOQ #Java #SQL #Programming

@rory_sawyer Generating SQL from Python #Python #SQL #Programming

@java_sql_and_jooq 3.18.0 Release with Support for more Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0 #Java #SQL #Database

@java_sql_and_jooq How to use jOOQ's Converters with UNION Operations #Java #SQL #jOOQ

@java_sql_and_jooq How to Write a Derived Table in jOOQ #Java #SQL #jOOQ

@java_sql_and_jooq The Performance Impact of SQL's FILTER Clause #SQL #Performance #PostgreSQL

@java_sql_and_jooq Emulating Window Functions in MySQL 5.7 #SQL #Java #Database

@java_sql_and_jooq Why You Should Execute jOOQ Queries With jOOQ #Java #SQL #jOOQ

@java_sql_and_jooq jOOQ's R2DBC LoggingConnection to log all SQL statements #Java #SQL #Database

@evert_pot Knex (with MySQL) had a very scary SQL injection #SQL #Security #OpenSource

@java_sql_and_jooq When to Use jOOQ and When to Use Native SQL #Java #SQL #Programming

@java_sql_and_jooq LATERAL is Your Friend to Create Local Column Variables in SQL #SQL #Database #Programming

@java_sql_and_jooq Calling Procedures with Default Parameters using JDBC or jOOQ #Java #SQL #Programming

@alexandru_nedelcu Building a Queue for Delayed Messages via a RDBMS (1): Design #Database #Programming #SQL

@david_winterbottom_tils That Postgres sequences aren't restored after a transaction rollback #Postgres #Database #SQL

@visidata_blog Connect VisiData to SQL Databases with vdsql #DataAnalysis #OpenSource #SQL

@thomas_larock Pro SQL Server 2022 Wait Statistics Book #SQL #Database #Tech

@java_sql_and_jooq Using jOOQ's Implicit Join From Within the JOIN .. ON Clause #Java #SQL #Database

@java_sql_and_jooq A Brief Overview over the Most Common jOOQ Types #Java #SQL #Programming