Win a copy of Java Challengers this week in the Java in General forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • paul wheaton
  • Devaka Cooray
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Piet Souris
Bartenders:
  • salvin francis
  • Mikalai Zaikin
  • Himai Minh

SQLite3 DB question with android studio

 
Ranch Hand
Posts: 39
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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....
 
Saloon Keeper
Posts: 23541
161
Android Eclipse IDE Tomcat Server Redhat Java Linux
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 39
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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: 39
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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!

 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
reply
    Bookmark Topic Watch Topic
  • New Topic