Hi All,
Has anyone encountered an indefinite database lock?
This is a condition where the database is in a locked
state and no process is connected to it. The database
cannot be unlocked by any means and is no longer usable.
My environment is FreeBSD 6.2, SQLite 3.3.7. Several processes
are
On 12/4/08, Julian Bui <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I can't seem to use fully qualified table names (dbName.tableName).
>
> For instance, I create a database file inventory.db, and create a table
> food. "SELECT * FROM inventory.food" does not work, nor does "SELECT * FROM
>
anyone can help me?
- Original Message
From: Igor Tandetnik <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, November 27, 2008 12:07:31 PM
Subject: Re: [sqlite] how do this stuff in sqlite
"Rachmat Febfauza" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
>
Hi,
as far as I can see from source code, there are support for various R-tree
variants:
/*
** Exactly one of the following must be set to 1.
*/
#define VARIANT_GUTTMAN_QUADRATIC_SPLIT 0
#define VARIANT_GUTTMAN_LINEAR_SPLIT0
#define VARIANT_RSTARTREE_SPLIT 1
My issue is the speed of
Julian Bui <[EMAIL PROTECTED]> wrote:
> I can't seem to use fully qualified table names (dbName.tableName).
>
> For instance, I create a database file inventory.db, and create a
> table food.
Database name has nothing to do with file name. The main database (one
you open with sqlite3_open) is
Hi all,
I can't seem to use fully qualified table names (dbName.tableName).
For instance, I create a database file inventory.db, and create a table
food. "SELECT * FROM inventory.food" does not work, nor does "SELECT * FROM
inventory.db.food" bc it says "no such table ...". Since there is no
I have successfully compiled the source for version 3.6.6.2 for Mac OS
X PowerPC that I have placed in a compressed tar file that I wouldn't
mind making available to be placed in the download section of the web
site. You only have Mac OS X Intel binary.
I created the tar flie from /usr and
Brad, Puneet,
Thanks for getting back to me so quickly. I feel like a fool ;-)
The error of "misuse of aggregate function MAX()" confused me. I ran the
same query in SQL Server, got an error message that I understood and
realised instantly that my brain wasn't switched on and that I needed to
Hello Donald,
I have managed to speed up some of my SQLite queries by about 300% by
writing them from joins to sub queries. I am comparing SQLite against a
custom SQL implementation we have here. It looks like it is our cursor
implementation that is so much faster than SQLite the regular queries
On 12/4/08, Brad Stiles <[EMAIL PROTECTED]> wrote:
> > SELECT *
> > FROM MyTableWithDates
> > WHERE datetime("now") > MAX(dtEndDate)
>
>
> What is it that you are actually trying to do with this query? As
> formulated (even if it were syntactically correct, which I don't think
> it is), you
> SELECT *
> FROM MyTableWithDates
> WHERE datetime("now") > MAX(dtEndDate)
What is it that you are actually trying to do with this query? As
formulated (even if it were syntactically correct, which I don't think
it is), you are either going to get every row in the table, or no rows
at all.
Hi,
I've been using SQL for years in SQL Server but I've only recently started
using Sqlite. I've got to grip with most of the little differences but I
can't for the life of me figure out how to do a query where I compare the
current date with the maximum date of a field in a table. E.g.
SELECT
Oyvind Idland wrote:
> Thanks for responses :)
>
> Whereby "objects" you mean "rows," no? You are getting upward of 5500
>> sustained inserts per second. That sounds pretty good. That said, are
>> you using transactions? See what difference that makes.
>>
>
> Yep, I meant rows. Inserting rows in
Regarding: "Does there any test case exist for ODBC testing of sqlite,
how one can be sure about sqlite working with ODBC."
=
Sqlite itself does not interface directly with ODBC. Some nice folks
have written ODBC wrappers, though, and it is those folks
Dear Cariotoglou Mike,
I am using VC++ for last 6 years to develop utilities and some small
projects. Formerly I was using MS-ACCESS and/or some database classes in my
projects. Once I felt the power of sqlite I started using it from 2003 /
2004. After that I have not used any ADO / ODBC for my
In the latest CVS code, the Unix interface for SQLite has been
extensively reorganized and cleaned up. It passes all regression
tests on Linux and MacOSX and so we have high confidence in it.
Nevertheless, we would appreciate it
if people could test out the latest code from CVS on Unix
"Hernan Eguiluz" <[EMAIL PROTECTED]>
wrote in message news:[EMAIL PROTECTED]
> The problem is that a
> query like this
>
>
> SELECT column1, column2 from TABLE WHERE column1 LIKE "%PATTERN%" or
> column2 LIKE "%PATTERN%"
>
>
> won't tell me what column matched the LIKE.
SELECT column1, column1
Hi, I need to search for matches of a string in two different fields of a
database table (column1, column2) and need to know which on of the two matched.
I can do this (ignoring duplicates) with the following code:
SELECT column1, 1 FROM TABLE WHERE column1 LIKE "%PATTERN%"
UNION
SELECT
"Ernany" <[EMAIL PROTECTED]> wrote in
message news:[EMAIL PROTECTED]
>> Is it possible to simplify the code? I have ten fields to UPDATE.
>> (STATUS, Responsavel, Country,..)
>>
>> UPDATE Bens SET *STATUS *=
>> CASE (SELECT COUNT(BENSBK.STATUS) FROM BENSBK WHERE BENSBK.BEM =
>> Bens.BEM)
>>
Thanks for responses :)
Whereby "objects" you mean "rows," no? You are getting upward of 5500
> sustained inserts per second. That sounds pretty good. That said, are
> you using transactions? See what difference that makes.
>
Yep, I meant rows. Inserting rows in the data table is much faster
Hi,
Does there any test case exist for ODBC testing of sqlite, how one can be
sure about sqlite working with ODBC.
Regards
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, 04 Dec 2008 10:34:59 +1100, you wrote:
> Tks. It would help if the doco made that known.
It is documented in the section that deals with omitted features of
SQL, which you can find at: http://www.sqlite.org/omitted.html
Best,
Tony
___
Hello Igor,
> Is it possible to simplify the code? I have ten fields to UPDATE.
> (STATUS, Responsavel, Country,..)
>
> UPDATE Bens SET *STATUS *=
> CASE (SELECT COUNT(BENSBK.STATUS) FROM BENSBK WHERE BENSBK.BEM =
> Bens.BEM)
> WHEN 0 THEN Bens.STATUS
> ELSE (SELECT BENSBK.STATUS FROM
> On these tables this query is very slow (about 1 row per second)
>
> select g.id from general g, general_text gt where g.id = gt.id;
>
> and these ones have a normal speed:
>
> select g.id from general g, general_text_content gt where g.id = gt.docid;
I think the point is that you cannot
24 matches
Mail list logo
