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

1. ibis

   1 5 1,989 0.0 PHP

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

   

2. InfluxDB

   influxdata.com featured

   InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

   

3. activerecord-summarize

   2 5 128 0.0 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

4. SQL-Server-First-Responder-Kit

   3 14 3,508 7.9 TSQL

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

   

5. SQL-Server-First-Responder-

   4 1 - -

Suggest a related project