Planet Ingres

May 21, 2026

 PgCache is a wire-compatible, transparent Postgres proxy that caches read data, then keeps it fresh using PostgreSQL Logical Replication.

PgCache is designed to accelerate PostgreSQL performance by providing a transparent caching layer between applications and the database. By utilizing Change Data Capture (CDC) through logical replication, the system ensures data remains current without requiring manual cache invalidation or application code modifications. This approach entirely eliminates the need to sprinkle cache invalidation logic throughout your application code or guess at appropriate Time-to-Live (TTL) settings.

https://www.i-programmer.info/news/84-database/18884-pgcache-transparent-postgresql-query-caching-and-cdc-maintenance.html#google_vignette

by Nikos Vaggalis (noreply@blogger.com) at May 21, 2026 03:23 PM

May 19, 2026

Nikos Vaggalis - Massachusetts' Institute of Technology Introduction to Deep Learning

 The full materials of the MIT 6.S191 lecture which took place just this March are now available for free and for all. This lecture is a comprehensive overview of deep learning architectures, specifically focusing on Convolutional Neural Networks (CNNs), Recurrent Neural Networks (RNNs), and Transformers.

https://www.i-programmer.info/news/150-training-a-education/18878-massachusetts-institute-of-technology-introduction-to-deep-learning.html

by Nikos Vaggalis (noreply@blogger.com) at May 19, 2026 05:47 PM

May 18, 2026

Nikos Vaggalis - Jupyter Notebooks MCP Server

 Jupyter gets its own MCP server. The Jupyter MCP Server by Datalayer is a Model Context Protocol server implementation designed to act as a bridge between Large Language Models, AI assistants and a user's live Jupyter environment. What does it enable?

https://www.i-programmer.info/news/90-tools/18875-jupyter-notebooks-mcp-server-.html

by Nikos Vaggalis (noreply@blogger.com) at May 18, 2026 05:52 PM

May 14, 2026

Nikos Vaggalis - The .NET Agent Skills

 Microsoft's extends the capabilities of the AI coding agents through Agent Skills for .NET framework-oriented tasks.

But first of all, what are Agent Skills? Agent Skills are a lightweight, open, and standardized format used to extend AI agents' capabilities with specialized knowledge and workflows

https://www.i-programmer.info/news/89-net/18867-the-net-agent-skills.html

by Nikos Vaggalis (noreply@blogger.com) at May 14, 2026 04:05 PM

May 13, 2026

Nikos Vaggalis - ggsql: SQL For Visualization

 ggsql is a novel data visualization tool that integrates the Grammar of Graphics directly into SQL environments.

Built by the creators of ggplot2, this system allows users to construct complex charts by adding declarative clauses like VISUALISE, DRAW, and SCALE to standard database queries. Unlike traditional tools that offer fixed chart types, ggsql employs a modular approach where independent components—such as layers, coordinates, and aesthetics can be combined to create custom visuals.


https://www.i-programmer.info/news/84-database/18862-ggsql-sql-for-visualization-.html

by Nikos Vaggalis (noreply@blogger.com) at May 13, 2026 06:21 AM

May 08, 2026

May 07, 2026

April 30, 2026

Nikos Vaggalis - Agentic Skills For The Database

 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

by Nikos Vaggalis (noreply@blogger.com) at April 30, 2026 06:46 PM

April 29, 2026

Nikos Vaggalis - Learn concurrency - a deep dive into multithreading with Python

 This article explains concurrency in Python including topics like multithreading, multiprocessing, race conditions, and synchronization mechanisms such as locks. We’ll then take a deep dive into switching off GIL to enable real multithreading in Python, highlighting the differences, the benefits and the gotchas with clear code examples.


https://blog.geekuni.com/2026/04/python-concurrency.html

by Nikos Vaggalis (noreply@blogger.com) at April 29, 2026 11:32 AM

April 28, 2026

Nikos Vaggalis - Microsoft Fabric Machine Learning Tutorial - The Course

 Learn about Microsoft Fabric and its applications of ML through a project analyzing Titanic's passenger data.

This tutorial is an end-to-end demonstration of Microsoft Fabric that guides learners from descriptive and diagnostic analytics to predictive analytics using the popular Kaggle Titanic dataset. The goal of the tutorial is to train a binary classification machine learning model capable of predicting whether an individual would have survived or perished on the Titanic, based on personal details like their age, gender, and ticket class.

https://www.i-programmer.info/news/150-training-a-education/18831-microsoft-fabric-machine-learning-tutorial-the-course.html

by Nikos Vaggalis (noreply@blogger.com) at April 28, 2026 06:02 PM