-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, February 10, 2006 7:41 PM
To: sqlite-users@sqlite.org; Chowdhury, Chandan Dutta
Subject: Re: [sqlite] unaligned access with sqlite 3.3.3 on IA64
"Chowdhury, Chandan Dutta" <[EMAIL PROTECTED]> wrote:
>
Jay Sprenkle wrote:
On 2/10/06, Fred Williams <[EMAIL PROTECTED]> wrote:
Well, unfortunately our bid'ness seems to be a "contact sport" for many.
I have been guilty of pretty much the same more times than I am proud
of. That said...
The question is quite valid. I do agree that something
Daniel Carosone <[EMAIL PROTECTED]> wrote:
>
> It seems a little odd to me to build a centralised, online
> information system for tracking state and documenting activity around
> and about source code in a distributed and disconnected VCS.
>
Ah yes, you're right. But in the system I
>It is a reasonable assumption to make that the only thing which can have
>changed since the last write is the disk becoming full. A disk cable falling
>off, head crash or mechanical disk failure is not only unlikely but would
>crash the entire machine and make error detection and recovery
Since the file access has already worked by this stage the "plethora" is
far smaller than you may have appreciated. It is a reasonable
assumption to make that the only thing which can have changed since the
last write is the disk becoming full. A disk cable falling off, head
crash or
[EMAIL PROTECTED] wrote:
Hamid Benhocine <[EMAIL PROTECTED]> wrote:
Hello, I m trying to upgrade from sqlite-3.2.7 on SGI IRIX64 to sqlite-3.3.3
The applications using sqlite-3.2.7 (compiled with mode 64 or 32 bits) work
fine. But the upgrade to sqlite-3.3.3 coredump on 64 bits when
On Feb 10, 2006, at 16:51, malcom wrote:
Hello,
I have a sqlite column with a string. This string is composed by n
different lines separated by an \n character. Each line is composed by
: . So my final string is something like this:
: \n
: \n
:
Now I need to search *only* inside a particular
On 2/10/06, Fred Williams <[EMAIL PROTECTED]> wrote:
> Well, unfortunately our bid'ness seems to be a "contact sport" for many.
> I have been guilty of pretty much the same more times than I am proud
> of. That said...
>
> The question is quite valid. I do agree that something must be amiss if
>
I suspect, although am not 100%, that a third-party database tool was
using the database file. As you say, I would have expected either that
tool or the actual program to have failed to open the file
However, we could be a lot more sure if we could see the Win32 error. In
the short-term I am
Hamid Benhocine <[EMAIL PROTECTED]> wrote:
> Hello, I m trying to upgrade from sqlite-3.2.7 on SGI IRIX64 to sqlite-3.3.3
> The applications using sqlite-3.2.7 (compiled with mode 64 or 32 bits) work
> fine. But the upgrade to sqlite-3.3.3 coredump on 64 bits when creating
> tables
> with the
Hello,
I've populated a 5MB database with a QT app.
I've got problem with a simple select query.
Here is the table's schema:
CREATE TABLE Perf ( IdEvent int,
IdComp int,
place smallint,
tps1 float,
pen1 smallint,
First, WHY move off sqlite.
Hosting companies are a dime-a-dozen.
sqlite is a library, it's part of your code, you are not asking the
provider to set up
or maintain another RDBMS engine.
Option one in my opinion is to find a cooperative hosting company and
move you
app unmodified.
IF your
At 09:00 AM 2/10/2006, [EMAIL PROTECTED] wrote:
>"Drew, Stephen" <[EMAIL PROTECTED]> wrote:
>> Hello,
>>
>> In sqlite3OsWrite function (in os_win.c) the following code exists:
>>
>> while( amt>0 && (rc = WriteFile(id->h, pBuf, amt, , 0))!=0 &&
>> wrote>0 ){
>>
>> amt -= wrote;
>>
>>
Hamid Benhocine <[EMAIL PROTECTED]> wrote:
> Hello, I m trying to upgrade from sqlite-3.2.7 on SGI IRIX64 to sqlite-3.3.3
> The applications using sqlite-3.2.7 (compiled with mode 64 or 32 bits) work
> fine. But the upgrade to sqlite-3.3.3 coredump on 64 bits when creating
> tables
> with the
Well, unfortunately our bid'ness seems to be a "contact sport" for many.
I have been guilty of pretty much the same more times than I am proud
of. That said...
The question is quite valid. I do agree that something must be amiss if
there is a requirement for a large number of columns in a
Hello, I m trying to upgrade from sqlite-3.2.7 on SGI IRIX64 to sqlite-3.3.3
The applications using sqlite-3.2.7 (compiled with mode 64 or 32 bits) work
fine. But the upgrade to sqlite-3.3.3 coredump on 64 bits when creating
tables
with the UNIQUE, PRIMARY constraints. I did not run in this
On Fri, Feb 10, 2006 at 04:44:30PM +0100, Fanda Vacek wrote:
> You can choose what to use. An Elephant or a Dolphin :))
Or you could use both! :P
http://commandprompt.com/images/mammoth_versus_dolphin_500.jpg
"Drew, Stephen" <[EMAIL PROTECTED]> wrote:
>>
> It's just a little bit misleading if you're not familiar with the
> circumstances it's raised in... I've had some confused colleagues
> wondering why their 100kb DB on a disk with 15gb free would be out of
> space :)
>
I'm curious. What was
Hello,
Thanks for the swift response.
Hmm I don't know to be honest, something generic perhaps like a failure
to write...
It's just a little bit misleading if you're not familiar with the
circumstances it's raised in... I've had some confused colleagues
wondering why their 100kb DB on a disk
On 2/10/06, m christensen <[EMAIL PROTECTED]> wrote:
> THANK YOU.
>
> Someone finally asked the right question instead of answering the
> original one.
>
> Why would you possibly need 1,000 columns in a single table?
Most people ask the little questions and don't give you the "big picture".
A lot
"Drew, Stephen" <[EMAIL PROTECTED]> wrote:
> Hello,
>
> In sqlite3OsWrite function (in os_win.c) the following code exists:
>
> while( amt>0 && (rc = WriteFile(id->h, pBuf, amt, , 0))!=0 &&
> wrote>0 ){
>
> amt -= wrote;
>
> pBuf = &((char*)pBuf)[wrote];
>
> }
>
> if( !rc ||
THANK YOU.
Someone finally asked the right question instead of answering the
original one.
Why would you possibly need 1,000 columns in a single table?
What are you trying to do?
Paul is probably correct and you don't really need to know how to create
a table
with a zillion columns
Hello,
In sqlite3OsWrite function (in os_win.c) the following code exists:
while( amt>0 && (rc = WriteFile(id->h, pBuf, amt, , 0))!=0 &&
wrote>0 ){
amt -= wrote;
pBuf = &((char*)pBuf)[wrote];
}
if( !rc || amt>(int)wrote ){
return SQLITE_FULL;
}
Is this really a
malcom <[EMAIL PROTECTED]> writes:
> Hello,
> I have a sqlite column with a string. This string is composed by n
> different lines separated by an \n character. Each line is composed by
> : . So my final string is something like this:
>
> : \n
> : \n
> :
>
> Now I need to search *only* inside a
> I have a sqlite column with a string. This string is composed by n
> different lines separated by an \n character. Each line is composed by
> : . So my final string is something like this:
>
> : \n
> : \n
> :
>
> Now I need to search *only* inside a particular key value. For example
> I would
Hello,
I have a sqlite column with a string. This string is composed by n
different lines separated by an \n character. Each line is composed by
: . So my final string is something like this:
: \n
: \n
:
Now I need to search *only* inside a particular key value. For example
I would to see if
You can choose what to use. An Elephant or a Dolphin :))
Fanda
On Thu, 09 Feb 2006 02:43:13 +0100, Jim C. Nasby <[EMAIL PROTECTED]>
wrote:
See also http://sql-info.de/mysql/gotchas.html.
About the only downsides I can think of with PostgreSQL is that it's
out-of-the-box configuration is
Nathan Kurz wrote:
Hello --
I'm trying to track down a segfault that happens when I'm using
DBD::SQLite for Perl, and I'm confused by the documentation for
sqlite3_column_decltype(). I think I understand what it does, but
I think there are some typos that make me uncertain:
On Fri, Feb 10, 2006 at 07:44:37AM -0500, Paul Tomblin wrote:
> Quoting James Biggs ([EMAIL PROTECTED]):
> > Hi. My problem is that i want to create a table which should have around
> > 1000
> > columns. Obviously, to add them manually would take a lot of time. Is there
> > a way to make this
Teg <[EMAIL PROTECTED]> wrote:
> I have a 15 gig database that I'm trying to "vacuum", the table
> structure's butt simple but, after running most of the night it tells
> me "Database is Full". Not sure exactly what that means.
>
> I have 24 gigs of disk space free on the disk so, I don't think I
I have a 15 gig database that I'm trying to "vacuum", the table
structure's butt simple but, after running most of the night it tells
me "Database is Full". Not sure exactly what that means.
I have 24 gigs of disk space free on the disk so, I don't think I ran
out.
SQlite3.exe is 3.2.2
The
"Chowdhury, Chandan Dutta" <[EMAIL PROTECTED]> wrote:
> Reading repository metadata in from local files
> yum(26535): unaligned access to 0x60404f44,
> ip=0x24e683e0
> yum(26535): unaligned access to 0x60405094,
> ip=0x24e683e0
> yum(26535): unaligned access to
chetana bhargav wrote:
>
> Hi,
>
> My requirement is that, I want to store some common properties and some
> more optional properties depending on the need of each application. Where
> these optional properties need to be stored as feild value pairs. Most of the
> values(almost 99.5%)
Hi,
My requirement is that, I want to store some common properties and some more
optional properties depending on the need of each application. Where these
optional properties need to be stored as feild value pairs. Most of the
values(almost 99.5%) values are of integer type. And there
On Feb 10, 2006, at 13:01, James Biggs wrote:
I can do for example
$dbh->do( "CREATE TABLE my_table (etc etc etc)");
but i don't know a Perl command for creating a table with many
columns. I
did not find one in the docs either. Thanks
The idea is that you build the SQL string
Hello All,
I am using sqlite-3.3.3 with yam and pysqlite on a RedHat Enterprise
Linux 4 IA64 machine. I get a lot of "unaligned access" message while
using yum.
# yum update
Setting up Update Process
Setting up repositories
os100% |=| 951 B
00:00
Markus Hoenicka <[EMAIL PROTECTED]> was heard to say:
Sorry for the typo, fixed below
my $command = "CREATE TABLE my_table (";
foreach my $counter (1..999) {
$command .= "INT column" . $counter . ", ";
}
$command .= "INT column1000)";
print $command;
--
Markus Hoenicka
[EMAIL PROTECTED]
James Biggs <[EMAIL PROTECTED]> was heard to say:
>
> I can do for example
>
> $dbh->do( "CREATE TABLE my_table (etc etc etc)");
>
> but i don't know a Perl command for creating a table with many columns. I
> did not find one in the docs either. Thanks
>
Something along these lines (untested!!)
I can do for example
$dbh->do( "CREATE TABLE my_table (etc etc etc)");
but i don't know a Perl command for creating a table with many columns. I
did not find one in the docs either. Thanks
--
View this message in context:
James Biggs <[EMAIL PROTECTED]> was heard to say:
>
> Hi. My problem is that i want to create a table which should have around 1000
> columns. Obviously, to add them manually would take a lot of time. Is there
> a way to make this automatically? Any program or a command? I have looked
> around
Hi. My problem is that i want to create a table which should have around 1000
columns. Obviously, to add them manually would take a lot of time. Is there
a way to make this automatically? Any program or a command? I have looked
around but not much luck. Thanks for looking
--
View this message in
41 matches
Mail list logo