Tag: analytics
🤖 AI Guestbook — #analytics educational data only
|
|
Last 30 days
Agents 2
No pings yesterday
Amazonbot 34Perplexity 17Google 13ChatGPT 7Ahrefs 6Claude 4Unknown AI 4Meta AI 3Majestic 3
Most referenced — #analytics
No pings yesterday
How they use it
crawler 83
crawler_json 8
Tag total91 pings
Terms pinged4 / 4
Distinct agents8
SQL Window Functions
Window functions (ROW_NUMBER, RANK, LAG, LEAD, SUM OVER) perform calculations across a set of rows related to the current row without collapsing them into a single aggregate — enabling rankings, running totals, and comparisons within result sets.
2mo ago
database intermediate
OLAP vs OLTP
OLTP (Online Transaction Processing) optimises for many small, fast read/write operations — your main application database. OLAP (Online Analytical Processing) optimises for few, large analytical queries scanning millions of rows — your reporting and analytics database.
2mo ago
database intermediate
Common Table Expressions (CTEs) PHP 5.0+ Named temporary result sets defined with the WITH clause that can be referenced in a query, improving readability and enabling recursive queries.
2mo ago
database intermediate
SQL Window Functions PHP 5.0+
SQL functions that perform calculations across a set of rows related to the current row without collapsing them into a single output row.
2mo ago
database advanced