Html5 store local storage database file

Question

I'm currently working on a client-side project with Html5 and javascript. I need create a large database (almost 2GB), and also I need to make this database portable. In other words, I actually need to store the database into a binary file, migrate it, and retrieve its information.

As the result of my recent research I found two good solutions (especially for Android and IOS)

But none of them really helped me. I should mention that my application is going to work on Desktop, Android, IOS, and any other platform that is going to support most of HTML5 features.

I should also mention that my DB is preloaded.

I could not find a way to store my database into a binary file. — Ata Iravani, Aug 01 '12 at 07:33
Yes, Do you have any other suggestions? But I actually need to retrieve the information by javascript. — Ata Iravani, Aug 01 '12 at 07:38
Ive found it easier to write a small convertor that transfers my database into json and then store the json strings in local storage. — Dominic Green, Aug 01 '12 at 07:39
Doesn't json have any limitations, especially in case of **Size** ? — Ata Iravani, Aug 01 '12 at 07:41
No, JSON is just made in to a string for easy storage/sending — Lemex, Aug 01 '12 at 08:02
I think [this question](http://stackoverflow.com/questions/11340852/how-to-create-client-side-full-text-search-engine-with-pure-javascript-and-html5) is somehow close to what I really need — Ata Iravani, Aug 01 '12 at 08:30

score 3 · Answer 1 · edited May 23 '17 at 12:03

3

I would highly recommend JSON, This article will explain some more: Databases using JSON as storage/transport format

I have personally used this one before which works well and loads its DB from a JSON: http://www.persvr.org/

JSON can be index if you create them corerctly, there basicly fully flexible and good for stroing, as far as i know they dont have any limitations as there just big strings when stringify and objects when parsed, Is there a limit on how much JSON can hold?

Also something similar has been asked before: Using JSon like a Relational SQL Database (Javascript)

edited May 23 '17 at 12:03

Community

1
1

answered Aug 01 '12 at 08:01

Lemex

3,772
14
53
87

As I mentioned, my DB will have 2GB size. So I think json is not going to help me (at least in case of size). And one more problem with json is that it is not an indexed Database, therefor, when my app is going to search through database and the performance will be reduced to a very bad level because json is not indexed. – Ata Iravani Aug 01 '12 at 08:10
what do you mean by "JSON can be index if you create them corerctly"? How can a json DB become indexed? – Ata Iravani Aug 01 '12 at 08:20
Updateed answer with link to similar question – Lemex Aug 01 '12 at 08:22
Atleast with a JSON you could save to a file and read/write when opening/closing your page. – Lemex Aug 01 '12 at 08:24

score 0 · Answer 2 · answered Aug 01 '12 at 07:42

0

I have personally found that it is better to write my database tables to json format, and then store the json into local storage as a string. This means your javascript will be able to easily access and modify the data client side, and what ever your using on the backend should be pretty happy working with it to put it back into what ever database your using if needed.

answered Aug 01 '12 at 07:42

Dominic Green

10,142
4
30
34

Is json an indexed database? Doesn't json have any limitations, especially in case of Size ? – Ata Iravani Aug 01 '12 at 07:51

Html5 store local storage database file

2 Answers2