PG Conf EU: Finding PostgreSQL’s fit in the AI space
Why PostgreSQL matters in the AI space as source, central component and target.
1 billion rows challenge in PostgreSQL and ClickHouse
Last week the good old Gunnar Morling launched an interesting challenge about ordering 1 billion rows in Java. Like my ex colleague and friend Robin Moffat, I’m not at all a Java expert, and while Robin used DuckDB to solve the challenge, I did the same with PostgreSQL and ClickHouse.
re:Invent: Accelerate Generative AI development with Integrated Data Platforms
Generative AI is revolutionizing how we work and interact. Yet for generative AI applications relying on private, regulated, or commercially valuable data, feeding the model with the right information is crucial. Failure could result in adverse consequences such as poor performance, confidential information exposure, or regulatory requirement breaches. An integrated data platform is a powerful way to accelerate the development of generative AI applications by providing real-time data feeds, consolidating inputs from different sources, and defining clear information boundaries.
Conference Talk: Attacking (and defending) Apache Kafka
When attacking any system, taking control of its central nervous system is the first step in infiltrating the core infrastructure and gaining control over its vital functions. Translating this to organization data, a clear target is Apache Kafka, the data hub increasingly adopted for mission-critical systems. This session explores the topic of attacking and defending Apache Kafka, shedding light on potential threats, attack vectors, and countermeasures.
Initially, we’ll focus on understanding the potential attack surface of Apache Kafka.
Kafka Connect sink to OpenSearch/ElasticSearch: how to sink unix timestamps
When sinking unix timestamps from Apache Kafka to OpenSearch/ElasticSearch using the dedicated connector, they are not recognized by default as timestamp in the target tech.
Consume Apache Kafka® messages via REST APIs
You have an Apache Kafka topic that you want to consume via REST APIs (think curl or just a web browser), how to do it?
The reply is Karapace an Open Source (Apache 2.0) tool providing Schema Registry and REST proxy functionality.
Let’s check out how to quickly run it on Docker.
Step 1: the Apache Kafka® Cluster You need an Apache Kafka cluster up & running, if you have one already you can skip to the next section.
Current 2023: From Batch to Streaming Data Pipeline Evolution
Useful Links Aiven Signup Code examples to run with Aiven for Apache Flink Flink JDBC SQL Connector Flink SQL CDC Connecto for PostgreSQL
How to tabulate a JSON document in MySQL
You can tabulate a JSON document (retrieve it as a row) in MySQL with the JSON_TABLE function.
How to remove a field in a JSON document in MySQL
You can remove a field from JSON document in MySQL with the JSON_REMOVE function.
How to insert a field in a JSON document in MySQL
You can insert a field in a JSON document in MySQL with the JSON_INSERT function.
