Re: [sqlite] uSQLite, doing HTTP

[EMAIL PROTECTED] wrote: Agree in principle with what you're saying here as well, one suggestion - perhaps you could mod your server to accept/general queries/output via standard in/out. That way its could be piped over a multitude of channels. Cheers - Lindsay The

Re: [sqlite] Importing data from Postgres

Christian Smith wrote: On Thu, 17 Nov 2005, Robert Leftwich wrote: Is it still the case that 'the text format used is the same as used by PostgreSQL' as described at http://sqlite.org/sqlite.html? I'm trying to import some data from Postgres using the approach described there i.e. sqlite

RE: [sqlite] Compiling from source code on Windows

> In addition, I wonder if anyone has a solution file or a project file > for > VC++ for building the .lib and the sqlite3 executable, or can give any > hints > about how to build SQLite on Windows using VC++. > > Thanks in advance, > > Ran > Don't know about VC++. But why bother? I compiled

Re: [sqlite] Compiling from source code on Windows

Ran <[EMAIL PROTECTED]> wrote: > Hi all, > > I have added some functionality to the source of SQLite3 to be used in a > project I work on. The changes were done in func.c and in > sqlite.h.in(I added one function to the API). This > was done in Linux, and compiles and > run

Re: [sqlite] Importing data from Postgres

On Thu, 17 Nov 2005, Robert Leftwich wrote: >Is it still the case that 'the text format used is the same as used by >PostgreSQL' as described at http://sqlite.org/sqlite.html? I'm trying to import >some data from Postgres using the approach described there i.e. > > sqlite ex3 pg_dump -a

[sqlite] Compiling from source code on Windows

Hi all, I have added some functionality to the source of SQLite3 to be used in a project I work on. The changes were done in func.c and in sqlite.h.in(I added one function to the API). This was done in Linux, and compiles and run fine. Now I would like to port it also to

Re: [sqlite] Rows to columns

On Thu, 17 Nov 2005, Dennis Cote wrote: >Matthias Teege wrote: > >>Moin, >> >>I have a table with a lot of field/value pairs and I need to create a >>view where rows are columns. Somthing like that: >> >>field|value >>name | ab >>stre | yo >>nr | 12 >> >>I need >> >>name | stre | nr >>ab | yo

RE: [sqlite] How dangerous is PRAGMA Synchronous OFF?

On Thu, 17 Nov 2005 [EMAIL PROTECTED] wrote: > >> >> Database corruption is uncommon. The usual causes are >> >> (1) Running with synchronous=OFF > >Which just about sums it up! > >But, a question, I assume there is no risk if you are only using >selects, i.e. the db is read only. Is there any

Re: [sqlite] uSQLiteServer F.Y.I. TWS web server

I've been following the uSQLiteServer conversations, and suddenly a light came ON. ( which often happens at my age). Perusing my "SQLITE WEB SERVER" documents, I find... >March '04 >borivoj wrote: >>Hello everybody, >> >>I would like to know is there

Re: [sqlite] Rows to columns

Matthias Teege wrote: Moin, I have a table with a lot of field/value pairs and I need to create a view where rows are columns. Somthing like that: field|value name | ab stre | yo nr | 12 I need name | stre | nr ab | yo | 12 Is this possible with sqlite3? Many thanks Matthias

RE: [sqlite] How dangerous is PRAGMA Synchronous OFF?

On 11/17/2005 at 00:54 Preston Z wrote: > >Anybody have a better way to tell if a db is garbage? You will know in the real world because things don't work randomly and the users will complain. My experience is like yours, a corrupt database can be worked with much like a normal one so long as

[sqlite] Importing data from Postgres

Is it still the case that 'the text format used is the same as used by PostgreSQL' as described at http://sqlite.org/sqlite.html? I'm trying to import some data from Postgres using the approach described there i.e. sqlite ex3

[sqlite] Rows to columns

Moin, I have a table with a lot of field/value pairs and I need to create a view where rows are columns. Somthing like that: field|value name | ab stre | yo nr | 12 I need name | stre | nr ab | yo | 12 Is this possible with sqlite3? Many thanks Matthias

RE: [sqlite] How dangerous is PRAGMA Synchronous OFF?

At 00:54 17/11/2005, Preston Z wrote: If the power never goes out and no programs ever crash on you system then Synchronous = OFF is for you, but the rest of the world might still want it ON. Really it sounds like the thing you need to worry about most is the unexpected termination of your

RE: [sqlite] How dangerous is PRAGMA Synchronous OFF?

> > Database corruption is uncommon. The usual causes are > > (1) Running with synchronous=OFF Which just about sums it up! But, a question, I assume there is no risk if you are only using selects, i.e. the db is read only. Is there any performance advantage in having synchronous off in

[sqlite] uSQLite RFC

No, I am not intending to submit uSQLite to the IETF! I am looking for feedback because things are getting out of hand. When I approached the problem of uSQLiteServer I tried to keep the protocol seperate from the transport, that's why I left the old name on the TechFell protocol and kept it as

RE: [sqlite] uSQLite, doing HTTP

> > Agree in principle with what you're saying here as well, one suggestion > - perhaps you could mod your server to accept/general queries/output via > standard in/out. That way its could be piped over a multitude of channels. > > Cheers - Lindsay The architecture would be all wrong for