How to Plot an ASCII Bar Chart with SQL
Java, SQL and jOOQ.by lukaseder1 Sept 2022
No need for expensive Tableau subscriptions. Ditch Microsoft Excel. Just use native PostgreSQL to quickly visualise your data! Here’s an idea I had for a while.
general
newest firstBack to general
top 33%Stable diffusion on an M1 Mac
Flurries of latent creativity - Stripe CTO blog31 Aug 2022
As you’ll know if you follow me on Twitter, I’ve been kindof obsessed with the text-to-image GPT models OpenAI released as DALL-E recently.
The Second Best Way to Fetch a Spring Data JPA DTO Projection
Java, SQL and jOOQ.by lukaseder30 Aug 2022
I’ve just stumbled upon this great post by Vlad Mihalcea, titled The Best Way to Fetch a Spring Data JPA DTO Projection. It got some nice traction on reddit, too.
Cannot resolve symbol ‘VERSION_3_17’ in jOOQ generated code
Java, SQL and jOOQ.by lukaseder30 Aug 2022
Starting with jOOQ 3.16 and #12601, there may be a compilation error with a message like this in your jOOQ generated code: [ERROR] …/DefaultCatalog.java:[53,73] cannot find symbol [ERROR] symbol...
jOOQ 3.17 Supports Implicit Join also in DML
Java, SQL and jOOQ.by lukaseder25 Aug 2022
Since jOOQ 3.11, implicit joins have been supported. An implicit join is a JOIN (mostly a LEFT JOIN) that is generated implicitly because of the presence of a path expression.
A Condition is a Field
Java, SQL and jOOQ.by lukaseder24 Aug 2022
Starting with jOOQ 3.17, the Condition type extends the Field<Boolean> type. Because, that’s what the SQL standard thinks it is, in sorts: <boolean value expression> ::= <predicate> The exact...
The Many Ways to Return Data From SQL DML
Java, SQL and jOOQ.by lukaseder23 Aug 2022
Probably the hardest thing to standardise in SQL is RETURNING data from DML statements. In this article, we’ll look at various ways of doing that with jOOQ, in many of jOOQ’s supported dialects...
How to Integration Test Stored Procedures with jOOQ
Java, SQL and jOOQ.by lukaseder22 Aug 2022
When you write stored procedures and functions in your database, you want to ensure their correctness, just like with your Java code. In Java, this is done with unit tests, typically with JUnit.
Drawing custom text spans in Compose UI
Saket Narayanby Saket Narayan12 Jul 2022
While exploring how text paragraphs are rendered in Compose UI, I nerd sniped myself into porting squiggly underlines from Sam Ruston’s Buzzkill app.
Switching between SwiftUI’s HStack and VStack | Swift by Sundell
Swift by Sundell8 Jul 2022
This article has been archived, as it was published several years ago, so some of its information might now be outdated. For more recent articles, please visit the main article feed.
Create Dynamic Views with jOOQ 3.17’s new Virtual Client Side Computed Columns
Java, SQL and jOOQ.by lukaseder30 Jun 2022
One of jOOQ 3.17‘s coolest new features are client side computed columns. jOOQ 3.16 already added support for server side computed columns, which many of you appreciate for various reasons.
iOS Accessibility Values
Mobile A11yby a11y@mobilea11y.com (Mobile A11y)19 Jun 2022
For iOS, Accessibility values are one of the building blocks of how Accessibility works on the platform, along with traits, labels, hints, and showing/hiding elements.
How to Filter a SQL Nested Collection by a Value
Java, SQL and jOOQ.by lukaseder10 Jun 2022
I stumbled upon a very interesting question on Stack Overflow about how to use jOOQ’s MULTISET operator to nest a collection, and then filter the result by whether that nested collection contains a...
Mobile-First CSS: Is It Time for a Rethink?
A List Apartby by Patrick Clancey9 Jun 2022
The mobile-first design methodology is great—it focuses on what really matters to the user, it’s well-practiced, and it’s been a common design pattern for years.
Using the ‘some’ and ‘any’ keywords to reference generic protocols in Swift 5.7 | Swift by Sundell
Swift by Sundell8 Jun 2022
This article has been archived, as it was published several years ago, so some of its information might now be outdated. For more recent articles, please visit the main article feed.
Rendering SwiftUI views within UITableView or UICollectionView cells on iOS 16 | Swift by Sundell
Swift by Sundell7 Jun 2022
This article has been archived, as it was published several years ago, so some of its information might now be outdated. For more recent articles, please visit the main article feed.
How to Dispute Mistakes On Your Credit Report
Wise Breadby Holly Johnson1 Jun 2022
There are several obvious reasons to give a hoot about your credit score, and very few reasons you should ignore it.
Changing SELECT .. FROM Into FROM .. SELECT Does Not “Fix” SQL
Java, SQL and jOOQ.by lukaseder31 May 2022
Every now and then, I see folks lament the SQL syntax’s peculiar disconnect between - the lexical order of operations (SELECT .. FROM ) - the logical order of operations (FROM ..
Kālua pork, cooked in an imu.
Flurries of latent creativity - Stripe CTO blog30 May 2022
If you’ve ever enjoyed a Luau in Hawaii, chances are that the pièce de résistance was delicious melt-in-the-mouth Kālua Pork which is often served as the centrepiece of the Luau feast.
The Many Different Ways to Fetch Data in jOOQ
Java, SQL and jOOQ.by lukaseder19 May 2022
The jOOQ API is all about convenience, and as such, an important operation (the most important one?) like fetch() must come with convenience, too.