The slides from my 2008 MySQL Conference Presentation can be downloaded from here .
The top 20 design tips for MySQL Enterprise data architects
Tagged with:
Databases
General
MySQL
MySQL User Conferences
MySQL Users Conference 2008
Producing Skewness statistics with SQL
Skewness measures the asymmetry of a distribution. A perfectly symmetric distribution has a skewness of zero. A positive skew (right-skewed) means the tail extends to the right — a small number of high values pull the mean above the median.
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 .
Producing Chi-Squared statistics with SQL
The Chi-Squared test is one of the most widely used statistical tests for categorical data. It comes in two flavors: the goodness-of-fit test asks whether an observed frequency distribution matches an expected one, while the test of independence asks whether two categorical variables are associated with each other.