Fast database to be queried offline ( 220k entries ) with node without need to "install" ?

[henrique matias]

Hello Guys,

I'm trying to find a database that i could "pack" together with a node application in order to query a 220k entries table.

To be more specific, i'm now building a node-webkit app and would like to have a solution that would not need it's own "installing" instructions, as in: a "binary" that i could start from node, connect on it and then execute the queries.

At the moment i'm using "javascript client side" solutions, like tingodb / nedb but its getting "kinda slow" ( i know it hardly will be blazing fast with 220k entries, but still would be nice to try other solution category )

Any advice is more than appreciated.

Thanks

--

time isn't passing, it's you passing.

❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ 

❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ ❂ ❁ 

[Aria Stewart]

On Oct 13, 2014, at 10:45 PM, henrique matias <hems....@gmail.com> wrote:

> Hello Guys,
>
> I'm trying to find a database that i could "pack" together with a node application in order to query a 220k entries table.
>
> To be more specific, i'm now building a node-webkit app and would like to have a solution that would not need it's own "installing" instructions, as in: a "binary" that i could start from node, connect on it and then execute the queries.
>
> At the moment i'm using "javascript client side" solutions, like tingodb / nedb but its getting "kinda slow" ( i know it hardly will be blazing fast with 220k entries, but still would be nice to try other solution category )
>
> Any advice is more than appreciated.

You may want to consider leveldb. What the right answer is depends a lot on what kind of query you're doing over the data, but leveldb is remarkably capable for a low-level API, and there's a great ecosystem around it. Should fit your deployment constraints without trouble.

Aria