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.
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.