What should be used in Chrome packaged apps to enable a "SQL like" database for persistant data and offline apps? (without database engine)
-
I would like to find a way to easily build a packaged app that deals with persistant user data without force the user to install a Database engine. Also app has to work in offline mode ... Perimeter : Chrome apps. Thanks ! :-)
-
Answer:
If I'm not mistaken, Chrome stores some of its persistant data in SQL Lite. I'm not sure if you can access it directly, but I assume this is a "best practice" approach if it's built into Chrome. Here is a good blog entry with some of SQL Lite issues related to Chrome's internal implementation: http://maxradi.us/documents/sqlite/
Joseph Hsieh at Quora Visit the source
Other answers
Others are correct and state that Web SQL DB is available to Chrome and thus Chrome packaged apps. A very good presentation for offline and storage options is: http://html5-demos.appspot.com/static/html5storage/index.html#slide1
Seth Ladd
I'm a Chrome dev that developed a packaged app. Chrome supports the Web SQL API that allows you to use basic SQL syntax to store your data in browser. I coupled it with a timer to ensure data was saved without user intervention. Works really well.
Matthew Phillips
You can use IndexedDB or Web SQL. Read this: https://developer.chrome.com/apps/offline_apps This is for your example: https://github.com/abdullahc/Indexeddb-Chrome-App
Kartikey Tanna
From my brother, a good article on how use localStorage with HTML 5 in Chrome : http://www.rajdeepd.com/articles/chrome/localstrg/LocalStorageSample.htm
Vincent Levasseur
Guys i am afraid i am still not very clear in this aspect that if i want to make a app like this that: 1. when offline it saves the data in the Local system and when connected to the internet it syncs all the data to the remote database Please tell me which database i can use to do the above procedure for chrome packaged Apps?
Abhishek Jain
Related Q & A:
- What is the best practice for free space for a SQL server database drive?Best solution by Database Administrators
- How to restrict access to a sql server database from Azure?Best solution by Stack Overflow
- How to change column data's as a separate column wise format in a SQL Server?Best solution by stackoverflow.com
- How do I connect to a SQL Server database?Best solution by Stack Overflow
- Where do I find the VIN Plate or Body Plate on a 1948 Mercury 2-Door Coupe without an engine or transmission?Best solution by answers.yahoo.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.