/TypeScript/How to calculate distance between 2 points in knex postgis

How to calculate distance between 2 points in knex postgis

const db = app.get('knex');


	// const distance = await db.raw(
	// 	`SELECT ST_Distance(
	//   ST_Transform('SRID=4326;POINT(${originCoords})'::geometry, 3857),
	//   ST_Transform('SRID=4326;LINESTRING(${destinationCoords})'::geometry, 3857)
	//  );
	// `,
	// );

Similar codes

0 vote278 views1 answer
Write a C proogram to find the roots of quadratic equation
TypeScript
0 vote239 views1 answer
Graphql mutation is not displaying array of objects in express-graphql
TypeScript
1 vote234 views1 answer
Typescript use object keys as index
TypeScript
12 votes299 views4 answers
Delete contents of directory python
TypeScript
0 vote244 views1 answer
Google map Argument of type 'HTMLElement | null' is not assignable to parameter of type 'Element'
TypeScript
8 votes272 views6 answers
Google fonts flutter
TypeScript
0 vote255 views1 answer
Reported error code “128” when it ended: Permission denied (publickey). fatal: Could not read from remote repository. Please make sure you have the correct access rights and the repository exists.
TypeScript
0 vote261 views1 answer
Typescript add days to date
TypeScript
0 vote255 views1 answer
How to add 3d objects folder to this pc windows 11
TypeScript
1 vote240 views2 answers
Docker An attempt was made to access a socket in a way forbidden by its access permissions.
TypeScript