Questions tagged [ydn-db]

Client-side javascript database library. Works which IndexedDB, WebDatabase (WebSQL) and WebStorage (localStorage).

Javascript database module for Indexeddb, WebDatabase (WebSQL) and WebStorage (localStorage) storage mechanisms supporting version migration, advanced query and transaction.

References:

97 questions
4
votes
0 answers

YDN DB Include issue

I have included YDN DB file (ydn-db-isw-core-crypt-qry-dev.js) to encrypt Index DB in angular app.It's added in index.html body section after socket.io-1.4.5.js,a loader spinner.head section includes plivo.min.js library-
Kishor
  • 201
  • 1
  • 10
3
votes
1 answer

Most efficient way to populate/distribute indexedDB [datastore] with 350000 records

So, I have a main indexedDB objectstore with around 30.000 records on which I have to run full text search queries. Doing this with the ydn fts plugin this generates a second objectstore with around 300.000 records. Now, as generating this 'index'…
David Mulder
  • 26,123
  • 9
  • 51
  • 114
3
votes
1 answer

Javascript - BackboneJS - Backbone.sync override - YDN - Asynchronous error

I'm trying to use YDN with Backbone.sync(), but I've a problem with the « fetchAll » function. For exemple, I've this View var UserListView = Backbone.View.extend({ el: ".page", initialize: function() { this.users = new…
Kai23
  • 1,556
  • 2
  • 16
  • 30
3
votes
2 answers

YDN-DB - How to update a record by id?

I'm using YDN-DB as my indexeddb wrapper; I've read the user guide and api, and have absolutely no idea how you'd update a record by id (primary key [auto incremented]). Is anyone familiar with this/have any…
Richard
  • 1,148
  • 3
  • 18
  • 33
2
votes
1 answer

How to Implement inner join in ydn-db?

I need to implement an inner join on two tables order_header and order_item based on their ORDER_ID. The equivalent SQL query: SELECT * FROM order_header INNER JOIN order_item ON order_header.ORDER_ID=order_item.ORDER_ID How to implement this in…
Ric
  • 211
  • 2
  • 16
2
votes
1 answer

Angular/ Ionic Binding slow

I am working on an Ionic tab app and i am using YDN database. I noticed that most of the lists take a while before they are rendered to the screen. i initially thought it was the YDN database query that was slow but that is not the case. if i add a…
Layinka
  • 405
  • 1
  • 4
  • 13
2
votes
1 answer

YDN-DB getting Store: null not exist

I can verify a record exists after adding it to a store but when I'm in another function and declare a new variable to point to the same database and store and execute a query I get the following error message. Store: null not exists. The method…
user3448990
  • 323
  • 6
  • 15
2
votes
2 answers

ydn-db: how to make any query more complex than getting a single record by id?

Using the packaged ydn-db library from here: http://git.yathit.com/ydn-db/downloads/ydn.db-jquery-0.7.12.js . Same happens with https://storage.cloud.google.com/download.yathit.com/ydn-db/build/zsk-ydn.db-dev-0.7.15.js . var db = new…
Andrew Magee
  • 6,506
  • 4
  • 35
  • 58
1
vote
1 answer

WebSQL unsupported in Office for Mac client enviornment

We are using indexedDB/WebSQL to store data locally in our Excel Task-pane add-in. While this works on all other environments, we are seeing it fail in Office for Mac client. While vorlon.js shows that WebSQL is supported when running inside the…
Sameera
  • 1,025
  • 13
  • 36
1
vote
1 answer

Is multiple search possible in ydn-db?

I want to do following queries, 1) Multi query like SELECT * FROM table_name WHERE username="Tom" OR lastname="Gordon" OR city="New York"; 2) Combination of AND and OR operations. Ex: SELECT * FROM table_name WHERE username="Tom" OR…
smitach
  • 11
  • 4
1
vote
1 answer

YDN-DB fetches only first 100 rows from my IndexedDb store

I'm trying to fetch all records from the IndexedDB using YDN-DB.js like so: var keyRange = new ydn.db.KeyRange.lowerBound(0, true); var cursor = new ydn.db.IndexValueIterator(store, keyName, keyRange); return this.database.values(store,…
bboydflo
  • 907
  • 1
  • 15
  • 24
1
vote
1 answer

How do I check if ydn.db database is ready for use?

I can successfully create an indexeddb database and load data into it. I can also read data from this database from the same page. I then try and read from the database from another page on my site. db = new…
user1757006
  • 705
  • 2
  • 12
  • 23
1
vote
1 answer

How does YDN handle private browsing?

Firefox disables IndexedDB in private browsing. Does YDN fallback to another mechanism in that case? We are getting InvalidStateErrors which tell me that it just fails. If that's the case, is there a way we can get force YDN to use a different…
RAD
  • 13
  • 2
1
vote
1 answer

ydn-DB doesn't work with iOS8 Safari

I recently updated my ipad to iOS8 and the HTML/Javascript app stopped working because safari on iOS8 cannot recognize ydn-db object. Has anybody else also facing this issue? Any workaround?
user976508
  • 167
  • 4
  • 16
1
vote
1 answer

Is it possible to write a query in ydn-db similar to a SQL "IN" or multiple "AND" clauses?

I'm trying to write a query that in SQL would look something like: select * from WorkOrder wo where wo.userId = 1 and wo.isSynced = 0 and wo.status in ('COMPLETE', 'REJECTED', 'SUSPENDED_NO_ACCESS', 'SUSPENDED_OTHER'); I've added an…
gusgorman
  • 170
  • 1
  • 11
1
2 3 4 5 6 7