Re: [sqlite] Database is Locked

On 28 Jan 2012, at 11:47pm, Jan Hudec wrote: > On Sun, Jan 29, 2012 at 00:43:07 +0200, Shahar Weinstein wrote: >> I know there is no permissions problems since after some time when I try >> the same action, it succeeds. in the website, I manage to read/write/delete >> in different locations of

Re: [sqlite] What is the definition/use/point with the xShm* procedures in sqlite3_io_methods, and what's the benefit of using WAL with those rather than the global file locking option?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 28/01/12 02:17, Mikael wrote: > I have a hard time getting a clue of how exactly sqlite uses them, WAL is well documented at: http://www.sqlite.org/wal.html The latest major section talks about shared memory and the wal-index. It also

Re: [sqlite] Database is Locked

On Sun, Jan 29, 2012 at 00:43:07 +0200, Shahar Weinstein wrote: > I know there is no permissions problems since after some time when I try > the same action, it succeeds. in the website, I manage to read/write/delete > in different locations of the code. Can it be that the database is really

Re: [sqlite] Database is Locked

hi, thanks for your reply. I know there is no permissions problems since after some time when I try the same action, it succeeds. in the website, I manage to read/write/delete in different locations of the code. and since the website is on a shared hosting I cannot modify the TMP definitions,

Re: [sqlite] Database is Locked

On Sat, Jan 28, 2012 at 23:36:36 +0200, Shahar Weinstein wrote: > I'm using System.Data.Sqlite the latest version that supports .NET 4 > in an ordinary .NET website. > when trying to issue a single update to the database I'm receiving the > error message saying that the database file is locked. >

[sqlite] Database is Locked

Hi, I'm using System.Data.Sqlite the latest version that supports .NET 4 in an ordinary .NET website. when trying to issue a single update to the database I'm receiving the error message saying that the database file is locked. there is only one connection open. In the connection string

Re: [sqlite] Problem with sqlite and codeblocks (mingw)

Thank you, You have right :) Thank's a lot :) 2012/1/28 Black, Michael (IS) > I don't think you want shell.c in your library. That has a "main" which > will conflict. > > You don't need it anways. > > > > Michael D. Black > > Senior Scientist > > Advanced Analytics

Re: [sqlite] [sqlite 3.6.22] database ".dump" function cannot export table of large number of columns < 2000

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 27/01/12 20:45, Antony wrote: > Did I miss any arguments in the ".dump" command to dump the database > successfully? Putting aside the wisdom of structuring a table this way, you did indeed hit a problem in the SQLite code to dump a table. The

Re: [sqlite] [sqlite 3.6.22] database ".dump" function cannot export table of large number of columns < 2000

On 28 Jan 2012, at 3:31pm, Alexey Pechnikov wrote: > 2012/1/28 Simon Slavin : >> If this database is for longterm use, you're doing the wrong thing. Those >> should be different rows, not all one huge long row. If it's a one-off >> hack, then do it and get rid of it

Re: [sqlite] Problem with sqlite and codeblocks (mingw)

I don't think you want shell.c in your library. That has a "main" which will conflict. You don't need it anways. Michael D. Black Senior Scientist Advanced Analytics Directorate Advanced GEOINT Solutions Operating Unit Northrop Grumman Information Systems

Re: [sqlite] Problem with sqlite and codeblocks (mingw)

No becuase, I need encryption and it is not supported bu wxslite3, I try Sqlcipher and I have exactly the same problem... http://forums.codeblocks.org/index.php/topic,15849.0.html I described it here but nobody can help me ___ sqlite-users mailing list

Re: [sqlite] Problem with sqlite and codeblocks (mingw)

Robert, Have you tried wxSQLite3? It works like a charm for many wxWidgets' projects. Here's the link http://wxcode.sourceforge.net/components/wxsqlite3/ Regards, Stefanos > > From: Robert Gdula >To: sqlite-users@sqlite.org >Sent:

[sqlite] Problem with sqlite and codeblocks (mingw)

Hi, I have a problem with compilation sqlite for mingw and code:blocks, everything is ok and compilation don't show any abnormal information, but when I try only add library of sqlite to the linker of sample wxwidgets program it doesn't work. Everything is ok when I use normal cosole program for

Re: [sqlite] [sqlite 3.6.22] database ".dump" function cannot export table of large number of columns < 2000

Without knowing what you're doing with the data or what your asbtract structure is many will asssume that too many columns means not enough "normalization" of your database. It's not SQLite -- it's standard database design. http://en.wikipedia.org/wiki/Database_normalization You may be

Re: [sqlite] [sqlite 3.6.22] database ".dump" function cannot export table of large number of columns < 2000

2012/1/28 Simon Slavin : > If this database is for longterm use, you're doing the wrong thing.  Those > should be different rows, not all one huge long row.  If it's a one-off hack, > then do it and get rid of it before anyone else sees it and shames you. Why not? Please

[sqlite] System.Data.SQLite version 1.0.79.0 released

System.Data.SQLite version 1.0.79.0 (with SQLite 3.7.10) is now available on the System.Data.SQLite website: http://system.data.sqlite.org/ Further information about this release can be seen at http://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki Please post on the

Re: [sqlite] sqlite mobile size capacity

On 28 Jan 2012, at 11:15am, Live Happy wrote: > what is the maximum size of sqlite on the mobiles phone (android, iPhone, > blackberry, windows mobile) > its the same on all of them ? SQLite can handle far bigger databases than any of those platforms can. So the maximum size of a database

Re: [sqlite] [sqlite 3.6.22] database ".dump" function cannot export table of large number of columns < 2000

On 28 Jan 2012, at 4:45am, Antony wrote: > |CREATE TABLE trace1001_constructs ( >id INTEGER NOT NULL, >tr FLOAT, >tr0001 FLOAT, >tr0002 FLOAT, If this database is for longterm use, you're doing the wrong thing. Those should be different rows, not all one

[sqlite] sqlite mobile size capacity

what is the maximum size of sqlite on the mobiles phone (android, iPhone, blackberry, windows mobile) its the same on all of them ? and in wish of them sqlite more compatibility and the performance of it is high thx for answer ___ sqlite-users mailing

[sqlite] [sqlite 3.6.22] database ".dump" function cannot export table of large number of columns < 2000

I have a table in my sqlite3 database that stores 1001 float numbers in 1001 columns. I wish to dump the database to ascii format for backup purposes, and I expect the ".dump" function will create a snapshot of the database. However, I didn't find any rows of data in the table after

[sqlite] What is the definition/use/point with the xShm* procedures in sqlite3_io_methods, and what's the benefit of using WAL with those rather than the global file locking option?

Dear list, I understand WAL recently got the option of only relying on a db-file-global lock in order to behave correctly across sqlite instances accessing the same file. At the same time, I presume the other access option, which is based on the presence and functioning of the shared memory