Show HN: I wrote a free eBook about many lesser-known/secret database tricks

• ibis

  4 1,899 0.0 PHP

  A PHP tool that helps you write eBooks in markdown and convert to PDF. (by themsaid)

• activerecord-summarize

  5 120 4.9 Ruby

  Transparently combine many reporting queries (on the same tables) into one fast query—even when queries have different groups or scopes.

This is cool! Re: multiple aggregates in one query, I wrote a Ruby gem that adds an even-more-powerful and multi-database-compatible version to ActiveRecord. (I have tested Postgres, MySQL, and SQLite are tested; others probably work, too.)

https://github.com/midnightmonster/activerecord-summarize

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• SQL-Server-First-Responder-Kit

  14 3,212 9.0 TSQL

  sp_Blitz, sp_BlitzCache, sp_BlitzFirst, sp_BlitzIndex, and other SQL Server scripts for health checks and performance tuning.

  

• SQL-Server-First-Responder-

  1 - -

Suggest a related project