GraphQL Weekly 409 is out 🥳 🔵 GraphQL Conf new date 🔵 GraphQL London April Meetup 🔵 Benjie @wundergraphcom interview 🟡 PostGraphile v5 & Grafast v1 🟣 @hemnet case study 🟣 "changed my mind about GraphQL" @JoviDeC 🟣 AI Ready @apollographql 🟣 @apollographql workshop 👇

Almost all my client projects are using PostGraphile. What an awesome project and the best maintainer ever!

One of my all-time favorite tools to build with. Hard to overstate how quickly you can build on top of PostGraphile, PostgreSQL, and RLS.

It would be hard to understate how large of a feat of engineering this was Kudos to @Benjie, @jemgillam, and all who contributed to Postgraphile

V5 is the culmination of all of the feedback and learnings I've received over the past 8 years maintaining PostGraphile; it's been a wild ride, and I'm so excited for the future of the project! Would love to hear from you if you're using it, or any of our other projects!

I've been using postgraphile for years at work, including latest V5 RCs and it's just a pure gem, very fast and extremely flexible, plus it works perfectly with rescript-relay! Kudos @Benjie for the great work!

PostGraphile V5 is here! New execution engine. New export system. New extension capabilities. Same focus on productivity and performance! This is the biggest release we’ve ever shipped. See what changed: postgraphile.org/news/2026-0…

I'll take the vercel guy with the moustache and unnecessary features clearly made for lock-in over "sustaining engineering model" any day but the real deal remains VPS with coolify and supabase for postgres object storage only (no postgrest, postgraphile, RLS, auth, and definitely NO deno cloud functions)

A New Data Era Arrives on TRON: Substreams Ignites Real-Time On-Chain Intelligence The TRON ecosystem just received a major infrastructure boost and developers who depend on live, high-volume data are about to feel the difference. The Graph’s Substreams is now fully integrated with TRON, introducing a lightning-fast streaming architecture that pushes structured on-chain data directly into your applications. No delays, no heavy indexing, and fully optimized for TRON’s unmatched USDT TRC-20 throughput. What This Means for Builders Whether you’re developing financial tools, analytics dashboards, payment rails, automation logic, or compliance systems, Substreams equips you with a ready-made real-time pipeline. Instead of manually decoding blocks, Substreams handles the hard part: processing TRON blocks, extracting key events, and streaming them straight into your backend in a clean, production-ready format. Blazing-Fast Access to TRON Activity Instant visibility into: 🖍️ USDT transfers and wallet interactions 🖍️ Deposit patterns and transactional flows 🖍️ Live analytics & monitoring dashboards 🖍️ Automated workflows powered by real-time triggers. This isn’t just an upgrade, it’s an entirely new workflow for TRON development at scale. A Streamlined Data Architecture That Just Works The pipeline operates with precision: 1. Substreams endpoints deliver real-time TRON mainnet data. 2. TRON Substreams modules extract events with high throughput. 3. Node.js consumers route data directly into PostgreSQL. 4. PostGraphile structures it into a clean, query-ready GraphQL API. 5. Optional integrations: contract interactions, Kafka messages, automated alerts, and more. This setup supports everything from startup analytics tools to enterprise-grade infrastructure. Ultra-Focused USDT Intelligence Forget indexing the entire chain, Substreams lets you monitor only what matters: 👉 High-frequency USDT transfers 👉 Liquidity variations 👉 Treasury movements 👉 Specific wallet behavior. Each event is streamed instantly into PostgreSQL for analysis, alerting, or automated systems. What Developers Can Build Now With real-time TRON data unlocked, builders can deliver: 👉 Instant deposit sweeping & automated settlements 👉 Fraud-detection engines running on Kafka streams 👉 Power BI dashboards with live TRON metrics 👉 On-the-fly anomaly detection 👉 Compliance-ready monitoring frameworks 👉 High-speed payment processors 👉 Any product requiring low latency precision. Real-time becomes the default. Production-Grade Best Practices To maximize performance and reliability: Use UPSERT operations to protect against reorgs Enable checkpoints for fast historical syncing Allocate higher Node.js memory to handle throughput Secure API keys and database endpoints Factor in TRON Energy/Bandwidth for contract automation. A few smart optimizations make your pipeline rock-solid. Real-time data is no longer an advantage, it’s the foundation of serious Web3 systems. With Substreams now powering the TRON ecosystem, builders gain a high-speed, scalable, production-ready data engine for anything driven by USDT, automation, dashboards, compliance, or advanced analytics. If TRON is your battleground, this is the upgrade you don’t want to miss. @trondao @justinsuntron #TRONEcoStar

$TRON Just Unlocked a New Era of Real-Time Data With Substreams Developers building on $TRON just got handed a serious power-up. The Graph’s Substreams integration now delivers ultra-fast, production-ready streaming of $TRON on-chain activity straight into your backend and yes, it’s optimized for the massive USDT TRC-20 flows $TRON is known for. If you’re building payment rails, analytics engines, treasury tools, automation systems, dashboards, or compliance frameworks, this upgrade is a complete shift in what’s possible. Why This Upgrade Hits Different Substreams turns TRON’s on-chain activity into a high-throughput, real-time data pipeline. Instead of your app doing all the heavy lifting, Substreams processes live blocks, organizes them, and streams clean event data directly to your system. On $TRON, that means instant access to: USDT transfers and wallet movements Real-time deposit tracking Live dashboards and analytics Instant automated workflows This is built for speed, scale, and serious production-grade environments. The Architecture: Simple, Powerful, Scalable Here’s how it all clicks together: 1.Substreams endpoints → stream TRON mainnet data 2.TRON Substreams package → parses blocks events 3.Node.js consumers → pipe processed data to PostgreSQL 4.PostGraphile → turns it into a clean GraphQL API 5.Optional modules → trigger contract calls, Kafka events, alerts & more This is a plug-and-play pipeline that scales from startups to enterprise-level infrastructure. Precision USDT Monitoring You don’t need the whole chain you just need the events that matter. Filter real-time data for: Incoming or outgoing USDT transfers Liquidity fluctuations Treasury movements Any wallet behavior you need to watch Every filtered event lands instantly in PostgreSQL, ready for analytics, alerts, or automation. What Builders Can Create With This From lightweight tools to enterprise systems, Substreams unlocks: Real-time deposit sweeps Fraud detection powered by Kafka Power BI dashboards pulling live TRON data Automated anomaly alerts Compliance-grade tracking systems Ultra-fast payment processors Anything that requires speed, accuracy, and live on-chain visibility now becomes frictionless. Production Tips That Matter To run this setup at scale, make sure you: Use UPSERT to handle chain reorgs Enable checkpoints for historical syncs Increase Node memory for high throughput Lock down API keys and database access Plan for $TRON Energy/Bandwidth for any automated contract calls These steps keep your pipeline fast, resilient, and bulletproof under stress. The Final Take Real-time blockchain intelligence isn’t optional anymore it’s the backbone of modern Web3 systems. With Substreams integrated into the $TRON ecosystem, builders now have a full-speed, real-time data foundation for USDT-driven products, dashboards, automation engines, compliance tools, and everything in between. If you’re building anything serious on $TRON, this is the upgrade you simply can’t overlook. @justinsuntron @trondao #TRONEcoStar

🌟Review: The Graph Substreams for @trondao 🌟 🍀The Graph Substreams mang đến một giải pháp streaming dữ liệu real-time rất mạnh cho mạng TRON, được ra mắt chính thức vào tháng 11/2025. Tính năng này đặc biệt hữu ích vì TRON có lượng giao dịch cực lớn — hơn 2,3 triệu giao dịch USDT TRC-20 mỗi ngày và 587,2 tỷ USD khối lượng giao dịch chỉ trong tháng 11/2024. 🌟Điểm Mạnh Nổi Bật 1. Hiệu Năng Cao - Xử lý song song thay vì tuần tự, phù hợp với khả năng xử lý khổng lồ của TRON (hàng triệu TPS). - Độ trễ thấp, rất thích hợp cho dashboard cập nhật liên tục và phân tích dữ liệu theo thời gian thực. - Hỗ trợ streaming chuẩn với thời gian finality 3 giây của TRON. 2. Kiến Trúc Linh Hoạt - Có endpoint riêng cho: TRON Native TRON EVM-compatible - Cung cấp sẵn các module cho: Chuyển TRC-20 Giao dịch DEX (SunSwap, JustSwap) Chuyển TRON native - Pipeline đơn giản: Substreams → PostgreSQL → GraphQL (qua PostGraphile) 3. Ứng Dụng Thực Tế - Thanh toán: Theo dõi real-time giao dịch USDT cho các luồng deposit/sweep (hơn 96.000 giao dịch/giờ). - DeFi: Theo dõi volume 24,6 tỷ USD/ngày trên JustLend và SunSwap. - Compliance: Triển khai on-premise cho tổ chức có yêu cầu tuân thủ nghiêm ngặt. - Tự động hóa: Kích hoạt smart contract, gửi dữ liệu vào Kafka, tạo cảnh báo tự động. 🌟Tác Động Đến Hệ Sinh Thái - Sự tích hợp này giúp giảm thời gian phát triển từ vài tuần xuống vài phút nhờ template và Token API có sẵn. Nó đặc biệt phù hợp với TRON, nơi: 75% giao dịch USDT toàn cầu diễn ra 69 triệu địa chỉ hoạt động Chiếm ưu thế trong thanh toán nhỏ lẻ (phần lớn dưới 100 USD) Các developer trong cộng đồng phản hồi tích cực, đánh giá cao việc có bộ công cụ “production-ready” mà không cần tự xây dựng hạ tầng phức tạp. 🔥Đánh giá: - The Graph Substreams cho TRON là một bước tiến lớn trong mảng hạ tầng dữ liệu, đáp ứng tốt nhu cầu phân tích real-time và vận hành hệ thống trong mảng payments và DeFi. Kiến trúc modular và khả năng xử lý throughput cao rất phù hợp với đặc điểm của TRON. - Điểm trừ nhỏ là bước xác thực và cấu hình ban đầu hơi phức tạp hơn so với Token API dạng plug-and-play, nhưng bù lại khả năng tùy chỉnh rất mạnh cho các use case chuyên sâu. 😁follow @trondao , @TronDao_VIE và @justinsuntron để cập nhật nhiều tin tức quan trọng về hệ sinh thái Tron. #TRONGlobalFriends

⚡ Real-Time TRON Data with The Graph Substreams — A New Standard for On-Chain Streaming The integration of The Graph Substreams with the TRON network unlocks one of the most powerful pipelines for real-time blockchain analytics, automation, and operational intelligence. By combining high-throughput data streaming with flexible transformations, developers can now capture TRON activity—including USDT TRC-20 flows—at production scale and push it directly into applications, databases, dashboards, or even on-chain actions. 🔥Substreams Matter for TRON Substreams delivers a high-throughput, composable, and efficient method for extracting TRON on-chain data. For TRON, this is especially valuable for: ⚡ Real-time payments telemetry (e.g., USDT TRC-20 deposits/sweeps) 📊 DeFi analytics and growth dashboards 🛠 Operational automations and risk monitoring 🔐 Compliance and settlement pipelines Instead of building indexers from scratch, Substreams provides an optimized, scalable foundation. 🏗️ Architecture Overview A high-level architecture for this integration includes: 🌐 Substreams Endpoints: mainnet.tron.streamingfast.i… (TRON native) mainnet-evm.tron.streamingfa… (EVM-compatible) 📦 Substreams Package (SPKG): tron-foundational@v0.1.2 with modules like map_transactions and filtered_transactions 🧩 Ingestion Layer: Node.js consumers parse JSONL and write to PostgreSQL 🗄 Database GraphQL API: PostgreSQL PostGraphile for fast querying 🔁 Downstream Actions: Smart contract sweeps Kafka event streams Alerting or compliance triggers This stack turns TRON into a real-time data engine. 🛠️ Setup Process (Simplified) 📥 Clone the repo scaffold-tron 🧰 Install Substreams CLI 🔐 Authenticate via StreamingFast token 🐘 Spin up PostgreSQL PostGraphile using Docker 📦 Download TRON Foundational SPKG ▶️ Run demo streams or full streams to verify ingestion Once configured, TRON data flows instantly into your tables. 🎯 Targeted USDT Capture (TRC-20) One of the strongest use cases is real-time USDT tracking. 🔻 Filter by sender → write to filtered_usdt_transactions 🔺 Filter by receiver → write to filtered_usdt_to These commands stream events into Node scripts such as: store-filtered-to-table.js store-filtered-to-table-credit.js This allows precise monitoring of inflows/outflows for payment systems, exchanges, or custodial workflows. 🔍 Querying Your Data Query examples include: View TRC-20 USDT flows Count transactions Inspect historical windows These queries can then feed dashboards, alerts, or automated actions. 🚀 Real-World Actions Powered by Streams Beyond storing data, Substreams enables: 🧹 On-chain sweeps: Move deposits instantly to secure wallets 📨 Kafka publishing: Power fraud systems or reconciliation tools 🔔 Alerts: Detect anomalies in real time This transforms TRON’s on-chain activity into actionable operational intelligence. 🧩 Operational Considerations To run a production-grade pipeline: 🔁 Use UPSERTS for idempotency 🕒 Handle backfills with checkpoints 🚄 Boost throughput via Node memory configs 🔐 Secure DB credentials and API keys ⚡ Plan Energy/Bandwidth for on-chain sweeps These best practices ensure stability and reliability. 🧭 Conclusion The combination of TRON Substreams creates a powerful foundation for real-time blockchain infrastructure. Whether you're building payment platforms, DeFi analytics, monitoring tools, or automated operations, this stack delivers everything you need: High-speed data Flexible transformations Production-ready integrations Support for both TRON native and TRON-EVM Immediate scalability for Web3 applications TRON developers now have access to one of the fastest, cleanest, and most scalable data pipelines in the entire blockchain ecosystem. If you're building with TRON, Substreams isn’t just an option — it’s becoming the new standard. @justinsuntron @trondao #TRONEcoStar

🚀 𝗥𝗲𝗮𝗹-𝗧𝗶𝗺𝗲 𝗧𝗥𝗢𝗡 𝗗𝗮𝘁𝗮 𝗝𝘂𝘀𝘁 𝗟𝗲𝘃𝗲𝗹𝗲𝗱 𝗨𝗽 𝗪𝗶𝘁𝗵 𝗦𝘂𝗯𝘀𝘁𝗿𝗲𝗮𝗺𝘀 Developers and data teams building on TRON now have a serious upgrade. The Graph Substreams brings ultra-fast, production-ready streaming of TRON’s on-chain activity straight into your backend—perfect for handling high-volume USDT TRC-20 flows. If you're building payments, analytics, treasury tools, automation systems, compliance monitors, or dashboards, this changes the game. 🔥 Why This Update Hits Hard Substreams creates a high-throughput, real-time data pipeline. It pushes live blocks events, processes them before they hit your app, and keeps them reorganized safely. On TRON, this means instant access to: – USDT movements – Deposit tracking – Live dashboards – Automated on-chain workflows ⚙️ How It All Connects The architecture is simple but powerful: ➤ Substreams endpoints stream TRON mainnet data ➤ A prebuilt TRON Substreams package handles parsing ➤ Node.js consumers pipe data into PostgreSQL ➤ PostGraphile serves a clean GraphQL API ➤ Optional modules can trigger contract calls, push Kafka events, or send alerts This is a plug-and-play pipeline ready for real production scaling. 🎯 Targeted USDT Monitoring You don’t need the whole chain—just the events you care about. You can filter: • Outgoing or incoming transfers • Liquidity shifts • Treasury flows in real time Every filtered event is immediately stored in PostgreSQL tables for analytics or automation. 🔧 What Teams Can Do With This • Sweep deposits the second they land • Run fraud detection via Kafka • Power BI dashboards with live TRON data • Trigger alerts on anomalies • Build compliance-grade monitoring systems This fits both lightweight tools and large enterprise systems. 🛠️ Operational Tips for Production • Use UPSERT to handle potential reorgs • Enable checkpoints for historical syncs • Boost Node memory for throughput • Secure API keys DB credentials • Plan for TRON Energy/Bandwidth on any automated actions These keep your pipeline resilient even under intense load. 💡 The Bottom Line Real-time blockchain visibility is no longer optional as it's essential. TRON’s Substreams integration gives builders a high-performance foundation for payments, dashboards, automation, and USDT-centric infrastructure that reacts instantly to on-chain activity. If you’re building in the TRON ecosystem, this is a tool you can’t ignore. #TRONEcoStar @justinsuntron @trondao

Unlock real‑time TRON insights with The Graph Substreams This guide shows how to: → Stream USDT TRC‑20 transactions directly from TRON → Persist them in PostgreSQL for analytics or compliance → Trigger on-chain sweeps or push to Kafka/alerts Frameworks included: Substreams endpoint & SPKG setup Node.js ingestion scripts GraphQL queries with PostGraphile Targeted filters for sender/receiver flows Whether you’re building DeFi dashboards, payment flows, or compliance pipelines, this workflow gives production-ready, scalable access to TRON on-chain data. Step in, capture the chain, and turn raw data into actionable operations. Guide → github.com/simbadMarino/scaf… @trondao @justinsuntron #TRONEcoStar

⚡ Truy Xuất Dữ Liệu TRON Thời Gian Thực với The Graph Substreams! 🔍 Vì sao chọn Substreams cho TRON? Substreams mang đến khả năng thu thập – xử lý – biến đổi dữ liệu blockchain với tốc độ cao và tính module hóa mạnh. Đối với TRON, điều này đặc biệt hữu ích cho: Luồng thanh toán: theo dõi nạp/rút USDT TRC-20, sweep tự động Phân tích DeFi: tổng hợp khối lượng, dòng tiền, hoạt động smart contract Dashboard vận hành: realtime monitoring cho sàn, ví, hoặc ứng dụng Web3 Substreams giúp rút ngắn đáng kể thời gian xây dựng hạ tầng dữ liệu, từ vài tuần xuống còn vài giờ. 🏗 Kiến trúc tổng quan Dưới đây là các thành phần chính để xây dựng pipeline realtime TRON data với Substreams: 1. Substreams endpoint (StreamingFast) TRON Native: mainnet.tron.streamingfast.i… TRON EVM: mainnet-evm.tron.streamingfa… Hai endpoint này cho phép bạn lấy dữ liệu raw từ mainnet theo thời gian thực. 2. Substreams Package (SPKG) Dùng gói tron-foundational@v0.1.2, bao gồm các module như: map_transactions filtered_transactions Các module này giúp lọc sự kiện, ánh xạ giao dịch và tùy chỉnh logic theo nhu cầu ứng dụng. 3. Ingestion Scripts Các script Node.js đóng vai trò là consumer: Nhận dữ liệu Substreams dạng JSONL Parse và chuyển đổi Ghi vào bảng PostgreSQL theo mô hình đã thiết kế 4. Database & API Layer Lưu toàn bộ dữ liệu vào PostgreSQL Dùng PostGraphile để expose thành endpoint GraphQL, giúp truy vấn nhanh và linh hoạt sau khi ingest. 5. Downstream Integrations Từ cùng một nguồn stream, bạn có thể: Gọi smart contract để sweep vốn tự động Đẩy dữ liệu vào Kafka cho hệ thống messaging realtime Tạo cảnh báo (alerts) dựa trên trigger sự kiện Hoặc mở rộng sang pipeline phân tích sâu hơn 🚀 Kết luận The Graph Substreams biến dữ liệu TRON thành “dòng suối” realtime, có thể xử lý, lọc, chuyển đổi và đưa vào vận hành ngay lập tức. Với cấu trúc module hóa và tốc độ cực cao, đây là giải pháp lý tưởng cho các doanh nghiệp Web3, ví điện tử, sàn giao dịch và ứng dụng cần dữ liệu tức thời và tin cậy. Một bước tiến lớn để giúp TRON trở thành hạ tầng dữ liệu mạnh mẽ cho Web3 hiện đại. @trondao @TronDao_VIE #TRONGlobalFriends

𝗥𝗲𝗮𝗹-𝗧𝗶𝗺𝗲 𝗧𝗥𝗢𝗡 𝗗𝗮𝘁𝗮 𝗜𝘀 𝗚𝗲𝘁𝘁𝗶𝗻𝗴 𝗦𝗺𝗮𝗿𝘁𝗲𝗿 𝗪𝗶𝘁𝗵 𝗦𝘂𝗯𝘀𝘁𝗿𝗲𝗮𝗺𝘀 It is time to explore a major step forward for anyone building with TRON or handling high-volume USDT flows. The Graph Substreams now provides a fast, reliable and production-ready way to stream real-time activity from the TRON network directly into your backend systems. This is extremely valuable for teams working on payments, treasury management, analytics, compliance, monitoring tools or on-chain automation. Why This Matters Substreams gives developers a high-throughput pipeline for blockchain data. It delivers blocks and events in real time, applies transformations before the data even reaches your application, and keeps everything consistent and reorganized safely. On TRON, this means you can follow USDT TRC-20 transfers the moment they occur, support deposit tracking, build instantly updating dashboards, and automate operations with confidence. How the System Works ➢ The setup connects several components into one smooth data flow: ➢ Substreams endpoints serve as the data source for TRON mainnet. ➢ A prebuilt Substreams package for TRON handles core parsing and transforms. ➢ Node.js consumers receive the streams and write the output into PostgreSQL. ➢ PostGraphile exposes a clean GraphQL API on top of the stored data. ➢ Optional modules allow you to trigger contract calls, publish to Kafka or send alerts. The result is a reliable pipeline that you can drop directly into production environments. Targeted Capture for USDT Filtering is one of the most useful features. Instead of processing the entire chain, you can subscribe only to the USDT transfers you care about. Examples include: • Capturing outgoing transfers from a specific address • Capturing incoming transfers to a specific address • Monitoring liquidity movements • Tracking treasury inflows in real time Filtered events are streamed and stored in dedicated PostgreSQL tables, ready for analysis or automated actions. Practical Applications Teams can use this setup to: • Sweep deposits into secure wallets the moment they arrive • Publish each event into Kafka for fraud detection or reconciliation • Feed dashboards and BI tools with live data • Trigger notifications when thresholds or anomalies appear • Build compliance and monitoring systems backed by real-time on-chain signals The flexibility of Substreams makes it suitable for everything from small analytics tools to large-scale operational systems. Key Operational Notes To maintain stability in production, consider the following: • Use UPSERT logic to handle potential reorgs • Use checkpoints when backfilling historical data • Increase Node memory for higher throughput • Treat API keys and database credentials as sensitive assets • Plan for TRON Energy and Bandwidth when performing on-chain actions These practices help ensure reliability even under heavy load. Final Thoughts Real-time on-chain visibility is becoming a core requirement for modern Web3 applications. TRON’s integration with Substreams offers developers a high-performance path to build payments infrastructure, operational dashboards and smart automation workflows that respond instantly to network activity. If you are building on TRON or working with high-volume USDT flows, this is a powerful resource worth adopting. x.com/trondao/status/1997012… #TRONEcoStar @justinsuntron @trondao

Mano, eu já trabalhei numa startup que “todo” backend tava em pgplsql. Tinha uma camadinha fina em node com uma lib chamada postgraphile que em resumo ela olha pro schema do banco de dados e gera uma api graphql. Era um inferno. Mas em resumo é você implementar regras de negócio no DB.

The ability to automatically add items to collections is unfortunately missing in GraphQL :/ even in @RelayFramework it's quite annoying to do, though there are some really nice directives that make it easy-ish But you still have to know which connections to add it to @AlecAivazis's Houdini also has some nice mechanisms for adding items to collections IIRC Anyway, this is an obvious missing feature in GraphQL. Something like Postgraphile a sufficiently smart client should be able to do it, since you're starting from a SQL schema I'm not sure how this would interact with pagination, tbh, though. (And especially with cursor-based pagination.)

Postgraphile ?????????????? Requires some amount of setup tho