Re: [sqlite] sqlite database handle caching and write permissions

2010-07-15 Thread Dan Kennedy
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

Re: [sqlite] How do I UN-subscribe from the mailing list?

2010-07-15 Thread Jim "Jed" Dodgen
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. >

Re: [sqlite] sqlite database handle caching and write permissions

2010-07-15 Thread JT Olds
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

Re: [sqlite] How to invoke successive SQLite script files

2010-07-15 Thread Kees Nuyt
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

Re: [sqlite] Database corruption on Linux ext3

2010-07-15 Thread Florian Weimer
* 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

Re: [sqlite] How to invoke successive SQLite script files

2010-07-15 Thread ca44
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"

Re: [sqlite] Removing duplicate entries from a database

2010-07-15 Thread Jay A. Kreibich
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

Re: [sqlite] Removing duplicate entries from a database

2010-07-15 Thread Woody & Yuni Ho
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

[sqlite] Removing duplicate entries from a database

2010-07-15 Thread Ted Rolle Jr.
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

Re: [sqlite] sqlite database handle caching and write permissions

2010-07-15 Thread Jim Morris
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

Re: [sqlite] sqlite database handle caching and write permissions

2010-07-15 Thread JT Olds
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

Re: [sqlite] How to invoke successive SQLite script files

2010-07-15 Thread Kees Nuyt
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

Re: [sqlite] How to invoke successive SQLite script files

2010-07-15 Thread Griggs, Donald
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

Re: [sqlite] sqlite database handle caching and write permissions

2010-07-15 Thread Simon Slavin
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.

Re: [sqlite] How do I UN-subscribe from the mailing list?

2010-07-15 Thread Simon Slavin
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-

[sqlite] sqlite database handle caching and write permissions

2010-07-15 Thread JT Olds
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

[sqlite] How do I UN-subscribe from the mailing list?

2010-07-15 Thread Abder-Rahman Ali
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

[sqlite] How to invoke successive SQLite script files

2010-07-15 Thread ca44
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

Re: [sqlite] WAL: no longer able to use read-only databases?

2010-07-15 Thread Matthew L. Creech
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

Re: [sqlite] WAL: no longer able to use read-only databases?

2010-07-15 Thread Pavel Ivanov
> 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

Re: [sqlite] WAL: no longer able to use read-only databases?

2010-07-15 Thread Simon Slavin
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

Re: [sqlite] WAL: no longer able to use read-only databases?

2010-07-15 Thread Matthew L. Creech
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

Re: [sqlite] error in sum function

2010-07-15 Thread Tim Romano
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

[sqlite] SQLITE_CANTOPEN returned from sqlite3_step

2010-07-15 Thread Yoav Apter
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

Re: [sqlite] SQLITE_CANTOPEN returned from sqlite3_step

2010-07-15 Thread Jay A. Kreibich
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

Re: [sqlite] SQLITE_CANTOPEN returned from sqlite3_step

2010-07-15 Thread Dan Kennedy
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

[sqlite] SQLITE_CANTOPEN returned from sqlite3_step

2010-07-15 Thread Yoav Apter
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

Re: [sqlite] SqLite 3.7.0 amalgamation build warnings

2010-07-15 Thread Nick Shaw
> 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

Re: [sqlite] error in sum function

2010-07-15 Thread Igor Tandetnik
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

Re: [sqlite] error in sum function

2010-07-15 Thread Igor Tandetnik
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 __

Re: [sqlite] EXTERNAL:Re: Sqlite Insert Speed Optimization

2010-07-15 Thread Paul Corke
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