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
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
Th
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 not return until it does).
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 imp
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 scr
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 th
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 s
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
___
-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
> rudiment
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
>an answer, so I thoug
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 searc
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 only name and
> > id to
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
http://sqlite.org:8080/cgi-
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 tou
14 matches
Mail list logo