Share My Creation [BANanoRelax] 1. Perform CRUD Offline, 2. Sync to Cloud and 3. Relax

Ola

With the upcoming updates to BANano 7, with cron jobs, background workers, it makes it more awesome to work with. So i guess we can only be limited by our own imagination. Hand clap to Alain for such an amazing software package.

So what is BANanoRelax?

BANanoRelax is a DB lib, made of PouchDB (Client) + CouchDB (Server).

1. You can work offline - it creates an indexedDB for you and you can use like how how you usually use BANanoSQL. As its not compatible with BANanoSQL,you cant use BANanoSQL commands.
2. This stores your data using an "_id" and a "_rev", this can either be your own specified id or use the BANano.GUID with (BANano.GenerateUUID). The "_rev" is generated automatically.
3. Using your own IDs is recommended.
4. Has a simple API for CRUD functionality.

CRUD Example - The BANano.Await() Version

1. Initialize the lib and tell it you want to work offline. By working offline, a local IndexedDB "todos" database is created. This is the recommended approach. And yes you can just work online with db.WORK_ONLINE.

'initialize the db and use own ids
Public db As BANanoRelax
    db.INITIALIZE(Me, "todos", False)
    'specify connecction details for online sync / work online
    db.Host = "127.0.0.1"
    db.Port = "5984"
    db.UserName = "XXX"
    db.Password = "XXX"
    db.WORK_OFFLINE

2. Create a record - think of it as the PUT

When we initialized, we said we want to use own ids, so our id here is "1"

Dim person As Map = CreateMap()
    person.Put("_id", "1")
    person.Put("firstname", "Anele")
    person.Put("lastname", "Mbanga")
    Dim res As Map = BANano.Await(db.PutWait(person))
    Log(res)

Result:

3. Read a record (using own id) - this of it as the GET

Dim rg As Map = BANano.Await(db.GetWait("1"))
    Log(rg)

Result

4. Update a record (using own id) - another PUT
'* here we are using the previous record we read, you can pass it any map object

Result

rg.Put("firstname", "Usibabale")
    Dim ru As Map = BANano.Await(db.UpdateWait("1", rg))
    Log(ru)

'

5. List all records

Dim recs As List = BANano.Await(db.GetAllWait(True))
    Log(recs)

Result

6. Delete a record (using own id) - think of it as the REMOVE

Dim rd As Map = BANano.Await(db.RemoveWait("1"))
Log(rd)

Result

7. Sync with clould DB (this is 2 way to cloud and from cloud)

db.SYNC(True)

8. Relax

So far tests are yielding good results.

CRUD Example - The BANano.CallBack() Version

For each CRUD call you make, you need to trap the result with a callback.

[Coming Soon]

So how do you get started with this?

• Install CouchDB (specify admin and password names - keep these safe, you will need for sync. This is the server part. I will avail the client part sometime next week.
• Check CouchDB is running; http://127.0.0.1:5984/ (observe the JSON result)
• Open Fauxton on: http://127.0.0.1:5984/_utils/
• Enable CORS : http://127.0.0.1:5984/_utils/#_config/couchdb@localhost/cors (this helps with sync and replication)

We are still running tests. The lib will be available next week sometime, if however you want to test it out. Send a ping on this thread and will send as soon as available.

Ta

#SharingTheGoodNess

 

[alwaysbusy]

This one was on my bucket list for quite a while but never found the time to wrap it, so I'm glad you tackled it. This is an interesting page for SQL buffs on how CouchDB compares to classic SQL: https://docs.couchdb.org/en/stable/ddocs/views/nosql.html. I always planned to write an extra SQL Query parser that could automatically convert them to NoSql commands and, when time permits, I still do. Good job! Looking forward to play with it.

Alwaysbusy

 

[Mashiane]

After adding the find plugin, executing statements like SELECT WHERE are possible. Here is the implementation, however you need to Create an index first on the fields to search on and the order of fields in your index is important.

9. Creating Indexes for searches (below we create an index using the first and lastname)

Dim res As Map = BANano.Await(db.CreateIndexWait(Array("firstname", "lastname")))
Log(res)

10. Executing an equivalent of a SELECT WHERE statement

Selecting records where the firstname is equal to. You can specify which fields to select on array(*) [this selects all fields], the other array is the sort order and 0 is limit.
You can specify which fields to select [array(*)], [this selects all fields *], the other array is the sort order and 0 is limit.

db.CLEAR_WHERE
    db.ADD_WHERE("firstname", db.EQ, "Usibabale")
    Dim res As List = db.SelectWhereWait(Array("*"), Array("firstname"), 0)
    Log(res)

Output:

11. Bulk Inserts

'insert bulk records, _id can be BANano.GenerateUUID
Dim lst As List
lst.Initialize
lst.Add(CreateMap("firstname" : "Lisa Says", "_id": "doc1"))
lst.Add(CreateMap("firstname" : "Space Oddity", "_id": "doc2"))
Dim recs As List = BANano.Await(db.InsertBulkWait(lst))

 

[Mashiane]

Release:

[BANanoRelax] 1. Perform CRUD Offline, 2. Sync to Cloud and 3. Relax

Ola The BANanoRelax library allows one to work offline, sync the crud data to cloud storage and basically relax. For more details, see this thread. Download Getting Started Install CouchDB (specify admin and password names - keep these safe, you will need for sync Check CouchDB is running...

www.b4x.com

 

[Mashiane]

Version 0.2 is now available with some additional functions to do stuff in bulk.

Download here