Re: [sqlite] PRAGMA user_version

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

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

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

Re: [sqlite] PRAGMA user_version

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"

Re: [sqlite] PRAGMA user_version

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

Re: [sqlite] PRAGMA user_version

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

Re: [sqlite] Unicode Confusion and Database Size

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

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

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

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?

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 >

Re: [sqlite] Speeding up index creation

On Fri, Sep 2, 2011 at 6:04 PM, Dan Kennedy wrote: > On 09/02/2011 07:32 PM, Filip Navara wrote: >> >> On Fri, Sep 2, 2011 at 11:04 AM, Filip Navara >>  wrote: >> *snip* >>> >>> The time to create an index on my 266 Mb experimental database is more

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

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 connections to the same database. Dr. Hipp suggested that we use MYSQL to do