Specifying SQL in DB Service

[skarun]

(I dont know AngularJS, just going through the examples and learning)
Can I create a service (ApperyIO Create New Database service) and specify SQL statements like
Select * from TAB1 order by sqrt ( abs(lat-input_lat)2 + abs(long-input_long)2 ) LIMIT 5

I still want to use the default DB (MongoDB) on the Appery platform. Do I have to use API Express (honestly I havent explore it).

What better way to do this on MongoDB - ie. without using SQL.

Any good examples, references and a little extra detailed explanation will be much appreciated.

Thanks!

[Serhii Kulibaba]

Hello,

You shouldn't use SQL queries in the MongoDB, because MongoDB is noSQL DB. The simpiest way to use default Appery.io DB is use default DB services. Please look at that example, how to work with them: https://devcenter.appery.io/tutorials...