[plugin] rex_taffydb (local database)

Joannesalfa

I had surveyed NeDB before. NeDB might not be convince because that it is asynchronous, like accessing to localstorage.

I still will try to wrap it into C2 plugin when I have time (maybe 2 moths later).

Update: add "Action:Define type"

Call "Action:Define type" to define a column to be number type. i.e. all values in that column are number. (sample capx)

Joannesalfa

I had surveyed NeDB before. NeDB might not be convince because that it is asynchronous, like accessing to localstorage.

I still will try to wrap it into C2 plugin when I have time (maybe 2 moths later).

It has ability to make a query part of data instead of storing more than 50 mb of data.

Joannesalfa

Right, because NeDB put data in disk (webstorage/indexDB), but taffydb is an in-memory database.

That why NeDB is asynchronous, taffyfb is synchronous.

Can you put a shuffle?

andykenobi

Shuffle could be implemented by events

1. add a column in each row named "index" with a random value

2. sort rows by this "index" column

Update

• Add "Action:Add to" to add a value to the key
• Add options 'if greater', 'if less' in "Action:set value", to set value by condition.

Sample capx

Here is another database plugin - nedb, asynchronous database. Reference

Joannesalfa

Here it is.

Kyatric

Please move this thread to "Completed Addons" section.

rexrainbow How do I do the following:

• I have a listview of several items
• When selecting each item, change the corresponding TaffyDB param for that item (i.e., "selected" = 1)
• Then I want to grab the selected items only, and group them into a new item by pressing a button (I already have a function for creating this item with text fields and stuff to name and classify the new item)

thanks

—

Assume that the content of each items in your listview come from the result of querying of taffydb.

1. Then you could get value of a key by "Expression:Index2QueriedRowContent( index , key )" , index is the "selected" in your case.

2. To save the modified item, uses "Action:Set row index" to set the row id by index. See the section "Insert a row" in my document for more detail.

Moved to completed addons as per request.

rexrainbow awesome! I thought it would never happen until now, so I can test with my huge rpg database

rexrainbow

If i use Nedb.QueiredRowsAsJSON, then it returns something like "key":"value". But how to get just value by key?

—

sample capx

+ Condition:For each row
[ul]
	[li]Expression:CurRowContent( key )[/code:1hq6cef9][/li]
[/ul]
Or
[code:1hq6cef9]Expression:Index2QueriedRowContent( index, key )[/code:1hq6cef9]