Logging in PL/SQL that survives ROLLBACK (and 4 mistakes to avoid)
You get a call: last night's batch failed, the transaction rolled back, and now someone asks "what happened?" You open your log table. It's empty. I…
Testing & QA
⚑ Сообщить о проблемеПоследние новости Testing & QA от Tech News
Все темы
agents
ai
api
architecture
automation
backend
beginners
career
claude
cybersecurity
devchallenge
devops
discuss
javascript
llm
machinelearning
mcp
node
opensource
performance
productivity
programming
python
security
showdev
softwareengineering
testing
tutorial
typescript
webdev
Use REST Describe Metadata Before a Payload Contract Drifts
An integration can keep sending syntactically valid JSON after its target contract has changed. The first visible symptom may be a rejected create,…
История миграции CDRs в чарджинг системах
Около 5 лет назад я участвовал в миграции OCS с Oracle на Apache Ignite и обновлении стека самого чарджинга. Это была огром…
Oracle Java 27 Release Updates Post-Quantum Cryptography
Oracle announced the official release of Java 27, marking a significant milestone for the programming language. This version introduces critical sec…
When Did This Transaction Happen? PostgreSQL Snapshots, LSNs, Oracle SCNs, and More
When did a database change happen? This isn't just academic. Incremental replication must order committed changes and resume exactly without locking…
Oracle Cloud Infrastructure AI Foundations: A Step into the World of AI and Machine Learning
When people hear the term artificial intelligence, they often think of tools that generate text, create images, or answer questions. But artificial…
Oracle Data Redaction: Mask at Read Time, Prove It Isn't Access Control
The support rep sees ****-****-****-0001 on their screen and everyone relaxes. The card number is "masked," the demo looks compliant, the box gets t…
OCI Monitoring Alarms: Six Ways an Alarm Can Look Ready and Still Fail
A practical review of metric timing, query scope, notification delivery, suppression, and operator response While reviewing Oracle's alarm documenta…
OCI - Connecting to an OCI Always Free MySQL DB System: Installing MySQL Shell and Building a "Poor Man's VPN"
%0A%20%20%20%20%20%20%20%20.libutton%20{ %0A%20%20%20%20%20%20%20%20%20%20display:%20flex; %0A%20%20%20%20%20%20%20%20%20%20flex-direction:%20column…
Teaching an AI to read a relational database — including Oracle APEX
A few months back I started building a tool to solve a problem that kept annoying me: when you want an AI assistant to help with an old database, yo…
I built a personal "Agentic OS" that runs my DBA work — with approval gates, audit trails, and a $0.01 morning brief
I'm an Oracle Apps DBA. My whole job is built on one instinct: nothing touches a production system without me knowing exactly what it's about to do.…
Series Week 25 of 52 : API Logging - The Infosec headache of maintaining the logs - The Oracle solution
%0A%20%20%20%20%20%20%20%20.libutton%20{ %0A%20%20%20%20%20%20%20%20%20%20display:%20flex; %0A%20%20%20%20%20%20%20%20%20%20flex-direction:%20column…
Oracle Patching, Demystified: CPU, RU, RUR — and What Changed in 2026
Few Oracle topics generate as much confident, contradictory advice as patching. Someone tells you to "apply the CPU," someone else insists you want…
autougpgrade.jar - Provision & switch Oracle Homes ( Hands on lab scenario to move OH from 19.19 to 19.31 and rollback to 19.19 )
%0A%20%20%20%20%20%20%20%20.libutton%20{ %0A%20%20%20%20%20%20%20%20%20%20display:%20flex; %0A%20%20%20%20%20%20%20%20%20%20flex-direction:%20column…
Как ораклист сертификацию по Postgres сдавал
Однажды я захотел узнать что-то новое по СУБД Postgres и структурировать уже имеющиеся знания. На помощь пришла программа сертификации. Рассказываю…
The Oracle HA Decision Tree: RAC vs Data Guard vs Both
"We have RAC, so we're covered for DR." It's one of the most expensive sentences in Oracle operations, and I've watched variations of it play out mo…
How I Exported 1 Million+ Oracle Records to CSV in Under 30 Seconds Using Node.js
The Problem During the modernization of a legacy enterprise application, one feature initially appeared deceptively simple: Export data to CSV. The…
BSON and OSON: documents are designed to be nested, not flat
I like vendors benchmarks as they are often good illustrations of worst practice. Rather than focusing on real implementation trade-offs, they pick…
I Built an Oracle DBA That Lives in Telegram. It Cut a 500K-Row Scan to 5 - After Asking Permission.
This is a submission for the Hermes Agent Challenge What I Built OracleOps is a Hermes Agent plugin and skill pack that turns any messaging app your…
An Oracle DBA builds AI: shipping Oracle 23ai RAG and an MCP server in a weekend
I asked Claude to 'DROP TABLE' on my Oracle database. It tried. The guardrails refused. The audit log captured it. That's the demo screenshot at the…