John Elrick wrote:
> Tim Anderson wrote:
>
> We are working on a project for the Census Bureau and needed an
> embeddable database that was zero configuration for the user and fast.
> We evaluated SQLite against numerous competitors...
IMHO, a bit exaggerated the "numerous competitors" part of t
Thanks Miguel, I fear you're right. For this infrequent update process
it just may just be easier to throw the data into another db format.
Thanks again
Rob
-Original Message-
From: miguel manese [mailto:[EMAIL PROTECTED]
Sent: Friday, 8 June 2007 3:31 PM
To: sqlite-users@sqlite.org
Sub
Maybe you really have to loop "outside" sqlite to align the rows &
values. From the result you got and the UPDATE documentation, I can
guess that the subselect in the assignment is flattened to a scalar.
Unfortunately sqlite does not have something like
update tbl1 set col=tbl2.col from tbl2 wher
Thanks John, that's what I thought too... My positioning on a row is
dependent on 2 values, and without any better knowledge of SQLite I've
tried implementing this:
Update
Parameter
set
ParameterValue = (select NewParams.parametervalue from Scenario, Link,
Catchment, FunctionalUnit, FunctionalU
If you don't truncate a file then you may have untruncated files. Why
can't you truncate a file? It is implemented one way or another on
pretty much every OS.
Sqlite uses truncate in it b-tree logic and probably elsewhere so you
would very likely encounter problems with no truncate.
Jimmy
You don't seem to be positioning on a row in the Parameter table with a
WHERE clause.
Ellis Robin (Bundaberg) wrote:
Could I please get some help on the syntax required to perform my UPDATE
based on a selection from multiple tables? I've been through the
archives but can't seem to make much sen
Could I please get some help on the syntax required to perform my UPDATE
based on a selection from multiple tables? I've been through the
archives but can't seem to make much sense of the examples given.
I have a table containing 'new' paramater values, I need to update the
relevant records in th
Hi all,
I am working in a porting project of SQLite from windows.
I Could not port the Truncate () function (For Eg: WinTruncate () in
windows code in the file os_win.c ) as the same logic cannot be applied
to my platform.
Can I make it a dummy function by just returning SQLITE_OK?
Plea
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
"Tim Anderson" <[EMAIL PROTECTED]> writes:
> I'm writing an article about SQLite and I'd love to get some comments
> from users about why you use it. Performance? Features? Reliability?
> Cost? Is the open source aspect important? Anything else? For t
We chose SQLite for many reasons:
- zero configuration/installation
- availability of wonderful ADO.NET 2.0 wrapper
- easily extensible with custom functions
- performance (4x faster than MSSQL in our tests)
- available commercial support
The only thing we don't like is the lack non-standard loos
John Elrick wrote:
Tim Anderson wrote:
I'm writing an article about SQLite and I'd love to get some comments
from users about why you use it. Performance? Features? Reliability?
Cost? Is the open source aspect important? Anything else? For that
matter, anything you really don't like about SQLite
Tim Anderson wrote:
I'm writing an article about SQLite and I'd love to get some comments
from users about why you use it. Performance? Features? Reliability?
Cost? Is the open source aspect important? Anything else? For that
matter, anything you really don't like about SQLite?
You can email me
It appears that I can *NOT* create a custom collation function for a column
declared as an INTEGER. Well, I can create it, and prepare a statement to
use it, but my custom function is *NEVER* called. Is this by design? The
exact same code works for a TEXT column.
Should the sqlite3_prepare()
Hi, Trey.
I checked not implemented features list of sqlite and found nothing
about "update ... from".
There's no "FROM" on http://www.sqlite.org/lang_update.html, so
that's a
hint that it's not supported. All the same, maybe this should be
added to
http://www.sqlite.org/omitted.html
u
> I'm writing an article about SQLite and I'd love to get some comments
> from users about why you use it. Performance? Features? Reliability?
> Cost?
- no restrictions, like only 1 LONG VARCHAR in the table, numer of columns,
maximum network packet size and similar (actually there are some
re
Hi, Tim.
We are using SQLite for two main reasons:
- no daemon needed: to use RDBMS on a cluster machine is quite
annoying. Most clusters administrators does not want more daemons
running.
- SQLite can be very fast when you tweak some of its basic
configuration pragmas, being more than 200% faste
I am using SQLite because it is easy to use (zero config). To add to your
project. And it was well designed by Mr. Hipp, with a really to use API. A
wild SQL support.
Because there is not Client-Server, and thousands times better than access
and foxpro
Many people uses, so there is a lot of help
Thanks Noah,
Yes that is what I have is a cross join. I was trying to simplify the
definition.
A more correct definition is:
TabA.ID1
TabA.ID2
TabA.field1
TabB.ID1
TabB.ID2
TabB.field2
TabC.ID1
TabC.field3
ViewBC:
SELECT * FROM TabB INNER JOIN TabC On TabB.ID1 = TabC.ID1
This is slow:
SELECT
I'm writing an article about SQLite and I'd love to get some comments
from users about why you use it. Performance? Features? Reliability?
Cost? Is the open source aspect important? Anything else? For that
matter, anything you really don't like about SQLite?
You can email me at tim(at)itwriting.co
Matt, if looks like you have a cross join between your tables.
Are the tables A, B, C related in some way? IF so, then your queries
should look something like
SELECT fields from TabA LEFT OUTER JOIN TabB where TabA.IDb = TabB.IDb
And your view like
SELECT fields FROM TabB INNER JOIN TabC where
I have Tables TabA, TabB and TabC
I have a view ViewBC that is a view
SELECT fields FROM TabB INNER JOIN TabC
If I run
SELECT fields FROM TabA LEFT OUTER JOIN ViewBC
it is way slow (like ignoring all indexes)
If I run
SELECT fields FROM TabA LEFT OUTER JOIN Ta
I have Tables TabA, TabB and TabC
I have a view ViewBC that is a view
SELECT fields FROM TabB INNER JOIN TabC
If I run
SELECT fields FROM TabA LEFT OUTER JOIN ViewBC
it is way slow (like ignoring all indexes)
If I run
SELECT fields FROM TabA LEFT OUTER JOIN Ta
Igor Tandetnik wrote:
John Stanton <[EMAIL PROTECTED]> wrote:
Predictability is ensured by using transactions. By using BEGIN and
COMMIT to make transactions atomic you enforce a predictable state.
Not if you modify the same data you are iterating over, on the same DB
connection and thus w
Scott Hess wrote:
On 6/7/07, John Stanton <[EMAIL PROTECTED]> wrote:
I have just started to use FTS2 and it is working well but I would like
to ask any other users if they have had good or bad experiences and why
they would use FTS2 rather than FTS1. The software is new and I have
not seen any
John Stanton <[EMAIL PROTECTED]> wrote:
Predictability is ensured by using transactions. By using BEGIN and
COMMIT to make transactions atomic you enforce a predictable state.
Not if you modify the same data you are iterating over, on the same DB
connection and thus within the same transactio
Greetings!
I am trying to connect to a SQLite database from inside a C++ program
(written in Visual Studio 6) using ADO without using a DSN. The
database file is c:\program files\wincaps\trend01.trd. The library
developed in house to wrap ADO calls contains an Open() method that
accepts a string
On 6/7/07, John Stanton <[EMAIL PROTECTED]> wrote:
I have just started to use FTS2 and it is working well but I would like
to ask any other users if they have had good or bad experiences and why
they would use FTS2 rather than FTS1. The software is new and I have
not seen any feedback at this st
I have just started to use FTS2 and it is working well but I would like
to ask any other users if they have had good or bad experiences and why
they would use FTS2 rather than FTS1. The software is new and I have
not seen any feedback at this stage and we are yet to apply large data
sets and h
Predictability is ensured by using transactions. By using BEGIN and
COMMIT to make transactions atomic you enforce a predictable state.
B V, Phanisekhar wrote:
Thanks Igor,
Why it's unpredictable?
Why can't the unpredictable be made predictable?
Assume I update the column of a row that
Igor Tandetnik wrote:
B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
Why it's unpredictable?
Why can't the unpredictable be made predictable?
Please feel free to submit a patch, if you believe it's that easy.
Assume I update the column of a row that meets the criteria of some
select stmt an
B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
Why it's unpredictable?
Why can't the unpredictable be made predictable?
Please feel free to submit a patch, if you believe it's that easy.
Assume I update the column of a row that meets the criteria of some
select stmt and I am yet to encounter th
I can see your point, I guess, though I can't say that it seems like
a major issue to me.
Just out of curiosity, why aren't the defaults derived in os_win.x
and os_unix.c sufficient?
> -Original Message-
> From: weiyang wang [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, June 06, 2
Thanks Igor,
>> Why it's unpredictable?
Why can't the unpredictable be made predictable?
Assume I update the column of a row that meets the criteria of some
select stmt and I am yet to encounter that row in sqlite3_step. So the
sqlite3_step on that row will return the old column value or ne
B V, Phanisekhar <[EMAIL PROTECTED]> wrote:
Why it's unpredictable?
You are enumerating rows in some order. A new row may be inserted before
or after your current position in this order. If it is inserted before,
you will not see it in this enumeration. If it is inserted after, you
will even
On 5/27/07, noname <[EMAIL PROTECTED]> wrote:
I am using SQL Server as a back end in my vb6 application i want to switch
over to sqlite server but terrainformatica.com site has not provided rates
for server. so i am confused that should i use it or not i enquired on sites
also but i am getting p
Igor,
Why it's unpredictable? It's because of different sqlite versions or
even in the same sqlite version it's unpredictable? If the latter is the
case, I would like to know the internal of sqlite which makes it
unpredictable.
Richard,
In sqlite 3.3.8, since it allows INSERT while SELECT stateme
36 matches
Mail list logo
