This week's book giveaway is in the Agile and Other Processes forum.
We're giving away four copies of The Little Book of Impediments (e-book only) and have Tom Perry on-line!
See this thread for details.
Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQLite3 DB question with android studio

 
Dirk Lucas
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

I was wondering if I could use a database I create in SQL Workbench (or any other tool) and open it with SQLite via Android Studio. It seems a bit of a hassle to make the whole DB in the command line so I figured there must be an easier way.

If this is not possible, is there a tool which enables me to open the DB file I make on the command line and actually view/correct/change/update(/create?) the tables?

I can find lots of info ont the internet about creating an empty DB in android studio and filling it with user input. I can find near to non about creating a new SQLite3 db to use in Android Studio (besides the cmd option). So if this is a bit of a not so smart question, my apologies but please give me an answer anyway;)

If no other option exists then at least I can let it go and continue on the cmd route....
 
Tim Holloway
Saloon Keeper
Posts: 18367
56
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'm not really clear on what you're hoping for.

In Android, the physical locations and management of databases is determined by Android itself. You wouldn't ordinarily create the database externally and upload it. For one thing, Android app installation is done via a single package file, not by splattering files all up and down the filesystem.
 
Dirk Lucas
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
So let me re-formulate my question like this: i.e. I want to add a file with employee info to my Android app and use info from this file in my application. Where/how should I store this information?

I saw an example of data stored in a Java file? But this seems a bit strange to me as when writing a normal program I think I would normally try to avoid this. There must be some way to use information from an existing database file in you application right?

If it still not clear please let me know! Ty for you answer!
 
Dirk Lucas
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Tim Holloway wrote:I'm not really clear on what you're hoping for.

In Android, the physical locations and management of databases is determined by Android itself. You wouldn't ordinarily create the database externally and upload it. For one thing, Android app installation is done via a single package file, not by splattering files all up and down the filesystem.


So...does this mean you can't use an external database with an Android app? Sounds a bit strange to me...? Than what is the solution to using outside Data in your app? How would anyone use a list of (whatever) if you can't use an external DB file in yur application? Seems kind of limiting to me!

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic