On Tue, Apr 29, 2008 at 10:10 PM, <[EMAIL PROTECTED]> wrote:
> P Kishor,
>
> > http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
>
> Oops, that's embarrassing!
>
> Do you have a favorite on this page that you would recommend?
>
> Thank you,
> Malcolm
tkSQLite at
http://reddog.s35.xrea.com/wi
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, ign
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 versions
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
documentat
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 alr
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 = $dbHandle->quer
Regarding: I think you're right for general purpose applications. But
if you have ETL or data conversion/analysis applications that can be
re-run after a failure (using source content), this type of pragma
sounds like a reasonable choice.
Malcolm
===
Hi Malcolm,
I very
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" ava
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
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 reck
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 th
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. I
> 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 mail
[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 settin
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 a
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 docum
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 to
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 RAM
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
Sent: Monday, April
[EMAIL PROTECTED] wrote:
> I'm new to SQLite and have been reading the archives for background.
>
> Are there a common set of pragmas that a new developer should master and
> if so which ones do you recommend I focus on?
>
> Is there a 'best practice' standard set of pragmas that apply to most
> ap
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
low
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 fo
[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 F
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
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 configure
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
___
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 to
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 '%glaven%'
28 matches
Mail list logo