Why Can't Database Tables Index Themselves?

This page summarizes the projects mentioned and recommended in the original post on news.ycombinator.com

Our great sponsors
  • SonarLint - Clean code begins in your IDE with SonarLint
  • Scout APM - Less time debugging, more time building
  • SaaSHub - Software Alternatives and Reviews
  • hypopg

    Hypothetical Indexes for PostgreSQL

    There's a lot of good ecosystem stuff around this:

    https://github.com/HypoPG/hypopg

    HypoPG is a PostgreSQL extension adding support for hypothetical indexes.

    An hypothetical -- or virtual -- index is an index that doesn't really exists, and thus doesn't cost CPU, disk or any resource to create. They're useful to know if specific indexes can increase performance for problematic queries, since you can know if PostgreSQL will use these indexes or not without having to spend resources to create them.

    With one approach to using it here: https://www.percona.com/blog/2019/07/22/automatic-index-reco...

  • noria

    Fast web applications through dynamic, partially-stateful dataflow

    Here's a database that does much better than this, it creates and fine-grainedly updates materialized views of the queries you're using: https://github.com/mit-pdos/noria

    Here's an excellent interview with the creator: https://corecursive.com/030-rethinking-databases-with-jon-gj...

  • SonarLint

    Clean code begins in your IDE with SonarLint. Up your coding game and discover issues early. SonarLint is a free plugin that helps you find & fix bugs and security issues from the moment you start writing code. Install from your favorite IDE marketplace today.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts