Streaming query results for faster data and more transparency 🧐
PopSQL now streams results into the app immediately upon receiving them from your database. This means that queries returning a lot of rows will start showing results much faster. For an average query that took 10 seconds to show results in the past, you’ll now start seeing results in 7 seconds (a 30% improvement). For queries that return more rows, you’ll see data even faster.
Streaming results also creates transparency in the whole query running process. You can now see every step in the process: compiling query variables, querying the database, and fetching results to display in PopSQL. You can also cancel results as they stream in, so you don’t get stuck waiting for millions of rows accidentally. If you cancel, you’ll still be able to see the results that were fetched before canceling.
Streaming results are currently only available on cloud connections to Redshift, Snowflake, BigQuery, and Postgres.