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

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

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

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

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

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

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

Re: [sqlite] Database corruption on Linux ext3

* 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,

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

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

Re: [sqlite] Removing duplicate entries from a database

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

Re: [sqlite] Removing duplicate entries from a database

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

[sqlite] Removing duplicate entries from a database

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

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

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

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

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

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. >

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

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

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

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?

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

[sqlite] sqlite database handle caching and write permissions

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

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

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

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

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

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

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

> 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

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

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?

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

Re: [sqlite] error in sum function

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

[sqlite] SQLITE_CANTOPEN returned from sqlite3_step

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

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

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

[sqlite] SQLITE_CANTOPEN returned from sqlite3_step

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

Re: [sqlite] SqLite 3.7.0 amalgamation build warnings

> 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- >

Re: [sqlite] error in sum function

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

Re: [sqlite] error in sum function

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

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

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