Accessing existing SQLite database using Eclipse

Question

I have created an android app in java using eclipse which creates a SQLite database and lets the user add data to it.

I would like to know how to access an already existing SQLite database (say, in our web server) to view and add data to it ? I Googled it and didn't get any clear picture. Do I need to install JDBC driver for doing this ?

Thanks.

SQLiteadmin could be what you need (it's a traditional app, and not a web application though): sqliteadmin.orbmu2k.de — ChristopheD
– ChristopheD, Commented Nov 13, 2012 at 18:12
SQLite is Serverless. There are webservices and things like that building upon SQLite but if you want a database with remote access you're probably better off using something else. — zapl
– zapl, Commented Nov 13, 2012 at 18:39
@zapl I think questioner need in ease way access database file in phone memory ant manipulate it. — neworld
– neworld, Commented Nov 13, 2012 at 21:29
@neworld possible, questioneer is not very clear about how device internal db and db on webserver should interact, or if at all. If it's about getting the file from the device stackoverflow.com/questions/6928849/… — zapl
– zapl, Commented Nov 13, 2012 at 21:43

tkotisis · Accepted Answer · 2012-11-13 19:31:13Z

1

SQLite is not a client/server database. That said, the SQLite wiki mentions some alternatives.

answered Nov 13, 2012 at 19:31

tkotisis

3,59227 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

toadzky · Accepted Answer · 2012-11-13 18:22:33Z

0

If you want to access a remote database from your app, you will need an interface (like a web service) that will take requests from your app and actually do the database manipulation. If you just want to access a local database from your computer, there are several utilities for it to do it graphically or you can use sqlite3 to do it from the command line. If you want to access the database through your browser, I think you need a web service for that too.

answered Nov 13, 2012 at 18:22

toadzky

3,8461 gold badge18 silver badges26 bronze badges

1 Comment

user1170168 Over a year ago

I read something about the JDBC driver and I wanted to know if I have to use that to form a connection between the SQLite database in our web server and java code in eclipse.

Collectives™ on Stack Overflow

Accessing existing SQLite database using Eclipse

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related