AI Agent Builds in Oracle Designer 10g Without Ever Opening Its GUI

·1 views

Oracle Designer 10g, a legacy CASE tool whose official support ended in 2013, remains the core development environment at one company managing a large insurance system with thousands of entities, tables, and PL/SQL modules. A developer set out to test whether an AI agent with SQL access could perform design tasks that are traditionally done through the tool's graphical interface. Over two days, the agent created entities, tables, sequences, triggers, and a complete form definition entirely through SQL, never launching the Designer GUI once. It accomplished this by reading undocumented API package specs directly from the database, using existing repository objects as templates to infer internal naming conventions, and writing changes through Designer's own transactional API with validation at each step. The experiment demonstrated that Oracle Designer's underlying repository is fully accessible via SQL, making it operable by any tool or agent that can run database queries.

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)

monkeypatch vs mock.patch: One rule to pick the right Python test tool

In Python testing, both monkeypatch and mock.patch replace attributes and clean up after tests, but choosing between them often comes down to a single question. If a test only needs a function to return a value or be suppressed, monkeypatch is the simpler choice, reading as plain Python with built-in cleanup for environment variables, directories, and sys.path. If a test needs to verify how a function was called — such as checking arguments with assert_called_once_with — MagicMock via mock.patch is the appropriate tool. The two can also be combined, using monkeypatch.setattr to install a MagicMock object, which avoids nested context managers while retaining full assertion capabilities. A key rule for both approaches is to patch where the name is looked up in the module under test, not where it was originally defined.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why a Green CI Pipeline Does Not Mean Your Release Is Safe

A passing CI pipeline only confirms that the specific checks configured have passed under controlled conditions, not that a release is production-ready. Code can clear every unit and integration test yet still fail in production due to mismatched environment variables, missing secrets, or incorrect feature flag states. Database migrations present a particular risk, as tests run against clean environments cannot replicate years of real production data, legacy records, or live traffic patterns. Modern applications also depend on external services and versioned APIs that CI cannot fully observe, meaning dependency-related failures may go undetected until deployment. Experts argue that release readiness is a broader operational concern, and treating a green pipeline as a final safety verdict is a common source of production incidents.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How Stripe Connect platforms silently absorb costs from lost payment disputes

When a payment dispute is lost on a Stripe Connect platform, the platform's balance is debited for both the disputed amount and a dispute fee of around $15, while the connected seller's account remains completely untouched. Unlike refunds, disputes are initiated by the cardholder's bank weeks after the transaction, leaving no automatic mechanism to reverse the original transfer to the seller. Platforms must manually trigger a transfer reversal via Stripe's API after a dispute closes, a step that is easy to overlook if webhook handlers only log the event without acting on it. The timing compounds the problem, as disputes typically close 30 to 90 days after the original charge, making the financial gap hard to spot in reconciliation reports. Platforms that have never reversed transfers on lost disputes may have unknowingly absorbed all such losses, and a targeted SQL query across dispute and transfer records can reveal the full unrecovered exposure.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why S3 Is an Underused but Cost-Effective Disaster Recovery Asset

Amazon S3 and compatible object storage services offer a practical, low-cost foundation for disaster recovery, yet many organizations fail to fully leverage them despite already storing critical data there. According to Uptime Institute's 2022 Outage Analysis, over 60% of IT outages now cost at least $100,000, up from 39% in 2019, underscoring the financial stakes of inadequate DR planning. AWS S3 is designed for 99.999999999% durability by storing data redundantly across at least three availability zones, making it more resilient than most on-premises database setups by default. At approximately $0.023 per GB per month, storing 10 TB of DR backups on S3 costs around $236 monthly — significantly cheaper than maintaining a warm-standby database instance. Experts note that the most common DR failure is not storage breakdown but the absence of tested restore procedures, making regular restore drills as important as the storage strategy itself.

0 comments Read more at DEV Community