Re: [sqlite] PRAGMA user_version

2011-09-03 Thread Igor Tandetnik
Walter wrote: > Thank you Igor I had the database name but did not > think of the the dot in between. Perhaps some one could update the > documentation to show this Perhaps someone could read the documentation before complaining about it. http://sqlite.org/pragma.html "A pragma may have an optio

Re: [sqlite] Widen output of file field for .databases CLI command

2011-09-03 Thread Keith Christian
On Thu, Aug 25, 2011 at 6:47 PM, Clark Christensen wrote: > Hi Keith, > > How about > > pragma database_list; > >  -Clark I'll try it! Thanks! Keith ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinf

Re: [sqlite] PRAGMA user_version

2011-09-03 Thread Jay Kreibich
On Sep 3, 2011, at 8:21 PM, Walter wrote: > > Thank you Igor I had the database name but did not think of the the dot in > between. Perhaps some one could update the documentation to show this Cheers > everyone Walter Please see "PRAGMA Command Syntax" http://sqlite.org/pragma.html -

Re: [sqlite] PRAGMA user_version

2011-09-03 Thread Mr. Puneet Kishor
On Sep 3, 2011, at 8:21 PM, Walter wrote: > > On 9/2/2011 11:02 PM, Walter wrote: > >> > Is there any way to get the user_version from an Attached database >> > PRAGMA attachedName.user_version; > > -- Igor Tandetnik Thank you Igor I had the database name but did not think of > the the do

Re: [sqlite] PRAGMA user_version

2011-09-03 Thread Walter
On 9/2/2011 11:02 PM, Walter wrote: > Is there any way to get the user_version from an Attached database PRAGMA attachedName.user_version; -- Igor Tandetnik Thank you Igor I had the database name but did not think of the the dot in between. Perhaps some one could update the documentati

Re: [sqlite] Unicode Confusion and Database Size

2011-09-03 Thread Simon Slavin
On 3 Sep 2011, at 4:27pm, Mohit Sindhwani wrote: > for our data, we can get savings in the region of 25% - 33% in the case of > strings being stored in a language that does require 3bytes/ character. So, > given that, we should explore UTF-16 in more detail. However, we also have a > lot of

Re: [sqlite] Unicode Confusion and Database Size

2011-09-03 Thread Mohit Sindhwani
Hi Igor, Thanks for your advice and guidance. On 1/9/2011 11:57 PM, Igor Tandetnik wrote: On 9/1/2011 10:24 AM, Mohit Sindhwani wrote: On the other hand, the other language that we are storing seems to require 3 bytes in UTF-8. Given that, it would appear that using UTF-8 would be a better id

Re: [sqlite] Is it possible to multithread the conversion of MySQLite database table to the SQLite database

2011-09-03 Thread Frank Chang
Kees Nuyt, Thank you for very impressive and excellent reply to our question. I will show it to my boss and ask him for the data necessary to answer your question. I will also ask my boss , who is a director of product development, whether he will allow us to try to implement your producer

Re: [sqlite] Is it possible to multithread the conversion of MySQLite database table to the SQLite database?

2011-09-03 Thread Kees Nuyt
Hi Frank, On Sat, 3 Sep 2011 02:55:17 -0400, Frank Chang wrote: > Good morning, > > Is it possible to multithread the conversion of MySQLite > database table to the SQLite database? Dr. Richard Hipp > said in a post recently that at that time it was not to > multithread SQLite database conne