Breaking the SQL Barrier: Google BigQuery User-Defined Functions —
Google BigQuery is a petabyte-scale data analytics service that uses SQL as its query interface. As part of its latest release, however, it supports user-defined functions (UDFs) written in JavaScript for when SQL doesn’t cut it.
Get Paid to Write about Databases — Write about databases, earn $200 cash and $200 in Compose credit. Write a deep dive into how you use databases in your technology stack. Let people know useful tips and tricks for a particular database. Explain the philosophy and practical implications of database concepts. All ideas welcome.
Compose.io sponsored
Why Gartner Dropped Big Data Off the Hype Curve —
Big data has been a fixture on the Hype Cycle for Emerging Technologies for several years, but now Gartner says it’s off the hype cycle entirely.
Generating MoM, YoY and CMGR from SQL —
Window functions are extremely powerful and you can do many things with them. One very common capability is computing month over month growth without having to break out a scripting language or Excel.
sql_firewall: SQL Firewall Extension for PostgreSQL —
Should a SQL injection vulnerability occur in your application it could be a huge disaster, here’s a newer approach for helping prevent such by analyzing every query and alerting on unknown queries against your system.
