<!DOCTYPE html><html lang="en"><head><meta http-equiv="Content-Type" content="text/html charset=UTF-8"><meta charset="UTF-8"><meta name="viewport" content="width=device-width"><meta name="x-apple-disable-message-reformatting"><title>TLDR Data</title><meta name="color-scheme" content="light dark"><meta name="supported-color-schemes" content="light dark"><style type="text/css"> :root { color-scheme: light dark; supported-color-schemes: light dark; } *, *:after, *:before { -webkit-box-sizing: border-box; -moz-box-sizing: border-box; box-sizing: border-box; } * { -ms-text-size-adjust: 100%; -webkit-text-size-adjust: 100%; } html, body, .document { width: 100% !important; height: 100% !important; margin: 0; padding: 0; } body { -webkit-font-smoothing: antialiased; -moz-osx-font-smoothing: grayscale; text-rendering: optimizeLegibility; } div[style*="margin: 16px 0"] { margin: 0 !important; } table, td { mso-table-lspace: 0pt; mso-table-rspace: 0pt; } table { border-spacing: 0; border-collapse: collapse; table-layout: fixed; margin: 0 auto; } img { -ms-interpolation-mode: bicubic; max-width: 100%; border: 0; } *[x-apple-data-detectors] { color: inherit !important; text-decoration: none !important; } .x-gmail-data-detectors, .x-gmail-data-detectors *, .aBn { border-bottom: 0 !important; cursor: default !important; } .btn { -webkit-transition: all 200ms ease; transition: all 200ms ease; } .btn:hover { background-color: #f67575; border-color: #f67575; } * { font-family: Arial, Helvetica, sans-serif; font-size: 18px; } @media screen and (max-width: 600px) { .container { width: 100%; margin: auto; } .stack { display: block!important; width: 100%!important; max-width: 100%!important; } .btn { display: block; width: 100%; text-align: center; } } body, p, td, tr, .body, table, h1, h2, h3, h4, h5, h6, div, span { background-color: #FEFEFE !important; color: #010101 !important; } @media (prefers-color-scheme: dark) { body, p, td, tr, .body, table, h1, h2, h3, h4, h5, h6, div, span { background-color: #27292D !important; color: #FEFEFE !important; } } a { color: inherit !important; text-decoration: underline !important; } </style><!--[if mso | ie]> <style type="text/css"> a { background-color: #FEFEFE !important; color: #010101 !important; } @media (prefers-color-scheme: dark) { a { background-color: #27292D !important; color: #FEFEFE !important; } } </style> <![endif]--></head><body class=""> <div style="display: none; max-height: 0px; overflow: hidden;">ClickHouse enables sub-200ms queries across billions of records by combining columnar storage, advanced compression, and vectorized execution โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ โ </div> <div style="display: none; max-height: 0px; overflow: hidden;"> <br> </div> <table align="center" class="document"><tbody><tr><td valign="top"> <table align="center" border="0" cellpadding="0" cellspacing="0" class="container" width="600"><tbody><tr class="inner-body"><td> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr class="header"><td bgcolor="" class="container"> <table width="100%"><tbody><tr><td class="container"> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" style="margin-top: 0px;" width="100%"><tbody><tr><td style="padding: 0px;"> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div style="text-align: center;"> <span style="margin-right: 0px;"><a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Ftldr.tech%2Fdata%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/hwxPdi8kXSttKyS2x-GlYqFKBef0WnhS5aqGrgwsSco=421" rel="noopener noreferrer" target="_blank"><span>Sign Up</span></a> |<span style="margin-right: 2px; margin-left: 2px;"><a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fadvertise.tldr.tech%3Futm_source=tldrdata%26utm_medium=newsletter%26utm_campaign=advertisetopnav/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/dUk2Qq3kGcMiTkb9-tchYJz9P1_wPmvgCL0mAYAYlQk=421" rel="noopener noreferrer" target="_blank"><span>Advertise</span></a></span>|<span style="margin-left: 2px;"><a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fa.tldrnewsletter.com%2Fweb-version%3Fep=1%26lc=1670a604-84b7-11f0-bcf5-55fc1d40139c%26p=68de275c-8c93-11f0-825b-f7fc195374ed%26pt=campaign%26t=1757326086%26s=f60e2974c4bd782f3d28c801f18ac083cbc9e1bf575b4ea945062ae0026d71d1/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/s8yc2iXt8-Xrq-F-Y-oSkhnAA20kyySfPxZSvjy2qng=421"><span>View Online</span></a></span> <br> </span></div> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="text-align: center;"><span data-darkreader-inline-color="" style="--darkreader-inline-color:#3db3ff; color: rgb(51, 175, 255) !important; font-size: 30px;">T</span><span style="font-size: 30px;"><span data-darkreader-inline-color="" style="color: rgb(232, 192, 96) !important; --darkreader-inline-color:#e8c163; font-size:30px;">L</span><span data-darkreader-inline-color="" style="color: rgb(101, 195, 173) !important; --darkreader-inline-color:#6ec7b2; font-size:30px;">D</span></span><span data-darkreader-inline-color="" style="--darkreader-inline-color:#dd6e6e; color: rgb(220, 107, 107) !important; font-size: 30px;">R</span> <br> </td></tr></tbody></table> <br> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr id="together-with"><td align="center" height="20" style="vertical-align:middle !important;" valign="middle" width="100%"><strong style="vertical-align:middle !important; height: 100%;">Together With </strong> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fsummit.starrocks.io%2F2025%2FTLDR/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/8zlqnzZtwZ3zwskD7N6bmbh_nWPokKbRUDDFjvyuArk=421"><img src="https://images.tldr.tech/celerdata.png" valign="middle" style="vertical-align: middle !important; height: 100%;" alt="CelerData"></a></td></tr></tbody></table> <table style="table-layout: fixed; width:100%;" width="100%"><tbody><tr><td style="padding:0;border-collapse:collapse;border-spacing:0;margin:0;"> <div style="text-align: center;"> <h1><strong>TLDR Data <span id="date">2025-09-08</span></strong></h1> </div> </td></tr></tbody></table> <table style="table-layout: fixed; width:100%;" width="100%"><tbody><tr id="sponsy-copy"><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fsummit.starrocks.io%2F2025%2FTLDR/2/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/4eTfM06EOAVECPd7LM-MyO861vbbIGYj7BFtUC0UsCk=421"> <span> <strong>Last chance to join: See how Pinterest, Coinbase, and Demandbase build with Iceberg + StarRocks (Sponsor)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> <strong>Happening this Wednesday!</strong> StarRocks Summit is a <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fsummit.starrocks.io%2F2025%2FTLDR/3/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/ybjG_yQYmniUTbQknsugVYQuugwRCPLAQBhC-hMwUg8=421" rel="noopener noreferrer nofollow" target="_blank"><span>free virtual summit</span></a> that's 100% engineering-focused. <p></p> <p><strong>What to expect</strong>: 25+ engineer-led talks from data teams at Coinbase, Intuit, Pinterest, Demandbase, and more</p> <p><strong>Not included</strong>: Sales decks, ads veiled as technical talks, vendor spam</p> <p>Save your spot for <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fsummit.starrocks.io%2F2025%2FTLDR/4/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/BfFicZnMGXu5kruqz1YL-UDCVB5mEp_AJePKAdju-As=421" rel="noopener noreferrer nofollow" target="_blank"><span>fascinating technical talks</span></a> on topics such as Iceberg, the lakehouse, and building AI-enabling infrastructure. Speakers will share <strong>real-life success stories</strong> on:</p> <p>โ Sub-second queries at petabyte scale, even under high concurrency <br>โ Fewer pipelines, fresher data, faster deliveryโwithout join bottlenecks <br>โ 10ร lower storage overhead and major infra cost savings <br>โ Running Apache Iceberg at production scale with warehouse-grade performance <br>โ Powering the next generation of AI-driven customer experiences</p> <p>๐ Grab your free pass now: <a class="decorated-link" href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fsummit.starrocks.io%2F2025%2FTLDR/5/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/JBafjZK1Daum8QcHjD_VaoXFwfNOzO1mzFtCaIfU6WQ=421" rel="noopener" target="_new"><span>https://summit.starrocks.io/2025/TLDR</span></a></p> <p>September 10. Don't miss out. </p> </span></span></div> </td></tr></tbody></table> </td></tr></tbody></table> </td></tr></tbody></table> </td></tr> <tr bgcolor=""><td class="container"> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td style="padding: 0px;"> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding-top: 0px; padding-bottom: 0px;"> <div class="text-block"> <div style="text-align: center;"><span style="font-size: 36px;">๐ฑ</span></div></div> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding-top: 0px; padding-bottom: 0px;"> <div class="text-block"> <div style="text-align: center;"> <h1><strong>Deep Dives</strong></h1> </div> </div> </td></tr></tbody></table> <table style="table-layout: fixed; width: 100%;" width="100%"><tbody><tr><td style="padding:0;border-collapse:collapse;border-spacing:0;margin:0;" valign="top"> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.ssp.sh%2Fblog%2Fpractical-data-modeling-clickhouse%2F%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/BoyonoLMrbstGoQkvVxFvk6v4km4FTMGIwSw_to7fy0=421"> <span> <strong>Data Modeling Guide for Real-Time Analytics with ClickHouse (14 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> ClickHouse enables sub-200ms queries across billions of records by combining columnar storage, advanced compression, and vectorized execution with minimal query-time joins. Its MergeTree engine supports high-throughput streaming ingestion, incremental partitioned updates, built-in deduplication, and multi-level optimizations like materialized views and projections, minimizing ETL complexity. Limitations include complex updates, limited joins, and a lack of foreign keys. Data Modeling techniques such as pre-aggregation, TTL, sampling, and stratified data management yield 10-100x performance and storage improvements. </span> </span> </div> </td></tr></tbody></table> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Flinks.tldrnewsletter.com%2FtUj3A2/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/iK0RxVPmcFGZn4ruhY8LTDVc0XSoHmA2KFms7-XOHxk=421"> <span> <strong>Building Etsy Buyer Profiles with LLMs (10 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> Etsy uses large language models to create personalized buyer profiles from browsing and purchasing data, enabling tailored search experiences for its 90M buyers while complying with privacy laws. Optimizations like partitioned BigQuery tables, reduced data windows, and scaling up computational resources cut profile generation time from 21 days to 3 days for 10M users and reduced estimated costs by 94%, powering applications like query rewriting and refinement pills. </span> </span> </div> </td></tr></tbody></table> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Faws.amazon.com%2Fblogs%2Fbig-data%2Fdeep-dive-into-the-amazon-managed-service-for-apache-flink-application-lifecycle-part-1%2F%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/B5mJ7yfwbfdZ4iLERRdCwyEShJauEJP5qL08-cidQ8s=421"> <span> <strong>Deep dive into the Amazon Managed Service for Apache Flink application lifecycle (5 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> Managed Service for Apache Flink simplifies application lifecycle management with API-driven operations like create, start, update, and stop, using snapshots for state consistency and supporting streaming/batch modes with dedicated clusters. </span> </span> </div> </td></tr></tbody></table> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding-top: 0px; padding-bottom: 0px;"> <div class="text-block"> <div style="text-align: center;"><span style="font-size: 36px;">๐</span></div> </div> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding-top: 0px; padding-bottom: 0px;"> <div class="text-block"> <div style="text-align: center;"> <h1><strong>Opinions & Advice</strong></h1> </div> </div> </td></tr></tbody></table> <table style="table-layout: fixed; width: 100%;" width="100%"><tbody><tr><td style="padding:0;border-collapse:collapse;border-spacing:0;margin:0;" valign="top"> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fdeveloper.nvidia.com%2Fblog%2Fhow-to-spot-and-fix-5-common-performance-bottlenecks-in-pandas-workflows%2F%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/LE63I8OdMTNsTBoYXN_I8INRv1d6cgqXEZF1EpNXsW0=421"> <span> <strong>How to Spot (and Fix) 5 Common Performance Bottlenecks in pandas Workflows (6 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> Identify and address five common pandas performance bottlenecks: slow CSV loading can be alleviated with PyArrow or GPU acceleration via cuDF; large merges can be optimized with indexed joins and also benefit from GPU processing; and high-memory string columns may be converted to categorical types to reduce RAM usage. Utilizing GPU resources, such as in Google Colab, can significantly enhance performance without altering existing code. </span> </span> </div> </td></tr></tbody></table> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fjoereis.substack.com%2Fp%2Fthe-pedantic-layer%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/w1gr002VZRkEaeP4NPvciabVKEaTHXvSZWn5jyqiRTk=421"> <span> <strong>The Pedantic Layer (3 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> The data industry is fixated on definitions and semantics, which often hinders practical advancements. Data leaders need to focus on the value and outcomes derived from data, rather than getting bogged down in debates about categorization, especially as AI blurs the lines between structured and unstructured data. Data professionals must prioritize extracting meaningful insights and improving decision-making over pedantic discussions. </span> </span> </div> </td></tr></tbody></table> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.dataengineeringweekly.com%2Fp%2Frevisiting-medallion-architecture%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/st81flAydsNf0WeSNHiWv9_AMd24v-_DdhYckq57J8s=421"> <span> <strong>Revisiting Medallion Architecture (5 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> The Medallion Architecture simplifies team collaboration with a clear, shared framework, enabling startups and enterprises to build scalable, trustworthy data systems. Its Platinum layer evolves the model beyond batch processing, supporting real-time analytics and data-driven products for both business and operational intelligence. </span> </span> </div> </td></tr></tbody></table> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Ftdan.com%2Fdata-is-risky-business-the-risk-of-ai-atrophy%2F32918%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/1sbyBLytCzURYM_-9CFeWXrhDxz83REN4xOzx37_y1g=421"> <span> <strong>Data Is Risky Business: The Risk of AI Atrophy (9 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> Widespread adoption of GenAI is shifting organizational structures, reducing traditional entry-level roles and automating foundational cognitive tasks. Research shows 71% of employees expect new hires to focus on output review, not creation. This undermines experiential learning critical for managerial progression, introduces risks of cognitive atrophy, and challenges knowledge transfer. Avoiding human โatrophyโ requires balanced investment in staff capabilities (data literacy, critical thinking, evaluation, and judgment) across three stages: before the prompt, after the answer, and at the point of action. </span> </span> </div> </td></tr></tbody></table> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding-top: 0px; padding-bottom: 0px;"> <div class="text-block"> <div style="text-align: center;"><span style="font-size: 36px;">๐ป</span></div> </div> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding-top: 0px; padding-bottom: 0px;"> <div class="text-block"> <div style="text-align: center;"> <h1><strong>Launches & Tools</strong></h1> </div> </div> </td></tr></tbody></table> <table style="table-layout: fixed; width: 100%;" width="100%"><tbody><tr><td style="padding:0;border-collapse:collapse;border-spacing:0;margin:0;" valign="top"> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.onetrust.com%2Fresources%2Ftldr-csyn%2Fthe-strategic-guide-to-consent-and-preferences-ebook%2F%3Futm_medium=newsletter%26utm_source=tldr-data%26utm_campaign=20250908/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/Wjaoq4uJjs0GueVcmOS4QVX7JWd08BL5pEhC6oKGz6I=421"> <span> <strong>The strategic guide to consent & preferences in 2025 (Sponsor)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> Shifting global regulations - including the GDPR, CPRA, and new TCPA updates, are reshaping consent and cookie requirements. With the right strategy, this doesn't have to be a bottleneck. Discover <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.onetrust.com%2Fresources%2Ftldr-csyn%2Fthe-strategic-guide-to-consent-and-preferences-ebook%2F%3Futm_medium=newsletter%26utm_source=tldr-data%26utm_campaign=20250908/2/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/PQSr2G0ThVQHI8eQo8AvB7sUkvITQpwQj12D9cV1EQI=421" rel="noopener noreferrer nofollow" target="_blank"><span>practical steps you can take</span></a> to build an integrated, future-ready consent infrastructure that supports business growth and regulatory agility. <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.onetrust.com%2Fresources%2Ftldr-csyn%2Fthe-strategic-guide-to-consent-and-preferences-ebook%2F%3Futm_medium=newsletter%26utm_source=tldr-data%26utm_campaign=20250908/3/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/jl5qToP1eeRucf3zAsZzvsCy_T5ir6UtZJcMux4mJ1o=421" rel="noopener noreferrer nofollow" target="_blank"><span>Get the OneTrust guide</span></a> </span> </span> </div> </td></tr></tbody></table> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.postgresql.org%2Fabout%2Fnews%2Fpostgresql-18-rc-1-released-3130%2F%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/kkULloFySefMvgIchIfI5YRHGHDM7C-RHSkiQzs1vXs=421"> <span> <strong>PostgreSQL 18 RC1 Released (5 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> PostgreSQL 18 delivers major improvements in performance, developer features, and security, including a new asynchronous I/O subsystem that speeds scan-heavy workloads, skip-scan support for b-tree indexes, virtual generated columns as the default, built-in UUIDv7 support, and richer EXPLAIN diagnostics. Security is also strengthened with OAuth authentication, MD5 password deprecation, TLS and cipher suite updates, and default data checksums. Upgrade tools have been enhanced with preserved planner statistics and faster pg_upgrade options. General availability is scheduled for September 25. </span> </span> </div> </td></tr></tbody></table> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fhackernoon.com%2Fstreamline-structured-unstructured-data-flows-from-postgres-with-ai%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/prCXZecAkp3PCAizxEnPDGoYuRpWCgCIqYAL03TH_0w=421"> <span> <strong>Streamline Structured + Unstructured Data Flows from Postgres with AI (6 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> CocoIndex lets you build incremental data flows across both structured and unstructured sources by treating AI operations, such as embedding generation, as standard pipeline transforms alongside classic data calculations and mappings. Direct PostgreSQL integration allows ingestion, transformation (including AI-powered semantic enrichment), and export to vector-indexed tables optimized for semantic + structured search. The framework provides field lineage visualization and live pipeline monitoring. </span> </span> </div> </td></tr></tbody></table> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.confluent.io%2Fblog%2Fintroducing-apache-kafka-4-1%2F%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/B0s2Rp5idyESMo_N-QAYU9vWYZj02QwryybSFU7siN4=421"> <span> <strong>Introducing Apache Kafkaยฎ 4.1.0: What's New and How to Upgrade (10 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> Apache Kafka 4.1.0 adds preview support for Queues, a new Streams Rebalance Protocol, and OAuth jwt-bearer grant. It also improves metrics, error handling, partitioning, transactional filtering, and connector plugin versions. </span> </span> </div> </td></tr></tbody></table> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding-top: 0px; padding-bottom: 0px;"> <div class="text-block"> <div style="text-align: center;"><span style="font-size: 36px;">๐</span></div></div> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding-top: 0px; padding-bottom: 0px;"> <div class="text-block"> <div style="text-align: center;"><strong><h1>Miscellaneous</h1></strong></div> </div> </td></tr></tbody></table> <table bgcolor="" style="table-layout: fixed; width: 100%;" width="100%"><tbody><tr><td style="padding:0;border-collapse:collapse;border-spacing:0;margin:0;" valign="top"> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.ssp.sh%2Fbrain%2Fdata-engineering-acquisitions%2F%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/HIt-RdqpvmWZIwbRyVb5HKKZSQ06c4rbxcS1boJoyM4=421"> <span> <strong>Data Engineering Acquisitions (3 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> Companies are acquiring specialized tools to build comprehensive platforms, reducing fragmentation and improving integration for data engineers. Acquisitions like Tabular reflect a push toward open-source table formats, enabling better data interoperability across platforms. </span> </span> </div> </td></tr></tbody></table> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fthenewstack.io%2Fgpus-never-signed-up-for-this-ai-security-job%2F%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/yhgPNrycgennNWsu4o00nHnma1bciK14xkpizUKsf84=421"> <span> <strong>GPUs Never Signed Up for This AI Security Job (4 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> GPUs, originally designed for trusted, single-user environments, lack fundamental multitenancy safeguards and runtime observability critical for secure AI workloads in modern shared infrastructure. Unlike CPUs, GPUs have no built-in process isolation, memory segmentation, or granular telemetry. Their large, privileged drivers amplify the attack surface. As organizations deploy sensitive AI workloads on shared GPU clusters, assuming CPU-style security creates acute vulnerabilities and blind spots that current infrastructure is ill-equipped to monitor or mitigate. </span> </span> </div> </td></tr></tbody></table> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding-top: 0px; padding-bottom: 0px;"> <div class="text-block"> <div style="text-align: center;"><span style="font-size: 36px;">โก</span></div></div> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding-top: 0px; padding-bottom: 0px;"> <div class="text-block"> <div style="text-align: center;"> <h1><strong>Quick Links</strong></h1> </div> </div> </td></tr></tbody></table> <table bgcolor="" style="table-layout: fixed; width: 100%;" width="100%"><tbody><tr><td style="padding:0;border-collapse:collapse;border-spacing:0;margin:0;" valign="top"> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.cybertec-postgresql.com%2Fen%2Fexploration-cnpg-kubectl-plugin%2F%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/Oqn35ht43HXoTeCUDUiJq79DbRgyn2nGfqN655Ug_vE=421"> <span> <strong>Exploration: CNPG Kubectl Plugin (3 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> CloudNativePG provides a Kubernetes plugin for PostgreSQL-specific commands for faster, safer database ops without pod hopping. </span> </span> </div> </td></tr></tbody></table> <table align="center" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block"> <span> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fdebezium.io%2Fblog%2F2025%2F09%2F04%2Fdebezium-3-2-2-final-released%2F%3Futm_source=tldrdata/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/pQslKmj-55ynzSKMytGRRSpagfluyG_6u9nTZNAIehQ=421"> <span> <strong>Debezium 3.2.2 Final Released (5 minute read)</strong> </span> </a> <br> <br> <span style="font-family: "Helvetica Neue", Helvetica, Arial, Verdana, sans-serif;"> Debezium 3.2.2 addresses 24 issues with critical enhancements, notably eliminating data loss during failed ad-hoc blocking snapshots, resolving misleading Oracle connector startup errors for more reliable upgrades, and providing more accurate JMX throughput metrics in Oracle LogMiner. </span> </span> </div> </td></tr></tbody></table> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td align="left" style="word-break: break-word; vertical-align: top; padding: 5px 10px;"> <p style="padding: 0; margin: 0; font-size: 22px; color: #000000; line-height: 1.6; font-weight: bold;"> Want to advertise in TLDR? ๐ฐ </p> <div class="text-block" style="margin-top: 10px;"> If your company is interested in reaching an audience of data engineering professionals and decision makers, you may want to <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fadvertise.tldr.tech%2F%3Futm_source=tldrdata%26utm_medium=newsletter%26utm_campaign=advertisecta/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/Qsnhg2VhDqDphA9Ja19WaOcFssSXdP3_kl28BinFpr0=421"><strong><span>advertise with us</span></strong></a>. </div> <br> <!-- New "Want to work at TLDR?" section --> <p style="padding: 0; margin: 0; font-size: 22px; color: #000000; line-height: 1.6; font-weight: bold;"> Want to work at TLDR? ๐ผ </p> <div class="text-block" style="margin-top: 10px;"> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fjobs.ashbyhq.com%2Ftldr.tech/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/WKeCiDDfR98HV4oV6HP83difMe5LfTl2Yfs956xXEU4=421" rel="noopener noreferrer" style="color: #0000EE; text-decoration: underline;" target="_blank"><strong>Apply here</strong></a> or send a friend's resume to <a href="mailto:jobs@tldr.tech" style="color: #0000EE; text-decoration: underline;">jobs@tldr.tech</a> and get $1k if we hire them! </div> <br> <div class="text-block"> If you have any comments or feedback, just respond to this email! <br> <br> Thanks for reading, <br> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.linkedin.com%2Fin%2Fjoelvanveluwen%2F/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/u2ouuKa9QzYcoRKBxeRP7CUW2pGNYYb5LUajsDmqkBQ=421"><span>Joel Van Veluwen</span></a>, <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.linkedin.com%2Fin%2Fjennytzurueyching%2F/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/wGyMIVPfDfffmv8xUt_X62ENNXiw3cFHkLxT398z3dc=421"><span>Tzu-Ruey Ching</span></a> & <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fwww.linkedin.com%2Fin%2Fremi-turpaud%2F/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/1mXOiGs3xk6dYdMCw5_mdtRzpTyedNEWZarBomAkffA=421"><span>Remi Turpaud</span></a> <br> <br> </div> <br> </td></tr></tbody></table> <table align="center" bgcolor="" border="0" cellpadding="0" cellspacing="0" width="100%"><tbody><tr><td class="container" style="padding: 15px 15px;"> <div class="text-block" id="testing-id"> <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Ftldr.tech%2Fdata%2Fmanage%3Femail=silk.theater.56%2540fwdnl.com/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/FL8Jc3to_swAJyOKi0ZnA4AVih6gK0ROxE1d_tThFZ8=421">Manage your subscriptions</a> to our other newsletters on tech, startups, and programming. Or if TLDR Data isn't for you, please <a href="https://tracking.tldrnewsletter.com/CL0/https:%2F%2Fa.tldrnewsletter.com%2Funsubscribe%3Fep=1%26l=037ede50-92cc-11ee-b0f2-b761aa2217ad%26lc=1670a604-84b7-11f0-bcf5-55fc1d40139c%26p=68de275c-8c93-11f0-825b-f7fc195374ed%26pt=campaign%26pv=4%26spa=1757325658%26t=1757326086%26s=8188cfe7617165ac7706cc3fa87a4beae33c17b3efefc23eb8ba75ee6a6e4582/1/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/e5YVRHJl6bMn1UEXe5_qTuL6wg54RSZDN9qDOFvRuqc=421">unsubscribe</a>. <br> </div> </td></tr></tbody></table> </td></tr></tbody></table> </td></tr></tbody></table> </td></tr></tbody></table> </td></tr></tbody></table> <img alt="" src="http://tracking.tldrnewsletter.com/CI0/0100019928cc140f-e55752e5-23f8-4070-9edf-5e46320f0fc2-000000/XpcrHDVDIeej0t0h1rHv74upBDGEDzUAPfnBfTdftX8=421" style="display: none; width: 1px; height: 1px;"> </body></html>