Re: [sqlite] unsupported file format

"Michael P. Soulier" <[EMAIL PROTECTED]> wrote: > I checked with the maintainer, and he used the latest 3.3.10 sqlite. I > had the 3.3.8 .dll installed, I think. I just upgraded to 3.3.10 and > it's ok now. > > So, how would I work on, say, a couple of different windows boxes and > linux boxes,

Re: [sqlite] unsupported file format

.dump? :) I think this is more a question for DRH tho. Michael P. Soulier wrote: > I checked with the maintainer, and he used the latest 3.3.10 sqlite. I > had the 3.3.8 .dll installed, I think. I just upgraded to 3.3.10 and > it's ok now. > > So, how would I work on, say, a couple of different

Re: [sqlite] unsupported file format

I checked with the maintainer, and he used the latest 3.3.10 sqlite. I had the 3.3.8 .dll installed, I think. I just upgraded to 3.3.10 and it's ok now. So, how would I work on, say, a couple of different windows boxes and linux boxes, all sharing the same sqlite3 database file, but with

Re: [sqlite] Database is locked when working in 2 processes

This issue has been resolved. I did not call sqlite3_finalize() in the reader process and kept the READ lock How to read after the database was written by another process? Reading function should wait until other process finishes writing and unlocks the file. But in our case unlocking never

Re: [sqlite] DROP INDEX not freeing up memory

Sqlite is allocating cache memory and reusing it. That is not a bug, it is a beneficial feature. Dave Gierok wrote: Yes, I did try that -- I should have mentioned it. When I create and drop the index again, the amount of memory that Sqlite takes is effectively the same. That is, to create

Re: [sqlite] Database is locked when working in 2 processes

Many threads or process can read, but just one can write, and when is writen the DB is locked, even for read. How to read after the database was written by another process? Reading function should wait until other process finishes writing and unlocks the file. But in our case unlocking never

Re: [sqlite] DROP INDEX not freeing up memory

Dave Gierok <[EMAIL PROTECTED]> wrote: > > I am running an in-memory db and am using the functionality where > we override all the OS calls such that we implement our own memory > management and file IO. Therefore, I am able to easily track the > amount of memory Sqlite is taking up. I have

Re: [sqlite] unsupported file format

On 1/16/07, Bill KING <[EMAIL PROTECTED]> wrote: Err, s/qt/ROR/ So, the sqlite3-ruby gem needs rebuilding then? I don't have a build environment for windows. I guess I'll point this out to the gem maintainer. Odd that I'm not running into this on any other windows system. My Linux boxes are

[sqlite] Re: attempt to write a readonly database

never mind... user error... unbeknowst to me, someone as copying the file from one computer to another over an extremely slow network connection. d'oh On 1/16/07, P Kishor <[EMAIL PROTECTED]> wrote: I am getting the "attempt to write a readonly database" on a database that has no readonly

[sqlite] attempt to write a readonly database

I am getting the "attempt to write a readonly database" on a database that has no readonly settings, does not have any associated journal files hanging around, and is not being accessed by any other process. I am trying to drop a table from it using the sqlite3 shell. Any ideas? It is a

Re: [sqlite] unsupported file format

Michael P. Soulier wrote: > Hello, > > I just checked out my Rails project on windows, and I'm getting the error > > "ActiveRecord::StatementInvalid: SQLite3::SQLException: unsupported > file format: > SELECT * FROM icps" > > It seems to be coming from sqlite3 itself, not from the ActiveRecord >

Re: [sqlite] unsupported file format

Michael P. Soulier wrote: > Hello, > > I just checked out my Rails project on windows, and I'm getting the error > > "ActiveRecord::StatementInvalid: SQLite3::SQLException: unsupported > file format: > SELECT * FROM icps" > > It seems to be coming from sqlite3 itself, not from the ActiveRecord >

RE: [sqlite] DROP INDEX not freeing up memory

Yes, I did try that -- I should have mentioned it. When I create and drop the index again, the amount of memory that Sqlite takes is effectively the same. That is, to create the index once costs a lot of memory, and then future deletions/creations does not change the amount of memory

[sqlite] unsupported file format

Hello, I just checked out my Rails project on windows, and I'm getting the error "ActiveRecord::StatementInvalid: SQLite3::SQLException: unsupported file format: SELECT * FROM icps" It seems to be coming from sqlite3 itself, not from the ActiveRecord adapter. I've searched and found many

Re: [sqlite] Database is locked when working in 2 processes

Many threads or process can read, but just one can write, and when is writen the DB is locked, even for read. On 16/01/07, Yuriy Martsynovskyy <[EMAIL PROTECTED]> wrote: I have a problem with SQLite when accessing DB file from two processes. Process 1 is writing to the database periodically in

[sqlite] Database is locked when working in 2 processes

I have a problem with SQLite when accessing DB file from two processes. Process 1 is writing to the database periodically in autocommit mode. Process 2 only reads from the same database file. After awhile Process 2 starts getting "Database is locked " error and can not read anymore until you

Re: [sqlite] SQLite 3.3.10 compilation with VC++ for Win64

[EMAIL PROTECTED] wrote: "Ian Frosst" <[EMAIL PROTECTED]> wrote: Looking at the code, there are pointer to int truncations everywhere, Where, specifically, are you seeing pointer to int truncations in the SQLite code base? This is something that needs to be fixed. I've compiled 3.3.10

Re: [sqlite] Re: How to optimize a select that gets 17 rows from a 700k row DB (via perl using DBI)?

On Sat, Jan 13, 2007 at 06:35:20PM -0500, [EMAIL PROTECTED] wrote: > I guess that's the trick, to have the "current" or at least "recent" > database and then the historical one. As of now, the process of polling > the 17 machines takes about 40 seconds or so (when I first started running > the

Re: [sqlite] SQL query problem

Ahhh .. yes they do have commas in them. I'll remove the commas and try it again. Thanks, Umesh Dan Baker wrote: - Original Message - From: "Umesh Persad" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 16, 2007 10:32 AM Subject: [sqlite] SQL query problem

Re: [sqlite] SQL query problem

- Original Message - From: "Umesh Persad" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 16, 2007 10:32 AM Subject: [sqlite] SQL query problem Hi, I was wondering if anyone can help with a problem I have having with SQL. I have a table 'people' in a Sqlite

Re: [sqlite] SQL query problem

Hi Umesh, What is the table structure of your SQLite table? Is it what you want it to be? I am assuming "population" should be integer, as you can't really have fractional people. Did you check your imported data and see if it looks the same as in Excel? Did all the data import? Probably yes

[sqlite] SQL query problem

Hi, I was wondering if anyone can help with a problem I have having with SQL. I have a table 'people' in a Sqlite database with a column 'population'. All I want to do is to add up all the values in this column. When the data is in an Excel file, the column adds up to 8,581,774. I used the

RE: [sqlite] Is there a way to turn off -journal files?

Dave Gierok uttered: Yes, that's exactly what we do: use the in-memory db until it comes time to save, and then we open a file db, attach, and copy it to disk. At that time, the journal files are created. If there is a nice way to serialize an in-memory db to disk without having to

[sqlite] DROP INDEX not freeing up memory

Hello, I am running an in-memory db and am using the functionality where we override all the OS calls such that we implement our own memory management and file IO. Therefore, I am able to easily track the amount of memory Sqlite is taking up. I have noticed that when I call CREATE INDEX and

RE: [sqlite] Is there a way to turn off -journal files?

Yes, that's exactly what we do: use the in-memory db until it comes time to save, and then we open a file db, attach, and copy it to disk. At that time, the journal files are created. If there is a nice way to serialize an in-memory db to disk without having to open/attach to a file db, I'm

Re: [sqlite] SQLite 3.3.10 compilation with VC++ for Win64

"Ian Frosst" <[EMAIL PROTECTED]> wrote: > the two suspects I see in the warnings are: > > static int winFileHandle(OsFile *id) > { >return (int)((winFile*)id)->h; > } > > The HANDLE will be64 bit, then get trunc'd when cast (unless there is some > compiler magic afoot that I'm not aware of.)

[sqlite] Re: SQLite 3.3.10 compilation with VC++ for Win64

My first post sounded *way* too alarmist, I appologise. I should have chosen my words more carefully. the two suspects I see in the warnings are: static int winFileHandle(OsFile *id) { return (int)((winFile*)id)->h; } The HANDLE will be64 bit, then get trunc'd when cast (unless there is some

[sqlite] [ANN] SQLiteManager 2.5

VIADANA, Italy (January 16, 2007) - SQLabs today announced the availability of SQLiteManager 2.5, their new SQLite database manager tool for MacOS X and Windows. SQLiteManager is a "next generation" GUI database manager for sqlite databases, it combines an incredible easy to use interface