Harry: Open-Source Tool Stores Oracle DB Performance History in PostgreSQL and Grafana

·1 views

A developer has released Harry Performance Scraper, an open-source pipeline that periodically collects detailed performance data from Oracle Database and stores it in PostgreSQL for historical analysis. The tool captures SQL statistics, session activity, wait events, blocking relationships, and execution plans at configurable intervals ranging from 2 seconds to 2 minutes. Unlike conventional monitoring tools such as Prometheus, which excel at real-time numeric metrics and alerting, Harry is designed to retain relational evidence needed to investigate incidents after workloads have already changed. Data is stored in a structured PostgreSQL schema that separates high-frequency samples from slowly changing information like SQL text and execution plans, reducing storage waste. Grafana serves as the visualization layer, while the PostgreSQL repository provides the queryable historical record for post-incident analysis.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Developer Builds Choose-Your-Own-Adventure REST API to Learn NestJS From Scratch

A developer is documenting their backend learning journey by building 'Grimoire API', a REST API powering a choose-your-own-adventure game with XP and badge mechanics. The project, shared on DEV Community, is structured so each milestone maps to a specific NestJS concept rather than following generic tutorial patterns. The first milestone covers creating a single working endpoint, GET /pages/:id, that returns a story page as JSON. The post breaks down four core NestJS building blocks — controllers, services, modules, and dependency injection — explaining how they interact to handle HTTP requests cleanly. The author highlights how dependency injection simplifies testing by allowing fake service instances to be passed to controllers without modifying any production code.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Logic Bug Found in Burp Suite's Top JWT Editor Extension After 15-Hour Investigation

A security researcher discovered a silent logic flaw in the JWT Editor extension for Burp Suite, currently the platform's most popular BApp Store tool and a nominee for its 2026 Best Auth & Access Control award. The bug surfaced during a routine Web Security Academy lab on JWT algorithm confusion, where the researcher's forged tokens were consistently rejected despite following the correct steps exactly. After ruling out user error through multiple community walkthroughs and official documentation, a 15-hour root-cause investigation pointed to the extension itself silently contaminating HMAC keys. The flaw relates to how the extension handles the Base64-encoded public key used as an HMAC secret during RS256-to-HS256 algorithm confusion attacks. The researcher ultimately filed a GitHub issue against the extension, highlighting how tooling bugs can silently undermine security testing workflows.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why AI-Generated Code Creates a Hidden Understanding Gap for Developers

A developer reflecting on years of code review experience argues that genuine code comprehension is the foundation of effective review, with the deepest understanding coming from those who wrote the code together. Traditional tools and asynchronous pull-request reviews rely on pattern-matching rather than true understanding, limiting their effectiveness. When AI agents generate large volumes of code, the reviewing developer faces a paradox: they are nominally the team lead but never wrote the code themselves. The sheer size of AI-generated diffs compounds the problem, since reviewing too much code at once degrades quality. The author's practical workaround is to instruct the AI to work in smaller, reviewable chunks — such as individual workflows with tests — to keep human understanding intact.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

7 Career Tips for New Software Engineers From a Startup Founder

A founding engineer at a startup has shared seven pieces of practical advice aimed at early-career software developers. The guidance emphasizes prioritizing personal health, continuous learning, and building a public professional presence rather than tying one's reputation to a single employer. The author highlights the importance of strong communication skills, asking quality questions, and avoiding assumptions in the workplace. Developers are also encouraged to read broadly beyond technical literature, covering areas like psychology, sales, and marketing, since the job involves working with people as much as writing code. On the topic of AI, the author advises mastering fundamentals, understanding systems design, and staying adaptable across the full stack as the best way to remain relevant.

0 comments Read more at DEV Community