UltimateLAMP Passwords

For those passwords I have not clearly mentioned within the included wiki documents, here is a summary.

  • UltimateLAMP is built on the VMWare Browser Appliance application, so all Linux passwords match the supplied default.
    • vmware/vwmare
    • root/vmware To use, you do $ sudo su –
  • For all UltimateLAMP passwords, I have used dolphin. Within MySQL, the username will match the database name of the application.
  • For all UltimateLAMP Applications, I have used a username that matches the product name (where possible), and have used the password dolphin. Some applications for example, have a default user (for example WordPress uses admin).
Tagged with: General UltimateLAMP

Producing Skewness statistics with SQL

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

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

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.