Re: [sqlite] VACUUM command not working

On Thu, Aug 18, 2011 at 11:19 PM, Tarun wrote: > Hi All, > > I am running program in which I have created SQLite DB file using: > > sqlite3async_initialize() > The easiest solution to your problem might be simply to not use the test_async.c module. That module was

[sqlite] VACUUM command not working

Hi All, I am running program in which I have created SQLite DB file using: sqlite3async_initialize() sqlite3_open_v2() Then created one table into SQLiteDB by using sqlite3_exec() in which I passed SQL command of creating table. Then I inserted records into table using INSERT sql command in

Re: [sqlite] EINTR and write() in os_unix.c

On Thu, Aug 18, 2011 at 5:27 PM, David Garfield < garfi...@irving.iisd.sra.com> wrote: > I think you are right, that it is too easy, at least on its own. You > also should account for partial writes. > i currently account for partial writes but simply report them as errors (i have no

Re: [sqlite] EINTR and write() in os_unix.c

On Thu, Aug 18, 2011 at 5:12 PM, Pavel Ivanov wrote: > to proceed. BTW, if signal will interrupt write() after it has written > part of the data already you won't get EINTR, you will get successful > result just with amount written less than you asked for. > AHA! That's a

Re: [sqlite] EINTR and write() in os_unix.c

I think you are right, that it is too easy, at least on its own. You also should account for partial writes. I think the general rule is: if it wrote anything, it tells you how much it wrote, which can be everything you asked it to write, or less. If it wrote nothing, it usually returns -1 and

Re: [sqlite] EINTR and write() in os_unix.c

> i understand the reason for it, but before i go adding this to my storage > API i just wanted to ask for some opinions as to whether this approach is > generically both technically and philosophically sound, or whether the fact > that it works at all relies on other voodoo deep within os_unix.

Re: [sqlite] PHP, SQLite3 object API, SQLite3::escapeString

I'd guess it was for escaping strings used to build SQL statements by concatenation rather than using prepared statements and binding. On 8/18/2011 7:12 AM, Simon Slavin wrote: > ... > The SQLite3 object API for PHP includes a function SQLite3::escapeString . > The documentation for it doesn't

Re: [sqlite] EINTR and write() in os_unix.c

On Thu, Aug 18, 2011 at 4:39 PM, Pavel Ivanov wrote: > If you don't want your library behavior to be changed when process > receives some signals then you have to use such or some similar > approach. > i understand the reason for it, but before i go adding this to my storage

Re: [sqlite] EINTR and write() in os_unix.c

If you don't want your library behavior to be changed when process receives some signals then you have to use such or some similar approach. Pavel On Thu, Aug 18, 2011 at 9:38 AM, Stephan Beal wrote: > Hi, sqlite3 hackers, > > i'm taking a look at os_unix.c: > >  do{

[sqlite] PHP, SQLite3 object API, SQLite3::escapeString

Recent versions of PHP and the SQLite3 API. No general problems with the system. The SQLite3 object API for PHP includes a function SQLite3::escapeString . The documentation for it doesn't explain what it's of or when to use it. My initial guess was that it should be used for entire SQLite

Re: [sqlite] Suggest some Tools for Sqlite

Hi, >> I hope there should be some good Free or License Tools for using Sqlite. I recently,( two days back) went through a lot GUIs for Windows. I have it narrowed down to four from the list... http://sqlite.com/cvstrac/wiki?p=ManagementTools 1: SQLite Expert Personal 3 <-- my preferred one

[sqlite] EINTR and write() in os_unix.c

Hi, sqlite3 hackers, i'm taking a look at os_unix.c: do{ got = osPwrite(id->h, pBuf, cnt, offset); }while( got<0 && errno==EINTR ); and i just have to ask: do you Unix signal experts out there (a group to which i do not belong, by the way) feel that this is a generically useful approach to

Re: [sqlite] ANALYZE necessary after database upgrade?

On 18 Aug 2011, at 2:03pm, Kristoffer Danielsson wrote: > Hi, The problem is that the database is around 100 MB large (the error goes > away if I remove unimportant data). Also, it contains data I'd like to keep > private. I do have a specific select query that produces what I believe is a >

Re: [sqlite] ANALYZE necessary after database upgrade?

On Thu, Aug 18, 2011 at 9:03 AM, Kristoffer Danielsson < kristoffer.daniels...@live.se> wrote: > > Hi, The problem is that the database is around 100 MB large (the error goes > away if I remove unimportant data). Also, it contains data I'd like to keep > private. I do have a specific select query

Re: [sqlite] ANALYZE necessary after database upgrade?

I did actually report this before, but nobody answered:http://www.mailinglistarchive.com/html/sqlite-users@sqlite.org/2011-04/msg00315.html As you can see, the query does not contain a LIMIT clause. > From: d...@sqlite.org > Date: Thu, 18 Aug 2011 09:00:23 -0400 > To: sqlite-users@sqlite.org >

Re: [sqlite] ANALYZE necessary after database upgrade?

Hi, The problem is that the database is around 100 MB large (the error goes away if I remove unimportant data). Also, it contains data I'd like to keep private. I do have a specific select query that produces what I believe is a data error (tested in the latest SQLite version). Can I zip the

Re: [sqlite] ANALYZE necessary after database upgrade?

On Thu, Aug 18, 2011 at 8:50 AM, Kristoffer Danielsson < kristoffer.daniels...@live.se> wrote: > > > > > I have noticed that certain (complex) select queries return unexpected data > (missing rows) on my upgraded SQLite databases.My guess is that the > optimizer makes an erroneous decision on

Re: [sqlite] ANALYZE necessary after database upgrade?

On 18 Aug 2011, at 1:50pm, Kristoffer Danielsson wrote: > I have noticed that certain (complex) select queries return unexpected data > (missing rows) on my upgraded SQLite databases. What do you mean by 'upgraded' ? > My guess is that the optimizer makes an erroneous decision on some index

Re: [sqlite] sqlite-users Digest, Vol 44, Issue 18

On 18 Aug 2011, at 1:30pm, Lisa Davey wrote: > Can you remove me from this mailing list? > > Lisa > > On Aug 18, 2011, at 8:00 AM, sqlite-users-requ...@sqlite.org wrote: > >> Send sqlite-users mailing list submissions to >> sqlite-users@sqlite.org >> >> To subscribe or unsubscribe via the

[sqlite] ANALYZE necessary after database upgrade?

I have noticed that certain (complex) select queries return unexpected data (missing rows) on my upgraded SQLite databases.My guess is that the optimizer makes an erroneous decision on some index (I'm using both sqlite_stat1 and sqlite_stat2). Is this a reasonable guess? Is it necessary to

Re: [sqlite] Suggest some Tools for Sqlite

On 18/08/2011, at 5:44 PM, Madhankumar Rajaram wrote: > Kindly suggest the best Free / Licence Tool for using Sqlite I've tabulated a comparison of several SQLite admin and data entry tools here: http://www.barefeetware.com/sqlite/compare/?ml Mainly tools for Mac, but a few are cross platform.

Re: [sqlite] type of a value bound by sqlite3_bind_blob ()?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 08/17/2011 09:25 PM, Ivan Shmakov wrote: > Somehow, I've assumed that sqlite3_bind_blob () will bind a > parameter to a blob. It does. There are no affinity rules that will cause otherwise. There are some operations that cause blobs

Re: [sqlite] sqlite-users Digest, Vol 44, Issue 18

Can you remove me from this mailing list? Lisa On Aug 18, 2011, at 8:00 AM, sqlite-users-requ...@sqlite.org wrote: > Send sqlite-users mailing list submissions to >sqlite-users@sqlite.org > > To subscribe or unsubscribe via the World Wide Web, visit >

Re: [sqlite] Suggest some Tools for Sqlite

I have found the SQL Maestro to be quite helpful. It is a licensed tool, you have to pay a nominal fee, but I like the tool. You can also find several good freeware tools, such as SQLiteAdmin. Be warned that many of these freeware programs are no longer actively being developed or supported.

Re: [sqlite] how can i download sqlite 2.x version database for trial version help me for this.i m waiting for your response .........

On Wed, 17 Aug 2011 15:31:45 +0530, "Rohit [Maco Infotech]" wrote: >hello , > > i want to search on google but i can 't find specific way to download sql > lite database.send me link immediately ... SQLite v2 is obsolete. For a trial, use SQLite v3.

Re: [sqlite] Difference between Setups and Precompiled binaries for windows

I think if you check the archives everybody has come to the conclusion that just putting the amalgamation in your project is your best solution and build it yourself. Then you never have to worry about somebody blowing away the DLL. You don't save anything using the DLL unless your planning

Re: [sqlite] Improving the query optimizer

Run "analyze" and your numbers will make more sense...albeit still not perfect. Those numbers are estimations, ergo the "~" in the answer. Michael D. Black Senior Scientist NG Information Systems Advanced Analytics Directorate From:

Re: [sqlite] fts3 table name cannot be the same as column name

On 08/17/2011 10:10 PM, George Brink wrote: > I think this is a bug... If you trying to create FTS3/FTS4 table, make > sure that column name in FTS table is not the same as the table name. > > C:\Projects>sqlite3 aaa > SQLite version 3.7.7.1 2011-06-28 17:39:05 > Enter ".help" for instructions >

Re: [sqlite] Improving the query optimizer

Please ignore my previous mail, it was accidentally sent. To continue with my previous mail, Offlate I have observed a strange behavior with Query Optimizer. I am not sure if it is the desired behavior, yet please find my observations below: Table employee_table

Re: [sqlite] Improving the query optimizer

Offlate I have observed a strange behavior with Query Optimizer. I am not sure if it is the desired behavior, yet please find my observations below: Table employee_table --- id nameage

[sqlite] fts3 table name cannot be the same as column name

I think this is a bug... If you trying to create FTS3/FTS4 table, make sure that column name in FTS table is not the same as the table name. C:\Projects>sqlite3 aaa SQLite version 3.7.7.1 2011-06-28 17:39:05 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> create

[sqlite] how can i download sqlite 2.x version database for trial version help me for this.i m waiting for your response .........

hello , i want to search on google but i can 't find specific way to download sql lite database.send me link immediately ... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Difference between Setups and Precompiled binaries forwindows

> > 1. what is difference of Setups and Pre-compiled binaries ? > The setups are designed to create a directory inside the "Program Files" location, create start menu shortcuts, and optionally register the core and LINQ assemblies in the GAC. They also install the necessary VC++ runtime

[sqlite] Difference between Setups and Precompiled binaries for windows

Hi, I am developing a windows desktop application (with .Net2010 C# and sqlite) I wanted to add sqlite dlls to my application to connect to database. But i need to know 1.what is difference of Setups and Pre-compiled binaries ? 2. I think 32bit and 64 bit is for speed (RAM), but can i use 64

Re: [sqlite] Suggest some Tools for Sqlite

On 18 August 2011 08:44, Madhankumar Rajaram wrote: > > Hi, >         I am working on sqlite3 using command prompt. > Its very hard to see the tables and datas. > > I hope there should be some good Free or Licence Tools for using Sqlite. > For ex : Toad for Oracle. > > so,

[sqlite] Suggest some Tools for Sqlite

Hi, I am working on sqlite3 using command prompt. Its very hard to see the tables and datas. I hope there should be some good Free or Licence Tools for using Sqlite. For ex : Toad for Oracle. so, Kindly suggest the best Free / Licence Tool for using Sqlite Thanks Madhan Kumar R