Efficiently Query BigQuery and Snowflake from Postgres

What it does

You have PostgreSQL stored procs for business logic and you want to extend them to data stored in your data warehouse. You want don't want to de-duplicate data and inflate storage costs. You want to pre-aggregate data in your data warehouse and create materialized views on your PostgreSQL database. You want to add a new feature to your application written for PostgreSQL and this feature relies on data stored in your data warehouse (say BigQuery). You want to keep your app code simple by just querying PostgreSQL and not introducing a new data store. Currently, there is no easy way to query BigQuery and Snowflake tables from your PostgreSQL database. You can write a foreign data wrapper in…from blog.peerdb.io

• 
  Hydra2022 · ▲116

  Query Postgres, route to any database

• 
  GraphQL for Postgres2015 · github.com · ▲195

  GraphQL for Postgres. Contribute to solidsnack/GraphpostgresQL development by creating an account on GitHub.

• 
  Query Google Sheet data using PostgreSQL clients2022 · roapi.github.io · ▲122
• 
  PRQL in PostgreSQL2024 · github.com · ▲267

  This extension let's you write PRQL functions in PostgreSQL. When I first saw PRQL on Hacker News a few months ago, I was immediately captivated by the idea, yet equally disappointed that there was no integration for PostgreSQL. Having previous experience with writing PostgreSQL extensions in C, I thought this was a great opportunity to try out the pgrx framework and decided to integrate PRQL with PostgreSQL myself. The maintainers of both PRQL and pgrx were very nice to work with. Thanks guys.

• 
  AskYourDatabase Desktop2023 · askyourdatabase.com · ▲138

  No SQL query, just chat with your SQL/NoSQL databases

• 
  SQLify2024 · sqlify.me · ▲121

  Query all your apps using sql

• 
  Resend▲1,325

  An entire collection of pre-built components with a much faster development experience.

  Dev tools · 2023 · resend.com

• 
  STORI AI▲1,316

  Your ideas become visually compelling branded social posts

  AI · 2023 · storiai.com

• 
  Kombai▲1,079

  A new AI model that you can prompt with UI designs

  AI · 2023 · kombai.com

• 
  User Persona Generator▲1,014

  Understand your audience without 50 interviews

  AI · 2023 · founderpal.ai

• 
  Lottielab▲869

  Create and ship lottie animations to sites and apps faster

  Dev tools · 2023 · lottielab.com

• 
  LLMs can generate valid JSON 100% of the time▲854

  Outlines is a Python library that focuses on text generation with large language models. Brandon and I are not LLM experts and started the project a few months ago because we wanted to understand better how the generation process works. Our original background is probabilistic, relational and symbolic programming. Recently we came up with a fast way to generate text that matches a regex (https://blog.normalcomputing.ai/posts/2023-07-27-regex-guide...). The basic idea is simple: regular expressions have an equivalent Deterministic-Finite Automaton (DFA) representation. We…

  AI · 2023 · github.com