taffydb | TaffyDB - an open source JavaScript Database | SQL Database library

According to the docs (http://taffydb.com/writing_queries.html)

leftnocase Used to see if the start of a column is the same as a supplied value. Ignores case of column and value.

isnocase Used to see if a column value is equal to a supplied value. Ignores case of column and value.

I am not aware of a way to do this.

While not technically the answer to your question, one possible alternative would be to return anything that is not "STS" AND not "EIAI".

TaffyDB's query system is a bit awkward until you get used to it.

The simple trick to it is this: The elements within an array are considered part of an OR condition. Matching is attempted on objects. If the object in the parameter fits the record you are looking for, it will be returned.

but unfortunately - after refreshing the browser tab - it loses the data

Well, yeah, that's how TaffyDB works.

however the previous statement should output 1

No, it shouldn't.

TaffyDB is in-memory only. As soon as the context for your script is torn down, such as on a page reload, it's gone. If you want to persist it, you have to do that yourself.

The easiest thing to do is serialize the entire dataset as JSON and shove it in localstorage, provided it's small enough to fit there.

You didn't declare your variable i = I've edited it for you below:

var entities = TAFFY([{id:"0",name:"name1",pos_x:"200",pos_y:"200"},{id:"1",name:"name2",pos_x:"200",pos_y:"400"}]); and would like to loop through picking up the x_pos of each database row in a variable.

This is what I got so far:

var entities_ID_array = Array(); entities_ID_array = entities().select("id");

for(var i=0; i

You can't write to the file system using HTTP, that's for the web only.

Electron is built on Node.js. So take a look at the Node.js File System module. For example:

Change