[sqlite] Point a newbie in the right direction ;)

2009-03-09 Thread Monte Milanuk
Hello all. New guy here ;) I started working my way through a Python programming book, and got introduced to SQLite on one of the Python mailing lists. I have a particular project goal in mind for when I get a little further along with Python - making a cross-platform application for running

Re: [sqlite] Formatted text with fts3

2009-03-09 Thread Alexandre Courbot
Never did this myself, but I think you can do what you need by writing your own tokenizer: http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/fts3/README.tokenizers Alex. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] bad index selection?

2009-03-09 Thread Derek Scherger
On Mon, Mar 9, 2009 at 12:08 AM, Igor Tandetnik wrote: > > It can't. "hash" column is not part of the index. > Right... I should have seen that. > > Would re-ordering our unique index to be (name, id, value, ...) > > rather than (name, value, id, ...) allow a query with

[sqlite] Formatted text with fts3

2009-03-09 Thread Paul Perry
I've been looking into the full text search capabilities of SQLite and it looks like exactly what I need. Cool stuff, especially in the confines of all the other great features of SQLite. The question is if I could put formatted text in a text field, and not have that show up in a full text

Re: [sqlite] how to do fulltest with amalgamation source

2009-03-09 Thread Kees Nuyt
On Mon, 9 Mar 2009 14:54:45 -0500 (CDT), Tim Mooney wrote: > >All- > >If this is a FAQ, please point me at the answer. I've looked in the FAQ, >skimmed and grepped the archives for this list, read the >http://www.sqlite.org/testing.html page and others and still don't have

Re: [sqlite] how to do fulltest with amalgamation source

2009-03-09 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tim Mooney wrote: > I can't find any test target whatsoever with the amalgamation source. Note that fulltest also includes more code to do things like fake IO errors and running out of memory. > I can download that would add at least some >

[sqlite] extra character when reading SQL file

2009-03-09 Thread anjela patnaik
Hello,   I noticed that when I .read a SQL file with insert statements, sqlite is inserting an \r before the \n for multiline chars. So I had to regsub out the \r char. Is there a way to override this extra char?   I'm on Windows2k   Thank you

[sqlite] how to do fulltest with amalgamation source

2009-03-09 Thread Tim Mooney
All- If this is a FAQ, please point me at the answer. I've looked in the FAQ, skimmed and grepped the archives for this list, read the http://www.sqlite.org/testing.html page and others and still don't have an answer, so I thought I would pose the question here. I've been building sqlite from

Re: [sqlite] SQLite Transaction Rate and speed...

2009-03-09 Thread Doug
Not sure if it would work in your situation, but I got a good performance boost in a similar situation by essentially queuing all the updates in memory (not using SQLite), and eventually flushing thousands of queued updates as a single transaction. Worked great and was simple to implement, with

Re: [sqlite] SQLite Transaction Rate and speed...

2009-03-09 Thread VF
Hi SQLite Gurus, I am a pretty new SQLite user, and looks like (from the research I've made so far) I am facing a pretty typical problem with the product - performing millions upserts as fast as possible. The good news is - there's no concurrent access involved - it's pretty much a single Perl

Re: [sqlite] SQLite Transaction Rate and speed...

2009-03-09 Thread Chris Wedgwood
On Fri, Mar 06, 2009 at 12:27:32PM -0800, Nuzzi wrote: > I have a project where I have to be determining if a row exists, if > so get the data, change it, and then write it back, if not, then > just writing the data. I have to be able to do millions of these > per minute. Is that pretty much

Re: [sqlite] SQLite Transaction Rate and speed...

2009-03-09 Thread Shane Harrelson
Already there: http://www.sqlite.org/faq.html#q19 On Sun, Mar 8, 2009 at 8:15 AM, Alexey Pechnikov wrote: > Hello! > > On Saturday 07 March 2009 01:59:13 Roger Binns wrote: >> A transaction requires two syncs (ie requesting the drive write the data >> to the metal and

Re: [sqlite] Feature request: Report constraint name(s) in error message

2009-03-09 Thread Ralf Junker
Roger Binns wrote: >> when a named constraint is violated, the name of the constraint which >> actually failed is not included in the error message. > >There has been a ticket about this for over 3 years, and also includes a >patch to fix it: > > http://www.sqlite.org/cvstrac/tktview?tn=1648

[sqlite] ANN: SQLite Maestro 9.3 released

2009-03-09 Thread SQL Maestro Group
Hi! SQL Maestro Group announces the release of SQLite Maestro 9.3, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ New features = 1. SQL Editor: support for explicit

Re: [sqlite] bad index selection?

2009-03-09 Thread Igor Tandetnik
"Derek Scherger" wrote in message news:e97446630903082113x1efb0173mfde6aa70909b1...@mail.gmail.com > I'm curious though, why does 'select *' not also use the unique index > on the > same grounds that it could get all the values it needs from the index > and > avoid the table