neoSql Plugin Coming Soon - Page 2 - Forum

Forum Navigation
You need to log in to create posts and topics.

neoSql Plugin Coming Soon

PreviousPage 2 of 2

@luishp

Hi Luis,
wouldn't it be useful also a similar command that executes sql query not only on a file on a server but also on a text formatted as csv  (or json) and contained in a variable? This would allow you to load a csv into a variable and then run queries on the variable's content very quickly, for example to filter the data to your liking.

It's an idea. =)

Rocco

@roccocogliano yes I totally agree. I will investigate if there is a possibility to implement it.

Thank you!

roccocogliano has reacted to this post.
roccocogliano

Thanks to you @luishp

@roccocogliano please test the attached updated neoSql plugin with the new neoSqlJson command.
In my tests it works fine :)

Uploaded files:
  • You need to login to have access to uploads.
Vadim and roccocogliano have reacted to this post.
Vadimroccocogliano

@roccocogliano you will probably like reading this to understand how to search into a JSON object:
http://flexdiary.blogspot.com/2017/03/alasql-to-search-your-json.html
https://embed.plnkr.co/GgB4qF/

It's quite interesting.

roccocogliano has reacted to this post.
roccocogliano
Quote from luishp on December 21, 2021, 2:17 pm

@roccocogliano please test the attached updated neoSql plugin with the new neoSqlJson command.
In my tests it works fine :)

It works very very well for me too !!

You are great @luishp
Thank you so much

Rocco

PS: This http://flexdiary.blogspot.com/2017/03/alasql-to-search-your-json.html is very interesting

 

Quote from luishp on December 21, 2021, 2:17 pm

@roccocogliano please test the attached updated neoSql plugin with the new neoSqlJson command.
In my tests it works fine :)

This is a great and quickly way to filter the data contained in a 'neotable' table.

This is a great and quickly way to filter the data contained in a 'neotable' table.

@roccocogliano and also data coming from neoPhp, neoCms and neoGSheets :)
I will include this update in the next minor version.

Regards.

Vadim and roccocogliano have reacted to this post.
Vadimroccocogliano
PreviousPage 2 of 2