Browsed by
Tag: kestra

CharacterEscapes: Jackson’s hidden gem

CharacterEscapes: Jackson’s hidden gem

Comments 0 Comment

At Kestra, the data orchestration platform I work for, we had an issue ([#10326] (https://github.com/kestra-io/kestra/issues/10326)) opened by a user reporting a problem with the PostgreSQL database and the Unicode character \u0000. A workflow task that returned this character in its output was failing. After investigation, PostgreSQL refuses to store a JSONB entry containing this character because it has no textual representation. This is because it is the null character in Unicode, which is not allowed in JSON, which represents null…

Read More Read More

VisualVM SQL profiler SQL

VisualVM SQL profiler SQL

Comments 2 comments

A little while ago, I discovered the SQL profiler of VisualVM and I thought I should share it with you ;). VisualVM is a tool that provides a visual interface to display detailed information about applications running on a Java Virtual Machine (JVM). VisualVM is designed for use in development and production. VisualVM provides lightweight profiling tools including a SQL profiler. This will detect each SQL query (passing through the JDBC layer) and group them in a tabular view with…

Read More Read More

Introduction to Kestra

Introduction to Kestra

Comments 0 Comment

Kestra is an open-source data orchestrator and scheduler. With Kestra, data workflows, called flows, use the YAML format and are executed by its engine via an API call, the user interface, or a trigger (webhook, schedule, SQL query, Pub/Sub message, …). The important notions of Kestra are : The flow: which describes how the data will be orchestrated (the workflow thus). It is a sequence of tasks . The task: a step in the flow that will perform an action…

Read More Read More