On 10-03-09 8:47 PM, Darren Duncan wrote:
>
> (Incidentally, I *have* registered my trademark. But that is a non-issue
> here.)
>
>
Darren,
Aren't you required to put the registered trademark symbol, ®, on each
use of your trademarked name or logo? I didn't see it (or the ™symbol
for an un
I just tried to build 3.6.23 on a PPC Mac running OS X 10.4.
>
> I got an undefined symbol error and the make aborted.
/bin/sh ./libtool --tag=CC --mode=link gcc -DSQLITE_THREADSAFE=1
-DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_RTREE -g -O2 -o libsqlite3.la -rpath
/usr/local/lib -no-undefined -versio
> Pavel, regarding the question about VFS, I'm not using one to my knowledge
> and have set the "name of VFS module" to NULL in sqlite3_open_v2. Maybe NULL
> means I'm using the standard VFS, but in any case, not a "non-standard" one.
If you pass NULL you use _default_ VFS, not a standard one.
Dennis Cote wrote:
> On 10-02-23 3:23 PM, Darren Duncan wrote:
>> Elefterios Stamatogiannakis wrote:
>>
>>> Madis is a extensible relational database system built upon the SQLite
>>> database and with extensions written in Python (via APSW SQLite
>>> wrapper). Its is developed at:
>>>
>>> http:
On 10-02-23 3:23 PM, Darren Duncan wrote:
> Elefterios Stamatogiannakis wrote:
>
>> Madis is a extensible relational database system built upon the SQLite
>> database and with extensions written in Python (via APSW SQLite
>> wrapper). Its is developed at:
>>
>> http://madis.googlecode.com
>>
>>
On 10-02-26 2:25 PM, Francisco Azevedo wrote:
> Hi all,
>
> I want to create a "publish/undo system" for some tables but i don't
> know what is the best approach to do it.
> Imagine i have a table with columns id (auto-inc), data (text) then i
> want to edit table data (eg: create 2 new rows now, d
On Mar 9, 2010, at 8:35 PM, C G wrote:
> Yes I am sending this in regards to sqlite files I have found on my
> computer. What are they ? Why are they on my computer ? Why even
> after I re install windows , is it STILL logging my key strokes ?
> Is this a key logger ? How do I remove it fr
As an update, I now confirm that the version of
http://sqlite.org/sqlite-amalgamation-3.6.23.tar.gz that was on the website 10
minutes ago seems to be fully corrected. That is, the file size is now normal
and the Perl binding DBD::SQLite successfully builds and passes all its tests
with it. --
D. Richard Hipp wrote:
> On Mar 9, 2010, at 4:40 PM, Terence Martin wrote:
>
>> On Tue, 9 Mar 2010 16:00:27 -0500
>> "D. Richard Hipp" wrote:
>>
>>> SQLite version 3.6.23 is now available from the SQLite website:
>>> http://www.sqlite.org/
>>
>> On closer examination it appears that the sqlite3.[
Are you sure this is right? Now the header sqlite3.h is a duplicate of the
source sqlite3.c and sqlite3.c is double the size it should be.
On Mar 9, 2010, at 4:04 PM, D. Richard Hipp wrote:
>
> On Mar 9, 2010, at 4:40 PM, Terence Martin wrote:
>
>> On Tue, 9 Mar 2010 16:00:27 -0500
>> "D. Ric
On Tue, 9 Mar 2010, D. Richard Hipp wrote:
>> The download page no longer mentions any version of SQLite:
> Oops. Does now.
And I thought it was me! I got lost in the repository, started over, tried
a different route, and suddenly the familiar download page appeared. Whew!
Rich
On Mar 9, 2010, at 5:07 PM, Roger Binns wrote:
> D. Richard Hipp wrote:
>> SQLite version 3.6.23 is now available from the SQLite website:
>> http://www.sqlite.org/
>
> The download page no longer mentions any version of SQLite:
>
> http://www.sqlite.org/download.html
Oops. Does now.
D. Ri
D. Richard Hipp wrote:
> SQLite version 3.6.23 is now available from the SQLite website:
> http://www.sqlite.org/
The download page no longer mentions any version of SQLite:
http://www.sqlite.org/download.html
roger
___
sqlite-users mailing list
sq
On Mar 9, 2010, at 4:40 PM, Terence Martin wrote:
> On Tue, 9 Mar 2010 16:00:27 -0500
> "D. Richard Hipp" wrote:
>
>> SQLite version 3.6.23 is now available from the SQLite website:
>> http://www.sqlite.org/
>>
>>
>> As always, please let me know if you find any problems in the new
>> release.
>
D. Richard Hipp wrote:
> SQLite version 3.6.23 is now available from the SQLite website:
> http://www.sqlite.org/
>
> Version 3.6.23 is a regularly scheduled bimonthly release of SQLite.
> Upgrading from version 3.6.22 is optional. For further information on
> the enhancements in version 3
On Tue, 9 Mar 2010 16:00:27 -0500
"D. Richard Hipp" wrote:
> SQLite version 3.6.23 is now available from the SQLite website:
> http://www.sqlite.org/
>
>
> As always, please let me know if you find any problems in the new
> release.
>
> D. Richard Hipp
> d...@hwaci.com
I think there may be
On 3/9/2010 2:13 PM, P Kishor wrote:
<>
about the following example I provided:
>> select min(c) from T where 1=2
>> group by foo
>>
>> returns no rows, presumably because the null value was removed from the
>> aggregated set.
>>
Foo was simply my shorthand for "another colum
Hello!
On Tuesday 09 March 2010 20:09:04 Kiril wrote:
> Fixes? Am I doing something wrong?
>
You may do these:
1. Use transactions
2. Increase page_size (as example, PostgreSQL use 8k pages by default)
3. Increase default_cache_size (your biggest index size must be smaller than
page_size*cache_
Hello!
Will be the very helpful sqlite3_intarray interface included to SQLite core? Or
this is
only example for developers?
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:80
SQLite version 3.6.23 is now available from the SQLite website:
http://www.sqlite.org/
Version 3.6.23 is a regularly scheduled bimonthly release of SQLite.
Upgrading from version 3.6.22 is optional. For further information on
the enhancements in version 3.6.23 visit:
http://www.sqlit
> I prefer to get any answer - since I will learn from it - than no answer at
> all.
What is "no answer at all" to someone can be a full answer to others.
It's like when some preschooler comes to you and asks "Daddy, tell me
please, how much is 2 + 2?" and you answer "Let's see, if we take
these
>- Original Message
>From: P Kishor
>To the veterans on the list, it is very clear that no one had a "how
>stupid are you" attitude
I totally agree, and I am new here.
I prefer to get any answer - since I will learn from it - than no answer at
all.
>Even if a particular reply might
On Tue, Mar 9, 2010 at 10:46 AM, Tim Romano wrote:
> On 3/9/2010 10:56 AM, Scott Hess wrote:
>> On Tue, Mar 9, 2010 at 7:15 AM, Tim Romano wrote:
>>> Of these three:
>>>
>>> select c from T where 1=2 // returns 0 rows
>>> select min(c) from T where 1=2 // returns 1 row
>>>
On Tue, Mar 9, 2010 at 12:46 PM, Tim Romano wrote:
> On 3/9/2010 10:56 AM, Scott Hess wrote:
>> On Tue, Mar 9, 2010 at 7:15 AM, Tim Romano wrote:
>>
>>> Of these three:
>>>
>>> select c from T where 1=2 // returns 0 rows
>>> select min(c) from T where 1=2 // returns 1 row
purely unsolicited, non-SQL related words here (I don't want to
classify them as 'advice') --
On Tue, Mar 9, 2010 at 12:33 PM, Ed Curren wrote:
>
> Yes. At times I get so wound up in the details of various parts of the code
> that I miss the obvious of setting the stmt pointer to null before us
Tim Romano wrote:
> select min(c) from T where 1=2
>
> returns 1 row that contains despite the presence of the
> aggregate function
Not despite - _because_ of. If you didn't have the aggregate there, you'd get
zero rows.
> and so
>
>select min(c) is null from T where 1 =2
>
> return
Ok, my mistake.
On Tue, Mar 9, 2010 at 7:37 PM, Jay A. Kreibich wrote:
> On Tue, Mar 09, 2010 at 07:30:54PM +0100, Jonas Sandman scratched on the wall:
>> Doesn't it return an array of sqlite3_stmt pointers?
>
> No.
>
>> If you prepare this statement:
>>
>> "BEGIN; UPDATE something SET this='tha
On 3/9/2010 10:56 AM, Scott Hess wrote:
> On Tue, Mar 9, 2010 at 7:15 AM, Tim Romano wrote:
>
>> Of these three:
>>
>> select c from T where 1=2 // returns 0 rows
>> select min(c) from T where 1=2 // returns 1 row
>> select min(88,99) from T where 1=2 // returns 0 rows
On Tue, Mar 09, 2010 at 07:30:54PM +0100, Jonas Sandman scratched on the wall:
> Doesn't it return an array of sqlite3_stmt pointers?
No.
> If you prepare this statement:
>
> "BEGIN; UPDATE something SET this='that'; COMMIT;"
>
> Then the array will contain the statement handles for the three
Yes. At times I get so wound up in the details of various parts of the code
that I miss the obvious of setting the stmt pointer to null before using it.
Thank you to Jay for reminding me of this.
Your collective replies, answers and advice are very much appreciated, however
the "how stupi
Doesn't it return an array of sqlite3_stmt pointers?
If you prepare this statement:
"BEGIN; UPDATE something SET this='that'; COMMIT;"
Then the array will contain the statement handles for the three
statements BEGIN, UPDATe and COMMIT.
/Jonas
On Tue, Mar 9, 2010 at 7:17 PM, Igor Tandetnik wro
> int sqlite3_prepare(sqlite3 *db, const char *zSql, int nByte, sqlite3_stmt
> **ppStmt, const char **pzTail);
>
> Please tell me what the 4th parameter is then if it not a statement so that I
> may ask you in the words you are looking for.
It's not a statement. Speaking in Igor's words it's a _
Ed Curren wrote:
> According to the documentation the function prototype for
> sqlite3_prepare_v2 is the following:
>
>
>
> int sqlite3_prepare(sqlite3 *db, const char *zSql, int nByte,
> sqlite3_stmt **ppStmt, const char **pzTail);
Note two stars in sqlite3_stmt **ppStmt. You pass a pointer
Thank you for a straight answer Jay.
> Date: Tue, 9 Mar 2010 12:10:17 -0600
> From: j...@kreibi.ch
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] How can I query a sqlite3_stmt to find out if it has
> been run through the sqlite3_prepare_v2 function?
>
> On Tue, Mar 09, 2010 at 11:47:39
On Tue, Mar 09, 2010 at 11:47:39AM -0500, Ed Curren scratched on the wall:
>
> Hello all,
>
> I have a function that is being passed an sqlite3_stmt object.
I assume you mean a sqlite3_stmt pointer. You should never
instance an actual sqlite3_stmt structure yourself.
> Within this function
Try to execute that statement. If you get "segmentation fault" then it
wasn't prepared yet. Though there's some 1% chance that it wouldn't
give you segmentation fault on the first execution attempt...
Pavel
P.S. To continue conversation answer the Igor's question: if you have
pointer how do you k
According to the documentation the function prototype for sqlite3_prepare_v2 is
the following:
int sqlite3_prepare(sqlite3 *db, const char *zSql, int nByte, sqlite3_stmt
**ppStmt, const char **pzTail);
Please tell me what the 4th parameter is then if it not a statement so that I
may ask
Hi Alexey,
>1. See internal sqlite instarray interface:
>http://sqlite.mobigroup.ru/src/finfo?name=src/test_intarray.c
>http://sqlite.mobigroup.ru/src/finfo?name=src/test_intarray.h
>http://sqlite.mobigroup.ru/src/finfo?name=test/intarray.test
>
>Note: http://sqlite.mobigroup.ru include official
Ed Curren wrote:
> Okay, let's try asking the question this way then. How do I know if
> I need to call prepare based on the condition or value or whatever of
> a statement that may or may not have already been passed to perpare
> as a parameter?
You _cannot_ pass a statement to prepare as a
Hi guys,
Had to take a break for a couple of days from my SQLite experiments, but back
on it now.
Pavel, regarding the question about VFS, I'm not using one to my knowledge and
have set the "name of VFS module" to NULL in sqlite3_open_v2. Maybe NULL means
I'm using the standard VFS, but in an
Okay, let's try asking the question this way then. How do I know if I need to
call prepare based on the condition or value or whatever of a statement that
may or may not have already been passed to perpare as a parameter?
> To: sqlite-users@sqlite.org
> From: itandet...@mvps.org
> Date: Tue,
Ed Curren wrote:
> This function will be called several times. The first time through
> the statment won't be prepared
What do you mean, won't be prepared? How can one obtain a statement handle
without calling prepare?
> so in that case the function will
> call sqlite3_preapre_v2 to prepare th
Thank you very much for your clarification! This is what I suspected.
Regards,
Samuel
- Original Message
From: Igor Tandetnik
a1rex wrote:
> What about void *p = sqlite3_column_blob()?
> From my tests it looks that pointer p survives sqlite3_finalize().
> Is it just a coincidence?
Hi Igor,
This function will be called several times. The first time through the
statment won't be prepared, so in that case the function will call
sqlite3_preapre_v2 to prepare the statement. Subsequent calls to the function
will have the statment that is already prepared, so I do not want t
Hello!
1. See internal sqlite instarray interface:
http://sqlite.mobigroup.ru/src/finfo?name=src/test_intarray.c
http://sqlite.mobigroup.ru/src/finfo?name=src/test_intarray.h
http://sqlite.mobigroup.ru/src/finfo?name=test/intarray.test
Note: http://sqlite.mobigroup.ru include official SQLite trun
Did you try to raise value of cache_size? Do you execute any other
queries on the same database besides INSERT?
Pavel
On Tue, Mar 9, 2010 at 12:09 PM, Kiril wrote:
> Hi all,
>
> I am facing performance issues after few thousand inserts.
> I have a DB with 3 tables, few columns each, each one has
Hello!
I think your structure is not good enough. You may use
cookie-based database selection instead and doesn't
store user information into your "Master DB".
The algorithm is like to:
Username -> user_id -> check password by user_id database
As example:
User enter USERNAME and PASSWORD and we
Ed Curren wrote:
> I have a function that is being passed an sqlite3_stmt object.
> Within this function I need to determine if the statement has been
> prepared. How can I accomplish this?
Where else would a statement handle come from, if not from sqlite3_prepare[_v2]
? What precisely is th
Tim Romano wrote:
> Of these three:
>
> select c from T where 1=2 // returns 0 rows
> select min(c) from T where 1=2 // returns 1 row
> select min(88,99) from T where 1=2 // returns 0 rows
>
>
> the only case that "threw" me is the second one, where a row is
> returned
Andrea Galeazzi wrote:
> I've got a table T made up of only two fields: INT id (PRIMARY KEY) and
> INT length.
> I need a statement in order to yield 0 when the key doesn't exist.
Well, "select 0;" fits your spec (you never said what should be returned when
the key does exist). I would hazard a g
a1rex wrote:
> What about void *p = sqlite3_column_blob()?
> From my tests it looks that pointer p survives sqlite3_finalize().
> Is it just a coincidence?
It "survives" in the same sense as in this example:
char* p = (char*)malloc(10);
strcpy(p, "Hello");
free(p);
printf(p);
Chances are high
Hi all,
I am facing performance issues after few thousand inserts.
I have a DB with 3 tables, few columns each, each one has auto-increment ID.
These tables are joined by ID, so after each INSERT, I read back the
last_insert_rowid() from 2 tables.
One or two columns per table are indexed.
I am us
Hello all,
I have a function that is being passed an sqlite3_stmt object. Within this
function I need to determine if the statement has been prepared. How can I
accomplish this?
Thanks very much.
___
sq
On Tue, Mar 9, 2010 at 9:56 AM, Scott Hess wrote:
> On Tue, Mar 9, 2010 at 7:15 AM, Tim Romano wrote:
>> Of these three:
>>
>> select c from T where 1=2 // returns 0 rows
>> select min(c) from T where 1=2 // returns 1 row
>> select min(88,99) from T where 1=2 // returns 0
On Tue, Mar 9, 2010 at 7:15 AM, Tim Romano wrote:
> Of these three:
>
> select c from T where 1=2 // returns 0 rows
> select min(c) from T where 1=2 // returns 1 row
> select min(88,99) from T where 1=2 // returns 0 rows
>
> the only case that "threw" me is the second one,
I see your point and your algorithm looks pretty reasonable. Except
that again it can be reasonable for you but not for general case which
is SQLite for. You have one flaw: SQLite doesn't "read page list in
cache", it reads every page that is needed during query execution. So
if one applied your al
> You said that only references are changed, right? That means, during appends
> the page content is still valid even if B-trees structure is changed because
> of references.
If B-tree is implemented with concurrency in mind then yes, but SQLite
wasn't implemented this way. First of all when page
> The writer application must be failsafe, as much as possible (acoustic
> emission recording devices); I simply can not afford that a reader makes a
> select and because of a programming error the acquisition be blocked. I had
> this just by opening sqliteman.
>
> The recording rate is variable; u
> sqlite> SELECT Min(m) AS m FROM t WHERE 1=2;
> m
> --
> sqlite> SELECT Min(m) FROM t;
> Min(m)
> --
> 88
Puneet, note that you probably missed one empty row of terminal output
in the first query above and when there's no row returned sqlite3
command line utility doesn't print any
On Tue, Mar 9, 2010 at 7:34 AM, Pavel Ivanov wrote:
>> sqlite> SELECT Min(m) AS m FROM t WHERE 1=2;
>> m
>> --
>> sqlite> SELECT Min(m) FROM t;
>> Min(m)
>> --
>> 88
>
> Puneet, note that you probably missed one empty row of terminal output
> in the first query above and when there
Probably I will express just my opinion but still...
Gabriel, what you described is clearly not a good or anywhere intended
use of SQLite. If you need writing at the rate of 800,000 records per
second you can't afford using database engine for this. Much better
option for you will be to have some
On Tue, Mar 9, 2010 at 6:18 AM, Tim Romano wrote:
> Wrapping a column in the min() function causes a query that returns no
> rows to return a row?
>
> select c from T where 1=2 // returns 0 rows
The above is correct SQL, and the answer is correct.
> select min(c) from T where 1=
Hello,
Thanks for your attention,
> Although speaking generally such method could be used in some situations, I
> don't think it's good to allow to use it even with a "i know what I'm
> doing"
> pragma. Any structured file (sqlite is an example) have internal
> dependencies. One of the reasons to
Hello again,
I start with your final words, "it's a general database engine".
On the main page it writes:
"Think of SQLite not as a replacement for Oracle but as a replacement for
fopen()"
That's why I try sqlite and not other database (I actually tried embedded
innodb but sqlite was muuuch bette
Sure I could have some kind of intermediate storage, but that would mean
unnecessary data moving / copying.
I really hope that I'll find some time and try to study the source and
eventually implement my ideas (maybe others find it interesting and/or
useful too).
You said that only references are c
> Then I tried in a loop with 2 programs to write / read in parallel and it
> seems to work without problems. Can anyone advise if this has any chance to
> work (or say it would definitely NOT work)?
>
> As a short summary: would it be interesting for anyone to enable read-only
> open with a specia
Wrapping a column in the min() function causes a query that returns no
rows to return a row?
select c from T where 1=2 // returns 0 rows
select min(c) from T where 1=2 // returns 1 row
select min(88,99) from T where 1=2 // returns 0 rows
Tim Romano
On 3/9/2010 4:15 AM,
> Wrapping a column in the min() function causes a query that returns no
> rows to return a row?
Yes, it's SQL standard for aggregate functions (min, max, avg and
count): without GROUP BY clause they always return one row.
Pavel
On Tue, Mar 9, 2010 at 7:18 AM, Tim Romano wrote:
> Wrapping a c
On 3/9/2010 8:04 AM, P Kishor wrote:
>
>> select min(88,99) from T where 1=2 // returns 0 rows
>>
> The above is correct SQL and the answer is correct. Per the docs,
> "Note that min() is a simple function when it has 2 or more arguments
> but operates as an aggregate function if given only
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> __ Informazioni da ESET NOD32 Antivirus, versione del database delle
> firme digitali 4927 (20100309) __
>
> Il messaggio è stato controllato da ESET NOD32 Antivirus.
>
> www.nod32.it
>
>
>
>
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello everybody,
I have the following situation:
1. a writer needs to continuously append some data in 1 or 2 tables, *
without* any possibility to be blocked.
2. one (or eventually more) reader needs to read the data for analysis.
Pt 1 is very important; therefore I use a "PRAGMA locking_mode =
Hi,
try this:
select coalesce(min(length), 0) from t where id = ?
Martin
Andrea Galeazzi schrieb:
> Hi All,
> I've got a table T made up of only two fields: INT id (PRIMARY KEY) and
> INT length.
> I need a statement in order to yield 0 when the key doesn't exist. At
> this moment the query i
Hi All,
I've got a table T made up of only two fields: INT id (PRIMARY KEY) and
INT length.
I need a statement in order to yield 0 when the key doesn't exist. At
this moment the query is too simple:
SELECT length FROM T WHERE id = ?
Any idea about it?
Cheers
__
73 matches
Mail list logo
