PERL,INGRES,PROGRAMMING

  Aurora DSQL is Amazon's serverless, fully managed, distributed relational database service optimized for transactional (OLTP) workloads.  A significant new capability is the Change Data Capture (CDC) preview, which streams real-time database modifications directly to Amazon Kinesis Data Streams. https://www.i-programmer.info/news/144-graphics-and-games/18930-aurora-dsql-gets-change-data-capture.html

  Companies like PlanetScale and Oracle are providing curated libraries of Skills that allow AI coding assistants, such as Claude Code or Cursor, to interact directly with databases. Skills, Skills, Skills...the latest buzzword in this era of AI induced coding practices. This time they come for the Database to enable agents to perform complex tasks like automated schema optimization, security audits and CSV data ingestion with higher precision and lower token consumption. https://www.i-programmer.info/news/90-tools/18846-agentic-skills-for-the-database-.html

  The Conference on Innovative Data Systems Research (CIDR), is a gathering for researchers and practitioners from both academia and industry to discuss the latest visionary ideas in the database field. We look into what this year's conference was about. https://www.i-programmer.info/news/84-database/18761-cidr-conference-2026-looks-at-future-of-databases.html

  Alibaba has introduced Zvec, an open-source vector database designed to function as a lightweight library for on-device Retrieval-Augmented Generation (RAG). https://www.i-programmer.info/news/84-database/18742-zvec-lightweight-vector-database.html

  SQL, yes that old horse, is still going. SQL has been the data access standard for decades. It levels the playing field, easily integrates with other systems and accelerates delivery. Here's a  beginner-friendly course on SQL for data engineering. https://www.i-programmer.info/news/150-training-a-education/18703-learn-sql-for-data-engineering-the-course.html

  Agentic AI and MPC are coming on strong in the database market. After the likes of Postgres and Oracle, now it's MongoDB's turn to incorporate MCP. https://www.i-programmer.info/news/105-artificial-intelligence/18540-mongodb-now-does-mcp.html

  InfluxData has released InfluxDB 3.6 for both Core and Enterprise, a  new version which incorporates AI and performance improvements. But, first of all what's the difference between Core and Enterprise? https://www.i-programmer.info/news/80-java/18465-influxdb-36-released-with-ai-capabilities.html

  ChartDB strikes back with a database agent that auto-magically draws database schemas for you. Last February in  Database Diagramming With ChartDB  we looked at ChartDB as an open-source database diagrams editor that can be self-hosted or used in the Cloud which could: https://www.i-programmer.info/news/90-tools/18391-chartdb-the-erd-agent.html

  Google's open source MCP server that allows AI agents to interact with SQL databases. The difference betweenm it and other MCP to SQL servers is that it takes out complexities such as connection pooling, authentication and observability so that the developer can solely focus on implementing the logic of his Agents https://www.i-programmer.info/news/89-net/18364-googles-mcp-toolbox-for-databases.html

  Oracle adds MCP support to two of its flagship tools, SQLcl and  SQL Developer for VS Code, in an attempt to simplify user interaction with the database. https://www.i-programmer.info/news/84-database/18289-oracle-database-adds-mcp-tooling-support.html

  The tools contradict each other; the first one allows you to write SQL instead of using Mongo's special syntax, while the other allows you to manipulate the database without having to write SQL and by just employing natural language. https://www.i-programmer.info/news/90-tools/18151-two-tools-to-elevate-your-mongodb-experience.html

  Use this Neo4J GraphRAG library to build your own knowledge graph-based applications. But why GraphRAG, the concept, in the first place? GraphRAG is an advanced RAG technique which consumes structured and unstructured documents to create knowledge graphs which extract context on top of the vectors. It's that property that renders graph based RAG to provide highly relevant answers to the users' questions. https://www.i-programmer.info/news/105-artificial-intelligence/18050-graphrag-with-python-and-neoj.html

  MotherDuck, DuckDB's makers, having listened to its users, has released a local GUI for easier interaction with the database. https://www.i-programmer.info/news/84-database/17935-interact-with-duckdb-using-local-ui.html

  ChartDB is an open-source database diagrams editor that can be self-hosted or used in the Cloud, for free. At IProgrammer we're very fond of utilities that make the developer's life just that little bit easier, especially on the database front. In the past we had covered a few such cool tools like Prisma Markdown which can automatically generate ERDs, ERDLab, an intuitive SQL Visualization tool which helps in capturing your database design thoughts and Azimutt, a database schema explorer with many great features. https://www.i-programmer.info/news/90-tools/17852-database-diagramming-with-chartdb.html

  Core, the new open source InfluxDB offering, promises enhanced performance and more freedom in using it under a permissive license. We've looked at Influx indirectly in the past through Amazon's Timestream, the fully-managed time series database service that is based on open source InfluxDB. In that article we also gave a formal definition of time-series : https://www.i-programmer.info/news/84-database/17798-influxdb-3-core-released-in-public-alpha.html

  SQLite lives in the browser thanks to WebAssembly. With Sqlime you can run your workload online with no need of setting up anything. On top of that ask questions on your data with AI enabled CLI utilities.  https://www.i-programmer.info/news/84-database/17786-sqlime-n-online-sqlite-playground.html

  Run DuckDB inside your browser thanks to Webassembly. When is that useful? Running a database instance inside a browser is nothing new. I've already explored the idea in  Running PostgreSQL Inside Your Browser With PGLite   where I explained: PGlite is a WASM Postgres build packaged into a TypeScript client library that enableyou to run Postgres in the browser with no need to install any other dependencies. https://www.i-programmer.info/news/84-database/17726-duckdb-webassembly-whattheduck.html

  Prisma Markdown is a new tool that takes the pain out of drawing entity relationship diagrams. An essential help if your design is database driven rather than code driven. https://www.i-programmer.info/news/84-database/17561-effortless-erd-design-with-prisma-markdown.html

  Valkey, heralded as a better alternative to Redis, has taken the industry by storm. Reinforcing its superiority, a rapidly growing ecosystem is being built around it. https://www.i-programmer.info/news/84-database/17540-valkeys-expanding-ecosystem.html#google_vignette

  This is thanks to sqlite-vec, a new vector search extension for SQLite written entirely in C and with no dependencies. Vendors are eager to add vector search to their dbms products. One prominent example is Postgres with pg_vector which we covered in "Turn PostgreSQL Into A Vector Store" and more recently Mariadb as examined in "MariaDB Introduces Vector Search". This begs the question of what's the rush for adding vetor support? https://www.i-programmer.info/news/84-database/17458-sqlite-gets-into-vector-search.html