P Kishor,
> I have started liking Malcolm Hardie Company's SQL Editor (an inexpensive,
> ERD diagramming tool that can read and write SQLite databases, among other
> db)... not really a db front-end, but a utility nonetheless.
Thank you,
Malcolm
___
Hi Olaf,
Aaah, that is a funny one!
Will test today then with PRAGMA temp_store = FILE
and see if that makes it slower!
Bart
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Olaf Schmidt
Sent: 30 April 2008 04:24
To: sqlite-users@sqlite.org
Subject:
Run a trial, but I am sure that fgrep will be faster.
Scott Baker wrote:
> I'm curious about the speed trade off between a full table scan and just a
> flat file search... Say I have a database with 2 records in it. If I do
> a query like:
>
> SELECT foo FROM table WHERE bar LIKE
Just open the file.
palmer ristevski wrote:
> I am new to this type of Forum.Here is my question : My development platform
> is VB6. I am using "SQLitePlus COM-DLL" from ez-tools.com.They have code to
> access and query an existing ".db" file, but I wish to know how to make a
> function call
Hi,
In the test folder of sqlite3 source distribution I saw so many test
scripts. How can I run these tests? I am curious to know the various
testing methods used in sqlite.
Thanks,
Lloyd
__
Scanned and protected by Email scanner
If you have TCL installed, you can build the 'testfixture' which is used to
run the tests.
;# Unpack the source tree into "sqlite"
mkdir sqlite
cd sqlite
tar xzf sqlite.tar.gz
;# Build will occur in a sibling directory
cd ..
mkdir bld
;# Change to the build directory
cd bld
;# Run the
I have an embedded application that uses a single :memory: database
connection. This application has a user interface via a networking socket
that receives SQL commands. The application tasks and the user interface
will use the single :memory: connection. I want to limit the user interface
for
[EMAIL PROTECTED] wrote:
>
> Do you have a favorite on this page that you would recommend?
>
On Windows I like SQLiteSpy from
http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index
For cross platform use (Mac, Windows, and Linux) you may be interested
in the SQLite Manager add-on for
Hi Dennis,
> On Windows I like SQLiteSpy from
> http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index
> For cross platform use (Mac, Windows, and Linux) you may be interested
> in the SQLite Manager add-on for Firefox at
> https://addons.mozilla.org/en-US/firefox/addon/5817.
Thanks
Hello,
I have a small concern about the FTS negative term search syntax. Currently,
all terms following any minus sign ("-") are excluded from the search. This is
a very welcome feature, but consider searching for these hyphenated words:
Coca-Cola -> FTS finds Coca, but never Cola
Have anyone had experience about one connection with multiple statement handle:
one for selection and one for deletion.
Is there any problem in this case.
Thanks,
JP
- Original Message
From: Joanne Pham <[EMAIL PROTECTED]>
To: General Discussion of SQLite Database
Hi Gerry,
> Much care and thought have gone into setting up the default behaviors in
> SQLite.
> My advice would be not to use any pragmas initially.
That may be the safe solution, but my impression was that SQLite
defaults to conservative settings that may not apply to many of today's
high
I've had good luck with Mike Cariotoglou's free Sqlite3Explorer
http://www.singular.gr/sqlite/
I especially like being able execute just the sql command that I've
highlighted.
Some other interesting features:
--Access-ish query designer (if you like that sort of thing)
--Integrated with
Interesting point. This seems like the kind of thing that could be
implemented in the existing fts codebase without involving a version
change. It also may be more general than just hyphenated words, for
instance $12.50 might be more usefully translated as the phrase search
"12 50" than all
Scott Hess wrote:
> It's not entirely clear that the fts search syntax should aim to hew too
> closely to consumer-oriented search syntax.
Indeed, I would expect the FTS search syntax to optimize for the machine
model, while the user-facing syntax optimizes for human
comprehensibility, and the
[EMAIL PROTECTED] wrote:
> Hi Gerry,
>
>
>> Much care and thought have gone into setting up the default behaviors in
>> SQLite.
>> My advice would be not to use any pragmas initially.
>>
>
> That may be the safe solution, but my impression was that SQLite
> defaults to conservative
> But my advice stands. Set things up and see how things work. If you want/need
> better performance, start tweaking. But there is a good chance that the
> performance "out of the box" will be fine.
Thanks Gerry!
Regards,
Malcolm
___
sqlite-users
Richard (or anyone else who knows),
I am looking at ticket 3084, and I am seeing a difference in behavior
between using the DLL and the amalgamation source with the exact same
test application.
I was under the impression that the DLL available for download is now
built from the amalgamation.
On Apr 30, 2008, at 3:29 PM, Dennis Cote wrote:
> Richard (or anyone else who knows),
>
> I am looking at ticket 3084, and I am seeing a difference in behavior
> between using the DLL and the amalgamation source with the exact same
> test application.
The script used to build the DLL found on
Regarding the article at:
>
http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragmas
Am I right in that the article above promotes the use of "PRAGMA
synchronous=OFF" without even a TRACE of warning that this may result in
irretrievable database corruption? Isn't that a bit
Donald,
> http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragmas
>
> Am I right in that the article above promotes the use of "PRAGMA
> synchronous=OFF" without even a TRACE of warning that this may result in
irretrievable database corruption? Isn't that a bit reckless?
I think
Dear Sqlite users,
I want to put a sqlite database under version control (in my case subversion).
As far as I know the sqlite database is a binary file.
Always exporting and importing the database to a sql file is quite laborious .
What is the standard approach for this ?
Is there any "filter"
Hey all,
I'm new to the list and SQLite, although I have
about 7 years with MySQL, and going back to Oracle
and Informix a rock's age with databases.
I have the following code in a PHP 5.2.5 install.
$sql="SELECT * FROM bsp_model WHERE makeID=$makeID
ORDER BY model";
$result =
I have a CSV file contains records with a unique randomized ID as the
primary key. I retrieve a copy of the file daily and I don't have
control over when old records are removed from the file. I would like
to simply import this data into a table each day, ignoring the rows
where I've
Skip Evans <[EMAIL PROTECTED]> writes:
> But when it runs I get the following error:
>
> Call to undefined method PDOStatement::numRows()
>
> All the documentation I see on SQLite shows this
> as a valid method.
If I'm reading correctly, $result is of type PDOStatement. From the
Hey Ty & all,
Yes, rowCount() worked, and thanks for the
reference to the podstatement.php page.
But why did so much documentation I found on the
web use numRows()?
What is the difference between the PDOStatement
set of functions and the set to which numRows()
belongs to?
Different
Paul DiSciascio wrote:
> I have a CSV file contains records with a unique randomized ID as the
> primary key. I retrieve a copy of the file daily and I don't have
> control over when old records are removed from the file. I would like
> to simply import this data into a table each day,
27 matches
Mail list logo
