Re: [sqlite] Corruption of incremental_vacuum databases

On 17/04/2009 1:39 AM, Filip Navara wrote: > Hello, > > I have expected at least some reply. Oh well, new the corruption has happened > again (on another different machine) and I have saved the database files. One > of the corrupted files is available at >

Re: [sqlite] 2 columns as primary key?

On 30/05/2009 12:43 PM, Andrés G. Aragoneses wrote: > I just tried to create a primary key with 2 columns and got this error: > > "sqlite error" "table X has more than one primary key" > > > Doesn't SQLite support this?? :o It does support multi-column primary keys. It's a bit hard to tell at

Re: [sqlite] 2 columns as primary key?

Thanks! It worked. Sorry for the silly question :) Igor Tandetnik wrote: > ""Andrés G. Aragoneses"" > wrote in message > news:gvq7b2$lp...@ger.gmane.org >> CREATE TABLE LastSyncedRatings ( >> DapID TEXT PRIMARY KEY, >> MetadataHashTEXT PRIMARY KEY, >>

Re: [sqlite] 2 columns as primary key?

create table tablename (     colname1 coltype,     colname2 coltype,     colname3 coltype,     PRIMARY KEY(colname1 asc, colname2 asc) ) --- On Fri, 5/29/09, Pavel Ivanov wrote: From: Pavel Ivanov Subject: Re: [sqlite] 2 columns as

Re: [sqlite] 2 columns as primary key?

""Andrés G. Aragoneses"" wrote in message news:gvq7b2$lp...@ger.gmane.org > CREATE TABLE LastSyncedRatings ( > DapID TEXT PRIMARY KEY, > MetadataHashTEXT PRIMARY KEY, > Rating INTEGER NOT NULL > ) Make it CREATE TABLE LastSyncedRatings

Re: [sqlite] 2 columns as primary key?

CREATE TABLE LastSyncedRatings ( DapID TEXT PRIMARY KEY, MetadataHashTEXT PRIMARY KEY, Rating INTEGER NOT NULL ) Pavel Ivanov wrote: > What create table statement did you use? > > Pavel > > 2009/5/29 "Andrés G. Aragoneses" : >> I just

Re: [sqlite] 2 columns as primary key?

What create table statement did you use? Pavel 2009/5/29 "Andrés G. Aragoneses" : > I just tried to create a primary key with 2 columns and got this error: > > "sqlite error" "table X has more than one primary key" > > > Doesn't SQLite support this?? :o > >        Andres > > --

[sqlite] 2 columns as primary key?

I just tried to create a primary key with 2 columns and got this error: "sqlite error" "table X has more than one primary key" Doesn't SQLite support this?? :o Andres -- ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Sqlite on a Virtual Machine of Microsoft's Hyper-V ?

okay, thanks to all for the info. I'm relieved.. best Marcus Sam Carleton wrote: > Well, Microsoft's Hyper-V is just like VMWare. It allows multiple OS's > to be installed and running on one machine at one time. Since sqlite is > simply reads/writes to a file, not track/sectors, it should

[sqlite] Global cache size restriction

Hi, all! Is there a way to set global restriction on cache size in SQLite? I like the default cache_size value for each database. But if I open a lot of different databases then total cache size for all of them could be too big for me. So I'd want to set some global_cache_size to limit it. Is it

Re: [sqlite] TOCTOU pager bug in 3.6.14.2

Could this be the same issue as this bug I reported a while ago? http://www.sqlite.org/cvstrac/tktview?tn=3833 Cheers, Dave. -Original Message- From: Brian Dantes [mailto:bdan...@coverity.com] Sent: 28 May 2009 16:01 To: Discussion of SQLite Database Subject: [sqlite] TOCTOU pager bug

Re: [sqlite] Coulden't access my db, because of "Out of memory" error

On 29 May 2009, at 10:42am, elmarr...@systemcompetence.de wrote: > My question would be, how I can resize the db file or how to check > if it > is corrupted. Or what I can do to access my data. Use the command-line tool to open it, and check it can access records using a few 'SELECT'

Re: [sqlite] Sqlite on a Virtual Machine of Microsoft's Hyper-V ?

Well, Microsoft's Hyper-V is just like VMWare. It allows multiple OS's to be installed and running on one machine at one time. Since sqlite is simply reads/writes to a file, not track/sectors, it should be fine. SQLite won't even know it is running on a virtual. Marcus Grimm wrote: Hello

Re: [sqlite] Sqlite on a Virtual Machine of Microsoft's Hyper-V ?

On Fri, May 29, 2009 at 8:27 AM, Marcus Grimm wrote: > Hello List, > > I've been asked if my server application will run > in a virtual machine: Microsoft's Hyper-V > I have no idea what this is, nor if it affects sqlite. > > My main concern would be if the (essential)

[sqlite] Sqlite on a Virtual Machine of Microsoft's Hyper-V ?

Hello List, I've been asked if my server application will run in a virtual machine: Microsoft's Hyper-V I have no idea what this is, nor if it affects sqlite. My main concern would be if the (essential) file locking and sync/commit commands will still do the intended job within a virtual

Re: [sqlite] add column creating null columns even with default?

I use a Python ORM called SQLAlchemy, which maps its generic boolean type to 'boolean' on SQLite - which I subsequently plucked from the schema and put into an alter statement. If this is going to cause problems then I can report it to SQLAlchemy, but as John said, this seems to be treated like a

Re: [sqlite] Slow Transaction Speed?

I agree that adding this to the library, and making it accessible via a pragma command would be very useful. For example, pragma commitrate 1000 would test the commit rate of 1000 commits and return the results in transactions per second as a row. If I install my app on a client's machine, I

Re: [sqlite] SQLite3 question

Hi Richard, Thank you for quick reply. Actually I am reading from that file only, but I didn't get the concept of 'Cell' that is mentioned as... " The payload for an entry and the preceding pointer are combined to form a "Cell". Can you please help me to clarify this. Actually I got some bug

[sqlite] Coulden't access my db, because of "Out of memory" error

Hello, I'm new to sqlite and have now the problem, that i couldn't access my database. When I try I get the following line. sqlite.c:210 Unable to open Database=/usr/local/testing/db/test.db. ERR=out of memory The database has nearly a size of 2GB. My guess would be that I've run out of

Re: [sqlite] FTS3

One further question: In fts3.c, a comment is found which describes the file format dependent on the different compiler settings. * Result formats differ with the setting of DL_DEFAULTS. Examples: ** ** DL_DOCIDS: [1] [3] [7] ** DL_POSITIONS: [1 0[0 4] 1[17]] [3 1[5]] ** DL_POSITIONS_OFFSETS:

Re: [sqlite] Slow Transaction Speed?

> On Thu, May 28, 2009 at 03:12:55PM -0700, Allen Fowler scratched on the > wall: >> >> > just for anybody who is interested: >> >> > >> > I translated Jim's function into window code and added >> > a page of 1024 that will be written, instead of a single byte. >> > On my Win-XP system I got 55