Results for “functions”

29 skills

mariadb-corporation

mariadb-aggregate-functions

Reference for MariaDB aggregate functions, covering counting, totals, extrema, string and bitwise aggregation, and statistical functions, with guidance on NULL handling and common pitfalls.

mariadb-corporation

mariadb-window-functions

Reference for MariaDB window functions and the OVER clause, covering ranking, value navigation, and ordered-set functions with syntax and common pitfalls.

mariadb-corporation

mariadb-numeric-functions

Reference for MariaDB numeric and math functions, covering rounding, division, powers, logs, trigonometry, randomness, base conversion, checksums, and formatting, with guidance on exact-vs-approximate types and division-by-zero behavior.

mariadb-corporation

mariadb-string-functions

Reference for MariaDB string functions: extraction, length, search, concatenation, modification, case, PCRE2 regex, formatting, and encoding, with common pitfalls and version notes.

mariadb-corporation

mariadb-date-time-functions

Reference for MariaDB's built-in date and time functions, covering current time, arithmetic, differences, extraction, parsing, formatting, Unix time, time-zone conversion, construction, and Oracle-compatible helpers, with guidance on version-specific behavior and common pitfalls.

mariadb-corporation

mariadb-encryption-functions

Reference for MariaDB's built-in encryption, hashing, and compression functions, covering AES_ENCRYPT/DECRYPT, SHA2, KDF, COMPRESS, and related functions, with guidance on correct usage and common pitfalls.

More results

mariadb-corporation

mariadb-json-functions

Catalog of MariaDB JSON functions with signatures and semantics, covering constructors, extraction, modification, merging, validation, introspection, and formatting. Use when writing SQL that builds, queries, or alters JSON data in MariaDB.

150-sql-860725fe

Provides PostgreSQL query patterns covering SELECT, JOINs, subqueries, CTEs, window functions, and advanced SQL techniques.

soql-date-functions

Write SOQL queries that group or filter records by date periods using the 13 SOQL date functions, with rules for WHERE vs GROUP BY placement, date-literal comparisons, and fiscal-year restrictions.

mariadb-corporation

mariadb-vector-functions

Reference for MariaDB's vector functions and VECTOR data type, covering VEC_Distance, VEC_Distance_Euclidean, VEC_Distance_Cosine, VEC_FromText, VEC_ToText, and MHNSW vector index usage for SQL queries over embeddings.

mariadb-corporation

mariadb-information-functions

Reference for MariaDB information functions, covering session and server metadata such as LAST_INSERT_ID, ROW_COUNT, FOUND_ROWS, USER, and VERSION, with usage guidance for writing SQL that reads auto-increment IDs, row counts, and connection details.

postgresql-optimization

Optimize PostgreSQL databases with advanced features, performance tuning, and best practices for JSONB, full-text search, window functions, and indexing.

leandrobenjaminl

Analiza datos en bases de datos relacionales con consultas SQL eficientes y legibles, incluyendo joins, window functions, CTEs y subqueries, para extraer insights directamente de la base de datos.

mariadb-corporation

mariadb-create-function

Explains MariaDB's three CREATE FUNCTION forms — stored functions, stored aggregate functions, and loadable UDFs — covering syntax, privileges, and behavior differences for writing or reviewing MariaDB SQL.

mariadb-corporation

mariadb-control-flow-functions

Reference for MariaDB control-flow functions and operators, including IF(), IFNULL(), NULLIF(), COALESCE(), CASE, NVL2(), and DECODE_ORACLE, with guidance on correct usage and common pitfalls.

soql-fundamentals

Write and debug SOQL queries covering SELECT syntax, filters, sorting, pagination, relationship traversal, and aggregate functions.

209-sql-23f1987a

Provides SQL window function examples for ranking, aggregation, lag/lead, value extraction, frame specifications, and advanced analytics.

Build and manage Convex backends: schema design, TypeScript functions, real-time subscriptions, auth, file storage, scheduling, and deployment.

Build reactive backends with Convex: schema design, TypeScript functions, real-time subscriptions, auth, file storage, scheduling, and deployment.

Design schemas, write TypeScript functions, and manage real-time subscriptions, auth, file storage, scheduling, and deployment for Convex backends.

lucaspmarie-a11y

Design schemas, write TypeScript functions, and manage real-time data, auth, storage, scheduling, and deployment for Convex backends.

Design schemas, write TypeScript functions, set up real-time subscriptions, authentication, file storage, scheduling, and deployment for Convex reactive backend projects.

160-sql-dce3acf3

Optimizes SQL queries by analyzing execution plans, rewriting patterns, and applying performance techniques for PostgreSQL and MySQL.

Run machine learning and generative AI tasks directly in BigQuery SQL using built-in functions for forecasting, anomaly detection, key driver analysis, and text generation.

14.4k · bundle

mariadb-corporation

Provides best practices for using MariaDB's built-in vector support for AI workloads, including SQL syntax for vector columns, indexes, distance functions, and RAG patterns.

Write correct, efficient Kusto Query Language queries with coverage of syntax, joins, dynamic types, datetime pitfalls, regex, serialization, memory management, and advanced functions.

postgresql-code-review

Review PostgreSQL code for best practices, anti-patterns, and quality standards including JSONB, arrays, custom types, schema design, functions, and security features like Row Level Security.

062-sql-5eac1a75

Explains syntax differences for common SQL operations across PostgreSQL, MySQL, SQL Server, and Oracle, including auto-increment keys, string concatenation, date functions, pagination, booleans, JSON, case sensitivity, and recursive CTEs.

mariadb-corporation

mariadb-rest-service-show

Browse and inspect MariaDB REST Service objects using read-only SHOW REST and SHOW CREATE REST statements to list services, schemas, views, procedures, functions, content sets, auth apps, roles, grants, and dump DDL for reverse-engineering or auditing.