Re: [sqlite] documentation on the webserver

[Jay Sprenkle]

On 10/19/06, Dennis Cote <[EMAIL PROTECTED]> wrote:

I agree that it would probably be worth adding a simply note to the
documentation for each API function which states the first version of
sqlite that made the function available.


Can the web pages be set so specific individuals can wiki them?
Then we could help with the maintenance of the site.

--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] bind with select?

[Jay Sprenkle]

On 10/16/06, Dave Dyer <[EMAIL PROTECTED]> wrote:


I can't find an example, but it seems like there ought to be
syntax to use bind to inline selection variables, instead of
having to have a callback function.

Something like:

 char *forval,*barval;
 sqlite_prepare(db,"select ?foo,?bar from table");
 sqlite_bind("?foo",&fooval);
 sqlite_bind("?bar",&balval);

 while () { sqlite_step()
// foo and var bound to current values
}

can someone point me to an example, or good documentation?


There's C++ source code available at the address shown in my signature line:

--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite

Cthulhu Bucks!
http://www.cthulhubucks.com

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] sqlite3sh.jar: 100% pure java port of sqlite 3.3.8+

[Joe Wilson]

Java port of the sqlite3 shell courtesy of the brilliant NestedVM  UNIX/MIPS 
emulation environment:

  http://www.sqlite.org/contrib?orderby=date

java -jar sqlite3sh.jar
SQLite version 3.3.8
Enter ".help" for instructions
sqlite> create table abc(a, b, c);
sqlite> insert into abc values (4, 5, 'frog');
sqlite> insert into abc values (13.4, 'A', null);
sqlite> select * from abc;
4|5|frog
13.4|A|
sqlite> update abc set c = 'something';
sqlite> .dump
BEGIN TRANSACTION;
CREATE TABLE abc(a, b, c);
INSERT INTO "abc" VALUES(4, 5, 'something');
INSERT INTO "abc" VALUES(13.4, 'A', 'something');
COMMIT;
sqlite> .q

Warning: No database file locking is performed by sqlite3sh.jar - use on a copy 
of a database file or risk data corruption. (If someone provides a fcntl() 
patch for NestedVM, please post it to this list.)

Note: this is not a JDBC driver. In theory you could use NestedVM to port 
Christian Werner's SQLite JDBC driver, but it would require a fair bit of work. 



diff -rN -u old-nestedvm/src/org/ibex/nestedvm/Interpreter.java 
new-nestedvm/src/org/ibex/nestedvm/Interpreter.java
--- old-nestedvm/src/org/ibex/nestedvm/Interpreter.java 2006-10-08 
23:16:14.0 -0400
+++ new-nestedvm/src/org/ibex/nestedvm/Interpreter.java 2006-10-09 
11:44:53.0 -0400
@@ -781,7 +781,7 @@
 Interpreter emu = new Interpreter(image);
 java.lang.Runtime.getRuntime().addShutdownHook(new Thread(emu.new 
DebugShutdownHook()));
 int status = emu.run(argv);
-System.err.println("Exit status: " + status);
+//System.err.println("Exit status: " + status);
 System.exit(status);
 }
 }
diff -rN -u old-nestedvm/src/org/ibex/nestedvm/Runtime.java 
new-nestedvm/src/org/ibex/nestedvm/Runtime.java
--- old-nestedvm/src/org/ibex/nestedvm/Runtime.java 2006-10-08 
23:16:15.0 -0400
+++ new-nestedvm/src/org/ibex/nestedvm/Runtime.java 2006-10-09 
13:57:36.0 -0400
@@ -809,6 +809,14 @@
 copyout(buf,addr,n);
 return n;
 }
+
+/** The ftruncate syscall */
+private int sys_ftruncate(int fdn, long length) throws ErrnoException {
+  if (fdn < 0 || fdn >= OPEN_MAX) return -EBADFD;
+  if (fds[fdn] == null) return -EBADFD;
+  fds[fdn].ftruncate(length);
+  return 0;
+}
 
 /** The close syscall */
 private int sys_close(int fdn) {
@@ -1017,6 +1025,10 @@
 return 0;
 case F_GETFD:
 return closeOnExec[fdn] ? 1 : 0;
+case F_GETLK:
+case F_SETLK:
+//if(STDERR_DIAG) System.err.println("WARNING: fcntl option 
not supported: " + cmd);
+return 0;
 default:
 if(STDERR_DIAG) System.err.println("WARNING: Unknown fcntl 
command: " + cmd);
 return -ENOSYS;
@@ -1058,6 +1070,7 @@
 case SYS_close: return sys_close(a);
 case SYS_read: return sys_read(a,b,c);
 case SYS_lseek: return sys_lseek(a,b,c);
+case SYS_ftruncate: return sys_ftruncate(a,b);
 case SYS_getpid: return sys_getpid();
 case SYS_calljava: return sys_calljava(a,b,c,d);
 case SYS_gettimeofday: return sys_gettimeofday(a,b);
@@ -1143,6 +1156,9 @@
 /** Write. Should return the number of bytes written or throw an 
IOException on error */
 public int write(byte[] a, int off, int length) throws ErrnoException 
{ throw new ErrnoException(EBADFD); }
 
+/** ftruncate */
+public void ftruncate(long length) throws ErrnoException { throw new 
ErrnoException(EBADFD); }
+
 /** Seek in the filedescriptor. Whence is SEEK_SET, SEEK_CUR, or 
SEEK_END. Should return -1 on error or the new position. */
 public int seek(int n, int whence)  throws ErrnoException  { return 
-1; }
 
@@ -1215,6 +1231,14 @@
 throw new ErrnoException(EIO);
 }
 }
+
+public void ftruncate(long length) throws ErrnoException {
+try {
+data.ftruncate(length);
+} catch(IOException e) {
+throw new ErrnoException(EIO);
+}
+}
 
 protected void _close() { try { data.close(); } catch(IOException e) { 
/*ignore*/ } }
 }
diff -rN -u old-nestedvm/src/org/ibex/nestedvm/util/Seekable.java 
new-nestedvm/src/org/ibex/nestedvm/util/Seekable.java
--- old-nestedvm/src/org/ibex/nestedvm/util/Seekable.java   2006-10-08 
23:16:14.0 -0400
+++ new-nestedvm/src/org/ibex/nestedvm/util/Seekable.java   2006-10-09 
11:49:21.0 -0400
@@ -14,6 +14,10 @@
 public abstract void close() throws IOException;
 public abstract int pos() throws IOException;
 
+public void ftruncate(long length) throws IOException {
+throw new IOException("ftruncate not implemented for " + getClass());
+}
+
 public int read() throws IOException {
 byte[] buf = new byte[1];
 int n

Re: Fwd: [sqlite] problems reading a sqlite db

[[EMAIL PROTECTED]]

I'll try that next time. This time i found a cheat way around the problem. I 
used the sqlite
command line program, which had no problems opening the database, and did a 
dump of the db. I then
used the command line program to create a new db, and read in the dump file. 
Then i just swaped the
problem db file with the one i just created.

Thanks for the help,

Ian

-- Forwarded message --
From: Steven Danneman <[EMAIL PROTECTED]>
Date: Oct 20, 2006 6:05 PM
Subject: Re: [sqlite] problems reading a sqlite db
To: sqlite-users@sqlite.org


It's possible that the end-of-line characters were converted when you
transferred the DB file from Windows to Linux.  This corrupts the binary
format and can happen when you transfer a file over FTP in text mode.

It's worth a shot to first run the DB file through the dos2unix command
then try opening it on your Linux machine.

--
Best regards,

Steven Danneman <[EMAIL PROTECTED]>
ITTIA - Mobile and Embedded Database Solutions

Download a free evaluation of ITTIA DB at:
http://www.ittia.com/community/request/ittiadb



[EMAIL PROTECTED] wrote:
> hi all,
>
> I'm trying to read a sqlite database that was created as part of a trac 
> installation. I'm running
> ubuntu, python 2.3.4 and pysqlite2
>
> I can read the db fine on a window server.
>
> When i copy the db over to our linux box though, i'm having some problems.
>
> I've written a very simple test script to try and open the db. When i run it, 
> i get an error when
i
> try to execute a SELECT statement.
>
> pysqlite2.dbapi2.OperationalError: unsupported file format
>
> As far as i can tell everything on the system is the latest version of both 
> pysqlite and sqlite.
> I'm not really 100% sure how i can verify that though.
>
> Can anyone offer any suggestions as to how i would troubleshoot and resolve 
> this?
>
> thanks
>
> Ian
>
>
>
>
>
> 
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -


-
To unsubscribe, send email to [EMAIL PROTECTED]
-


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] problems reading a sqlite db

[Steven Danneman]

It's possible that the end-of-line characters were converted when you
transferred the DB file from Windows to Linux.  This corrupts the binary
format and can happen when you transfer a file over FTP in text mode.

It's worth a shot to first run the DB file through the dos2unix command
then try opening it on your Linux machine.

-- 
Best regards,

Steven Danneman <[EMAIL PROTECTED]>
ITTIA - Mobile and Embedded Database Solutions

Download a free evaluation of ITTIA DB at:
http://www.ittia.com/community/request/ittiadb



[EMAIL PROTECTED] wrote:
> hi all,
>
> I'm trying to read a sqlite database that was created as part of a trac 
> installation. I'm running
> ubuntu, python 2.3.4 and pysqlite2
>
> I can read the db fine on a window server.
>
> When i copy the db over to our linux box though, i'm having some problems.
>
> I've written a very simple test script to try and open the db. When i run it, 
> i get an error when i
> try to execute a SELECT statement.
>
> pysqlite2.dbapi2.OperationalError: unsupported file format
>
> As far as i can tell everything on the system is the latest version of both 
> pysqlite and sqlite.
> I'm not really 100% sure how i can verify that though.
>
> Can anyone offer any suggestions as to how i would troubleshoot and resolve 
> this?
>
> thanks
>
> Ian
>
>
>
>
>   
> 
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sqlite-locked error

[Jay Sprenkle]

>Either there is a bug in your operating system (you didn't tell
>us what operating system you are using, by the way) or else there
>is still a process holding a transaction open that you are unaware
>of.


It turns out to be the latter.

It would be useful in such circumstances to identify the
process holding the lock in some way.


If you're on unix/linux the command  'lsof' will do that.
google will give you the specs and a link to the source if you want to
give it a go

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] problems reading a sqlite db

[[EMAIL PROTECTED]]

hi all,

I'm trying to read a sqlite database that was created as part of a trac 
installation. I'm running
ubuntu, python 2.3.4 and pysqlite2

I can read the db fine on a window server.

When i copy the db over to our linux box though, i'm having some problems.

I've written a very simple test script to try and open the db. When i run it, i 
get an error when i
try to execute a SELECT statement.

pysqlite2.dbapi2.OperationalError: unsupported file format

As far as i can tell everything on the system is the latest version of both 
pysqlite and sqlite.
I'm not really 100% sure how i can verify that though.

Can anyone offer any suggestions as to how i would troubleshoot and resolve 
this?

thanks

Ian




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] See table structure

[David Crawshaw]

Lloyd <[EMAIL PROTECTED]> wrote:

Hi List,
  In SQLite, to see the table structure which command can I use?
  (as in Oracle's desc  )


You can use "select * from sqlite_master;" and there is specific
information available by the pragma command:

http://sqlite.org/pragma.html

d

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] [OT] Java wrapper binaries for Windows with larget MAX_ARGS

[David Crawshaw]

Adriano Ferreira <[EMAIL PROTECTED]> wrote:

Does anyone know where I can get binary files for the Christian
Werner's Java wrapper (sqlite.jar and sqlite_jni.dll) which allows for
a large number of placeholders (something like 256 or so)?


If you are just after a JDBC driver with no arbitrary limit on the
number of statement parameters, I provide a Windows binary:

http://www.zentus.com/sqlitejdbc/

David

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Re: [OT] Java wrapper binaries for Windows with larget MAX_ARGS

[Adriano Ferreira]

Only to make things explicit, I believe the failure to get useful
Windows binaries according to the instructions is all mine - some
unfortunate combination of the environment I am using and my lack of
skills.

On 10/20/06, Adriano Ferreira <[EMAIL PROTECTED]> wrote:

Does anyone know where I can get binary files for the Christian
Werner's Java wrapper (sqlite.jar and sqlite_jni.dll) which allows for
a large number of placeholders (something like 256 or so)? This is
currently configured by a #define at the file sqlite_jni.c and
defaults to 32. I followed the instructions to compile the wrapper on
Windows, but despite a successful compilation, all I got is segfaults
in the Java virtual machine.

Anyone?

Best regards,
Adriano Ferreira.



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] [OT] Java wrapper binaries for Windows with larget MAX_ARGS

[Adriano Ferreira]

Does anyone know where I can get binary files for the Christian
Werner's Java wrapper (sqlite.jar and sqlite_jni.dll) which allows for
a large number of placeholders (something like 256 or so)? This is
currently configured by a #define at the file sqlite_jni.c and
defaults to 32. I followed the instructions to compile the wrapper on
Windows, but despite a successful compilation, all I got is segfaults
in the Java virtual machine.

Anyone?

Best regards,
Adriano Ferreira.

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] new sqlite-based webserver

[Günter Greschenz]

P Kishor schrieb:

On 10/20/06, Paul M <[EMAIL PROTECTED]> wrote:

On 10/20/06, Günter Greschenz <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> a new version is available (0.5.1.9) on
> "http://greschenz.dyndns.org/gas.html";.
> this version uses threads for sending files now ! the reply time is 
much

> better now...


Very cool program. I once wrote something like this in perl, but it 
never

used a database. I do wish to pose one question. Can this server handle
multipart form uploads(multiple files from one form)? I remeber in 
perl I
had to implement the support for that and regular form submissions 
manually.
I tell you that was a pain. I must say I am impressed with your work 
though.
I will take a look and see what I can use this thing for, because it 
sounds

like something that can be useful. One last remark, when I built mine I
spent hours deciphering HTTP's exact workings. I hope you didn't have 
to do

the same.



I am looking around for a standalone webserver/db solution written in
Perl. I found "Paul's trivial httpd"
. Maybe your are the same Paul ;-).

Nevertheless, is your product available for circulation?

Many thanks,



well, this is a standalone webserver/db solution, but you have to use 
javascript instead of perl. i tried perl some years ago, but even with 
>20 years programming experience it was to difficult for me :-)


what do you mean by "available for circulation" ? you can download the 
source and build it yourself :-) it circulates (i look at my server logs 
;-) about 50 times now :-)))

but before you go to "production mode" you should wait some more time.
i think sqlite and spidermonkey are very well tested, but i still have 
to find the "sigsegv" from today :-)



cu, gg


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] new sqlite-based webserver

[Günter Greschenz]

hi,

yes, multipart form uploads are possible, and yes, it was a pain :-) but 
i developed some http-servers before so i know what to do...
at the moment, i'm still using (heavy transformed) external http-code 
(from www.hughes.com.au/products/libhttpd/) which was not  able to do 
this...
well, before using it you shoud wait at least for the next release. 
today i had a sigsegv ! but some minutes ago i learned about 
"backtrace_symbols" :-)
really kind, thanx very much: /I must say I am impressed with your work 
though/ , but the big part was done by the sqlite- and the 
spidermonkey-crew  !
i "just" glued it together... look at the code sizes:  only about 100k 
is from me (for now) !


cu, gg

Paul M schrieb:

On 10/20/06, Günter Greschenz <[EMAIL PROTECTED]> wrote:


Hi,

a new version is available (0.5.1.9) on
"http://greschenz.dyndns.org/gas.html";.
this version uses threads for sending files now ! the reply time is much
better now...



Very cool program. I once wrote something like this in perl, but it never
used a database. I do wish to pose one question. Can this server handle
multipart form uploads(multiple files from one form)? I remeber in perl I
had to implement the support for that and regular form submissions 
manually.
I tell you that was a pain. I must say I am impressed with your work 
though.
I will take a look and see what I can use this thing for, because it 
sounds

like something that can be useful. One last remark, when I built mine I
spent hours deciphering HTTP's exact workings. I hope you didn't have 
to do

the same.

Paul M

Re: [sqlite] new sqlite-based webserver

[P Kishor]

On 10/20/06, Paul M <[EMAIL PROTECTED]> wrote:

On 10/20/06, Günter Greschenz <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> a new version is available (0.5.1.9) on
> "http://greschenz.dyndns.org/gas.html";.
> this version uses threads for sending files now ! the reply time is much
> better now...


Very cool program. I once wrote something like this in perl, but it never
used a database. I do wish to pose one question. Can this server handle
multipart form uploads(multiple files from one form)? I remeber in perl I
had to implement the support for that and regular form submissions manually.
I tell you that was a pain. I must say I am impressed with your work though.
I will take a look and see what I can use this thing for, because it sounds
like something that can be useful. One last remark, when I built mine I
spent hours deciphering HTTP's exact workings. I hope you didn't have to do
the same.



I am looking around for a standalone webserver/db solution written in
Perl. I found "Paul's trivial httpd"
. Maybe your are the same Paul ;-).

Nevertheless, is your product available for circulation?

Many thanks,

--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation https://edu.osgeo.org/
---
collaborate, communicate, compete


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Re: new sqlite-based webserver

[Paul M]

On 10/20/06, A. Pagaltzis <[EMAIL PROTECTED]> wrote:


You didn't use the CGI module, did you?



If you must know it was POE based and no I did not use the CGI module. I
have implemented later versions that where capable of using database
servers. SQLite amoung them of course as well as MySQL and Postgresql. Part
of the reason was actually to learn howto do it manually as well. Reason was
if I choose to implement it in FreePascal or PureBasic that I could.

Re: [sqlite] Extra functions - New Project?

[Mikey C]

Hi Rohit.

I sent the source code to DRH with the extra functions.  I don't myself have
the time now to incorporate the extra functions into SQLite.

I don't know if DRH plans to add the extra functions.  If he does not and he
doesn't mind, I am happy to send the source code to anyone that is
interested.

Regards,

Mike


RohitPatel wrote:
> 
> Mike
> 
> When are you planning to put code of your SQL functions for SQLite ?
> 
> Waiting...eagerly...
> I may try to use it in my app.
> 
> Thanks
> Rohit
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Extra-functions---New-Project--tf1674436.html#a6919718
Sent from the SQLite mailing list archive at Nabble.com.


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Re: new sqlite-based webserver

[A. Pagaltzis]

* Paul M <[EMAIL PROTECTED]> [2006-10-20 17:35]:
> Can this server handle multipart form uploads(multiple files
> from one form)? I remeber in perl I had to implement the
> support for that and regular form submissions manually. I tell
> you that was a pain.

You didn’t use the CGI module, did you?

Regards,
-- 
Aristotle Pagaltzis // 

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] new sqlite-based webserver

[Paul M]

On 10/20/06, Günter Greschenz <[EMAIL PROTECTED]> wrote:


Hi,

a new version is available (0.5.1.9) on
"http://greschenz.dyndns.org/gas.html";.
this version uses threads for sending files now ! the reply time is much
better now...



Very cool program. I once wrote something like this in perl, but it never
used a database. I do wish to pose one question. Can this server handle
multipart form uploads(multiple files from one form)? I remeber in perl I
had to implement the support for that and regular form submissions manually.
I tell you that was a pain. I must say I am impressed with your work though.
I will take a look and see what I can use this thing for, because it sounds
like something that can be useful. One last remark, when I built mine I
spent hours deciphering HTTP's exact workings. I hope you didn't have to do
the same.

Paul M

Re: [sqlite] Inserting uniquely

[Sergio 'OKreZ' Agosti]

On 20/ott/06, at 17:06, Lloyd wrote:


Hi List,
  Is there is any easy way to insert a value to a table, if and  
only if

it is not existing ?

For example.

If I have these values 1,2,3,4,1,2,3,4
when I insert these to a table

it must be
1
2
3
4

[By using primary key or unique constraint, it will work. But I dont
want sqlite to throw error]

How can I get this done?


If you use INSERT OR IGNORE INTO table... you won't get any error  
thrown by sqlite


---
Sergio 'OKreZ' Agosti
---
icq: 112421063
msn: [EMAIL PROTECTED]
skype:   sergio.agosti
iChat:   sergio.agosti
jabber:  sergio.agosti
---


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Inserting uniquely

[dcharno]

Lloyd wrote:

Hi List,
  Is there is any easy way to insert a value to a table, if and only if
it is not existing ? 


http://sqlite.org/lang_conflict.html

ON CONFLICT clause
conflict-clause ::= ON CONFLICT conflict-algorithm
conflict-algorithm ::=  ROLLBACK | ABORT | FAIL | IGNORE | REPLACE

The ON CONFLICT clause is not a separate SQL command. It is a 
non-standard clause that can appear in many other SQL commands. It is 
given its own section in this document because it is not part of 
standard SQL and therefore might not be familiar.


The syntax for the ON CONFLICT clause is as shown above for the CREATE 
TABLE command. For the INSERT and UPDATE commands, the keywords "ON 
CONFLICT" are replaced by "OR", to make the syntax seem more natural. 
For example, instead of "INSERT ON CONFLICT IGNORE" we have "INSERT OR 
IGNORE". The keywords change but the meaning of the clause is the same 
either way.


The ON CONFLICT clause specifies an algorithm used to resolve constraint 
conflicts. There are five choices: ROLLBACK, ABORT, FAIL, IGNORE, and 
REPLACE. The default algorithm is ABORT. This is what they mean:




-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] Inserting uniquely

[Lloyd]

Hi List,
  Is there is any easy way to insert a value to a table, if and only if
it is not existing ? 

For example.

If I have these values 1,2,3,4,1,2,3,4
when I insert these to a table

it must be 
1
2
3
4

[By using primary key or unique constraint, it will work. But I dont
want sqlite to throw error]

How can I get this done?

Thanks,
  Lloyd. 


__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] unsigned shorts in bindInt on ARM

[Jim Dodgen]

I suspect a little vs. big endian problem.


chetana bhargav wrote:

Hi,

I saw a strnage problem using unsigned shorts, not sure if any one saw that, I 
was using an unsigned short for binding it to integer, the lint wasn't 
complaining and everything seem to go ahead fine, when I tested that on 
windows, all my querys were returning as expected. But when I moved my code to 
ARM platform, all my queries were failing, the reason was that as I used 
unsigned short for binding with int, it was taking zero.

Any idea why this would be so, is it compiler problem as to how it intrepets 
that data.? Of course when I changed the data type to int everything went ahead 
fine. Wanted to know if any one saw this.

Just wanted to let people know if anyone intends to use uint16's on ADS1.2 be 
prepared for strange results.


...
Chetana.


  



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Select with join does not returning same-named columns

[Dennis Cote]

other mail wrote:


is it safe to assume negligable timing differences between using the sql
USING clause vs the sql ON clause in a join?



Devorah,

I would not expect there to be any significant difference.

It should be easy enough to try it both ways and measure the difference. 
Then you would be sure. :-)


HTH
Dennis Cote


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] See table structure

[Jim Dodgen]

from the command line in sqlite3:

.schema 

Lloyd wrote:

Hi List,
  In SQLite, to see the table structure which command can I use? 
  (as in Oracle's desc  )

Thanks,
  Lloyd



__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-



  



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] See table structure

[Lloyd]

Hi List,
  In SQLite, to see the table structure which command can I use? 
  (as in Oracle's desc  )
Thanks,
  Lloyd



__
Scanned and protected by Email scanner

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] sqlite_corrupt

[drh]

"Kalle Klovn" <[EMAIL PROTECTED]> wrote:
> Yesterday I received the
> SQLITE_CORRUPT error message. This happened on a test system so it is not
> that bad, but I am now very nervous about this happening in my production
> system. Is this a common problem with sqlite? 

I get very few reports of database corruption and SQLite is
widely deployed.  So, no, this is not a common problem.

There is a bug in version 3.2.1 that can cause corruption if
you try to vacuum a database that is larger than 1GiB and the
vacuum fails, for example due to a power failure.  You should
upgrade to 3.3.8 if you can.

Other causes of database corruption are listed at

  http://www.sqlite.org/lockingv3.html

under the heading "6.0 How To Corrupt Your Database Files".

--
D. Richard Hipp  <[EMAIL PROTECTED]>


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] unsigned shorts in bindInt on ARM

[chetana bhargav]

Hi,

I saw a strnage problem using unsigned shorts, not sure if any one saw that, I 
was using an unsigned short for binding it to integer, the lint wasn't 
complaining and everything seem to go ahead fine, when I tested that on 
windows, all my querys were returning as expected. But when I moved my code to 
ARM platform, all my queries were failing, the reason was that as I used 
unsigned short for binding with int, it was taking zero.

Any idea why this would be so, is it compiler problem as to how it intrepets 
that data.? Of course when I changed the data type to int everything went ahead 
fine. Wanted to know if any one saw this.

Just wanted to let people know if anyone intends to use uint16's on ADS1.2 be 
prepared for strange results.


...
Chetana.

Re: [sqlite] new sqlite-based webserver

[Martin Jenkins]

Günter Greschenz wrote:

Hi,

a new version is available (0.5.1.9) on 
"http://greschenz.dyndns.org/gas.html";.


I'd just like to confirm that I can still see your site from the UK. ;)

Martin

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] new sqlite-based webserver

[Günter Greschenz]

Hi,

a new version is available (0.5.1.9) on 
"http://greschenz.dyndns.org/gas.html";.
this version uses threads for sending files now ! the reply time is much 
better now...


btw: some time ago someone searched a possibility to expose a sqlite 
database over http: have a look at the sqlitebrowser-sample in my 
source-zip.
its not perfectly running (still in work) but you can see how this could 
be done...


cu, gg


Günter Greschenz schrieb:

hi,

i dont know if anyone is interested in my new open source project...
i implemented a little webserver with javascript as backend-language
(1.7 from mozilla 2.0.rc1) and sqlite as datastorage (3.3.7)
the server is serving himself on "http://greschenz.dyndns.org"; :-)
the source can be downloaded at 
"http://greschenz.dyndns.org/download/gas/";

its compilable with gcc(linux) and vs2005(win32)

please send me any comments / ideas...

cu, gg



- 


To unsubscribe, send email to [EMAIL PROTECTED]
- 






-
To unsubscribe, send email to [EMAIL PROTECTED]
-