How to query javascript object [closed]

Question

Closed. This question is seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. It does not meet Stack Overflow guidelines. It is not currently accepting answers.

We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations.

Closed 5 years ago.

Improve this question

I have a big JSON received from another server that I want to do some query operations on it. for example :

{
  "name":"John",
  "age":30,
  "cars": {
    "car1":"Ford",
    "car2":"BMW",
    "car3":"Fiat"
  },
  "friends": ["abby","benji","ciri"]
 }

I can do the queries manually and maybe use lodash, but is there a library to perform queries like: FIND.. WHERE.. , SELECT, TOP 5...

Should I consider using no sql in memory DB for this?

even if i'm working on just single json document at a time? i don't really need to save that json , just query it and return filtered result — Tomer
– Tomer, Commented Dec 23, 2019 at 10:14
If you are asking for a library, then this is off-topic. If you have a problem with implementing a solution, please concentrate on one aspect, and describe what you have done so far and where you have a problem. Otherwise this question is too broad. Note that there are several Q&A on this site, on specific aspects, like find, filter, intersect, union, ....etc — trincot
– trincot, Commented Dec 23, 2019 at 10:14
You can see this : stackoverflow.com/questions/8913011/query-javascript-object — Nazmul81
– Nazmul81, Commented Dec 23, 2019 at 10:20

Mihai Alexandru-Ionut · Accepted Answer · 2019-12-23 10:19:55Z

1

You can try alasql.js where you can do queries over JSON objects.

var data = [{
  "name":"John",
  "age":30,
  "cars": {
    "car1":"Ford",
    "car2":"BMW",
    "car3":"Fiat"
  },
  "friends": ["abby","benji","ciri"]
 },
 {
  "name":"Smith",
  "age":17,
  "cars": {
    "car1":"Ford",
  },
  "friends": ["a","b","c"]
 }]

// Do the query
console.log(alasql("SELECT * FROM ? WHERE age >= 18",[data]));

<script src="https://cdnjs.cloudflare.com/ajax/libs/alasql/0.5.1/alasql.min.js"></script>

answered Dec 23, 2019 at 10:19

Mihai Alexandru-Ionut

48.6k14 gold badges106 silver badges132 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Andreas Over a year ago

Asking for off-site resources (like libraries) is off-topic for SO. Why do you add an answer anyway?

Mosè Raguzzini Over a year ago

600+kb library for this kind of simple task can be an overkill, IMHO. Nice discover for me, anyway :)

Mosè Raguzzini · Accepted Answer · 2019-12-23 10:18:22Z

0

For "querying" collections and array lodash and ramda are appropriated.

For making "real queries", although, you need a db (documental (Eg Mongo), relational (Eg PostGre) or graph (Eg Neo4J), in base of your needs).

answered Dec 23, 2019 at 10:18

Mosè Raguzzini

15.9k1 gold badge34 silver badges46 bronze badges

2 Comments

Andreas Over a year ago

Asking for off-site resources (like libraries) is off-topic for SO. Why do you add an answer anyway?

Mosè Raguzzini Over a year ago

This is about problem approach, not particular libraries. Doing SQL-like queries is not common, is still a better option to rely on array/collection libraries or just vanilla javascript.

Collectives™ on Stack Overflow

How to query javascript object [closed]

2 Answers 2

2 Comments

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Linked

Related