Yep, there are some solid code samples for using Hyperdrive with Cloudflare Workers!
Cloudflare’s official docs have examples for connecting to Postgres using libraries like Postgres.js or node-postgres-basically, you just swap in the Hyperdrive connection string and run your queries as usual.
Here’s a quick sample using Postgres.js:
import postgres from 'postgres';
export default {
async fetch(request, env, ctx) {
const sql = postgres(env.HYPERDRIVE.connectionString);
const rows = await sqlSELECT * FROM books_to_read;
return new Response(JSON.stringify(rows));
},
};
You can find more detailed examples and step-by-step guides in the Cloudflare Hyperdrive docs.
J'ai vu le "cookie" de session d'une appli client-serveur chargé en mémoire avec un malloc, l'adresse mémoire stockée en bdd dans un varchar et pour avoir accès aux données de session sqlselect, atoi() et zou... ça plantait au delà de 2147483648 😀
(Vous en voulez d'autres ? )
ah, drat
relevant instance is actually
instance SqlSelect (SqlExpr (Value a)) (Value )
and, indeed, all 'single' instances have this form
it's tuples that fuck it up
because `pure (a, b)` is `(SqlExpr _, SqlExpr _)` not `SqlExpr (_, _)`