[sqlite] Files required to be changed to handle different file system

2006-07-30 Thread Vivek R
Hi, I am porting SQLite to DVD, I am using the harddisk which uses our own file system. Can I know which are the files and API's to be changed for reading and writeing the database on to the disk. Thanx in advance, Regards, Vivek R

Re: Re: [sqlite] New JDBC driver for SQLite

2006-07-30 Thread David Crawshaw
Michael Scharf wrote: I quickly looked at the code -- it's amazingly small! I really like that. I have to do some performance tests to see if it fits my needs.. Thanks. I think you will find the JNI is not a problem, I tested it on its own and the overhead is non-existent. The problem you shoul

Re: [sqlite] New JDBC driver for SQLite

2006-07-30 Thread Michael Scharf
Hi David, I quickly looked at the code -- it's amazingly small! I really like that. I have to do some performance tests to see if it fits my needs.. Michael I have written a new JDBC driver for SQLite. http://java.zentus.com/sqlitejdbc.html It is designed to be easy to read and as thin a lay

Re: AW: [sqlite] New JDBC driver for SQLite

2006-07-30 Thread David Crawshaw
Martin Pfeifle <[EMAIL PROTECTED]> wrote: Does the jdbc driver also provide the direct reading and writing of BLOBs? Yes, through PreparedStatement.setBytes() and ResultSet.getBytes(). I haven't added support yet for the java.sql.Blob type, because I am funadmentally opposed to the idea of SQL

AW: [sqlite] New JDBC driver for SQLite

2006-07-30 Thread Martin Pfeifle
Does the jdbc driver also provide the direct reading and writing of BLOBs? Best Matin - Ursprüngliche Mail Von: David Crawshaw <[EMAIL PROTECTED]> An: sqlite-users@sqlite.org Gesendet: Sonntag, den 30. Juli 2006, 14:56:18 Uhr Betreff: [sqlite] New JDBC driver for SQLite Hello all, I

[sqlite] Way to "Bind" Columns in Prepare

2006-07-30 Thread michael cuthbertson
Of course. Thanks.

[sqlite] New JDBC driver for SQLite

2006-07-30 Thread David Crawshaw
Hello all, I have written a new JDBC driver for SQLite. http://java.zentus.com/sqlitejdbc.html It is designed to be easy to read and as thin a layer as possible on top of the C functions. The new _prepare()/_step() API is surprisingly similar to the JDBC API, making it efficient code. SQLite is

Re: [sqlite] Retrieving ROWID value on duplicate conflict

2006-07-30 Thread Naveen Nathan
> Naveen, > > There is no way to do what you want directly in SQL. You are looking for an > INSERT OR UPDATE type of functionality, this does not exist in SQL. > > Your program can retrieve the rowid of a conflicting insert by doing a select > before the insert. If there is a conflicting record