Can we use Elastic SQL for Production version project in PHP?

Elastic Stack Elasticsearch
1

For Example
GET _sql
{
"query": "select * from index limit 10"
}

Can we use Elastic SQL for Production version project in PHP?
If yes then how to use using PHP?

If SQL is available in ELastic than I dont want to use JSON base query, Is it ok for large data project?
If there any chance to performance issue with this?

2

yes.

I don't know (not a PHP dev here) but you can probably call the _sql Rest endpoint in the same way you'd call whatever endpoint from PHP code...

I'd although use it but it's up to you.

If there any chance to performance issue with this?

No. It's translating your query to the QueryDSL behind the scene and running it the same way you'd call the _search endpoint. I think the translation overhead is probably so minimal that you won't really see it.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.