Light

vercel-labs / function-database-latency Goto Github PK

View Code? Open in Web Editor NEW

170.0 8.0 28.0 31.96 MB

Visualize the latency of databases from Vercel Functions.

Home Page: https://db-latency.vercel.app/

JavaScript 57.84% TypeScript 42.13% CSS 0.03%

function-database-latency's Introduction

Vercel Functions Database Latency

This demo helps observe the latency characteristics of querying different popular data services from Vercel Functions.

https://db-latency.vercel.app

Providers

Here is an overview of all data service providers and the compute locations available in this app:

Provider	Edge (Global)	Edge (Regional / US East)	Node
Convex (SDK)	✅	✅	✅
Fauna	✅	✅	✅
Grafbase (GraphQL)	✅	✅	✅
Neon w/ @neondatabase/serverless	✅	✅	✅
Neon w/ Drizzle ORM	✅	✅	✅
Neon w/ Prisma ORM	✅	✅	✅
PlanetScale w/ Kysely	✅	✅	❌
PlanetScale w/ Prisma ORM	✅	✅	✅
PlanetScale w/ Drizzle	✅	✅	✅
PolyScale	✅	✅	❌
Shopify (Storefront GraphQL API)	✅	✅	✅
Supabase w/ supabase-js	✅	✅	❌
Supabase w/ Prisma ORM	❌	❌	✅
Supabase w/ Drizzle	❌	❌	✅
TiDB Cloud (serverless-js)	✅	✅	❌
Tigris	✅	✅	❌
Turso	✅	✅	✅
Turso w/ Prisma ORM	✅	✅	✅
Turso w/ Drizzle	✅	✅	✅
Upstash (SDK)	✅	✅	✅
Xata w/ TypeScript SDK	✅	✅	✅
Xata w/ Prisma ORM	❌	❌	✅
Xata w/ Drizzle	❌	❌	✅

Testing Methodology

Smallest atomic unit, e.g. 1 item / row.
Data schema:

interface EmployeeTable {
  emp_no: number;
  first_name: string;
  last_name: string;
}

function-database-latency's People

Contributors

Stargazers

Watchers

function-database-latency's Issues

Supabase result is misleading (data returned is null from db)

When testing from Asia (Thailand) Supabase gave 100ms latency for global edge function and it seems too good to be true (afaik supabase db is in the US). Upon debugging, I discovered the data returned from the DB is null. I inspected it from the browser console log.

I compared it with another Postgres provider, neon tech, and it gave 3.5sec latency and the data was returned.

Add CockroachDB serverless provider

I was interested in comparing Turso's benchmarks with Cockroach Labs serverless offer.
Does it seem interesting to add here? Maybe I can give a try.

Supabase w/ Prisma ORM & Drizzle sometimes fails with 500 errors

The Supabase-based tests using Prisma ORM and Drizzle sometimes seem to fail with a 500 error.

The corresponding API route are api/supabase-prisma-node and api/supabase-drizzle-node.

When it breaks, this is the output in the browser console:

In these cases, the rendered chart areas stay empty.

@leerob would you be able to take a look at the logs for the above routes and see if there are any errors related to the Supabase DB or some other thing?

Add no. of request selector & display average

There could be an input or a slider to select no. of requests to be made for testing
And after all the requests are made, we could show the average of all.

I'd be happy to open a PR.

Y-axis formatting broken with >1000 ms latencies

The end-to-end latency from my home can be much more than 1000 ms for some data services with 5 serial queries. However, the y-axis formatting is broken:

Add Cloudflare D1

D1 is pretty similar to Turso in terms of infrastructure, which I would like to see how they compare to each other.

Stuck on processing with no data displayed for PlanetScale

The PlanetScale test does not seem to work. It says processing, but does not display any data. I tried every type of query.

All the other tests work fine for me.

Recommend Projects

React

A declarative, efficient, and flexible JavaScript library for building user interfaces.
Vue.js

🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
Typescript

TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
TensorFlow

An Open Source Machine Learning Framework for Everyone
Django

The Web framework for perfectionists with deadlines.
Laravel

A PHP framework for web artisans
D3

Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

javascript

JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
web

Some thing interesting about web. New door for the world.
server

A server is a program made to process requests and deliver data to clients.
Machine learning

Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Visualization

Some thing interesting about visualization, use data art
Game

Some thing interesting about game, make everyone happy.

Recommend Org

Facebook

We are working to build community through open source technology. NB: members must have two-factor auth.
Microsoft

Open source projects and samples from Microsoft.
Google

Google ❤️ Open Source for everyone.
Alibaba

Alibaba Open Source for everyone
D3

Data-Driven Documents codes.
Tencent

China tencent open source team.