On 14 July 2010 17:24, Werner Smit wrote:
I'd however like to test this with a local server - is there a faq
somewhere about compressed ssh tunneling on oracle ports? Is it open
source? Have you done it yourself? What was speed improvement?
As mentioned by other posters, compressing on the
Tim Romano tim.romano...@gmail.com wrote:
So it would appear that if the numeric value to be inserted can be coerced
to INTEGER without loss, it will in fact become an INTEGER, otherwise it
stay what it was, REAL.
..., the behavior that is amply documented at http://sqlite.org/datatype3.html
Tim Romano tim.romano...@gmail.com wrote:
Ignore the typo:
should be 2 | 2.2
As someone who tends to make typogarphical errors, I do like forums with
post-editing capabilities much better than mailing lists.
I don't. While this capability can be used benignly - fixing a typo or two -
Looks like this warning can be safely ignored and internet even has
quite a few suggestions on its suppression. Here's what I found:
http://social.msdn.microsoft.com/Forums/en-US/vcgeneral/thread/195e7065-
b429-4324-9f38-35558867cfbd
http://www.tech-
Hi
We are building a Windows application using a read-only Sqlite database. When
executing many queries in a short time, we sometimes get SQLITE_CANTOPEN from
sqlite3_step. Checking GetLastError gives us error code 123: The filename,
directory name, or volume label syntax is incorrect. If we
On Jul 15, 2010, at 8:35 PM, Yoav Apter wrote:
Hi
We are building a Windows application using a read-only Sqlite
database. When executing many queries in a short time, we sometimes
get SQLITE_CANTOPEN from sqlite3_step. Checking GetLastError gives
us error code 123: The filename,
On Thu, Jul 15, 2010 at 04:35:56PM +0300, Yoav Apter scratched on the wall:
Using ProcMon we notice that when this happens, Sqlite is trying to
open a new file with a gibberish name which explains the OS error.
At what time does sqlite3_step needs top open a file (considering
the database is
Thanks. It is indeed a problem with a temp file - I set the temporary directory
with an uninitialized value.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Indeed, Igor, it is documented behavior, but my point was to reply to the
OP, who had written ruefully about SQLite's laissez-faire approach to
datatypes. For the OP's benefit, I wanted to demonstrate the behavior, show
what can be done with CAST, and then finally to show what can be done with
So if I'm reading the documentation correctly:
The wal-index is in shared memory, and so technically it does not have
to have a name in the host computer filesystem. Custom VFS
implementations are free to implement shared memory in any way they
see fit, but the default unix and windows
On 15 Jul 2010, at 4:52pm, Matthew L. Creech wrote:
This exists in many Linux systems as /dev/shm, or even /tmp would
work fine for a lot of users.
I don't think so. Just like the older SQLite journal system, it's important
that the WAL files survive through a crash. SQLite finds the WAL
I don't think so. Just like the older SQLite journal system, it's important
that the WAL files survive through a crash.
I believe WAL file is not a problem here (despite some confusing macro
name that Matthew proposed). The problem is SHM file which don't have
to survive - SQLite rebuilds it
On Thu, Jul 15, 2010 at 12:23 PM, Pavel Ivanov paiva...@gmail.com wrote:
I don't think so. Just like the older SQLite journal system, it's important
that the WAL files survive through a crash.
I believe WAL file is not a problem here (despite some confusing macro
name that Matthew
I have a file which contains SQLite and SQLite/SQL commands.
I can invoke that file and successfully execute all of the commands in that
file by starting a SQLite cmd line session and using the .read command.
I'll refer to that as script-C.
What I would like to do is create a higher
Hi,
How do I UN-subscribe from the mailing list?
Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello all,
I have two slightly related questions regarding sqlite database handles.
First, I'm developing a system that opens thousands of different
sqlite databases at a variety of times, some database handles more
often than others, but never the same one multiple times concurrently,
though
On 15 Jul 2010, at 7:04pm, Abder-Rahman Ali wrote:
How do I UN-subscribe from the mailing list?
Start by clicking the link included at the bottom of every post.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 15 Jul 2010, at 7:07pm, JT Olds wrote:
is there a way to check a prepared statement
before allowing its use as to if it will attempt to write to disk?
You could perhaps accept only statements that start with 'SELECT'. It depends
on how you're passing them to SQLite.
Simon.
Regarding: My question is, what command do I use in script-A to invoke
script-C, script-B, etc?
Is it the same .read command?
I believe it does work that way. What did you get when you tried it?
___
sqlite-users mailing list
On Thu, 15 Jul 2010 17:54:38 + (UTC), c...@comcast.net
wrote:
I have a file which contains SQLite and SQLite/SQL commands.
I can invoke that file and successfully execute all
of the commands in that file by starting a SQLite cmd
line session and using the .read command.
I'll refer to
You also need to watch for multiple command separated via ';'
On 7/15/2010 11:36 AM, JT Olds wrote:
I considered that also, but I wasn't sure about whether or not that
guaranteed no disk writes (maybe some sort of function call might be
made there). That also restricts things like the usage of
I just found an elegant query to identify duplicate entries in a
table. It is from Microsoft.
http://support.microsoft.com/kb/139444
Here's the information:
create table t1(col1 int, col2 int, col3 char(50))
insert into t1 values (1, 1, 'data value one')
insert into t1 values (1, 1, 'data
Uhh its cool but been around for over a decade at least. Sorry
Woody wizard at large(I'm in shape. Round is a shape)
Connected by MOTOBLUR™ on T-Mobile
-Original message-
From: Ted Rolle Jr. ster...@gmail.com
To: SQLite Database sqlite-users@sqlite.org
Sent: Thu, Jul 15, 2010 11:45:35
On Thu, Jul 15, 2010 at 02:44:54PM -0400, Ted Rolle Jr. scratched on the wall:
The first step is to identify which rows have duplicate primary key (my
table has no primary keys, but it still works) values:
If a set of columns has duplicate values they are, by definition,
not a primary key.
Thanks Kees for your response.
I tried embedding the .read command into my sql script files and it appears
to work fine.
One thing I don't like is having to specify the full path (relative to where
I'm invoking SQLite3 from) to each file I reference in the scripts I invoke
with .read.
* D. Richard Hipp:
An appliance manufacturer has discovered a database corruption issue
on Linux using ext3. The issue is documented here:
http://www.sqlite.org/draft/lockingv3.html#ext3-barrier-problem
It's a generic Linux problem, not an ext3-specific issue. Until
recently, the
On Thu, 15 Jul 2010 19:14:20 + (UTC), c...@comcast.net
wrote:
Thanks Kees for your response.
I tried embedding the .read command into my sql script files and it appears
to work fine.
One thing I don't like is having to specify the
full path (relative to where I'm invoking SQLite3
I really would rather not depend on what is in the SQL itself, as the
concern I have has nothing to do with whether or not the user runs
SELECT, but whether or not this will cause the library to write to
disk. I'd love to decouple those two things.
To that end, from an API perspective, is it safe
As additional help in gmail click on show details to see the link
On Thu, Jul 15, 2010 at 11:22 AM, Simon Slavin slav...@bigfraud.org wrote:
On 15 Jul 2010, at 7:04pm, Abder-Rahman Ali wrote:
How do I UN-subscribe from the mailing list?
Start by clicking the link included at the bottom of
On Jul 16, 2010, at 6:33 AM, JT Olds wrote:
I really would rather not depend on what is in the SQL itself, as the
concern I have has nothing to do with whether or not the user runs
SELECT, but whether or not this will cause the library to write to
disk. I'd love to decouple those two things.
30 matches
Mail list logo