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 w
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
"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.)
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 al
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 th
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 open/att
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 SQl
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 be
- 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 database with a column 'popu
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
Hi,
I was wondering if any
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
[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 (plu
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 close
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
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 instan
(I'm resending this, as I have not seen it posted the first time I sent -
apologies if it gets posted twice)
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 easi
Dave Gierok wrote:
(I'm resending this, as I have not seen it posted the first time I sent -
apologies if it gets posted twice)
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.
Therefo
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 allocated
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
> ad
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
> ad
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 large-ish
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 settin
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 fin
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 no
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 hap
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
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 happ
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
differen
.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 wi
"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, al
On 1/16/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Every version of SQLite will read and write databases generated by
all prior version of SQLite going back to 3.0.0. The reverse is
That's odd then, since my db was made with 3.3.8, but a ruby gem made
with 3.3.10 gave me this "unsupport
31 matches
Mail list logo