Database - what will be the best way?

Shay · May 28, 2011

Hi

Starting to build new app - would like to get recommedation / help to the following:

1. app will have local db of products - which database to use? (how to create it locally? is there any software that I can do it on my windows computer and then move it to the android)
2. user can add his own products - which sql to use?
3. user can send his products to the internet (server) and get update from that server

so what is the best way to do all the above?

thanks

Merlot2309 · May 28, 2011

Hi Shay,

I am working with sql(ite) databases and I find them easy to handle in B4A.
Transactions are carried out fast (way faster then in Windows Mobile)
To maintain the database I use the Mozilla Firefoxplug SQLite Manager.

Have a look at http://www.b4x.com/forum/basic4android-share-your-creations/6998-family-med-list.html

Succes,
Helen.

Shay · May 29, 2011

Thanks I will check it

but how do I prepare the db in advance?
I wish to insert most of the data using my PC
since there are lot's of data

thanks

Erel · May 29, 2011

SQLite is a cross platform database. There are many tools that will allow you to work with SQLite databases from Windows and import your data.

aklisiewicz · May 30, 2011

you can use SQLite Manager, or SQLiteBrowser (free for non commercial use) it will let you input manually, or copy/paste SQL to import data. Make sure that every table has a PrimaryKey. SQLite is probably the best choice but if you would want for example OpenOffice compatybility you may consider HSQL dB, there are other alternatives as well....

Arthur

Database - what will be the best way?

Shay

Well-Known Member

Merlot2309

Active Member

Shay

Well-Known Member

Erel

B4X founder

aklisiewicz

Active Member

Database - what will be the best way?

Shay

Well-Known Member

Merlot2309

Active Member

Shay

Well-Known Member

Erel

B4X founder

aklisiewicz

Active Member

Privacy & Transparency

Privacy & Transparency