>you didn't happen to ftp any files in the incorrect mode did you?
>ascii rather than binary perhaps for the tar/tar.gz file?
>
Just downloaded the source, from sqlite.org
and that it. why?
-Rick
I work with spatial data, so I will take a stab at answering this.
On Sep 7, 2005, at 2:35 PM, Rajan, Vivek K wrote:
I have a need to store spatial and connectivity data (think verilog
netlist with x, y coordinate information) in a persistence on-disk
file.
I am looking at different SQL-based
SQLite Version: 3.2.5
Platform: Windows XP
I happen to have a bug in my wrapper that allowed an empty filename to
be passed on to sqlite3. I noticed from check-in 1085 that it opens a
temporary database, and seems to be acceptable behavior to go on with
life. I'm guessing this is an in
Why don't you try compiling it with gcc, in a shell?
Richard Nagle wrote:
Does anyone have a 3.2.x with all the updates, for importing spreadsheets, tab
delimited files..etc
already compiled for MacOS X (10.3.9 ) G4
Thanks -
Richard
PS: Yes, I did download the sorce code, and have xcode 1.5
Richard Nagle wrote:
Below is a snip it
of compiling sqlite using MacOS X 10.3.9
& Xcode 1.5 with XCODE updates of gcc
This would be the second time,
I wipe the hard drive, and re-install ALL,
and try this again, with the same results.
So, far no-one, was able to find the cause,
of these
Ralf Junker schrieb:
I don't like using the MSLU because its a dependency that up until now SQLite
has not had. Since the unicows.dll is not part of a standard Windows
installation, it would require developers to redistribute that DLL in addition
to the sqlite DLL.
I very much agree
On Tue, 2005-09-06 at 16:07 -0400, D. Richard Hipp wrote:
> On Tue, 2005-09-06 at 15:49 -0400, Mark Drago wrote:
>
> > 2. I could continue to write to the database in the single thread, but
> > if the write fails, add the data to a queue and continue. Then, when
> > another piece of data has to
Hi,
I have a huge (> 40 000 lines) insert-script I want to run.
Some of the lines may have something wrong with them, and I want to
check if there are are any errors on importing the data.
Is there a way to tell SQLite only to output the errors, instead of the
'successful' inserts?
Thanx,
On Wed, 2005-09-07 at 20:25 +0100, Brandon, Nicholas wrote:
>
> >take longer than 5 seconds. These reads are being done by PHP using the
> >PDO driver for sqlite3. My understanding of the problem is that the PHP
> >reader is holding a SHARED lock for longer than 5 seconds, so while the
> >C
I have a need to store spatial and connectivity data (think verilog
netlist with x, y coordinate information) in a persistence on-disk file.
I am looking at different SQL-based databases and am wondering if anyone
has recommendations/opinions on how good SQLite is for:
- Storing spatial data.
>take longer than 5 seconds. These reads are being done by PHP using the
>PDO driver for sqlite3. My understanding of the problem is that the PHP
>reader is holding a SHARED lock for longer than 5 seconds, so while the
>C program can acquire a PENDING lock, it can not get the EXCLUSIVE lock
Hello,
In attachement, there's a diff/patch against os_unix.c
in version 3.2.5.
Its allows threads to access successively to a DB handle
and remove the heavy restriction of the SQLITE_MISUSE.
In case of simultaneous access, threads get SQLITE_BUSY
until the OsFile is unlocked.
I test it a bit,
> > I'd like to create another table with
> > "AverageSalaries" combining the ID's from (a) and (b)
> > into a unique 8 byte ID. I'm thinking that the
> > columns would be "SuperID" (8 bytes integer created by
> > combining each ID from the city table with the ID from
> > each job table and
Below is a snip it
of compiling sqlite using MacOS X 10.3.9
& Xcode 1.5 with XCODE updates of gcc
This would be the second time,
I wipe the hard drive, and re-install ALL,
and try this again, with the same results.
So, far no-one, was able to find the cause,
of these errors... and garbage
--- Andrew Piskorski <[EMAIL PROTECTED]> wrote:
> That seems bizarre. Typical RDBMS practice would be
> to just use a
> two-column composite primary key.
>
>
> Did you measure a serious performance problem when
> joining on two
> separate columns?
>
You're right. It feels bizarre to me too.
On Wed, Sep 07, 2005 at 07:23:59AM -0700, Jay Siegel wrote:
> I'd like to create another table with
> "AverageSalaries" combining the ID's from (a) and (b)
> into a unique 8 byte ID. I'm thinking that the
> columns would be "SuperID" (8 bytes integer created by
> combining each ID from the city
On Sep 7, 2005, at 9:45 AM, Richard Nagle wrote:
Does anyone have a 3.2.x with all the updates, for importing
spreadsheets, tab delimited files..etc
already compiled for MacOS X (10.3.9 ) G4
Thanks -
Richard
PS: Yes, I did download the sorce code, and have xcode 1.5 installed
with all
On Wed, 2005-09-07 at 07:23 -0700, Jay Siegel wrote:
> 1. Is numeric column storage maintained in an
> endian-independent way?
Numbers are stored on disk in big-endian byte order.
> Can an 8 bytes
> numeric key be used or must if be treated as an 8 byte
> text field?
>
SQLite uses 64-bit
Does anyone have a 3.2.x with all the updates, for importing spreadsheets, tab
delimited files..etc
already compiled for MacOS X (10.3.9 ) G4
Thanks -
Richard
PS: Yes, I did download the sorce code, and have xcode 1.5 installed with all
the updates,
there is a major compiling error, going on,
Just testing to see if message is received.
Rick
I have two questions. I'm starting a large project
with SQLite on multiple platforms. I'm hoping I can
get some ideas about two issues:
1. Is numeric column storage maintained in an
endian-independent way? I need to port SQLite to a
platform that is in Motorola format (big endian) but
haven't
> Are all transactions database locks (not table locks)?
Yes.
> If I prepare a select statement and start stepping on Table A on process one
> and pause before finializing and do an update on Table B with process two or
> even the same process I will get a database is locked error?
Yes.
> Does
Hi,
> What about jffs2? I had added it to my system.
I'm using jffs2 in an embedded linux-arm application I'm putting together
with sqlite. I'm still in the early stages so don't have much sqlite
specific info. We have found that the wear leveling/garbage collection in
jffs2 works a lot better
AFAIK if you do not give an ORDER BY clause the db can give it to you
in any order it feels like.
On 9/6/05, Tom Deblauwe <[EMAIL PROTECTED]> wrote:
> Hello,
>
> If I do a select query, and that query uses an index, will the results
> come out sorted like the index? Or is that random?
>
> Kind
>I don't like using the MSLU because its a dependency that up until now SQLite
>has not had. Since the unicows.dll is not part of a standard Windows
>installation, it would require developers to redistribute that DLL in addition
>to the sqlite DLL.
I very much agree with Robert for the
The flash will die after a
while. How can I solve this problem. Thankyou.
The simplest solution is to use a filesystem with builtin
wear levelling. (Some flash chips also have it builtin
such as those from M-Systems).
You can get file systems that do wear levelling for
most embedded
Yes, and distributing the DLL may not be an option for some developers
(mostly Open Source developers). The EULA for UnicoWS.dll specifies,
among other things:
The intentions from the Microsoft chap who pushed unicows and
the license on the technical side:
Hello,
If I do a select query, and that query uses an index, will the results
come out sorted like the index? Or is that random?
Kind regards,
Tom
I found sqlite will update some fixed places
frequently in the database file when insert,update or
even create operation happens.It means that if my
database file in flash and I do high-frequency insert
or update(about 3000/day).The flash will die after a
while.How can I solve this problem.
Are all transactions database locks (not table locks)?
If I prepare a select statement and start stepping on Table A on process one
and pause before finializing and do an update on Table B with process two or
even the same process I will get a database is locked error? Do I understand
that this
30 matches
Mail list logo