/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 vote126 views1 answer
Convert javascript to typescript
TypeScript
5 votes103 views1 answer
Git remove commits from branch after push
TypeScript
17 votes122 views3 answers
Typescript Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
TypeScript
11 votes118 views1 answer
Eliminate dots li
TypeScript
0 vote119 views1 answer
Average of two lists python
TypeScript
3 votes122 views1 answer
Ts reverse array
TypeScript
6 votes112 views3 answers
Mongodb count based on array of ids
TypeScript
2 votes140 views2 answers
Constraints in sql
TypeScript
0 vote118 views1 answer
Query orders by products woocommerce
TypeScript
0 vote127 views1 answer
Error: postfix operator toArray needs to be enabled
TypeScript