tags:

views:

30

answers:

2
Q: 

Does anybody know how to access a remote sqlite database using objective-c?

I'm developing a simple macosx application and it needs to access a remote sqlite database (must be sqlite). I've been looking for an example on how to do it through ODBC (I don't know if ODBC is the best or easy way). Does anybody have any idea?

Thanks!

A: 

You don't. SQLite is local only.

Andrew Medico  2010-07-23 12:09:54
SQLite is open source. You could – in some way – change the source code so that you can create a database handle to a virtual file which points to a remote file. I don't know how to do this, but what migoux asks **must** be possible in some way...
Time Machine  2010-07-23 12:12:55
On the sqlite website they said that it's possible: "Using SQLite on a NetworkSQLite database files may be shared accross a network using a network filesystem. This is never a particularly efficient method and may have problems (depending on the filesystem, or may simply not be available."And then they list some alternative techniques. http://www.sqlite.org/cvstrac/wiki?p=SqliteNetwork
migoux  2010-07-23 12:13:46
A: 

OK, I solved it in another way (like Koing Baard said). I mounted the remote sqlite folder (through mount_afp) and it worked.

Thanks all!

migoux  2010-07-23 14:17:23

related questions

SQLite3::BusyException
How do I dump the data of some SQLite3 tables?
Database functionality with WPF app: SQLite, SQL CE, other?
SQLite UDF - VBA Callback
JavaScript sqlite
SQLite/PHP read-only?
Is there a MySQLAdmin or SQL Server Management Studio equivalent for SQLite databases on Windows?
What are the advantages of VistaDB
How Scalable is SQLite?
Programmatically access browser history
SQL Pagination
Metalanaguage to describe the Model from MVC to generate identical client and server side code
Java and SQLite
Is there a good IDE for SQLite ?
Does Visual Studio Server Explorer support custom database providers?
Objective-C: Passing around sets of data
What is the best way to connect and use a sqlite database from C#
Quick easy way to migrate SQLite3 to MySQL?
Why does sqlite3-ruby-1.2.2 not work on OS X?
T-Sql date format for seconds since last epoch / formatting for sqlite input
What's the best way of converting a mysql database to a sqlite one?
SQLite vs MySQL
Using SQLite with Visual Studio 2008 and Silverlight
Adobe Air - Using multiple SQLite databases at once
SQLite and XSD