Re: [sqlite] SQLITE3 64-bit version

Yes, that's the one. Hmm, so you say that I'm safe if I statically link SQLITE in each of my modules... goes a bit against my reflexes (paraphrasing an old saying: 1 MB here 1 MB there; soon you start talking real memory bloating) but I'll give it a thought. Thanks again, Mircea On

Re: [sqlite] SQLITE3 64-bit version

> I've also read Richard Hipp's > advice about potential issues if multiple threads of the same process access > the same DB so I figured I'd be safer if I have just one SQLITE module I guess you refer to this Richard's advice: http://www.mail-archive.com/sqlite-users@sqlite.org/msg69579.html.

Re: [sqlite] SQLITE3 64-bit version

Thanks everyone for your answers. Man, this list is one of the most helpful places to hang out in the whole wide web; full of friendly and knowledgeable advice - reminds me of the Usenet of the 80-es. @Michel: Is there a reason you can't just compile it into your program instead of using it

Re: [sqlite] SQLITE3 64-bit version

On 23 Apr 2012, at 10:06pm, Roger Binns wrote: > I think what is confusing Windows developers is that they go to the > download page and can find 32 bit downloads, but no 64 bit downloads and > hence come to the conclusion there must be some sort of unspecified issue. >

Re: [sqlite] location of database wrt

If you do a file search you will probably find an empty database of the same name as what you expect. You're probably using the "default working directory" and the file isn't where you expect it. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions

[sqlite] location of database wrt

I am having a problem locating my database within my eclipse project. I am willing to bet that I have overlooked something simple but thus far I cannot find it in my code structure no matter where I locate it. Here is the logging up to the point of the error (which occurs when I try and save a

Re: [sqlite] SQLITE3 64-bit version

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 23/04/12 13:33, Richard Hipp wrote: > A 64-bit build of SQLite on windows is one of our test cases. (See > checklist item 9f > ). I think what is confusing Windows developers is that they go to

[sqlite] Visual Studio 2005

Hello, I need help to configure SQLite with Visual Studio 2005. I can't see the option to add SQLite on Server Explorer. How can I do that? Is there any video or articule explaining this? I read a lot of articles and I could make it work with VS2008 but I have no luck with VS2005. Many thanks

Re: [sqlite] SQLITE3 64-bit version

On Mon, Apr 23, 2012 at 2:12 PM, Mircea Neacsu wrote: > Hello list, > > Would you know if SQLITE3 can be compiled (and if it will work) as a > 64-bit DLL? > A 64-bit build of SQLite on windows is one of our test cases. (See checklist item 9f

Re: [sqlite] SQLITE3 64-bit version

Is there a reason you can't just compile it into your program instead of using it as a DLL? Are you distributing multiple executables that would actually take advantage of that? It's under 1Meg as it's not much by today's standards. Seems to me we've heard more than one person with DLL

Re: [sqlite] SQLITE3 64-bit version

Thanks everyone, @Roger: Is there anything that lead you to believe it wouldn't work or there may be issues? No, I just haven't seen any pre-compiled binaries and wanted to save myself some trouble in case there are any known issues. I'll just go ahead and make myself one. One more thing if

Re: [sqlite] SQLITE3 64-bit version

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 23/04/12 11:12, Mircea Neacsu wrote: > Would you know if SQLITE3 can be compiled (and if it will work) as a > 64-bit DLL? Yes - I use it as both 32 bit and 64 bit on non-Windows platforms. On Windows I also do 32 and 64 bit. I've only done the

Re: [sqlite] SQLITE3 64-bit version

> Would you know if SQLITE3 can be compiled (and if it will work) as a 64-bit > DLL? > I use SQLITE as a 64 bit dll on windows. However for me it is included with the Qt library. John ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Suggestion about hard-coded time string format YYYY-MM-DD

On 4/23/2012 2:34 PM, Pete wrote: Folks, I'm a bit late to this discussion but what are the new PRAGMAs referred to here? They were discussed hypothetically. As in, wouldn't it be nice if there were pragmas to control date and time formats. -- Igor Tandetnik

[sqlite] Suggestion about hard-coded time string format YYYY-MM-DD

Folks, I'm a bit late to this discussion but what are the new PRAGMAs referred to here? I don't see them listed in the documentation - do they exist or are they a suggestion for future implementation? On Tue, Apr 3, 2012 at 9:00 AM, wrote: > Message: 2 > Date:

[sqlite] SQLITE3 64-bit version

Hello list, Would you know if SQLITE3 can be compiled (and if it will work) as a 64-bit DLL? Thanks, Mircea ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Is it possible to preclude the latest sqlite 3.7.11 Windows warning message?

Simon Davies, We tried your suggestion, /Ze on Visual Studio 2008, buy we are still encountering Microsoft Visual 2008 warning, Thank you for your help. e:\users\frank\dqt_memorymap\sqlite\sqlite3.c(32329) : warning C4232: nonstandard extension used : 'pCurrent' : address of dllimport

[sqlite] error 404

Good day, This page http://sqlite.org/cvstrac/wiki?p=SqliteNetwork Is giving an error 404 for this link *SQL4Sockets* (http://www.oneledger.co.uk/sql4sockets.html) regards, Adam ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Memory Usage/ Drawbacks of Statements

Thanks Pavel, That gives me something new to do with SQLite over the next few weeks. On 23/4/2012 8:47 PM, Pavel Ivanov wrote: 1. Do statements do any thing that would require a lot of memory to be maintained? No, they don't need a lot of memory, but still some memory is used. So if you have

Re: [sqlite] free list performance

> I think that the PRAGMA for auto-vacuum might be the right thing for your > situation.  Unfortunately it would have to be done before any tables were > created.  The simplest way to do this for a database which already exists > might be to use the shell tool to dump the existing database to

Re: [sqlite] free list performance

On 23 Apr 2012, at 2:25pm, Max Vlasov wrote: > On Mon, Apr 23, 2012 at 3:35 PM, Simon Slavin wrote: >> >> For the second one, the simplest way to do something like defragment the >> data inside the file is to use the VACUUM command: > > Simon,

Re: [sqlite] free list performance

On Mon, Apr 23, 2012 at 3:35 PM, Simon Slavin wrote: > > For the second one, the simplest way to do something like defragment the data > inside the file is to use the VACUUM command: Simon, thanks, I see what vacuum can do, sure I use it frequently as many of us.

Re: [sqlite] Is it possible to preclude the latest sqlite 3.7.11 Windows warning message?

On 23 April 2012 13:04, Frank Chang wrote: > > >       Good morning, We are trying to compile  the latest SQLITE 3.7.11 > release but we keep getting the Windows Visual Studio 8 warning message: > warning C4232: nonstandard extension used : 'pCurrent' : address

Re: [sqlite] Memory Usage/ Drawbacks of Statements

> 1. Do statements do any thing that would require a lot of memory to be > maintained? No, they don't need a lot of memory, but still some memory is used. So if you have like thousands of statements you should worry about this. If you have 20 or 30 statements your database cache will likely

Re: [sqlite] help

> 11       COMMENT         VARCHAR(150)       0                            0 > > So it is possible: ? > UPDATE t1 SET comment = 'here the text of 160 characters long' Yes, that's possible. You can put text of any length into VARCHAR or TEXT field no matter what size you declare for it (you can

[sqlite] Is it possible to preclude the latest sqlite 3.7.11 Windows warning message?

Good morning, We are trying to compile the latest SQLITE 3.7.11 release but we keep getting the Windows Visual Studio 8 warning message: warning C4232: nonstandard extension used : 'pCurrent' : address of dllimport 'AreFileApisANSI' is not static, identity not guaranteed showm

[sqlite] Memory Usage/ Drawbacks of Statements

Hi, our system does fairly predictable queries when it runs. A number of modules all access data using a handful of queries of each. We open the database at the start and close it at the end of the program. Each query follows the usual pattern of prepare - bind - step - reset - (eventually)

Re: [sqlite] free list performance

Stop that BULLSHIT - Original Message - From: "Simon Slavin" To: "General Discussion of SQLite Database" Sent: Monday, April 23, 2012 1:35 PM Subject: Re: [sqlite] free list performance On 23 Apr 2012, at 11:15am, Max Vlasov

Re: [sqlite] free list performance

On 23 Apr 2012, at 11:15am, Max Vlasov wrote: > Some time ago I worked with a database repeating the same sequence of > actions multiply times. They're basically: > - create table > - populate table > - do some deletes with some criteria > - drop table Okay. That's

Re: [sqlite] Help

23 апреля 2012 г. 15:07 пользователь Ковригина Ольга: > From Russian developer you respect!  =) куда же без них ;) -- Regards,   niXman ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Help

Dear,Simon  James! Thank you very much. Worked!Similarly, the type has no size! From Russian developer you respect!  =) 2012/4/23 Ковригина Ольга : > Hello,support! > Tell me how to resize columns in a table? > I do like this: > ALTER TABLE t1 MODIFY (c1 TYPE VARCHAR(2500)); >

[sqlite] Help

2012/4/23 Ковригина Ольга : > Hello,support! > Tell me how to resize columns in a table? > I do like this: > ALTER TABLE t1 MODIFY (c1 TYPE VARCHAR(2500)); > or > ALTER TABLE t1 ALTER (c1 TYPE VARCHAR(2500)); > But it does not work. >   The column does not have a size:

[sqlite] help

Mon, 23 Apr 2012 11:33:47 +0100 от Simon Davies : > 2012/4/23 Ковригина Ольга : > > Hello,support! > > Tell me how to resize columns in a table? > > I do like this: > > ALTER TABLE t1 MODIFY (c1 TYPE VARCHAR(2500)); > > or > > ALTER TABLE t1 ALTER

Re: [sqlite] Permissions

[Richard Hipp] > On Sun, Apr 22, 2012 at 12:40 PM, Steinar Midtskogen > wrote: > >> >> Any reason why sqlite doesn't use the same file permissions as the >> database file when creating these extra files? >> >> > There was a change in version 3.7.11 to do exactly that. >

Re: [sqlite] help

2012/4/23 Ковригина Ольга : > Hello,support! > Tell me how to resize columns in a table? > I do like this: > ALTER TABLE t1 MODIFY (c1 TYPE VARCHAR(2500)); > or > ALTER TABLE t1 ALTER (c1 TYPE VARCHAR(2500)); > But it does not work. > The column does not have a size:

[sqlite] free list performance

Hi, Some time ago I worked with a database repeating the same sequence of actions multiply times. They're basically: - create table - populate table - do some deletes with some criteria - drop table After about 20 times I started to notice the usual effects of internal fragmentation (slowness in