Re: [sqlite] Duplicate records

2006-06-15 Thread C.Peachment
On Thu, 15 Jun 2006 20:12:41 +0100, Adam wrote: >Hi All, >I'm creating a database which will look a little like: >create table main (f1 TEXT, f2 TEXT, f3 TEXT, t1 TEXT, t2 TEXT, tn TEXT); >f1, f2 and f3 will always be present. Any or all of the ts might be NULL. >I'd like to prevent entries

Re: [sqlite] accessing sqlite files directly via http

2006-06-15 Thread John Stanton
I have implemented just such a system as an RPC. It accesses an HTTP server using CGI and returns the table or view requested in XML. The application parses what it wants from the XML. The programs are simple C, compiling on Unix and Windows, and include an XML parser based on Expat. You

Re: [sqlite] Index in seperate db file, low impact change?

2006-06-15 Thread drh
Russell Leighton <[EMAIL PROTECTED]> wrote: > Given you can attach multiple database files in sqlite, perhaps it could > be extended such that: > > * When you name an index, you optionally prepend the database name > which can be in another currently attached db > * You attached to

Re: [sqlite] Index in seperate db file, low impact change?

2006-06-15 Thread Lindsay
Russell Leighton wrote: > > Big distruptive code change? Also more opportunites for things to go wrong with mismatched index/db files Also no longer can copy/move db as a single file -- Lindsay

[sqlite] Index in seperate db file, low impact change?

2006-06-15 Thread Russell Leighton
Given you can attach multiple database files in sqlite, perhaps it could be extended such that: * When you name an index, you optionally prepend the database name which can be in another currently attached db * You attached to multiple db files that have cross references as:

Re: [sqlite] Duplicate records

2006-06-15 Thread Jay Sprenkle
Hi All, I'm creating a database which will look a little like: create table main (f1 TEXT, f2 TEXT, f3 TEXT, t1 TEXT, t2 TEXT, tn TEXT); f1, f2 and f3 will always be present. Any or all of the ts might be NULL. I'd like to prevent entries where all of the fields are the same being created. How

[sqlite] Duplicate records

2006-06-15 Thread Adam
Hi All, I'm creating a database which will look a little like: create table main (f1 TEXT, f2 TEXT, f3 TEXT, t1 TEXT, t2 TEXT, tn TEXT); f1, f2 and f3 will always be present. Any or all of the ts might be NULL. I'd like to prevent entries where all of the fields are the same being created. How

Re: [sqlite] Question on SQL query optimization with joins

2006-06-15 Thread Dennis Cote
Bob Dankert wrote: I have been pondering an issue for a while regarding the separation of query conditions from the join condition and the where condition of the query. All I have been able to find on this matter is general text "use the ON clause for conditions that specify how to join tables,

Re: [sqlite] Multiple Threads with a DROP command

2006-06-15 Thread drh
"James Butts" <[EMAIL PROTECTED]> wrote: > > In the main thread, I open a connection to database and create a timer > function and start a worker thread. The worker thread establishes its own > separate connection to database. The worker thread creates a table and then > signals the main

Re: [sqlite] Avoiding Fragmentation of SQLite database file ???

2006-06-15 Thread drh
Florian Weimer <[EMAIL PROTECTED]> wrote: > * A. Pagaltzis: > > >> On Windows, perhaps. On most UNIX systems, this is very hard > >> to do and often not supported at all by the file system. > > > > Then again, Unix filesystems tend to be designed such > > that as long as there is sufficient free

Re: [sqlite] Multiple Threads with a DROP command

2006-06-15 Thread James Butts
On 6/15/06, James Butts <[EMAIL PROTECTED]> wrote: > > In the main thread, I open a connection to database and create a timer > function and start a worker thread. The worker thread establishes its own > separate connection to database. The worker thread creates a table and > then signals the

Re: [sqlite] Multiple Threads with a DROP command

2006-06-15 Thread Jay Sprenkle
On 6/15/06, James Butts <[EMAIL PROTECTED]> wrote: In the main thread, I open a connection to database and create a timer function and start a worker thread. The worker thread establishes its own separate connection to database. The worker thread creates a table and then signals the main

[sqlite] Multiple Threads with a DROP command

2006-06-15 Thread James Butts
I have a problem involving multiple threads and trying to create a table after its been dropped. Perhaps I'm doing something wrong. Here is the jist. In the main thread, I open a connection to database and create a timer function and start a worker thread. The worker thread establishes its

Re: [sqlite] Avoiding Fragmentation of SQLite database file ???

2006-06-15 Thread Florian Weimer
* A. Pagaltzis: >> On Windows, perhaps. On most UNIX systems, this is very hard >> to do and often not supported at all by the file system. > > Then again, Unix filesystems tend to be designed such > that as long as there is sufficient free space on the > device, fragmentation will remain

[sqlite] accessing sqlite files directly via http

2006-06-15 Thread Martin Pfeifle
Hello, We would like to access (only reading access) a remote sqlite database via http. On a remote computer, an http server is located and an sqlite database file (we are not allowed to install any software on that http-server). On a client computer, an application program wants to access the

Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

2006-06-15 Thread John Newby
Yes please, I am using vb.net but I should be able to work through and see whats going on and transfer it to my project. Many thanks for your help. John On 15/06/06, Noel Frankinet <[EMAIL PROTECTED]> wrote: John Newby wrote: > Hi, I don't know if you can remember but I was asking for

Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

2006-06-15 Thread Noel Frankinet
John Newby wrote: Hi, I don't know if you can remember but I was asking for advice on displaying info to the user using a dataset/datagrid, and you said you used a virtual listview. I am currently having loads of trouble using the dataset/datagrid so I was wondering if you could let me know

Re: [sqlite] VB.Net DataSet & DataGrid with ADO.Net Provider

2006-06-15 Thread John Newby
Hi, I don't know if you can remember but I was asking for advice on displaying info to the user using a dataset/datagrid, and you said you used a virtual listview. I am currently having loads of trouble using the dataset/datagrid so I was wondering if you could let me know more about your