I don't know your Wrapper, but try this:
CppSQLite3DB db;
db.open("Stocks.db");
db.execDML("ATTACH 'Options.db' AS OPT;");
sSQL = "UPDATE Stocks SET bOption=1 WHERE rowid IN ";
sSQL += "(SELECT Stocks.rowid FROM Stocks, OPT.Options ";
sSQL += "WHERE Stocks.sStockSymbol =
"chueng alex1985" <[EMAIL PROTECTED]> wrote:
> I want to lock a DB when I access it, in case of two processes write/read it
> at the same time.
>
This happens automatically. You do not have to do anything.
--
D. Richard Hipp <[EMAIL PROTECTED]>
I'm implementing the SQLData interface. Is it the right one ?
John Stanton wrote:
You need to revise your Java interface or maybe find another. What
are you using?
Jerome CORRENOZ wrote:
Now, I can use user-dfined types by declaring them with SQL create
tables. Fine !
But when I try to
Ion Silvestru <[EMAIL PROTECTED]> wrote:
> If we have a query where we compare a column to a set of values, then
> which is faster: OR or IN?
> Ex: OR: (mycol = "a") OR (mycol = "b") OR (mycol = "c") OR...
> IN: (mycol IN "a", "b", "c" ...)
>
IN is faster. However, version 3.2.3
Hello everybody
I'm cross compiling sqlite3 for arm and there's errors in the
configure and the makefile generated.
Do anyone of you cross compiled sqlite3?
thanks in advance
-
To unsubscribe, send email to [EMAIL
On Thu, 1 Feb 2007 10:41:25 +0100, anis chaaba wrote:
>I'm cross compiling sqlite3 for arm and there's errors in the
>configure and the makefile generated.
>Do anyone of you cross compiled sqlite3?
>thanks in advance
Using the preprocessed source code in sqlite-source-3_3_12.zip
lets you avoid
thanks
i've user sqlite 3.3.11.tar.gz and i made some modifications on configure
and make file and it works
2007/2/1, C.Peachment <[EMAIL PROTECTED]>:
On Thu, 1 Feb 2007 10:41:25 +0100, anis chaaba wrote:
>I'm cross compiling sqlite3 for arm and there's errors in the
>configure and the
Hi Mike,
Thanks, that helped. Not that I needed to do that but it got me to
find the real problem... "Options.db was not in the current folder!"
which apparently is sufficient reason for its tables not being found.
Go figure! : )
Roger
[EMAIL PROTECTED] wrote:
I don't know your
SQLite has supported collating sequences since version 3.0.0.
A collating sequence is really a specification on how comparison
operators work on strings.
You can have arbitrary collating sequences in SQLite. But for
the sake of this discussion, lets focus on just two: BINARY
which is the
From: "T" <[EMAIL PROTECTED]>
Hi Jeff,
I've encountered some functions that apparently aren't supported by
SQLite
So have I, such as replacing occurrences of an inner string.
so I've created my own
I've yet to figure out/try that. Is there a library somewhere of
prebuilt functions we
[EMAIL PROTECTED] writes:
> (4) What syntax do you prefer?
This seems the clearest to me, of the given choices:
SELECT * FROM t1 WHERE CAST(x AS TEXT COLLATE NOCASE)='HELLO';
Derrell
-
To unsubscribe, send
>From the CLP (i.e., w/o user-defined functions) is there any way to get
the equivalent of the sybase ltrim, rtrim functions? (ltrim/rtrim trim
spaces from the right/left end of a column value.)
jim
NOTICE: If received in error, please
DRH and Sqlite Community,
Provide two sql functions: toupper() and tolower() that can be applied. And
always use binary comparison.
so:
select x from where toupper(y) = 'HELLO' ;
would return 1 row...
But here is the gotcha, more than likely applying that function would negate
the use
I suppose since no one replied to this, that it's not possible to do it. Just
wanted to confirm. Thank you...
- Original Message
From: David Champagne <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Monday, January 29, 2007 2:32:00 PM
Subject: [sqlite] Memory database to file
Ken <[EMAIL PROTECTED]> wrote:
> DRH and Sqlite Community,
>
> Provide two sql functions: toupper() and tolower() that can be
> applied. And always use binary comparison.
>
> so:
> select x from where toupper(y) = 'HELLO' ;
> would return 1 row...
>
> But here is the gotcha, more than
If you are dealing with say a chinese char set then wouldn't you want to
handle this at a "global" level by modifying the database characteristics, then
maybe a Pragma command would be the way to go.
[EMAIL PROTECTED] wrote: Ken wrote:
> DRH and Sqlite Community,
>
> Provide two sql
Roger Miskowicz wrote:
CppSQLite3DB db;
db.open("Stocks.db");
db.execDML("ATTACH 'Options.db' AS OPT;");
sSQL = "UPDATE Stocks SET bOption=1 WHERE rowid IN ";
sSQL += "(SELECT Stocks.rowid FROM Stocks, Options ";
sSQL += "WHERE Stocks.sStockSymbol = Options.sStockSymbol); ";
After re-reading this:
(2) Oracle does the following:
Binary and Linguistic sorting:
Binary is the default.
Linguistic sorting is configured by setting NLS_COMP=LINGUISTIC and Setting
NLS_SORT to a language specific sort rule.
(these can be set at the session level or DB etc,
On 1/29/07, David Champagne <[EMAIL PROTECTED]> wrote:
Hi,
I've got an application that creates a database with a large number of records
(millions),
and the indexation of the tables is taking a long time. Once the database is
initially
created, it is never modified. No records are added or
Just found out on my forums that the National Library of Medicine is using
SQLite. They provide a free software program for HAZMAT first-responders to
use on their PDA's to get information on hazardous materials.
>From their website:
Mobile support, providing First Responders with critical
[EMAIL PROTECTED] schrieb:
SQLite has supported collating sequences since version 3.0.0.
A collating sequence is really a specification on how comparison
operators work on strings.
You can have arbitrary collating sequences in SQLite. But for
the sake of this discussion, lets focus on just
[EMAIL PROTECTED] wrote:
A collating sequence is really a specification on how comparison
operators work on strings.
This is a bit of a simplification, at least as far as the SQL:1999
standard goes.
You can have arbitrary collating sequences in SQLite. But for
the sake of this
Does the fact that I have received no reply mean that there's no way to
get this functionality within the CLP?
-Original Message-
From: Anderson, James H (IT)
Sent: Thursday, February 01, 2007 9:09 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Function question
>From the CLP (i.e.,
[EMAIL PROTECTED] wrote:
(2) How do other SQL engines do this kind of thing?
MS SQL Server supports
a=b collate CollationName
syntax. There are a few examples at
http://msdn2.microsoft.com/en-us/library/ms179886.aspx
This article also specifies a rather complicated set of rules for
On 2/1/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote:
Does the fact that I have received no reply mean that there's no way to
get this functionality within the CLP?
-Original Message-
From: Anderson, James H (IT)
Sent: Thursday, February 01, 2007 9:09 AM
To:
"glob(X,Y) This function is used to implement the "X GLOB Y" syntax of
SQLite. The sqlite3_create_function() interface can be used to
override this function and thereby change the operation of the GLOB
operator."
Excuse my ignorance, but what exactly does glob(x, y) do? Or, what is
the "X GLOB
OK, thanks.
-Original Message-
From: Nemanja Corlija [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 2:33 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Function question
On 2/1/07, Anderson, James H (IT) <[EMAIL PROTECTED]>
wrote:
> Does the fact that I have received
"Igor Tandetnik" <[EMAIL PROTECTED]> wrote:
>
> MS SQL also supports defining multiple indexes on the same table and
> field(s), differing only in collation (and the optimizer is smart
> enough, most of the time, to use these indexes appropriately). I haven't
> tried it with SQLite, maybe it's
Hi Jim,
On Thu, 1 Feb 2007 09:08:44 -0500, you wrote:
>From the CLP (i.e., w/o user-defined functions) is there any way to get
>the equivalent of the sybase ltrim, rtrim functions? (ltrim/rtrim trim
>spaces from the right/left end of a column value.)
As far as I can tell load_extension(X,Y)
On 2/1/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote:
On 2/1/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote:
> Does the fact that I have received no reply mean that there's no way to
> get this functionality within the CLP?
>
> -Original Message-
> From: Anderson, James
On 2/1/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote:
Does the fact that I have received no reply mean that there's no way to
get this functionality within the CLP?
-Original Message-
From: Anderson, James H (IT)
Sent: Thursday, February 01, 2007 9:09 AM
To:
A very minor efficiency note.
You can eliminate the runtime concatenation of your SQL strings by
letting the compiler do it at compile time. The compiler will
concatenate char[] constants that are separated by whitespace into a
single char[] constant. Replacing
sSQL = "UPDATE Stocks SET
[EMAIL PROTECTED] wrote:
(2) How do other SQL engines do this kind of thing?
MS SQL Server supports
a=b collate CollationName
syntax. There are a few examples at
http://msdn2.microsoft.com/en-us/library/ms179886.aspx
This article also specifies a rather complicated set of rules for
Based on the example, I was under the impression you were trying to fix a
comparison operator.
Oracle used hints( ie comments embedded in the sql) to tell the optimizer
which index to select.
Cant you assign a collating sequence in the ordre by? Why not use that to
determine if there is
That's an interesting idea, thanks, Kees.
-Original Message-
From: Kees Nuyt [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 01, 2007 2:57 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Function question
Hi Jim,
On Thu, 1 Feb 2007 09:08:44 -0500, you wrote:
>From the CLP
Dennis Cote <[EMAIL PROTECTED]> wrote:
>
> In the standard character strings have a couple of attributes, a
> character set and a collation. SQLite does not support multiple
> character sets, so we can ignore that attribute. This leaves each string
> with a collation attribute. This attribute
[EMAIL PROTECTED] wrote:
What are the precedences. If I say:
x COLLATE seq1 || y COLLATE seq2
Does that mean:
(x COLLATE seq1) || (y COLLATE seq2)
Yes, I believe this is the meaning the standard would take. But notice
that you have a dyadic function (concatenation) with two
select x, y, z
from t1
where collate binary x = y ;
collating_expr ::= [collate ] expr ;
The collating expression would apply to both x and y.
[EMAIL PROTECTED] wrote: Dennis Cote wrote:
>
> In the standard character strings have a couple of attributes, a
> character
Hi, I'm a newbie using sqlite 3 via Python 2.5, I've created a db using
CREATE TABLE messages (
id INTEGER PRIMARY KEY,
subjectTEXT
)
Populated it with a few lines and one of the row of rows is (1, u'News')
after:-
rows = curs.fetchall()
How do I pass these parameters in a cgi
Richard,
Some of the standard syntax definitions for the collate clauses are:
Table column definition
::=
{ | }
[ ]
[ ]
[ ... ]
[ ]
A string expression
::=
|
|
::=
|
::=
::=
[ ]
::=
|
The collate clause:
::= COLLATE
The details about the use of collations
Dennis Cote <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> >
> > What are the precedences. If I say:
> >
> > x COLLATE seq1 || y COLLATE seq2
> >
> > Does that mean:
> >
> > (x COLLATE seq1) || (y COLLATE seq2)
> >
> Yes, I believe this is the meaning the standard would take.
On 2/1/07, Paul Issott <[EMAIL PROTECTED]> wrote:
Hi, I'm a newbie using sqlite 3 via Python 2.5, I've created a db using
CREATE TABLE messages (
id INTEGER PRIMARY KEY,
subjectTEXT
)
Populated it with a few lines and one of the row of rows is (1, u'News')
after:-
rows =
If you are implementing JDBC to Sqlite then you just need to write a
class. You could use an existing JDBC class as a template.
Jerome CORRENOZ wrote:
I'm implementing the SQLData interface. Is it the right one ?
John Stanton wrote:
You need to revise your Java interface or maybe find
Dennis Cote <[EMAIL PROTECTED]> wrote:
>> >
> > (x COLLATE seq1) || (y COLLATE seq2)
> >
> Yes, I believe this is the meaning the standard would take.
The words I am putting into the SQLite language spec are
shown below. Please tell me if you thing my understanding
is correct:
The
"Shane Harrelson" <[EMAIL PROTECTED]> wrote:
>
> I have two tables, an "Objects" table with a foreign key into a second
> "Strings" table which is composed of unique values. It is a many to
> one relationship, that is, several Objects may reference the same
> String. When an Object is added,
Using the VB wrapper dll SQLite3VB.dll from Todd Tanner's site:
http://www.tannertech.net/sqlite3vb/index.htm
In one particular procedure I had a serious problem when doing a call to
sqlite_get_table, causing Excel to crash. It took me a long time to pinpoint
the trouble as VBA debugging methods
[EMAIL PROTECTED] wrote:
Note that SQLite has historically resolved an ambiguous collation
by choosing the collation of the left operand. I'll need to preserve
that behavior in order to maintain backwards compatibility.
Richard,
Perhaps you could add (yet another | a) pragma that would
sqlite_get_table does not terminate unless there is an error or it has
retrieved all the records you asked for. Something else must have been causing
the error, or the wrapper you are using is not implementing the function call
correctly.
--
Eric Pankoke
Founder / Lead Developer
Point Of
Thanks, yes, I somehow didn't think my explanation made sense and in fact I
just had another Excel crash, caused by the same call to sqlite_get_table.
I just can't understand why this is happening.
There is a valid connection, there is a valid SQL, the DB file is there and
working otherwise fine,
Think I managed to solve it using:-
print '%s' % (row[0], row[1])
Paul
Paul Issott wrote:
Hi, I'm a newbie using sqlite 3 via Python 2.5, I've created a db using
CREATE TABLE messages (
id INTEGER PRIMARY KEY,
subjectTEXT
)
Populated it with a few lines and one of the row of
Maybe this is old news, but I noticed that Sqlite is used by "OpenPBX,"
an open source PBX.
I would think it's yet another tribute to Sqlite's reliability that it
was chosen to run in a phone switch.
-
OpenPBX is a fork of the Asterisk PBX.
On the home page of the OpenPBX
[EMAIL PROTECTED] wrote:
The words I am putting into the SQLite language spec are
shown below. Please tell me if you thing my understanding
is correct:
The COLLATE operator can be throught of as a unary
postfix operator. The COLLATE operator has the highest
precedence. It always
Well...
At 23:17 2/1/2007 +, you wrote:
Thanks, yes, I somehow didn't think my explanation made sense and in fact I
just had another Excel crash, caused by the same call to sqlite_get_table.
I just can't understand why this is happening.
There is a valid connection, there is a valid SQL,
Hi SQLite users
Thank you for your attention - I am just hoping for some clarification
of usability of SQLite.
Referring to: http://www.sqlite.org/whentouse.html
- SQLite works well in websites
- Other RDBMS may work better for Client/Server applications
- SQLite will work over a network file
Good thought, but
1. I set the connection
2. get the array
3. dump it in the sheet
4. and then close the connection.
The crash happens at number 2.
I am sure I must be overlooking something simple here. The trouble is that
this error is not consistent.
RBS
-Original Message-
From: Guy
I am not an expert on SQLite - but if you are running separate
websites from your multiple servers, then why not use 4 instances of
SQLite ?? That is unless the websites need to share the same
database/tables.
If they do need to share the same database/tables, then PostgreSQL or
MySQL
Thanks for replying Phil...
Actually I am not running separate websites - but I have to deploy to
multiple webservers which will all serve the same pages. Each webserver
will have their own copy of the SQLite code, but they need to load the
data from a network file server to share the same data.
And this is when I'll step back and listen to the experts...
Since it is a low-load situation, file/record locking on SQLite seems
like it would be acceptable to me.
As for data corruption - that's bad -- very bad. However, with
automated backups some degree of comfort may be realized.
I'd be _extremely_ leery of doing this on a network store. In theory,
it should work just fine, but bridging theory and practice may very
well cost you many sleepless nights. sqlite is in many ways easier
than mysql, but mysql isn't _that_ much harder to use, and it just
won't have this class
That's what I'm talking about! It's good to get the perspective from
your setup, Phil. I'm beginning to get the picture.
I am starting to think that I should stick to an enhancement of my
current system. It's *very* basic, even more basic than SQLite, but
corruption seems almost impossible when
Hmmm.. Seems to confirm my previous feeling, Scott. You even used the
word 'extremely', plus 'sleepless nights'. With the current workload I
need all the sleep I can get.
Trouble is, I don't have admin access to the server. All my solutions
need to be user deployed. Already have access to Oracle
Is it possible for you to post the "offending" block of VBA code? Even
seeing your list of steps, it might be easier to help if we can view the
actual syntax.
Eric Pankoke
Founder
Point Of Light Software
http://www.polsoftware.com/
-Original Message-
From: RB Smissaert [mailto:[EMAIL
By separate files, do you mean that each user has their own data store?
If so, why not do the same thing with SQLite? If each user has a unique
name or ID, append that to a generic file name and you have a separate
instance for each user. I don't believe there's that much overhead to
the system
I think that he said that he is running one website on four different
servers using loadbalancing, in which case they do need to all share the
same database.
I have not tested this with SQLite, but if all four servers are connected
via a gigabit ethernet backbone then you shouldn't have to worry
That's the principle I am currently using, but that functionality is
extended and packaged in a Perl module. There is not one store per user,
data has to be shared between users. Each file is named by a multi-part
index with other non-indexed data also inside the file. Files in
multiple
Sounds like performance is going to be fair and acceptable. I am not
sure of the bandwidth on the network mounted file system but I believe
its fairly good, probably gigabit.
Seems like my only worry is the data corruption possibilities. That's
the crunch.
Thanks for answering the latency
"Anil Gulati -X \(agulati - Michael Page at Cisco\)" <[EMAIL PROTECTED]> wrote:
>
> I am trying to decide whether I can use SQLite for a website that runs
> on 4 load-balanced servers using networked file storage mounted by all
> servers for common data access.
This sounds like a job for a
Ok - it looks like the network file system is the main problem. That is
what introduces the risk of database corruption, and 'quickly' too!
SQLite apparently locks perfectly well and maintains integrity through
concurrent access but the network file system is likely to break.
It definitely now
On Thu, 2007-02-01 at 21:18 +0100, Info wrote:
> If I use the following inner join of 3 tables:
>
> SELECT T1.A
> FROM(T1 INNER JOIN T2 ON T1.A=T2.A) INNER JOIN T3 ON T1.B=T3.B
>
> SQLite returns an error message saying that the column T1.A does not exist.
> If I run this statement on
Ha!!
PayPal wrote:
Dear sqlite-users@sqlite.org,
We recently noticed one or more attempts to log in to your account
from a foreign IP address.
If you recently accessed your account while traveling, the unusual log in
attempts may have been initiated by you. However, if you did not initiate
Sure, here it is:
'SQLite3VB.dll declarations
Private Declare Sub sqlite3_open Lib "SQLite3VB.dll" _
(ByVal FileName As String, _
ByRef handle As Long)
Private Declare Sub
71 matches
Mail list logo