Re: [sqlite] Problem opening a new SQLite3 database file

On 8/23/07, Dennis Achá <[EMAIL PROTECTED]> wrote: > I cannot open a new SQLite3 database file through the command prompt. In > the > windows "run" window, I type "SQLite3 mydatabase.db3" and I get the > following error > message: > ** >

Re: [sqlite] Looking for a cryptographic library

John Raymond Hurst wrote: > Search for the following on the web: > BeeCrypt, CryptoPP, OpenSSL > Ray Hurst > > [EMAIL PROTECTED] wrote: >> Hi all: >> I'm writing an application that uses SQLite to store user's data, and >> need a library to

Re: [sqlite] Enumerating rows in a view

Hi Darren, If that works, then try using a subquery in the view definition instead. create view Enumerated as select rowid as Sequence, Name from ( select Name from Planets order by Name ) Sort of like that. Thanks for the suggestion, but, unless I'm missing something, it doesn't

Re: [sqlite] Enumerating rows in a view

At 1:08 AM +1000 8/26/07, T wrote: When I create a view, is there any way to enumerate the output rows? Another method would I've developed/discovered is to create a temporary table, fill it with the data from the view, then use the automatically created rowid column as the enumeration. This

Re: [sqlite] Sparse matrix

Hi All, Simon answered: Here's a less gruesome version - no cases. I've given no thought to performance comparisons. Thanks for the two great solutions you posted. Upon further investigation, those solutions assume that we want all like occurrences together, effectively sorting records

Re: [sqlite] Enumerating rows in a view

Hi All, Again following up: When I create a table, SQLite enumerates the rows in the rowid column. When I create a view, is there any way to enumerate the output rows? Another method would I've developed/discovered is to create a temporary table, fill it with the data from the view, then

Re: [sqlite] Enumerating rows in a view

When I create a table, SQLite enumerates the rows in the rowid column. When I create a view, is there any way to enumerate the output rows? For example, say I have a table: create table Planets( Name text collate nocase ); insert into Planets values( 'Mercury' ); insert into Planets values(

Re: [sqlite] Client/Server approach

In that case you are best to implement a server on one machine and have the others connect to it. Since you only have 5 clients you do not need to use the shared cache approach. When we use networked clients we use a server with HTTP protocol so that penetrating firewalls is no problem.

Re: [sqlite] Client/Server approach

I found one open source api for making network interface for any embedded rdbms. The problem was concurrency,for that reason i develop a small thread pool inside the open source network interface and now one rdmbs connection is shared between threads or applications in network. I implement that

RE: [sqlite] Client/Server approach

I am not using 5 clients from the same machine. In a network 5 clients and 1 server will be present. Regards, A.Sreedhar. -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Friday, August 24, 2007 6:17 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite]