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

• octosql

  34 4,689 4.3 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

  26 1,646 8.4 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.

• SurveyJS

  surveyjs.io sponsored

  Open-Source JSON Form Builder to Create Dynamic Forms Right in Your App. With SurveyJS form UI libraries, you can build and style forms in a fully-integrated drag & drop form builder, render them in your JS app, and store form submission data in any backend, inc. PHP, ASP.NET Core, and Node.js.

  

• materialize

  117 5,558 10.0 Rust

  The data warehouse for operational workloads. (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

  40 2,349 7.7 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