Re: [sqlite] GROUP BY driving me crazy

ere I just specify an image as "featured". James On Wed, Nov 10, 2010 at 4:03 PM, Jim Morris <jmor...@bearriver.com> wrote: > If you would explain why/how the position value is significant that > might help. > > I fixed your pseudo SQL to run in SQLite Manager and I don

Re: [sqlite] GROUP BY driving me crazy

This will only display products which have items with images. I think I'm going to sit back and see if there's a simpler way to achieve what I'm trying to do. Maybe I'm going about this the wrong way, or I need to make some compromises. Thanks On Wed, Nov 10, 2010 at 3:01 PM, Igor Tandetnik

Re: [sqlite] GROUP BY driving me crazy

Sorry, I probably should've been clearer. I do have the data in place to filter by color. The problem is I can't get the image.filenames returned in the desired order. Even if I wanted to use group_concat, I still would want them in a particular order (based on images.position). On Wed, Nov

Re: [sqlite] GROUP BY driving me crazy

quot;, it would show the "sqlt-white.jpg" image. I'm not really working with t-shirts, but rather vehicle specific products. I just wish I was working with t-shirts, as I'd probably do this differently ;) Is this best left for post-processing outside the database? James On Wed, Nov 10, 201

[sqlite] GROUP BY driving me crazy

I've been fighting with this for a couple days now. I've been searching like mad, and thought I found solutions, but nothing seems to work. I think I may have reached the limit of my understanding :) This is just a simplified example of what I'm going after: SELECT products.id, products.name,

Re: [sqlite] VFS Layer for to split databaseinto several files?

discussing writing just such a layer, thought there might be something reusable :-) I will work on bringing the customer into the 20th century instead. Thanks! - James > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf

Re: [sqlite] EXTERNAL:Re: VFS Layer for to split database into several files?

it could be reasonably easy to turn one db file into, say, a series of four each with a maximum size of 2GB, and decide which fd to use based on the offset requested. Plus enough logic to keep pages in the same partition. Thanks, - James > -Original Message- > From: sqlite-user

Re: [sqlite] VFS Layer for to split database into several files?

Hi Michael, I'm trying to support a user running on an NFSv2 file server, which is limited to a maximum file size of 2GB. Thanks, - James > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Black, Michael (I

[sqlite] VFS Layer for to split database into several files?

a DISKIO feature that I'm frankly not familiar with. Has anyone come up with a solution that they would be willing to share? I am in a time crunch here and anything that would save me some time reaching a solution would be *much* appreciated. Thanks! - James

[sqlite] difficulty installing sqlite3 into rubygems

:in `require': no such file to load -- mkmf (LoadError) from extconf.rb:2:in `' Any thoughts? @james -- @ james sheldon @ http://www.jamessheldon.com @ voyager...@gmail.com ___ sqlite-users mailing list

Re: [sqlite] Bug in porter stemmer

fts4; I'm not sure how the two compare in terms of performance. Thanks again, James On Feb 24, 2010, at 7:05 AM, D. Richard Hipp wrote: > We got the Porter stemmer code directly from Martin Porter. > > I'm sorry it does not work like you want it to. Unfortunately, we > cannot

Re: [sqlite] Bug in porter stemmer

will just be forgotten others, as well as by me. How does this bug move from a message on a list to a ticket (and ultimately a patch, we hope) in the system? James On Feb 22, 2010, at 2:51 PM, James Berry wrote: > I'm writing to report a bug in the porter-stemmer algorithm supplied as p

[sqlite] Bug in porter stemmer

I'm writing to report a bug in the porter-stemmer algorithm supplied as part of the FTS3 implementation. The stemmer has an inverted logic error that prevents it from properly stemming words of the following form: dry -> dri cry -> cri This means, for instance, that the

[sqlite] Installation problem on OS-X 10.4

: assignment makes pointer from integer without a cast make: *** [shell.o] Error 1 I know next to nothing about installations like this. What should I do? James C. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin

[sqlite] negative numbers

I am writing an open source program. I am having trouble getting any results using this query. This returns none select * from signs where lon>-121 and lon<-119; onCreate(SQLiteDatabase db) { db.execSQL("CREATE TABLE " + TABLE_NAME + " (" + _ID + " INTEGER PRIMARY KEY

[sqlite] contribution: fts3 porter stemmer enhancements to handle common european accents

so far, these small changes have meant that we now normalize away all of the important utf-8 characters in our input text, which gives us 100% searchability of significant input tokens. The patch (to the 3.6.22 amalgamation) is attached. James ___

[sqlite] Surprisingly slow performance

, I'm inside a single transaction; the sequence of operations is the problematic select, followed by an insert; repeated several thousand times. Hopefully that's all clear - if not, I can supply an example database file, or an EXPLAIN output of the select operation. Regards, James

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

On Jul 6, 2009, at 3:14 PM, Nicolas Williams wrote: > On Mon, Jul 06, 2009 at 02:49:07PM -0700, James Gregurich wrote: >> 1) Why on earth would you want to scroll all the way to the bottom of >> a long email to get the response simply for the sake of "We read >> Engli

Re: [sqlite] referential integrity and INSERT OR REPLACE

based on the test I just ran, it reports the first one encountered only. On Jul 6, 2009, at 2:53 PM, Nicolas Williams wrote: > On Sat, Jul 04, 2009 at 10:24:50AM +0200, Kees Nuyt wrote: >> On Fri, 03 Jul 2009 14:38:43 -0700, James Gregurich >> <bayouben...@mac.com> w

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

ey is used): > - before insert > - before delete > - after delete > - after insert On Jul 6, 2009, at 1:15 PM, Simon Slavin wrote: > Please quote previous text above your response to it. We read English > top to bottom. > > On 6 Jul 2009, at 8:22pm, James Gregurich wro

Re: [sqlite] plans for completion of INSERT OR REPLACE INTO?

On Jul 6, 2009, at 3:53 AM, Simon Slavin wrote: > (Sorry, hit 'Send' before I meant to.) > > On 6 Jul 2009, at 6:34am, James Gregurich wrote: > >> a question for the sqlite developers. >> >> The inability of "INSERT OR REPLACE" to maintain referen

[sqlite] plans for completion of INSERT OR REPLACE INTO?

EPLACE" to call delete triggers so that referential integrity can be maintained? thanks, James ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] How to refer to a multiple-column primary key (PK) as 1 column (field) name

I have the following: CREATE TABLE [Sections] ( [Department] varchar NOT NULL COLLATE NOCASE, [Course] varchar NOT NULL COLLATE NOCASE, [Section] varchar NOT NULL COLLATE NOCASE, [Class_Time] timestamp, [I_Id] varchar COLLATE NOCASE, [Room] varchar COLLATE NOCASE, CONSTRAINT

Re: [sqlite] referential integrity and INSERT OR REPLACE

nuts. that makes INSERT OR REPLACE worthless if you have tables dependent on one another. Is there any way to manually get a list of records for which there would be a conflict if a given record was inserted? > On Fri, 03 Jul 2009 11:29:14 -0700, James Gregurich > <bayouben..

Re: [sqlite] referential integrity and INSERT OR REPLACE

I read on another posting in the archives that it does not. However, I haven't tried it myself. -James > Simon Slavin > Fri, 03 Jul 2009 09:44:22 -0700 > > On 3 Jul 2009, at 3:28am, James Gregurich wrote: > > > How do I maintain referential integrity on a INSERT OR REPL

[sqlite] referential integrity and INSERT OR REPLACE

question: How do I maintain referential integrity on a INSERT OR REPLACE given it does not call the delete trigger on the offending rows? thanks, james ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman

Re: [sqlite] getting offending constraint

d INTEGER); CREATE TRIGGER trig BEFORE INSERT ON test1b BEGIN SELECT CASE WHEN (1) THEN RAISE(ABORT, 'no parent element') END; END; COMMIT; sqlite> INSERT INTO "test1b" VALUES(1,10,20); SQL error: no parent element sqlite> On Jul 1, 2009, at 6:40 PM, Simon Slavin wrote: >

Re: [sqlite] getting offending constraint

thanks. I tried that, but I still got back "constraint failed" rather than my RAISE message. Since you say it should work, I probably did something wrong. I'll look at it again. On Jul 1, 2009, at 3:59 PM, Simon Slavin wrote: > > On 1 Jul 2009, at 8:19pm, James Gregurich w

Re: [sqlite] getting offending constraint

ah. I have no knowledge of how mailing list programs work. no "poor etiquette" was intended. On Jul 1, 2009, at 1:41 PM, P Kishor wrote: > On Wed, Jul 1, 2009 at 3:39 PM, James Gregurich<bayouben...@mac.com> > wrote: >> >> How would I have "hij

Re: [sqlite] getting offending constraint

How would I have "hijacked" a thread? I changed the subject and removed the original text. On Jul 1, 2009, at 12:32 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > James Gregurich wrote: >> >> howdy! > > You hijacke

[sqlite] getting offending constraint

howdy! Would there be a way to identify the offending constraint if "SQLITE_CONSTRAINT" is returned? sqlite3_errmsg is just telling me "constraint failed"...which is of limited usefulness. -James ___ sqlite-users maili

Re: [sqlite] [noob] merge statement equivalent?

thanks! On Jun 18, 2009, at 6:01 PM, Dennis Cote wrote: > James Gregurich wrote: >> on that update statement, is the SQL optimizer smart enough to not >> rerun that select statement for each column in the update's set >> clause? Is it going to run a single select statem

Re: [sqlite] [noob] merge statement equivalent?

oops. sorry for errant message, folks. I had the wrong email selected when I hit the button and didn't pay attention to what I was doing. On Jun 17, 2009, at 3:19 PM, James Gregurich wrote: > > So what are you going to do? we need to get your plans pinned down. > > On Jun 17, 20

Re: [sqlite] [noob] merge statement equivalent?

So what are you going to do? we need to get your plans pinned down. On Jun 17, 2009, at 11:46 AM, James Gregurich wrote: > > Dennis, > > question on an old post of yours below... > > > on that update statement, is the SQL optimizer smart enough to not > rerun that s

Re: [sqlite] [noob] merge statement equivalent?

column in the update statement? -James > Petite Abeille wrote: > > > > How does one emulate a DML MERGE statement in SQLite [1]? > > > > INSERT OR REPLACE sounds promising but the REPLACE documentation > under > > the ON CONFLICT clause seems to imply

[sqlite] append table

t2 and issue a "INSERT INTO t1 SELECT * FROM d2.t2;" query. Is that correct? Is there a better way? Is this operation inefficient or pitfalls any pitfalls to watch out for? -James ___ sqlite-users mailing list sqlite-users@sqlite.org http

Re: [sqlite] mutex and begin/end transaction

ithesis of politics. There are no facts in > science, > only observations and any hypothesis is only valid until a better one > replaces it. > > You describe bad, politicized science. > > James Gregurich wrote: >> With all due respect, science itself is a set of >>

Re: [sqlite] mutex and begin/end transaction

in an uncontrollable environment (i.e. a consumer desktop computer) when I can just use NSOperation, boost::thread, and boost::mutex to build a single-process solution that shares data in a normal way between tasks? James Gregurich Engineering Manager Markzware On Apr 29, 2009, at 11:23 PM

Re: [sqlite] mutex and begin/end transaction

had to come up with a scheme to throttle the task queue once memory consumption reached a certain level. As for the quality of staff members, that is always a challenge. All I can do about that is recruit and retain people who are talented and can write solid code. -James On Apr 30, 2009

Re: [sqlite] mutex and begin/end transaction

in an uncontrollable environment (i.e. a consumer desktop computer) when I can just use NSOperation, boost::thread, and boost::mutex to build a single-process solution that shares data in a normal way between tasks? James Gregurich Engineering Manager Markzware On Apr 29, 2009, at 11:23 PM

Re: [sqlite] mutex and begin/end transaction

rograms doesn't mean threaded programs are inherently doomed to be ill-conceived. The development tools and techniques for building concurrent systems are advancing and making concurrency quite feasible. James Gregurich Engineering Manager Markzware On Apr 30, 2009, at 5:01 AM, John Stanton w

Re: [sqlite] mutex and begin/end transaction

is a major part of that effort. As I understand it, MS is developing their copy of NSOperation for VS2010. The development landscape is only going to get more threaded as time goes on. -James > On Apr 29, 2009, at 10:03 PM, James Gregurich wrote: > > > howdy! >

[sqlite] mutex and begin/end transaction

howdy! question: for an in-memory db with the threading mode set to serialized, is the internal mutex held for an entire transaction so that one thread won't access the db while another one is in the middle of a transaction with multiple insert statements? thanks for any info. James

Re: [sqlite] Bug or working as designed?

James Sheridan wrote: > CREATE TABLE [Query] ( > [id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, > [creatorID] INTEGER NOT NULL, > [ownerID] INTEGER NOT NULL, > [type] VARCHAR NOT NULL > ); > CREATE TABLE [UserQuery] ( > [u

[sqlite] Bug or working as designed?

JOIN gets around this, but the original question still stands :) Thanks. -- James Sheridan Tenable Network Security ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Adding index to table makes SELECT much slower. Why?

e data (450Mb) which exhibits the same behaviour. The data is public (it is from the National Ocean Database), and so if anyone wants to see it I would be happy to put it on my web server. Cheers, and thanks to everyone who helped me! Jamie Pringle On Wed, Oct 8, 2008 at 6:50 PM, James Pring

[sqlite] Adding index to table makes SELECT much slower. Why?

Hi- I am new to sqlite, and am having a puzzling problem. I have read that adding an INDEX to a sqlite table can never make a SELECT statement slower. However, in my case, it seems to be making the select statement an order of magnitude slower, which is not what I wanted! What could be going

[sqlite] Data Analysis help

nyone that may be willing to help. Thanks and cheers James -- -- -- "Problems are solved by method" ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] NOT LIKE statement

operation of the LIKE operator are '%' and '_'. Regards, Simon 2008/6/25 James <[EMAIL PROTECTED]>: > Hi, Simon: >Thanks for help me solve this problem. >I have study the link you give me. But I still don't understand why > my original SQL statement can't work.

Re: [sqlite] NOT LIKE statement

Hi, Simon: Thanks for help me solve this problem. I have study the link you give me. But I still don't understand why my original SQL statement can't work. Could you explain in detail? Thank you. James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

Re: [sqlite] NOT LIKE statement

: [sqlite] NOT LIKE statement Hi James, I think the problem lies with your expectations. Read the section on the LIKE operator in http://www.sqlite.org/lang_expr.html Rgds, Simon 2008/6/25 James <[EMAIL PROTECTED]>: > Hi, > > I execute the SQL statement [SELECT Name FROM

[sqlite] NOT LIKE statement

. James Liang ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Corrupted sqlite_sequence table

I would remove the leading/trailing quotes external to the import of the file, using something like sed or gawk. I couldn't work out how to do this purely using sqlite, however. _ It's simple! Sell your car for just $30 at

Re: [sqlite] multiple writers for in-memory datastore

interesting. thanks for the tip. I"ll give it some consideration. -James On Apr 21, 2008, at 1:07 :50PM, Scott Hess wrote: > If you create a file on disk and set PRAGMA synchronous = OFF, you > should get pretty close to the performance of a shared in-memory > database on most

[sqlite] Select TOP n

get around it? Or is it there and I've missed it? TIA, James No virus found in this outgoing message. Checked by AVG. Version: 7.5.524 / Virus Database: 269.23.2/1387 - Release Date: 19/4/2008 11:31 ___ sqlite-users mailing list sqlite-users@sqlite.org http://

Re: [sqlite] multiple writers for in-memory datastore

. Actually, CoreData is what I intended to use at first. However, I have explored the possibility of directly using SQLite instead to keep my document readers and their data management cross-platform. On Apr 20, 2008, at 8:31 AM, Dennis Cote wrote: > James Gregurich wrote: >> I think

Re: [sqlite] multiple writers for in-memory datastore

oh well. I think I will go with CoreData on MacOSX and figure out something else to do on Windows later. my thanks to all who attempted to provide a solution. -James ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

Re: [sqlite] multiple writers for in-memory datastore

new file in vfs, a new handler is created and > assigned to > that filename and registered in this map. > > > > > > > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of James Gregurich > Sent: sábado, 19 de abril de 2008 17:02 > T

Re: [sqlite] multiple writers for in-memory datastore

system. -James On Apr 19, 2008, at 12:03 PM, Virgilio Fornazin wrote: > what about creating a VFS for such task ? Can be accomplished in > many ways, > using heap memory, shared memory... not so easy to do, but not much > complicated too... locking can be provided by multiple-read

Re: [sqlite] multiple writers for in-memory datastore

on simultaneously on the same connection but each insert operation going into a different attached in-memory db. On Apr 19, 2008, at 9:20 AM, Dan wrote: > > On Apr 19, 2008, at 6:06 AM, James Gregurich wrote: > >> >> I'll ask this question. The answer is probab

Re: [sqlite] multiple writers for in-memory datastore

an I share the connection across the 2 threads if each thread works exclusively in its own db? I am aware that the connection is generally not threadsafe, but will it work if the two threads don't operate on the same db at the same time? tha

Re: [sqlite] multiple writers for in-memory datastore

On Apr 18, 2008, at 2:33 :32PM, Dennis Cote wrote: > > To share an attached database the threads must be able to name it, and > this is only possible with a file database. you could change the open() function to be able to assign a name to an in-memory db and then keep a mapping of all the

Re: [sqlite] multiple writers for in-memory datastore

On Apr 18, 2008, at 1:25 :36PM, Dennis Cote wrote: > James Gregurich wrote: >> >> suppose I create a temporary db file on disk. Each task ( a thread) >> opens a connection to the temp file and attaches an in-memory db to >> it. > > You will have to open the memor

Re: [sqlite] multiple writers for in-memory datastore

full concurrency on my writer tasks until they are ready to flush their results to the disk file? As I understand it, the attached db won't be locked by reading done on the disk file. thanks, James On Apr 18, 2008, at 10:33 :39AM, Dennis Cote wrote: > James Gregurich wr

Re: [sqlite] multiple writers for in-memory datastore

an in-memory data stores to another one via the C API belong on the sqlite-dev list? thanks, James On Apr 18, 2008, at 9:43 :22AM, John Stanton wrote: > Just use a thread as a DB handler. Queue transactions to it using > some > IPC mechanism like a message queue or named pipe. Another

[sqlite] multiple writers for in-memory datastore

. Is there a way to attach an existing in-memory store to another in-memory store? If not, how hard would it be to modify the sqlite source to allow such an attachment to be made given the two connection pointers to two independent stores? thanks, James Gregurich

Re: [sqlite] sqlite3_get_table only get 16 rows

Sorry, I have already solved! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of James Sent: Tuesday, March 11, 2008 4:34 PM To: sqlite-users@sqlite.org Subject: [sqlite] sqlite3_get_table only get 16 rows Hi, I use command-line to query

[sqlite] sqlite3_get_table only get 16 rows

Hi, I use command-line to query the table: # sqlite3 listtable sqlite> select Name,Value from TblDeviceInfo; AdditionalHardwareVersion AdditionalSoftwareVersion Description DeviceLog DeviceStatus EnabledOptions FirstUseDate HardwareVersion

Re: [sqlite] Odd problem with select on large table

On the command line: / > sqlite3 test.db `select name from PerfTest1 where name = "key5000"' does work. I know this because if I query for "key500" I get back that row. It's not blanks either because if I do: where name link "key1%" I only get rows prior to "key199". Very weird. I did

Re: [sqlite] Performance

> > >That's sounds like good advice. I'll do that. >> >> Working with flash in this way is going to be a challenge. With limited >> number of writes in a lifetime (this device needs to last approx 20 >> years...) I will have to make some major design decisions around how >> I handle the writes.

Re: [sqlite] Performance

> One thing I can highly recommend on embedded systems, especially flash > based ones, is turn pragma synchronous to off. Having sqlite write every > record modification to the flash, is a stunningly expensive process, > even when it's all encapsulated in a large transaction. Let linux handle >

Re: [sqlite] Performance......

> > >I'm in the process of architecting the software for an embedded Linux system >> that functions as a remote and local user interface to a control system. >> There >> will be a lot of analog (fast) data arriving via SPI bus and I'm thinking of >> using SQLite to store this data in a well

Re: [sqlite] Performance

>I'm in the process of architecting the software for an embedded Linux system >> that functions as a remote and local user interface to a control system. >> There >> will be a lot of analog (fast) data arriving via SPI bus and I'm thinking of >> using SQLite to store this data in a well

RE: [sqlite] Using LIKE to check the first digits?

t; > this? > > > > WHERE col LIKE '123%' > > or WHERE substr(col,1, 3) = '123' One note: The optimizer has a decent chance of using an index for LIKE '123%' but I'd be surprised (and impressed) if it looks inside function calls such as substr for opportunities to use indexes. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Solaris bus error

async3-1.0... Ok > async3-1.1...make: *** [test] Bus Error (core dumped) > > Any ideas? Getting a stack trace out of that core file with a debugger would seem to be the next step, and seeing the full text output if there is any more. -- James -

RE: [sqlite] Solaris make test compilation error

ritten to > .libs/testfixture > > collect2: ld returned 1 exit status > > make: *** [testfixture] Error 1 > > > > So how does a thread yield its timeslice on solaris? sched_yield is there, it just needs -lrt

RE: [sqlite] Odd issue when SELECT querying

gchar > > Now it works !! > > A newbie error... Now you just need to watch out for memory leaks. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Odd issue when SELECT querying

rs can return std::string objects and avoid this issue (though even in C++ it's important to consider validity/lifetime issues for both pointers and iterators). -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] How to specify regular expression in a query?

-defined functions interface > does not allow for this sort of optimization. Right, which is why this conversation is about extending that interface :) > Or did I miss something? No, I think you're in "violent agreement". -- James ---

RE: [sqlite] order by issue?

rily by b (with the default, ascending, order) and secondarily by a (with inverted/descending order). select * from tst order by b desc, a desc; might be what you were wanting? -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Query problem

> -Original Message- > From: Dennis Cote [mailto:[EMAIL PROTECTED] > Sent: Wednesday, January 23, 2008 3:08 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Query problem > > James Dennett wrote: > > > > Square brackets don't "escape&quo

RE: [sqlite] Query problem

ning only the character '['. [][], however, is a character class containing two characters. The special rule is that the first character after the opening '[' is part of the class even if it's a ']' or a '-'. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Query problem

authentic C-shell? > What do they do? C shell on Solaris 9 gives an error on echo [!c]* as it considers the !c to be an event specification. Tcsh the same. Ksh treats echo [^c]* the same as echo c* but does "the right thing" with echo [!c]* bash treats the two the same

[sqlite] How to repaire Sqlite3 database

isk is full > > > Thanks in advance! > James >

[sqlite] Re: ezmlm response

isk is full > > > Thanks in advance! > James >

RE: [sqlite] Re: Access from Multiple Processes

o access the database. So something odd is happening, but I don't think you've shared enough information for this list to guess what. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] sqlite3 performace

utex > > This seems to work well except I have noticed some performance issue when > the database grows beyond a MB. Why not move the Open/Close outside of the mutex, hold a connection open, and re-use it for all queries? Otherwise you're making SQLite reload the schema def

Re: [sqlite] Sqlite File Access Restriction

On Jan 9, 2008 1:12 PM, Dean Brotzel <[EMAIL PROTECTED]> wrote: > > 1) Sqlite database file access restriction: Is there a built-in or > preferred method to block other processes from writing or even accessing > a database file when its opened first by another process. I can get this > to work by

RE: [sqlite] Syntax for Multi-table Join

A tired James wrote: > > select foo as bah from baz, not select foo from baz as bar, I think. > > -- James Evidently I don't think too well this afternoon; please disregard this... -- James - To unsub

RE: [sqlite] Syntax for Multi-table Join

WHERE f.parent=v.name AND f.comp=v.comp_name and > f.subcomp=v.subcomp_name) > > SQL error: near "as": syntax error > >A clue stick is appreciated. select foo as bah from baz, not select foo from baz as bar, I think. -- James --

[sqlite] "Can't we all just get along?" [Was: RE: [sqlite] "always-trim" - feature suggestion]]

there are disagreements on what constitutes "improvement", and even that there will be tensions as the forces behind those disagreements are resolved. Let's not waste time debating perceived insults on the list? Regards, James - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Encryption?

On Wed, 2007-12-19 at 16:10 -0800, James Dennett wrote: > > -Original Message- > > From: Jason Tudor [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, December 19, 2007 4:06 PM > > To: sqlite-users@sqlite.org > > Subject: [sqlite] Encryption? > > >

RE: [sqlite] Encryption?

n. > Also, can I use extensions other than .db for SQLite database files? Certainly; SQLite doesn't care about the filename conventions. -- James - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

topic, and I shall hence forth cease to contribute to this, and related threads. Regards, James. - To unsubscribe, send email to [EMAIL PROTECTED] -

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

Look out for Tux! At every planning meeting I push open source, and cross platform solutions, because I know today the majority is still under Bill's spell, but the magic in Vista is fading... Ciao. James. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] DeviceSQL

sers, and an active and helpful user forum, which gives me good vibes at least. Cheerio, James. - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] DeviceSQL

steveweick wrote: Richard has it right this time. Today DeviceSQL uses no SQLite code. One of the things we might consider is bolting the SQLite parser/front end to our table engine, in theory to get the both worlds. Just an idea at the moment. Such an interesting discussion to be

Re: [sqlite] Seg fault after calling sqlite3_exec while running under cygwin

On Mon, 2007-12-10 at 20:37 -0700, John Williams wrote: > Since I'm not really sure where the problem is I've attached a zip of my c > files. AptAssist.c is my main file and contains the full program. > Temp.cis a simple pull out of the problem function. I didn't get an attachment. Did anyone?

RE: [sqlite] version 3.3.12 -- malformed schema after using "limit 0" ??

le" and there was *no* integrity_check failure. Same > with version 2.8.13 (sqlite.exe). > > Is this an easily-repeatible issue, or do I have some corrupted files > somewhere? With your recipe, I

RE: [sqlite] SQLite Manager Firefox extension

resources > and causing Firefox to come up with "stop script" dialogs. > > Otherwise, a nice UI. I agree with both comments. Big tables are slow to load, but otherwise, great. Regards, James. - To unsub

<    4   5   6   7   8   9   10   11   >