Win a copy of Rust Web Development this week in the Other Languages 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:
  • Tim Cooke
  • Campbell Ritchie
  • Ron McLeod
  • Liutauras Vilda
  • Jeanne Boyarsky
Sheriffs:
  • Junilu Lacar
  • Rob Spoor
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Tim Moores
  • Jesse Silverman
  • Stephan van Hulst
  • Carey Brown
Bartenders:
  • Al Hobbs
  • Piet Souris
  • Frits Walraven

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: 24846
174
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!

 
reply
    Bookmark Topic Watch Topic
  • New Topic