#26 2016-03-30 11:52:53

David
Admin
From: Alcobendas, Madrid, Spain
Registered: 2015-04-21
Posts: 1,660
Website

Re: sqlite javascript

Hello,

Please, take a look at the External app sample: you can see here how to change app's variables from "pure" Javascript. I don't know if any other problems can be, but, for example, in your code:

window.App.RootScope.Input1.value = window.MyCuteFunction();

... "value" must be "Value" (case sensitive).

Offline

#27 2016-03-30 12:02:34

romarom
Member
Registered: 2016-03-20
Posts: 24

Re: sqlite javascript

inserting (window.App.RootScope.Input.Value window.MyCute = Function (); and javascript files (window.MyCuteFunction = function () {text ('Hi from my cute function!');) does not return any value in box input1

Offline

#28 2016-03-30 12:12:26

David
Admin
From: Alcobendas, Madrid, Spain
Registered: 2015-04-21
Posts: 1,660
Website

Re: sqlite javascript

Hello,

Please, take care about your forum's posts: use the "code" tag when possible, so your messages can be readed in a better way. I am not sure if your Javascript code contains some problem or something like that, because it's difficult to read.

About your question, the next App Builder releases includes a new "External2" app sample, which show us how to use Javascript functions declared in Javascript files. You can download such "External2" from here

As you can see, we get the result of certain Javascript function in an app's variable.

Offline

#29 2016-04-05 23:13:58

tin
Member
Registered: 2016-03-20
Posts: 161

Re: sqlite javascript

Maybe this is a good news to bypass browser-based storage
http://blog.ionic.io/screencast-ionic-and-sqlite/
https://pouchdb.com/

Offline

#30 2016-04-05 23:41:56

David
Admin
From: Alcobendas, Madrid, Spain
Registered: 2015-04-21
Posts: 1,660
Website

Re: sqlite javascript

Hello,

Thanks for sharing tin. However, I want to insist. If we want to save app's options, then the local storage can be sufficient. If we wanted more, then we can use text files. If we need a database... probably the best option today is to use a remote database, and then, any database can be used, since our apps are completely abstracted about that.

Offline

#31 2016-04-05 23:53:07

tin
Member
Registered: 2016-03-20
Posts: 161

Re: sqlite javascript

yes ,I agree with you.AppOption is another idea if data is not much complicated.

Offline

#32 2016-04-08 19:32:25

tin
Member
Registered: 2016-03-20
Posts: 161

Re: sqlite javascript

Offline

#33 2016-04-08 19:36:36

David
Admin
From: Alcobendas, Madrid, Spain
Registered: 2015-04-21
Posts: 1,660
Website

Re: sqlite javascript

Hello,

If SQLite is extremely required may can be an option.

Offline

#34 2016-04-08 19:50:41

tin
Member
Registered: 2016-03-20
Posts: 161

Re: sqlite javascript

David wrote:

Hello,

If SQLite is extremely required may can be an option.

Maybe,Because many Mobile App use it as local database.

Offline

#35 2016-04-08 19:56:45

David
Admin
From: Alcobendas, Madrid, Spain
Registered: 2015-04-21
Posts: 1,660
Website

Re: sqlite javascript

Hello,

That's depend on the application tin. The problem is this is something that works only with Cordova, but, App Builder produces HTML5 applications in the first time, and, something like Cordova's plugins does not work in the browsers, just because the database supports in browsers is very low at this time.

Offline

#36 2016-04-08 20:02:52

tin
Member
Registered: 2016-03-20
Posts: 161

Re: sqlite javascript

David wrote:

Hello,

That's depend on the application tin. The problem is this is something that works only with Cordova, but, App Builder produces HTML5 applications in the first time, and, something like Cordova's plugins does not work in the browsers, just because the database supports in browsers is very low at this time.

Yes,I know it.It difficult when debug,because you need to debug on mobile or emulator.

Offline

#37 2016-04-19 11:08:10

nehir_nehir
Member
Registered: 2016-04-05
Posts: 4

Re: sqlite javascript

I've just come to the SQLite-JavaScript links because i Appbuild release point. It does nobody uses SQLite database on disk? I can read the database with Sql.js. However, update, delete, insert can not do the operation. I'm looking for three days. A lot of things written. But the link with the SQLite is provided by the fact that the registration process is made as simple as three to five lines of information written.
Why is everything so complicated? And inadequate help files.
help page of any programming language is not so simple and inadequate.
I am sorry for my English...

Offline

#38 2016-04-19 11:19:52

David
Admin
From: Alcobendas, Madrid, Spain
Registered: 2015-04-21
Posts: 1,660
Website

Re: sqlite javascript

Hello,

nehir_nehir wrote:

I've just come to the SQLite-JavaScript links because i Appbuild release point. It does nobody uses SQLite database on disk? I can read the database with Sql.js. However, update, delete, insert can not do the operation. I'm looking for three days. A lot of things written. But the link with the SQLite is provided by the fact that the registration process is made as simple as three to five lines of information written.
Why is everything so complicated? And inadequate help files.
help page of any programming language is not so simple and inadequate.
I am sorry for my English...

First of all, thanks very much for your interest in my work at App Builder. Databases are "complicated" because browsers' vendors don't want to compromise the users security/file system, in my opinion. Then, if you look at this webpage you can see client side databases support is not very good nowadays.

About the program's documentation, well, I try to offer the best as I can. Certainly the program's documentation is always in revision, but, I am an only guy and do not have all the resources of a big company. If you want to contribute with the program development, please, consider to purchase a license, since this is the only way the program can be up to date and well supported.

Thanks again for your interest in my work at App Builder.

Offline

#39 2016-04-19 11:48:21

nehir_nehir
Member
Registered: 2016-04-05
Posts: 4

Re: sqlite javascript

I'm testing program is 15-20 days. Not a problem getting License. I'm looking for the other programs of the actions of a few lines (such as SQLite), I have my appbuild is unable to.
A lot of things I can do very cozy. However, I can not do the things that are simple for most programs.
applications should work without the Internet also need to think. MySQL and without php in database operations should be able to do.
At least, how SQLite connection with Javascript would not work if you had told a lot of people on a page.
Thank you....

Offline

#40 2016-04-19 13:09:44

David
Admin
From: Alcobendas, Madrid, Spain
Registered: 2015-04-21
Posts: 1,660
Website

Re: sqlite javascript

Hello,

nehir_nehir wrote:

I'm testing program is 15-20 days. Not a problem getting License. I'm looking for the other programs of the actions of a few lines (such as SQLite), I have my appbuild is unable to.
A lot of things I can do very cozy. However, I can not do the things that are simple for most programs.
applications should work without the Internet also need to think. MySQL and without php in database operations should be able to do.
At least, how SQLite connection with Javascript would not work if you had told a lot of people on a page.
Thank you....

You're welcome. If we want to store app's options then probably the "local storage" is sufficient. We can use actions like "SetOption" and "GetOption" to store options into the "local storage", and, with the help of other actions (which can serialize and unserialize JSON data) we can save more or less complex object/information in that place.

If we need more, and, if our application is intended to be deployed in the Android platform or any other Apache Cordova supported platform, then we can use the "File" plugin along the serialize/unserialize actions, in order to save data in text files, then we can overpass the limit of the "local storage", which allow us to use around 5MB.

But, while the browser's vendors don't provide a good support for databases, then App Builder can't include support for them. We can use remote databases (as you can see) if we need more than the "local storage" or the "Files" plugin for Cordova. When the client side databases are supported by the browser's vendors, then maybe App Builder can include some stuff "out of the box".

Offline

#41 2016-04-19 18:46:03

nehir_nehir
Member
Registered: 2016-04-05
Posts: 4

Re: sqlite javascript

I had to use my databases have to be Sqlite. For example, to keep the 30,000 lyrics. But I do not want to use the internet connection. Or I can already use MySQL. However SQLite enough for me. All I want to do the SQLite connections and update-delete-able to make the insert operation.
Now I've ever done in the investigation, it was the only thing I do in appbuild application. You the one that I want, I can do it one page, for example, do you have information?
SQLite subject was a dejavantaj. Camera, barcode and other features also want to buy the license if it works flawlessly. However, this database work missed all my enthusiasm.

Offline

#42 2016-04-19 18:48:25

David
Admin
From: Alcobendas, Madrid, Spain
Registered: 2015-04-21
Posts: 1,660
Website

Re: sqlite javascript

Hello,

nehir_nehir wrote:

I had to use my databases have to be Sqlite. For example, to keep the 30,000 lyrics. But I do not want to use the internet connection. Or I can already use MySQL. However SQLite enough for me. All I want to do the SQLite connections and update-delete-able to make the insert operation.
Now I've ever done in the investigation, it was the only thing I do in appbuild application. You the one that I want, I can do it one page, for example, do you have information?
SQLite subject was a dejavantaj. Camera, barcode and other features also want to buy the license if it works flawlessly. However, this database work missed all my enthusiasm.

I am sorry, but, I explain above the reason why client side databases are not well supported. If you found a way (using Javascript, for example) to use SQLite, then you can try it, if you wanted, since App Builder's applications can be extended using "pure" Javascript. If this cannot be useful for you, then you need to found another possible program that suite your needs.

Offline

#43 2016-04-19 19:09:48

nehir_nehir
Member
Registered: 2016-04-05
Posts: 4

Re: sqlite javascript

Understood thanks. I must continue to seek other then. You success ...

Offline

#44 2016-04-19 19:13:18

David
Admin
From: Alcobendas, Madrid, Spain
Registered: 2015-04-21
Posts: 1,660
Website

Re: sqlite javascript

Hello,

nehir_nehir wrote:

Understood thanks. I must continue to seek other then. You success ...

Always thanks you.

Offline

#45 2016-05-12 14:40:56

tin
Member
Registered: 2016-03-20
Posts: 161

Re: sqlite javascript

Another way to connect Sqlite with cordova.
http://blog.bradleygore.com/2015/08/25/ … va-sqlite/

Offline

Board footer

Powered by FluxBB


Copyright ©2018 DecSoft. All rights reserved.