- This topic has 8 replies, 4 voices, and was last updated 12 years, 1 month ago by
.
-
Posts
-
Does anybody know how to bind a list element to query results from an SQLite database? I simply want my list element to display what was captured and stored in my database.
I’ve studied information at jquery.org and I still can’t figure out how to bind a select list to my SQLite database select query. Has anyone tried this yet?
Hi ssquire,
Do you mean WebSQL(database local storage in iPhone)?
If yes, try this topic: http://www.genuitec.com/support-genuitec/viewtopic.php?f=14&t=1858&hilit=dynamically
specially a part of landng page. Basically, you will prepare landing page with text widgets and so on, and every list item will have onClick action to get there. Once it’s clicked, you will get WebSql select object and overwrite text widgets in landing page.Thanks for the tip when I port the code to iPhone Max87, but right now I’m using the Nexus for Android template. Any ideas there, or are they similar conceptually?
Hi ssquire,
You can use the Local Storage on android too. To learn more about Local Storage see: http://www.genuitec.com/support-genuitec/viewtopic.php?f=14&t=2251
local storage on WebSQL is only for very simple data and is not suited for anything more serious. For that you need to use SQLite or other flavors like HSQL etc.
It looks so far like any of those are not supported at this moment with MB1Hi aklisiewicz,
In my opinion, WebSql is good solution for data storing and reading(in one of my apps I use webSql for store 30 000 entries). Would be great, if M1 supports SQLite, but I don’t think that is possible. Octavio or Wayne can answer this question maybe…edit: I found SQLite plugin for Phonegap here: https://github.com/davibe/Phonegap-SQLitePlugin
Octavio, can you add this plugin to MobiOne together with other plugins mentioned in nother topic?Almost every serious App requires relational database with RI defined. SQLite is the most popular mobile database, so there is no doubt that support for this database is a must.
I have seen some mobile Apps created with Basic4Android, with native access to SQLite through appropriate library. Operating on a database/records was very easy by using simple functions/methods like Add(), Change(), Delete() etc. The record manipulation was transparent to the developer as everything was wrapped up in a LIB. This was an excellent idea. The only thing I’m missing in this tool is lack of support for iPHONE. I’m nove very well familiar with PhoneGap (altough I know basically how it works). If there is anything that allows implement record manipulation within SQLite it should be added ASAP. For all business type Apps it is simply required. On the other hand WebSQL is an abandoned project and it is not supported anymore, so why bother,…Arthur
@support-octavio wrote:
Hi ssquire,
You can use the Local Storage on android too. To learn more about Local Storage see: http://www.genuitec.com/support-genuitec/viewtopic.php?f=14&t=2251
Just by looking at this post http://www.genuitec.com/support-genuitec/viewtopic.php?f=8&t=1037&hilit=SQLite and number of views it is very easy to say that there is a tremendous interest in implementing local SQL storage (no WebSQL). Almost 5000 views!
Implementing data binding and creating some SQLite example App should be FIRST PRIORITY for Genuitec.
I’m watching closely this forum and the reason I haven’t bough the product is the fact that it is missing this feature. I watch the threads for about 2 months and see no progress on this topic. As a matter of fact most of my posts regarding local storage in SQLite remain unanswered.The developers should really take this into consideration.
