RANDOMBLOGS (RSS)

blog.jooq.org


3. 6. 2024Emulating SQL FILTER with Oracle JSON Aggregate Functions – blog.jooq.org
1. 3. 2024Getting Top 1 Values Per Group in Oracle – blog.jooq.org
16. 2. 2024An Efficient Way to Check for Existence of Multiple Values in SQL – blog.jooq.org
10. 1. 2024A Hidden Benefit of Implicit Joins: Join Elimination – blog.jooq.org
28. 12. 2023jOOQ 3.19’s new Explicit and Implicit to-many path joins – blog.jooq.org
20. 12. 2023Workaround for MySQL’s “can’t specify target table for update in FROM clause” Error – blog.jooq.org
15. 12. 2023jOOQ 3.19.0 Released with DuckDB, Trino, Oracle 23c support, join path improvements, an official gradle plugin, commercial maven repositories, policies, UDT paths, trigger meta data, hierarchies, and much more – blog.jooq.org
13. 12. 2023Maven Coordinates of the most popular JDBC Drivers – blog.jooq.org
6. 12. 2023To DAO or not to DAO – blog.jooq.org
1. 12. 2023JDBC Connection URLs of the Most Popular RDBMS – blog.jooq.org
28. 6. 2023How to Generate Package Private Code with jOOQ’s Code Generator – blog.jooq.org
25. 4. 2023How to Pass a Table Valued Parameter to a T-SQL Function with jOOQ – blog.jooq.org
24. 3. 2023How to Turn a List of Flat Elements into a Hierarchy in Java, SQL, or jOOQ – blog.jooq.org
8. 3. 20233.18.0 Release with Support for more Diagnostics, SQL/JSON, Oracle Associative Arrays, Multi dimensional Arrays, R2DBC 1.0 – blog.jooq.org
2. 3. 2023How to use jOOQ’s Converters with UNION Operations – blog.jooq.org
24. 2. 2023How to Write a Derived Table in jOOQ – blog.jooq.org
6. 2. 2023The Performance Impact of SQL’s FILTER Clause – blog.jooq.org
20. 1. 2023Emulating Window Functions in MySQL 5.7 – blog.jooq.org
18. 1. 2023Why You Should Execute jOOQ Queries With jOOQ – blog.jooq.org
17. 1. 2023jOOQ’s R2DBC LoggingConnection to log all SQL statements – blog.jooq.org
8. 12. 2022When to Use jOOQ and When to Use Native SQL – blog.jooq.org
4. 11. 2022LATERAL is Your Friend to Create Local Column Variables in SQL – blog.jooq.org
21. 10. 2022Calling Procedures with Default Parameters using JDBC or jOOQ – blog.jooq.org
13. 9. 2022Using jOOQ’s Implicit Join From Within the JOIN .. ON Clause – blog.jooq.org
6. 9. 2022A Brief Overview over the Most Common jOOQ Types – blog.jooq.org
1. 9. 2022How to Plot an ASCII Bar Chart with SQL – blog.jooq.org
30. 8. 2022The Second Best Way to Fetch a Spring Data JPA DTO Projection – blog.jooq.org
30. 8. 2022Cannot resolve symbol ‘VERSION_3_17’ in jOOQ generated code – blog.jooq.org
25. 8. 2022jOOQ 3.17 Supports Implicit Join also in DML – blog.jooq.org
24. 8. 2022A Condition is a Field – blog.jooq.org
23. 8. 2022The Many Ways to Return Data From SQL DML – blog.jooq.org
22. 8. 2022How to Integration Test Stored Procedures with jOOQ – blog.jooq.org
19. 8. 2022Using H2 as a Test Database Product with jOOQ – blog.jooq.org
28. 7. 2022The Best Way to Call Stored Procedures from Java: With jOOQ – blog.jooq.org
30. 6. 2022Create Dynamic Views with jOOQ 3.17’s new Virtual Client Side Computed Columns – blog.jooq.org
22. 6. 20223.17.0 Release with Computed Columns, Audit Columns, Pattern Matching, Reactive Transactions and Kotlin Coroutine Support – blog.jooq.org
10. 6. 2022How to Filter a SQL Nested Collection by a Value – blog.jooq.org
9. 6. 2022The Performance of Various To-Many Nesting Algorithms – blog.jooq.org
31. 5. 2022Changing SELECT .. FROM Into FROM .. SELECT Does Not “Fix” SQL – blog.jooq.org
19. 5. 2022The Many Different Ways to Fetch Data in jOOQ – blog.jooq.org
11. 5. 2022Setting the JDBC Statement.setFetchSize() to 1 for Single Row Queries – blog.jooq.org
9. 5. 2022How to Typesafely Map a Nested SQL Collection into a Nested Java Map with jOOQ – blog.jooq.org
4. 5. 2022A Quick and Dirty Way to Concatenate Two Vaguely Related Tables in SQL – blog.jooq.org
28. 4. 2022Nested Transactions in jOOQ – blog.jooq.org
1. 3. 2022How to Fetch Sequence Values with jOOQ – blog.jooq.org
24. 2. 2022Various Meanings of SQL’s PARTITION BY Syntax – blog.jooq.org
22. 2. 2022Use MULTISET Predicates to Compare Data Sets – blog.jooq.org
21. 2. 2022Projecting Type Safe Nested TableRecords with jOOQ 3.17 – blog.jooq.org
14. 2. 2022jOOQ 3.16 and Java EE vs Jakarta EE – blog.jooq.org
8. 2. 2022No More MultipleBagFetchException Thanks to Multiset Nested Collections – blog.jooq.org
4. 2. 2022Approximating e With SQL – blog.jooq.org
2. 2. 2022Traversing jOOQ Expression Trees with the new Traverser API – blog.jooq.org
28. 1. 2022Detect Accidental Blocking Calls when Using R2DBC – blog.jooq.org
14. 1. 2022A Rarely Seen, but Useful SQL Feature: CORRESPONDING – blog.jooq.org
11. 1. 2022Using jOOQ’s DiagnosticsConnection to detect N+1 Queries – blog.jooq.org
7. 1. 2022The Useful BigQuery * EXCEPT Syntax – blog.jooq.org
5. 1. 20223.16.0 Release with a new Public Query Object Model API, Spatial Support, YugabyteDB Support and Much More – blog.jooq.org
16. 12. 2021How to customise a jOOQ Configuration that is injected using Spring Boot – blog.jooq.org
9. 12. 2021Using JDK Collectors to De-duplicate parent/child nested collections – blog.jooq.org
6. 12. 2021Why You Should Use jOOQ With Code Generation – blog.jooq.org
15. 11. 2021Fun with PostGIS: Mandelbrot Set, Game of Life, and More – blog.jooq.org
5. 11. 2021PostgreSQL 14’s enable_memoize For Improved Performance of Nested Loop Joins – blog.jooq.org
1. 11. 2021Java’s Checked Exceptions Are Just Weird Union Types – blog.jooq.org
29. 10. 2021Functional Dependencies in SQL GROUP BY – blog.jooq.org
22. 10. 2021Write C-Style Local Static Variables in Java 16 – blog.jooq.org
19. 10. 2021The jOOQ Parser Ignore Comment Syntax – blog.jooq.org
7. 10. 2021Use jOOλ’s Sneaky Throw to Avoid Checked Exceptions – blog.jooq.org
27. 8. 2021Using Testcontainers to Generate jOOQ Code – blog.jooq.org
26. 8. 2021Using jOOQ to write vendor agnostic SQL with JPA’s native query or @Formula – blog.jooq.org
25. 8. 2021Vendor Agnostic, Dynamic Procedural Logic with jOOQ – blog.jooq.org
23. 8. 2021MySQL’s allowMultiQueries flag with JDBC and jOOQ – blog.jooq.org
20. 8. 202110 Things You Didn’t Know About jOOQ – blog.jooq.org
19. 8. 2021Formatting ASCII Charts With jOOQ – blog.jooq.org
27. 7. 2021Standard SQL/JSON – The Sobering Parts – blog.jooq.org
27. 7. 2021Standard SQL/JSON – The Sobering Parts – blog.jooq.org
20. 7. 2021Ad-hoc Data Type Conversion with jOOQ 3.15 – blog.jooq.org
20. 7. 2021Ad-hoc Data Type Conversion with jOOQ 3.15 – blog.jooq.org
15. 7. 2021Reactive SQL with jOOQ 3.15 and R2DBC – blog.jooq.org
15. 7. 2021Reactive SQL with jOOQ 3.15 and R2DBC – blog.jooq.org
6. 7. 20213.15.0 Release with Support for R2DBC, Nested ROW, ARRAY, and MULTISET types, 5 new SQL dialects, CREATE PROCEDURE, FUNCTION, and TRIGGER support and Much More – blog.jooq.org
6. 7. 20213.15.0 Release with Support for R2DBC, Nested ROW, ARRAY, and MULTISET types, 5 new SQL dialects, CREATE PROCEDURE, FUNCTION, and TRIGGER support and Much More – blog.jooq.org
6. 7. 2021jOOQ 3.15’s New Multiset Operator Will Change How You Think About SQL – blog.jooq.org
6. 7. 2021jOOQ 3.15’s New Multiset Operator Will Change How You Think About SQL – blog.jooq.org
24. 6. 2021Quickly Trying out jOOQ with Jbang! – blog.jooq.org
24. 6. 2021Quickly Trying out jOOQ with Jbang! – blog.jooq.org
4. 6. 2021How to Prevent Execution Plan Troubles when Querying Skewed Data, with jOOQ – blog.jooq.org
4. 6. 2021How to Prevent Execution Plan Troubles when Querying Skewed Data, with jOOQ – blog.jooq.org
17. 5. 2021Use ResultQuery.collect() to Implement Powerful Mappings – blog.jooq.org
17. 5. 2021Use ResultQuery.collect() to Implement Powerful Mappings – blog.jooq.org
12. 5. 2021How to Get an RDBMS Server Version with SQL – blog.jooq.org
12. 5. 2021How to Get an RDBMS Server Version with SQL – blog.jooq.org
22. 4. 2021Use IN List Padding to Your JDBC Application to Avoid Cursor Cache Contention Problems – blog.jooq.org
22. 4. 2021Use IN List Padding to Your JDBC Application to Avoid Cursor Cache Contention Problems – blog.jooq.org
30. 3. 2021Never Again Forget to Call .execute() in jOOQ – blog.jooq.org
30. 3. 2021Never Again Forget to Call .execute() in jOOQ – blog.jooq.org
11. 3. 2021Calculating Pagination Metadata Without Extra Roundtrips in SQL – blog.jooq.org
11. 3. 2021Calculating Pagination Metadata Without Extra Roundtrips in SQL – blog.jooq.org
15. 2. 2021Simulating Latency with SQL / JDBC – blog.jooq.org
10. 2. 2021Translating Stored Procedures Between Dialects – blog.jooq.org
8. 2. 2021Implementing a generic REDUCE aggregate function with SQL – blog.jooq.org
4. 2. 2021jOOQ Internals: Pushing up SQL fragments – blog.jooq.org
17. 11. 2020Automatically Transform Oracle Style Implicit Joins to ANSI JOIN using jOOQ – blog.jooq.org
20. 10. 2020jOOQ 3.14 Released With SQL/XML and SQL/JSON Support – blog.jooq.org
13. 10. 2020Using jOOQ 3.14 Synthetic Foreign Keys to Write Implicit Joins on Views – blog.jooq.org
9. 10. 2020Nesting Collections With jOOQ 3.14’s SQL/XML or SQL/JSON support – blog.jooq.org
10. 9. 2020Having “constant” columns in foreign keys – blog.jooq.org
5. 8. 2020Use NATURAL FULL JOIN to compare two tables in SQL – blog.jooq.org
22. 7. 2020Could we Have a Language That Hides Collections From Us? – blog.jooq.org
5. 5. 2020Using SQL Server FOR XML and FOR JSON Syntax on Other RDBMS With jOOQ – blog.jooq.org
10. 4. 2020The Many Flavours of the Arcane SQL MERGE Statement – blog.jooq.org
3. 4. 2020What’s a “String” in the jOOQ API? – blog.jooq.org
6. 3. 2020Create Empty Optional SQL Clauses with jOOQ – blog.jooq.org
5. 3. 2020Using Java 13+ Text Blocks for Plain SQL with jOOQ – blog.jooq.org
4. 3. 2020Never Concatenate Strings With jOOQ – blog.jooq.org
3. 3. 20205 Ways to Better Understand SQL by Adding Optional Parentheses – blog.jooq.org
2. 3. 2020SQL DISTINCT is not a function – blog.jooq.org
25. 2. 2020Use the jOOQ-Refaster Module for Automatic Migration off of Deprecated jOOQ API – blog.jooq.org
14. 2. 2020jOOQ 3.13 Released with More API and Tooling for DDL Management – blog.jooq.org
13. 11. 2019Stop Mapping Stuff in Your Middleware. Use SQL’s XML or JSON Operators Instead – blog.jooq.org
29. 10. 2019A Guide to SQL Naming Conventions – blog.jooq.org
25. 10. 2019Dogfooding in Product Development – blog.jooq.org
16. 10. 2019How to Simulate a Liquibase Migration using H2 – blog.jooq.org
30. 9. 2019A Quick Trick to Make a Java Stream Construction Lazy – blog.jooq.org
27. 9. 2019How to Map MySQL’s TINYINT(1) to Boolean in jOOQ – blog.jooq.org
19. 9. 2019What’s Faster? COUNT(*) or COUNT(1)? – blog.jooq.org
11. 9. 2019Oracle’s BINARY_DOUBLE Can Be Much Faster Than NUMBER – blog.jooq.org
9. 9. 2019Using DISTINCT ON in Non-PostgreSQL Databases – blog.jooq.org
5. 9. 2019Quantified LIKE ANY predicates in jOOQ 3.12 – blog.jooq.org
29. 8. 2019jOOQ 3.12 Released With a new Procedural Language API – blog.jooq.org
16. 7. 2019How to Fetch All Current Identity Values in Oracle – blog.jooq.org
26. 6. 2019How to Use jOOQ’s Commercial Distributions with Spring Boot – blog.jooq.org
6. 6. 2019How to Write a Simple, yet Extensible API – blog.jooq.org
24. 4. 2019Using IGNORE NULLS With SQL Window Functions to Fill Gaps – blog.jooq.org
16. 4. 2019Calling an Oracle Function with PL/SQL BOOLEAN Type from SQL – blog.jooq.org
9. 4. 2019The Difference Between SQL’s JOIN .. ON Clause and the Where Clause – blog.jooq.org
26. 3. 2019The Cost of Useless Surrogate Keys in Relationship Tables – blog.jooq.org
15. 3. 2019Calculating Weighted Averages When Joining Tables in SQL – blog.jooq.org
14. 3. 2019How to Statically Override the Default Settings in jOOQ – blog.jooq.org
14. 2. 2019How to Calculate a Cumulative Percentage in SQL – blog.jooq.org
11. 2. 2019Lesser Known jOOλ Features: Useful Collectors – blog.jooq.org
28. 1. 2019How to Emulate PERCENTILE_DISC in MySQL and Other RDBMS – blog.jooq.org
22. 1. 2019Calculate Percentiles to Learn About Data Set Skew in SQL – blog.jooq.org
2. 1. 2019How to Work Around ORA-38104: Columns referenced in the ON Clause cannot be updated – blog.jooq.org
7. 12. 2018How to Unit Test Your Annotation Processor using jOOR – blog.jooq.org
22. 11. 2018How to Create a Good MCVE (Minimal Complete Verifiable Example) – blog.jooq.org
16. 11. 2018How to Aggregate an Archive Log’s Deltas into a Snapshot with SQL – blog.jooq.org
5. 11. 2018How to Use jOOQ’s UpdatableRecord for CRUD to Apply a Delta – blog.jooq.org
29. 10. 2018Imperative Loop or Functional Stream Pipeline? Beware of the Performance Impact! – blog.jooq.org
9. 10. 2018Writing Custom Aggregate Functions in SQL Just Like a Java 8 Stream Collector – blog.jooq.org
26. 9. 2018How to Use SQL UPDATE .. RETURNING to Run DML More Efficiently – blog.jooq.org
21. 9. 2018How to Write a Multiplication Aggregate Function in SQL – blog.jooq.org
20. 9. 2018How to Reduce Syntactic Overhead Using the SQL WINDOW Clause – blog.jooq.org
7. 9. 2018Beware of Hidden PL/SQL to SQL Context Switches – blog.jooq.org
3. 9. 2018Find the Next Non-NULL Row in a Series With SQL – blog.jooq.org
28. 8. 2018A Frequent Question: Does jOOQ Have a First Level Cache? – blog.jooq.org
15. 8. 2018How to Write Multiset Conditions With Oracle VARRAY Types – blog.jooq.org
13. 7. 2018How SQL DISTINCT and ORDER BY are Related – blog.jooq.org
5. 7. 2018PostgreSQL 11’s Support for SQL Standard GROUPS and EXCLUDE Window Function Clauses – blog.jooq.org
27. 6. 2018Using UNPIVOT to Traverse a Configuration Table’s Rows and Columns – blog.jooq.org
25. 6. 2018Oracle’s OFFSET .. FETCH Can be Slower than Classic ROWNUM Filtering – blog.jooq.org
15. 6. 2018How to Patch Your IDE to Fix an Urgent Bug – blog.jooq.org
7. 6. 2018jOOQ 3.11 Released With 4 New Databases, Implicit Joins, Diagnostics, and Much More – blog.jooq.org
6. 6. 2018Truth First, or Why You Should Mostly Implement Database First Designs – blog.jooq.org
25. 5. 2018How to Group By “Nothing” in SQL – blog.jooq.org
14. 5. 2018Selecting all Columns Except One in PostgreSQL – blog.jooq.org
2. 5. 2018How to Run a Bulk INSERT .. RETURNING Statement With Oracle and JDBC – blog.jooq.org
19. 4. 2018The Performance Difference Between SQL Row-by-row Updating, Batch Updating, and Bulk Updating – blog.jooq.org
13. 4. 2018When Using Bind Variables is not Enough: Dynamic IN Lists – blog.jooq.org
12. 4. 2018Why SQL Bind Variables are Important for Performance – blog.jooq.org
10. 4. 2018Mocking JDBC Using a Set of SQL String / Result Pairs – blog.jooq.org
3. 4. 2018How to Compile a Class at Runtime with Java 8 and 9 – blog.jooq.org
1. 4. 2018A Completely Overhauled, Modularised jOOQ 3.11, Ready for Java 11 – blog.jooq.org
28. 3. 2018Correct Reflective Access to Interface Default Methods in Java 8, 9, 10 – blog.jooq.org
13. 3. 2018Top 10 SQL Dialect Emulations Implemented in jOOQ – blog.jooq.org
27. 2. 2018Map Reducing a Set of Values Into a Dynamic SQL UNION Query – blog.jooq.org
23. 2. 2018How to Order Versioned File Names Semantically in Java – blog.jooq.org
20. 2. 2018Type Safe Implicit JOIN Through Path Navigation in jOOQ 3.11 – blog.jooq.org
19. 2. 2018How to Implement Your Own XJC Plugin to Generate toString(), equals(), and hashCode() Methods – blog.jooq.org
5. 2. 2018Calculating Tupper’s Self-Referential Formula With SQL – blog.jooq.org
12. 1. 2018Top 5 Hidden jOOQ Features – blog.jooq.org
22. 12. 2017Do not GRANT ALL PRIVILEGES to your Production Users – blog.jooq.org
22. 12. 2017Creating a Microsoft Excel Style Pivot Table With Grand Totals in SQL – blog.jooq.org
@kaja47, 0xDEADBEEF funkcionálně.cz, k47.cz