← Înapoi la Urmăritori

Cel mai recent articol

Ultima verificare

Urmăritori 0 urmăritori
Articole: 202
  1. How easy is it to use the VillageSQL MCP extension?

    VillageSQL published Access MySQL over MCP with vsql-mcp .

  2. Getting VECTOR capabilities in MySQL 8.4 using VillageSQL

    For this quick verification of the 0.0.7 development branch of VillageSQL with the new vsql-vector plugin.

  3. Improving container security in your CI/CD pipeline

    At PyCon AU 2026 , the presentation Your Python container is 90% stuff you didn’t ask for by Scott Norris at Chainguard really exposed the impact of being lazy in container management for security purposes.

  4. My take on PyCon Australia 2026

    PyCon AU 2026 held in Brisbane this week was a five day event for the Python community.

  5. Fixing Old Software Bugs Without Thinking

    I previously came across an issue in my benchmarking work where I relied on the Latency Histogram section of sysbench output.

  6. Curating DuckDB Datasets Leveraging AI

    In Curated MySQL Data Sets for Realistic Testing I described datasets assembled the manual way — download, schema, load, validate, document — over hours or days per source.

  7. Why INSERT IGNORE should not be used

    Let’s say you’re building a reference table from source data, e.g. a silver medallion table from a primary source.

  8. What Constitutes Clean Data?

    Clean data is one of those terms everyone uses and few define precisely.

  9. Curated MySQL Data Sets for Realistic Testing

    Synthetic benchmarks have their place, but I have always preferred working with real data.

  10. COSCUP 2026: Planning your upgrade to MySQL 9.7

    I recently had the pleasure of presenting Planning your upgrade to MySQL 9.7 at COSCUP 2026 in Taipei, Taiwan.

  11. DataEngBytes Sydney Overview

    I have just returned from my first DataEngBytes conference in Sydney.

  12. MITRE ATLAS - A 2025 Review

    The MITRE ATLAS Matrix provides a working knowledge base of adversary tactics, techniques, and real-world case studies specifically for Artificial Intelligence (AI) and Machine Learning (ML) systems.

  13. Foundational Frameworks for GenAI Security Analysis

    Three frameworks form the analytical foundation of this series’ threat analysis, selected for their complementary coverage of the GenAI security landscape and their broad adoption across enterprise security practices.

  14. A first look at MySQL 26.7 Early Access

    MySQL has dropped its newest release , categorized as “Early Access” and available at https://labs.mysql.com/ .

  15. Where is the technology breakdown? Can AI help?

    On a major financial institution website I was asked to complete a contact form.

  16. Why My Mac Was Not Using Post-Quantum SSH With GitHub (And How I Fixed It)

    In my previous post I made the case that the only post-quantum protection that counts is the algorithm your connection actually negotiates.

  17. Q Day Is Coming: A Plain-English Guide to Post-Quantum Cryptography

    Every time you see the padlock in your browser, push code over SSH, or your application connects to a database, TLS or SSH is quietly doing two jobs.

  18. VillageSQL Extensions with versioning

    VillageSQL has just released it’s latest version 0.0.5 , describing this as stable release for installations with full MySQL 8.4.10 compatibility.

  19. Producing IQR and Outlier statistics with SQL

    The interquartile range (IQR) measures the spread of the middle 50% of a distribution — the distance between the first quartile (Q1) and the third quartile (Q3).

  20. Producing Mode statistics with SQL

    The mode is the value or values that appear most frequently in a dataset.

  21. Extending MySQL Capabilies with UDFs, Plugins and Components - Part 2

    MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install.

  22. Producing Alternative Means statistics with SQL

    MySQL’s built-in AVG() computes the arithmetic mean — the sum divided by the count.

  23. Extending MySQL Capabilities with UDFs, Plugins and Components

    MySQL offers three different approaches to extending the SQL capabilities with the default product you download and install.

  24. Producing One-Sample Z-Test statistics with SQL

    The one-sample Z-test determines whether a sample mean differs significantly from a known population mean when the population standard deviation is also known.

  25. Switching to JSON Error Logging in MySQL

    You no longer need to manually parse the MySQL Error log via scripting and RegEx pattern matching.

  26. Installing MySQL 9.7 LTS Community Edition on CentOS

    Historically installing MySQL on a RedHat Compatible Linux server was as simple as yum install mysql-server.

  27. Using GenAI directly in the database. A practical example using MySQL 8.0

    If you have a typical MySQL production setup using MySQL 8.0 (EOL) with replication, you can take advantage of VillageSQL extensions to generate AI responses directly with your source data with no impact on your production setup or existing application so…

  28. Producing Skewness statistics with SQL

    Skewness measures the asymmetry of a distribution.

  29. Exploring the vsql-ai extension

    The vsql-ai extension adds AI prompt capabilities and text embeddings directly in SQL queries, with support for Anthropic Claude , Google Gemini , OpenAI ChatGPT , or a local LLM such as Ollama .

  30. Producing Chi-Squared statistics with SQL

    The Chi-Squared test is one of the most widely used statistical tests for categorical data.

  31. Speaking at COSCUP 2026 — Planning your upgrade to MySQL 9.7

    I am excited to be speaking at COSCUP 2026 in Taipei, Taiwan on August 8th and 9th.

  32. Producing Two Sample T-Test statistics with SQL

    The two sample t-test for equal variance is a statistical test to determine if the means of two groups are different enough that the difference is likely caused by some underlying difference, rather than random chance.

  33. Building your first VillageSQL Extension with AI skills

    This is a technical walkthrough of the vsql-extension-builder recently released May 28 at Percona Live Bay Area 2026 and found at https://github.com/villagesql/villagesql-skills .

  34. Why using production workloads over simulated workloads is critical

    AI-Assisted SQL Tuning Last week in his keynote speech at Percona Live Bay Area 2026 , Andy Pavlo presented Databases: The Final Boss of Agents and provided some useful insights into query optimization of simulated workloads leveraging AI.

  35. Improving your MySQL Security Posture Presentation

    At the MySQL BR Conference 2025 I had the opportunity to speak about Improving Your MySQL Security Posture.

  36. MySQL and Heatwave Summit Presentation

    Last week I had the opportunity to speak at the MySQL and Heatwave Summit in San Francisco.

  37. Readyset QueryPilot Announcement

    At the MySQL and Heatwave Summit 2025 today, Readyset announced a new data systems architecture pattern named Readyset QueryPilot .

  38. More CPUs or Newer CPUs

    In a CPU-bound database workload, regardless of price, would you scale-up or scale-new?

  39. An Interesting Artifact with AWS RDS Aurora Storage

    As part of using public datasets with my own Benchmarking Suite I wanted upsize a dataset for larger volume testing.

  40. How long does it take the ReadySet cache to warm up?

    During my setup of benchmarking I run a quick test-sysbench script to ensure my configuration is right before running an hour+ duration test.

  41. Monitoring Latency with Throughput

    Higher throughput does not imply improved performance.

  42. Using Readyset Caching with AWS RDS MySQL

    Readyset is a next-generation database caching solution that offers a drop-in; no application code changes; approach to improve database performance.

  43. Sysbench Under the Covers

    Sysbench is a popular open-source benchmarking tool designed to evaluate the performance of system components such as CPU, memory, disk I/O, and databases.

  44. Tracking new AWS Database Infrastructure Availability

    AWS can drop 10+ articles a day just in the What’s New feed.

  45. Evaluating Readyset Caching for MySQL

    Readyset is a database caching solution for MySQL and PostgreSQL .

  46. Creating a More Realistic Benchmark

    Common benchmark approaches fall into two general categories, synthetic testing and realistic testing.

  47. Testing, Benchmarking, Evaluating

    Testing and benchmarking are widely used terms in software technology, each serving a distinct purpose and goal.

  48. Your Attack Vector Extends Beyond Production Systems

    A common data security issue is the unprotected copying of production data to non-production environments without any redaction, masking, or filtering.

  49. Easy Money-Saving Tips for Your AWS Cloud Spend

    There are numerous Cloud Service Provider (CSP) FinOps products that can review, collate, summarize, and recommend ways to optimize your cloud spend.

  50. Why Being Proactive Is Always a Winning Approach

    Many companies manage production infrastructure using a reactive model rather than a proactive one.