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 thin
As additional help in gmail click on "show details" to see the link
On Thu, Jul 15, 2010 at 11:22 AM, Simon Slavin 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 every post.
>
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
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
* 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, th
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"
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
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."
To: SQLite Database
Sent: Thu, Jul 15, 2010 11:45:35 PDT
Subject: [sqlite] Removing duplicate
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 value
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
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 in-memory
temp tables that might be useful. It appears that sqlite knows whether
or not a statement will
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
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
sqlit
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.
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
http://sqlite.org:8080/cgi-
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 som
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
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 l
On Thu, Jul 15, 2010 at 12:23 PM, Pavel Ivanov 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 proposed). The proble
> 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 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
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 driver
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
CAST
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
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
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
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 op
> 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-
> archive.net/Archive/VC/microsoft.pub
Tim Romano 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 -
too often I see it
Tim Romano 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
--
Igor Tandetnik
__
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 th
31 matches
Mail list logo
