Tricking PostgreSQL into using an insane – but 200x faster – query plan

• octosql

  10 3,076 9.2 Go

  OctoSQL is a query tool that allows you to join, analyse and transform data from multiple databases and file formats using SQL.

  I don't really want a wholly different language - I'm happy with SQL most of the time. (I've even written a tool for ubiquitus data access with sql - OctoSQL - so there's that.)

• testcontainers-node

  6 751 8.7 TypeScript

  TestContainers is a NodeJS library that supports tests, providing lightweight, throwaway instances of common databases, Selenium web browsers, or anything else that can run in a Docker container.

  

  The Test Containers project is pretty great for this, and I've personally had success with the stock postgres image and the testcontainers-node library.

• Appwrite

  appwrite.io

  sponsored

  Appwrite - The Open Source Firebase alternative introduces iOS support . Appwrite is an open source backend server that helps you build native iOS applications much faster with realtime APIs for authentication, databases, files storage, cloud functions and much more!

  

• materialize

  58 4,038 10.0 Rust

  The Fastest Way to Build the Fastest Data Products. Build data-intensive applications and services in SQL — without pipelines or caches — using materialized views that are always up-to-date. (by MaterializeInc)

  

  Alternatively, you can install Materialize, configure change data capture to stream the relevant data to it and then write this query as a live view that gets instantly and incrementally updated instead of performing it periodically.

• pev2

  16 1,479 7.3 TypeScript

  Postgres Explain Visualizer 2

  

  Interesting blog, thanks! I never knew https://explain.dalibo.com/ before but it looks really usefull

Suggest a related project