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: > ** > "Ca

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&B 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. Thi

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 i

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 u

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( 'Ve

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. Sre

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 fo