Droidscript Database Method

[Nicola Dalozzo]

Hello I am a novice user of droidscript I am making a app that allows you to enter data in a local database delete them and then display a data entered in the database through a search. can someone help me  where I can learn what I need. 

Thank you.

[Dave Smart]

Hi Nicola,

It depends on how big your database is going to be and what sort of information you need to store.

If it is going to be quite small and not require sophisticated search queries, then it will probably be easier to simply load and save JSON data to the internal sdcard.  If it requires multiple tables and you need to do SQL 'join' type queries, the SQLite might be a better choice.

What is your database going to be like?

[Nicola Dalozzo]

Hello dave, yes my database is a sample db with one table with 3 date , id, name service , login , password. I think use sql lite with droidscript but not know the command, you can help me????

[Symbroson Development]

I think there is an sql saple on droidscripts sampme list. Touch the 'samples' button on top right in DS and scroll a bit down

[Nicola Dalozzo]

Hi Symbros

 Thanks for replay, I saw l as in DS is good to enter data but for viewing makes no research exists another example but I cannot access it because it's only for premium ... ... .... should I find especially a function do a search on the database msql lite from the fates of a text box. Thanks for the help

[Thierry Derick]

Old topic, but in case : I created a small example long ago here in the wiki
http://wiki.droidscript.me.uk/doku.php?id=sample_code:database_navigate

and someone a demo on youtube
regards, Thierry