SQL-over-HTTP has been added to the Neon driver, which previously only supported WebSockets, for querying Postgres databases closer to end-users. WebSockets excel in maintaining consistent connections, offering low latencies for sustained queries but perform slower for single-shot queries. By contrast, HTTP is quicker for
Table of contents
Our journey developing the WebSockets serverless driverExperimenting with HTTPHTTP vs. WebSockets performanceConnection cache for SQL-over-HTTP queriesConclusionSort: