[sqlite] how to add time in a new column

2012-03-28 Thread YAN HONG YE
sqlite> alter table dzh add mtime NOT NULL DEFAULT CURRENT_TIME; Error: Cannot add a column with non-constant default ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] how to built xml file from sqlite database?

2012-03-28 Thread YAN HONG YE
how to built xml file from sqlite database? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] In-memory and temporary database

2012-03-28 Thread Larry Brasfield
On March 28, Simone P. Lossani wrote: Hello, I'm doing some test with SQlite 3.7.11 in Windows Embedded industrial PC. I need to store data in a table very quickly. Let's say new data each 10 msec. I tryed with DB on disk but obviously was not possible to reach the correct performance. So I

Re: [sqlite] In-memory and temporary database

2012-03-28 Thread Simon
> I red a lot of article and documentation but I have not solved the problem. Did you read these? http://sqlite.org/faq.html#q19 (I doubt you'll read anything really new here) http://sqlite.org/atomiccommit.html#opts (this one may be really helpful) It depends on your situation, but if it's

Re: [sqlite] In-memory and temporary database

2012-03-28 Thread Stephan Beal
On Wed, Mar 28, 2012 at 11:32 AM, Simone P. Lossani wrote: > I red a lot of article and documentation but I have not solved the problem. > Maybe with temporary DB I can have the same performance and also I can > share > DB? > Have you some suggestion? > On a full-blown

Re: [sqlite] In-memory and temporary database

2012-03-28 Thread Simon Slavin
On 28 Mar 2012, at 10:32am, Simone P. Lossani wrote: > I need to store data in a table very quickly. Let's say new data each 10 msec. > I tryed with DB on disk but obviously was not possible to reach the correct > performance. > So I tryed with in-memory DB and in this

[sqlite] In-memory and temporary database

2012-03-28 Thread Simone P. Lossani
Hello, I'm doing some test with SQlite 3.7.11 in Windows Embedded industrial PC. I need to store data in a table very quickly. Let's say new data each 10 msec. I tryed with DB on disk but obviously was not possible to reach the correct performance. So I tryed with in-memory DB and in this case