Noticias Tech
Artículos relevantes de tecnología resumidos en español. Actualizamos cada 6 horas.
Gaussian Splat of a Strawberry
Comments
Native SQL in Java without JDBC boilerplate — meet Ujorm3
If you've ever written raw JDBC, you know what's coming. Open a connection, create a PreparedStatement, set parameters by index (hope you counted right), iterate a ResultSet, close everything in a finally block, declare SQLException on every I've been experimenting with Ujorm3, static final ResultSe
GBase 8a Backup and Restore Guide: Full and Incremental Backups with gbackup
GBase 8a stores massive analytical datasets across many nodes. If hardware fails, someone drops a table, or an upgrade goes wrong, a solid backup strategy is your only lifeline. This guide covers the official gbackup tool for full and incremental backups, plus mysqldump for finer-grained tasks. A
Certified Site Reliability Architect: A Smart Move for Cloud Engineers
The way engineering teams build software has changed dramatically over the last decade. Organizations are no longer operating small applications running on fixed infrastructure. Today’s systems are built using distributed architectures powered by cloud-native technologies, containers, Kubernetes clu
Master JasperReports 2026 – Complete Beginner to Advanced Course in Java
Hello developers I have created a complete JasperReports 2026 Course for beginners and intermediate Java developers who want to learn professional report generation using Java and Jaspersoft Studio. In this course, you will learn how to design reports, connect databases, use parameters, filters, tab
From DeepSeek to Quack: When the Dream of Distributed DuckDB Started to Feel Real
At the beginning of 2025, DeepSeek changed the conversation around AI infrastructure. Most people focused on the model quality, the training cost, and the geopolitical story around a new Chinese AI lab suddenly competing with the biggest names in the industry. That part was interesting, of course. B
Come estrarre una singola tabella da un file dump MySQL
Ti è mai capitato di dover ripristinare una sola tabella ma di avere a disposizione solo un file dump .sql gigante dell'intero database? Invece di perdere tempo cercando di aprire un file da svariati gigabyte con un editor di testo, o peggio, importare tutto il database su un server locale solo per
Pourquoi ta requête Supabase s'arrête à exactement 1000 lignes (et ne te le dit jamais)
La nuit où un dropdown m'a menti Vingt-trois heures, fin avril. Une utilisatrice de mon outil interne me signale un filtre incomplet sur un dropdown. Mon premier diagnostic accuse un sous-filtre côté interface. Je le démonte, j'isole la source du dataset, je relance sans filtre. Le compteur retour
Why your Supabase query stops at exactly 1000 rows (and never tells you)
The night a dropdown lied to me Eleven at night, late April. A user of my internal tool reports an incomplete filter on a dropdown. My first diagnosis blames a sub-filter on the UI side. I take it apart, I isolate the dataset source, I re-run without filters. The counter returns a thousand on the
In some scenarios, relying on LLMs to generate SQL is neither rigorous nor reliable.Right way to teach LLMs to generate SQL is here
Over the past two years, tools that generate SQL from natural language have become very popular. Type a question in plain English, and an LLM produces SQL for you. It's convenient. But from my experience on real‑world projects, there is a clear problem when business requirements demand high accurac
Peter Neumann has died
Comments
Building a Healthcare RCM Analytics API with FastAPI and PostgreSQL
Introduction I'm a biomedical engineer who ended up doing data analysis for a Revenue Cycle Management company in the U.S. — and honestly, I wouldn't change it. There's something fascinating about the intersection of healthcare operations and data. But after two years on the floor, one thing becam
Every AI database answer needs a source trail
An AI answer without provenance is just a confident paragraph. That may be fine for brainstorming. It is not enough for database answers that drive product, finance, support, or operations decisions. When an agent returns “MRR is up 8%,” the useful question is not only whether the number came from a
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 OracleOps is a Hermes Agent plugin and skill pack that turns any messaging app your team already uses into a senior Oracle DBA you can DM at 3 AM. 📡 One install. Any chat platform. Telegram, but the same OracleOps skills work identically in Slack,
Click (2016)
Comments
Cleaning Messy Phone Numbers in PostgreSQL Using REGEXP_REPLACE
Introduction The first thing anyone that has worked with real world data will tell you is that rarely does data come in the clean, uniform format you expect. Phone numbers are one of the biggest culprits. One person enters +254712345678, another writes 0712345678, someone else throws in 254-712-3
DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity
DuckDB EC2 Optimization, Postgres FDW Pushdown, SQLite NetBeans Connectivity Today's Highlights This week features crucial insights into optimizing DuckDB performance on cloud instances, a deep dive into PostgreSQL FDW pushdown strategies, and practical guidance on connecting SQLite dat
I red-teamed Oracle APEX 26.1's new AI Agent feature in the 72 hours after it went GA. Claude refused 7 of my 10 attacks on its own.
"With a weak system prompt, zero security configured, and a deliberately permissive set of tools, I tried 10 attack patterns against a vulnerable APEX 26.1 AI Agent. Claude refused 7 of them on its own. The 3 that worked are the same 3 every Oracle DBA needs to defend at the tool layer." Oracle APEX
$0 Personal Agentic AI Assistant - Setting Up Free Cloud Server - Part 2
Introduction This is Part 2 of the Zero Dollar AI Assistant series. Part 1- Running a Personal AI Assistant for $0 - Architecture covers the full stack and why it works. AWS, Google Cloud, and Azure have a free tier. However, they all have one thing in common: a clock ticking. Twelve months, then
Polypad
Comments
I Found Ultra-Pure Quantum Crystals in an Abandoned Mine in the Atacama Desert
Comments
Avoiding range overlaps in PostgreSQL with EXCLUDE constraint, better than serializable or assertions
Two groups of friends try to book seats ranges 5–8 and 7–9 in the same row, for the same show, at the same time. One of them must fail and retry. An ACID database can help enforce this rule. The question is: how much collateral damage does your concurrency control cause for everyone else? In modern
Oracle Fusion vs EBS: 7 SQL Patterns Every BIP Report Developer Needs
If you've spent any time writing BIP (or OTBI) reports against Oracle Fusion Procurement Cloud, you've probably hit a wall that didn't exist back on EBS: half the columns you "remember" don't exist anymore, and the display names you actually want to show live on a different table than the ID you're
How Distribution Tables Keep Data Consistent When Replacing a Data Node
When you swap a failed Data Node with a fresh one in GBase 8a, a carefully choreographed sequence ensures data distribution stays consistent: a transitional distribution map isolates the fault, then an automatically rebuilt map restores the original layout while data is moved in the background. The
Launch HN: Ardent (YC P26) – Postgres sandboxes in seconds with zero migration
Comments
Query Everything with SQL: The Ultimate Compliance and Security Toolkit
Three practical guides to turn your files, emails, and project data into queryable SQLite databases If you've ever struggled with compliance audits (HIPAA, SOX, GDPR, SOC 2), security investigations, or e-discovery requests, you know the pain: Data is everywhere — Files on disks, emails in inboxes,
Why You Must Clean Data, Distribution, and Nodedatamap Before Removing a VC
In GBase 8a, deleting a Virtual Cluster (VC) without first clearing its data, distribution maps, and nodedatamap entries is blocked — or worse, causes metadata corruption. This strict sequence is mandatory and enforced by the resource management model and tight metadata coupling inside a gbase datab
Open-sourced ZenithDB, Fastest DB for Agent Traces in Rust
Hey Guys! I just open-sourced Zenith, a columnar database engine purpose-built for AI agent traces. Got mad with Clickhouse and couldn't find a OSS alternative for traces. tbh Agent traces are weird. they're long, sparse, high-cardinality JSON with bursty ingest, late annotations, and fat text field
S-100 Virtual Workbench
Comments
Why GBase 8a Express Logs Default to ERROR and WARN Only
By default, the Express log in GBase 8a outputs only ERROR and WARN messages — not INFO or DEBUG. This is a deliberate choice that prioritizes production performance while keeping logs readable and manageable. INFO and DEBUG levels capture extensive execution details — query plan steps, intermediate
Building a RAG Application with pgvector and the OpenAI API
Retrieval-Augmented Generation is now the default architecture for adding knowledge to LLM-powered applications. When a user asks a question, you retrieve relevant context from your own data, pass that context to the model alongside the question, and the model answers based on what you gave it. Most
Design review: Live SQL queries on PostgreSQL
I’ve been experimenting with something I’ve wanted for a long time: "live mode" in SQL. Today, this is now possible on PostgreSQL: const result = await db.query( `SELECT * FROM users`, { live: true } ); With { live: true }, you get back a live result set that reflects the state of the DB in re
Why your async user-creation endpoint silently produces duplicates
Six hours. That's how long I burned last Tuesday tracking down a bug that only showed up in production. The tests passed. CI was green. Two reviewers approved the PR. But once real traffic hit, our user-creation endpoint started silently producing duplicate rows. I've seen this exact pattern enough
Open Source Resistance: keep OSS alive on company time
Comments
Setting up a free *.city.state.us locality domain
Comments
AI agents know SQL. Oracle Database Skills teach them Oracle
This is article 1 of 8 in my Oracle Database Skills series. Most assistants can write SQL. That’s not the same as knowing Oracle Database. The difference shows up in production. A model that learned generic patterns can assume another vendor’s isolation semantics, borrow date arithmetic that silentl
Running Postgres at Scale: Lessons Learned
We run Postgres for a product with millions of users. Along the way I've broken it in every possible way. Here are the lessons I wish I'd known on day one. You can ignore autovacuum for a while. You cannot ignore it forever. Dead tuples accumulate. Query plans go bad. Eventually a query that used to
Best PostgreSQL ODBC Drivers: Choosing the Right Connectivity Tool
PostgreSQL is widely used for business-critical databases, but many external platforms still rely on ODBC to connect with relational databases. Reporting tools, ETL platforms, analytics suites, and older enterprise systems often require an ODBC driver to communicate with PostgreSQL. Because of this,
Understanding SQL query structure
This is basically SQL’s version of BODMAS/PEDMAS. We write SQL one way… executes it differently. The golden rule: F/JWGBHSOL/O Looks gibberish at first. Build the dataset. FROM → grab the main table JOIN → combine other tables First filter. Removes rows that don’t match conditions. Create groups fr
SQL Execution Order: Write Queries That Think Like the Database
Most SQL bugs aren't logic errors. They're sequence errors — the result of writing a query in one order and the database executing it in another. Consider this query: SELECT department, COUNT(*) AS headcount FROM employees WHERE headcount > 5 GROUP BY department; It looks reasonable. It will not ru
Senior SQL: Advanced Joins, Window Analytics, Plans, Indexing & Production Mindset
Senior SQL is not a longer SELECT — it is scale-aware relational engineering: you can state grain, predict cardinality, read a planner, choose indexes and partitions, and reason about correctness under concurrency while keeping SQL maintainable for the next teammate. Hiring loops for senior data eng
SQL-First-in-Migrations: Governing Every Database Artifact Through EF Core Migrations
SQL-First-in-Migrations: Governing Every Database Artifact Through EF Core Migrations 1. Introduction Entity Framework Core's code-first approach is frequently understood as limited to entity classes and their table mappings. A production database contains more than tables: views, funct
The 12 Best Free Access Database Templates to Streamline Your Work
Managing business data efficiently is critical for your small business, but building a database from scratch requires time, technical expertise, and meticulous planning. Fortunately, there are numerous free, ready-to-use Access database templates that provide a solid foundation for organizing vital
Don't Trust AI-Generated SQL Blindly: A Developer's Validation Checklist
AI coding assistants can knock out a SQL query in seconds. You describe what you want in plain English, and out comes a SELECT statement that looks completely reasonable. So you copy it, paste it into your app or dashboard query runner, and hit execute. This is where things go wrong. Unlike a syntax
Learning Software Architecture
Comments
Try SLayer, the open-source semantic layer for agents
If you want to connect your agent to a database (say, to build a data analyst chatbot or any kind of agentic app) today you have 2 options: an SQL MCP server or a semantic layer. SQL MCP is the easiest path to setup, especially if you also have a .md knowledge base which the agent can update. It get
Full-Text Search on a 2 GB PostgreSQL Instance
AFK.live aggregates headlines from 250+ news sources. I needed search. I had a 2 GB database and no budget for Elasticsearch. Fair warning: this article goes deep into PostgreSQL internals — query plans, GIN indexes, trigram scoring. I've added links throughout for context. If you're not familiar wi
GDPR for Developers: What the Regulation Actually Means in Code
Most articles about GDPR are written by lawyers for lawyers. This one is written by a developer for developers — with real code, real mistakes, and real consequences. I've built several B2B SaaS products in Europe. Billing platforms, webhook inspectors, hotel management systems. Every single one had
Your agent doesn't remember anything. Persistence isn't memory.
A customer support agent that forgets a user's billing conversation from two days ago isn't broken — it's just missing memory. Not persistence. Not idempotency. Memory. And they're not the same thing. That's the argument Ed Huang (CEO of PingCAP) makes in a sharp piece on The New Stack, and it's wor
When the Pentest Wins: Hardening a Legacy API Without Breaking the Business
The report was a disaster. During a scheduled Penetration Test, the security firm didn’t just find "theoretical vulnerabilities"—they walked out the digital front door with a database full of real customer PII. They didn't need a complex zero-day exploit; they just used the doors we left wide open.