how select the database?
Moderators: FourthWorld, heatherlaine, Klaus, kevinmiller, robinmiller
-
- Posts: 33
- Joined: Mon Apr 27, 2009 3:32 pm
- Contact:
how select the database?
Hello to all, i has been reading a lot in the forums, learning about revolution and databases, but i still have the doubt which database is better working with REV? i read about that SQlite is for a single user and MySQL for cliente-server (i do not if it is free), also about valentina but valentina has different options and it confused me.
That i would like to do is develop a good commercial application using REV and connect with a database to store the information, put both in one computer than can be as a server, and allow computers to get the data from there, multiple users using the database at the same time.
Anybody can clarify this for me, please, what is better for the programmer and for the customer (in order to sell the application). Which version of valentina do you use?.
Thanks so much and greetings from México.
Greg Garcia
That i would like to do is develop a good commercial application using REV and connect with a database to store the information, put both in one computer than can be as a server, and allow computers to get the data from there, multiple users using the database at the same time.
Anybody can clarify this for me, please, what is better for the programmer and for the customer (in order to sell the application). Which version of valentina do you use?.
Thanks so much and greetings from México.
Greg Garcia
Hi greggarcia,
I'd go with SQlite. It is included with Revolution and you can redistribute the external/driver without paying a fee. Make a server application that talks to the database and a client application to talk to the server application.
Another option might be MySQL, but you can't include that with your application. You will have to add an interface to your server application to allow the server administrator to include login data for the MySQl database. Also, this might be rather expensive for some of your users, if they are commercial companties and don't have a license for MySQL yet.
As far as I know, every Valentina user always needs to have a license, not just developers who make software. Therefore, I don't think this is an option, if you would like to include all database server software with your application and don't want to incur an additional financial burden on the users of your software.
Depending on your needs, you might even create your own database engine. This eliminates financial and continuity risks, but would cause you a lot of work. There are also more database engines available on the internet for free. Unfortunately, most of them seem difficult to connect to from within Revolution.
Best,
Mark
I'd go with SQlite. It is included with Revolution and you can redistribute the external/driver without paying a fee. Make a server application that talks to the database and a client application to talk to the server application.
Another option might be MySQL, but you can't include that with your application. You will have to add an interface to your server application to allow the server administrator to include login data for the MySQl database. Also, this might be rather expensive for some of your users, if they are commercial companties and don't have a license for MySQL yet.
As far as I know, every Valentina user always needs to have a license, not just developers who make software. Therefore, I don't think this is an option, if you would like to include all database server software with your application and don't want to incur an additional financial burden on the users of your software.
Depending on your needs, you might even create your own database engine. This eliminates financial and continuity risks, but would cause you a lot of work. There are also more database engines available on the internet for free. Unfortunately, most of them seem difficult to connect to from within Revolution.
Best,
Mark
The biggest LiveCode group on Facebook: https://www.facebook.com/groups/livecode.developers
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
The book "Programming LiveCode for the Real Beginner"! Get it here! http://tinyurl.com/book-livecode
-
- Posts: 33
- Joined: Mon Apr 27, 2009 3:32 pm
- Contact:
Something else which may help: I find SQLite Expert really useful. While you are developing your app, you can use this to look at your data, and to add/change/delete records. Handy when you're trying to get your SQL sorted out ! The Personal version is free, and is available for download from www.sqliteexpert.com.
Hope this helps.
Pete
Hope this helps.
Pete
...and along that line, I use the FireFox plugin SQLite Manager (downloadable through the FireFox Add-ons menu) from http://sqlite-manager.googlecode.com
This seems incorrect for deploying apps built by owners of the ADK or VDN licenses. As part of the ADK embedded standalone or VDN embedded server packages, the developer receives a license which is included in the distributed software which enables the db connection for that software. This is a royalty free license which involves no distribution or use costs to either developer or application end user. There are some restrictions but you can check the EULAs online.Mark wrote:Hi greggarcia,
As far as I know, every Valentina user always needs to have a license, not just developers who make software. Therefore, I don't think this is an option, if you would like to include all database server software with your application and don't want to incur an additional financial burden on the users of your software.
I find Pardigm's website to be somewhat less than perfectly intuitive, and the information they provide regarding the various versions and licensing differences a little less clear than it should be, but here are some links regarding Revolution and Valentina that may be worth investigating:
Valenitina for Rev