/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

2 votes158 views5 answers
Js create query string from object
TypeScript
0 vote138 views1 answer
Typescript generic record
TypeScript
0 vote166 views1 answer
Concat and nunll check in typescript
TypeScript
0 vote137 views1 answer
"Property 'mocha' does not exist on type 'Cypress & EventEmitter'."
TypeScript
3 votes143 views3 answers
Angular email regular expression
TypeScript
4 votes147 views2 answers
What were four effects of the War of 1812?
TypeScript
1 vote145 views2 answers
Common legend for multiple plots in r
TypeScript
0 vote148 views1 answer
Update multiple documents with different field value by id set. Mongoose
TypeScript
3 votes145 views2 answers
Angular onclick toggle class
TypeScript
0 vote139 views1 answer
React onclick action starts automatically
TypeScript