er using SQLite in their product should never have to mess
with SQLITE_CORE. The SQLITE_CORE macro is for internal use only. If
you find a case where you think you have to set SQLITE_CORE manually
in order to compile SQLite, that is bug - either in SQLite itself or
in your use of SQLite.
, then the file name argument passed to the program
> is
> encoded in GB18030, and this exact byte stream (without any encodig
> conversion) shoud be passed to system APIs. Correct me if I'm wrong
> here,
> please.
I designed and implemented SQLite under the assumption that unix
alw
ts in
mutex_unix.c to see if the HOMEGROWN_RECURSIVE_MUTEX implementation
really is safe for FreeBSD.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ain that all prepared statements are finalized prior to
calling sqlite3_close()?
I have no idea what kind of VFS layer is being used for the iPhone.
It might be something custom. If so, there could be a leak in the VFS
layer someplace.
D. Richard Hipp
[EMAIL PROTECTED]
_
't make any difference. But for a table with millions of
entries, you could run into performance problems.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
LIKE 'AA' is
true but 'aa'='AA' is false.
The previous paragraph is true by default. There are ways of changing
the default. For example, if you declare a column to be COLLATE
NOCASE then it will not be case sensitive (for US-ASCII characters).
And there is a PRAGMA that will mak
bigendian, regardless of what
processor is being used. The database files are cross-platform
between PPC and x86.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
gh "where app like 'AA'" works! The LENGTH()
> function returns the number of characters which one would expect.
Did you use bind_text, or bind_blob? What does:
SELECT typeof(app) FROM ...
Tell you? Comparing a BLOB to a text string is always false in SQLite.
specially section 9.0: Things That Can Go Wrong.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
wchar_t *)b,
> (alen < blen) ? alen : blen);
>
> if(r == 0)
> r = alen - blen;
>
> return r;
> }
>
> Still doesn't work though :(
>
How did you register the collating sequence? Did you use the
SQLITE_UTF16_ALIGNED argumen
urself, or are you really using _wcsnicmp()?
You might want to have a look at how the "NOCASE" collation is
implemented in the nocaseCollatingFunc() function in the main.c source
file of SQLite.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-us
ls with this error.
The error only occurs if the temp_store value really is trying to
change. If the new temp_store value is the same as the old, no error
is generated. Are you sure you had not already issued the PRAGMA once
before, prior to starting the trans
rhaps also provide us
with a C preprocessor macro that we can use to conditionally compile
for AIX.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
is used to do the sort.
So there is potentially some memory savings from specifying a LIMIT
with an ORDER BY but the computation time is roughly the same with or
without the LIMIT. The query still must compute the entire result set
before it outputs the first row.
D. Ri
e patch
would be inserted would be the sqlite3_os_end() implementation at the
very bottom of os_win.c.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
with the upcoming release, or finds omissions
or errors or ambiguities in the documentation, now would be a very
good time to speak up. Thank you for your attention.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users
on rounds toward zero. And
2.3*100.0 in IEEE float notation is
229.971578290569595992565155029296875 which when rounded
toward zero yields 229.
See also http://www.sqlite.org/faq.html#q16
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-user
te3_get_table() to
find out?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ite::db commit failed: database is locked(5) at dbdimp.c
> line 218 at db_access.pl
>
> what would be the reason , is it about a permission issue or coding
> issue ?
> Please help
>
Do you have write permission on /var/tmp?
D. Richard Hipp
[EMAIL PROTECTED]
___
te that there is a subtle change in column naming that will
appear in version 3.6.0 - a change which I believe will make SQLite
behave more like MySQL and omit the table names in cases where they
are not needed. So version 3.6.0 might work for your situation above
without the use of AS. But
ubquery runs once and the results are
cached. In the second query, the subquery runs once for each row in
the result set.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ng. I'm running on Ubuntu 8.04, and I don't have any
> multiple threads or clients or virus software running, so I can't see
> why the database would be locked. The database file gets created okay,
> but it's empty.
>
> Any suggestions?
>
Are you using an NFS filesystem?
rv = sqlite3_bind_blob(pStmt, 3, (void*)1, 0,
> SQLITE_TRANSIENT);
>
>}
>
Perhaps the statement would read better as follows:
rv = sqlite3_bind_blob(pStmt, 3, "", 0, SQLITE_TRANSIENT);
D. Richard Hipp
[EMAIL PROTECTED]
In SQLite, we have observed that NaN detection does not work with -
ffast-math. This problem cascades whenever NULL values and floating
point values are intermixed.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.
an_year = bbb.human_year
> AND aaa.human_month = bbb.human_month
> AND aaa.human_day = bbb.human_day) AS num_unique_visits
> FROM nm_visitors AS bbb
> GROUP BY human_year, human_month, human_day
> ORDER BY date DESC LIMIT
____
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hence when
extending the size of a database file, a rollback journal does less I/
O than a replay journal.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ge burden - something worth
avoiding. In practice it is usually very fast. What problem are you
trying to solve?
No, there is no other way to validate an SQL statement.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@s
memory, especially
in memory-constrained devices such as cellphones.
Keeping track of changes is not a problem with a rollback journal, you
will notice. The current value of any page can always be obtained
directly from the database file using the page number to compute the
offset.
D. Richard Hip
n see above.
>
Production tests for the descending index feature are found here:
http://www.sqlite.orc/cvstrac/fileview?f=sqlite/test/descidx1.test
http://www.sqlite.orc/cvstrac/fileview?f=sqlite/test/descidx2.test
http://www.sqlite.orc/cvstrac/fileview?f=sqlite/test/descidx3.tes
an steer
SQLite toward the better choice with the judicious use of a "+" symbol.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
every test I have
tried, SQLite does in fact use an index on WHERE pk<=X ORDER BY pk
DESC. If you can demonstrate a case where it does not, we will fix it.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
ht
to being given a preallocated but empty file
> that
> exists.
No. SQLite sees a file of zeros as a corrupt database. The internal
structure of the file must be correctly initialized.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users
DROP TABLE dummy;
Change the argument of zeroblob to get the size you want.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
friends. Or omit the -DSQLITE_DEBUG=1
that you are currently using and the assertion will not fail. Either
way, it should start working for you.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:80
; same function. Inside sqlite3FaultEndBenign(), a static variable,
> aFault, is
> accessed (operator--, which i believe is read,modify,write) without
> the
> protection of a mutex.
It is not a bug because sqlite3FaultEndBenign() is used during testing
only. And the tests in whi
t
proposed changes that might impact projects can be found at:
http://www.sqlite.org/draft/doc/35to36.html
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Jun 30, 2008, at 2:37 PM, Andrea Connell wrote:
> Any ideas? It's driving me crazy why SQLite is this much slower on
> UNIX
> boxes, while other applications maintain their speed.
What filesystem are you using on the unix boxes? Are you *sure* you
are not using NFS?
D. Ric
INDEX ev4_idx ON event(type);
Or perhaps:
CREATE INDEX ev4_idx ON event(type, tid);
Try that and see if it works better for you.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Jun 25, 2008, at 2:23 PM, <[EMAIL PROTECTED]> <[EMAIL PROTECTED]
> wrote:
> Is there a way in a user program to get the db file name that has been
> associated with a particular sqlite3* ?
>
PRAGMA database_list;
D. Richard
On Jun 25, 2008, at 12:48 PM, Wilson, Ron P wrote:
> It seems to me that using NULL ... could
> create a lot of confusion in queries.
Yes, yes. SQL-NULL excels at creating confusion!
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailin
a NULL which is a placeholder for an unknown
value which might be a 1 or a 2 - we just don't know.
If I understand Peter correctly, he is saying that NULL should mean
"unknown" in the context of the RHS of a NOT IN operator. SQLite does
not currently operate this way. SQLite cur
s do
it differently, do you have any evidence that this really is incorrect?
NULL behavior in SQL is highly unintuitive. In fact, as far as I can
tell it is arbitrary. Can you or anybody else point to text in any
SQL spec that would suggest that SQLites behavior in this case is wrong?
D. R
en fixed. http://www.sqlite.org/cvstrac/chngview?cn=5207
and http://www.sqlite.org/cvstrac/tktview?tn=3172
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
lite.org/download.html)
on your database file so that we have a better idea of what kind of
data we are dealing with?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
written in C, not C++. You have to use a C compiler to
compile it. If you compile to object code, you can normally link it
against C++ code without difficulty. But you cannot compile SQLite
directly using a C++ compiler.
D. Richard Hipp
[EMAIL PROTECTED]
__
ot. The -DSQLITE_THREADSAFE=0 eliminates the
needs for pthreads and -DSQLITE_OMIT_LOAD_EXTENSION=1 removes the
requirement for dlopen, and on most systems those are the only two
libraries required. But if your system doesn't have a Bourne shell,
who knows what other peccadillos lurk around
l_mode=OFF on any database that you cannot recreate in its
entirety from secondary data following a program crash.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
use of SQLite. An Mozilla is a sponsor of the SQLite
project. So by supporting firefox, you are also supporting SQLite!
You have a little less than 24 hours. Go download your copy now.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing
MARY KEY)
> vs.
> CREATE Table myTab ('AUTOINCREMENT col' INTEGER PRIMARY KEY)
>
http://www.sqlite.org/c3ref/table_column_metadata.html
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
. Text sorts next in the order determined by the collating
sequence
4. BLOBs sort last in memcmp() order.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
;AS" clause on each column. The column naming algorithm for results
without an AS clause has changed in the past and will probably change
again in the future. So make no assumptions. Always use an AS clause.
D. Richard Hipp
[EMAIL PROTECTED]
__
ER BY owner} {
puts ${(owner)}
}
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
; of the
> 1000 queries have this error) as a return from the function when
> using the
> same data. Is there any known compatibility issues between SQlite
> and Vista,
> specifically 64-bit?
There are no known issues. Can you tell us what the query is and what
your database sche
On Jun 11, 2008, at 10:07 AM, Dennis Cote wrote:
> D. Richard Hipp wrote:
>>> i always get the error "unable to open database file", error number
>>> is 14
>>>
>>
>> Probably it is unable to open a temporary file in /tmp or /var/tmp or
>
On Jun 10, 2008, at 7:55 PM, Igor Tandetnik wrote:
> D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>> On Jun 10, 2008, at 4:04 PM, Robert Lehr wrote:
>>> Specifically, does SQLite lock the DBs incrementally, as they are
>>> accessed within the transaction? Or does
anybody an idea??
>
Probably it is unable to open a temporary file in /tmp or /var/tmp or
wherever temporary files are suppose to live on your system.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
; transaction? what locking sequence does SQLite execute?
>
> If a transaction reads from multiple DBs but WRITES to only one DB,
> what
> locking sequence does SQLite execute?
>
Databases are locked as needed - incrementally.
D. Richard Hipp
[EMAIL PROTECTED]
y never block waiting on
the writer since they will be serialized.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
repared statements on a
single table at a single time. The above is not correct.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
t uses something different, SQLite won't work on it (or at
least it won't have a compatible file format.) I have never yet heard
of this being a problem for anyone.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Jun 7, 2008, at 4:40 PM, Peter K. Stys wrote:
> On Thu, Jun 5, 2008 at 2:04 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>
>>
>> On Jun 5, 2008, at 12:09 PM, Shawn Wilsher wrote:
>>
>>> Hey all,
>>>
>>> We are getting reports that
I'd like to take credit for the new r-tree module because it is a fine
piece of work. But in truth the new r-tree module was written
entirely by Dan Kennedy. http://www.sqlite.org/crew.html Good job,
Dan!
D. Richard Hipp
[EMAIL PROTECTED
On Jun 5, 2008, at 1:32 PM, Shawn Wilsher wrote:
> On Thu, Jun 5, 2008 at 4:04 PM, D. Richard Hipp <[EMAIL PROTECTED]> wrote:
>> I think the solution might be as simple as compiling with -
>> DSQLITE_ENABLE_LOCKING_STYLE=1. This option only works on a Mac. It
>> ena
FF handled all of its own locking
such that the SQLite database locking was really unnecessary. Is that
still the case? If so, then perhaps the simplest solution here would
be to provide a new compile-time option to disable all of the locking
logic on all systems.
D. Richard Hipp
[
lite.org/cvstrac/fileview?f=sqlite/ext/rtree/README=1.4
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Jun 4, 2008, at 7:13 AM, Derrell Lipman wrote:
> On Wed, Jun 4, 2008 at 10:01 AM, D. Richard Hipp <[EMAIL PROTECTED]>
> wrote:
>
>>
>> Let me strongly reiterate that you look into using the new R-Tree
>> virtual table available for SQLite. R-Trees are sp
ght now might not be the best time to recompile the core from CVS.)
To compile the R-Tree extension, you only need rtree.c and rtree.h,
which you can pull directly from the website without having to use
CVS. (OK, you'll probably also need sqlite3.h an
r SQLite. R-Trees are specifically designed
to do exactly the kind of query you are asking to do. See
http://www.sqlite.org/cvstrac/fileview?f=sqlite/ext/rtree/README=1.2
R-Trees will be way faster than anything you will do using B-Tree
indices.
D. Richard Hip
m [test]
>>
>> The returned value is 2.2737e-13 instead of 0.
>>
>> Can anyone shed some light?
>>
Floating point round-off error. The number 720.237 does not exist as
an IEEE 754 floating point number. So an approximation has to be
used. In this case, the ap
ng edge, you might want to investigate SQLite's R-
Tree capabilities.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On May 31, 2008, at 7:41 AM, Aladdin Lampé wrote:
>
> Hi!
> I remember a message from DRH about SQLite's roadmap for 2008,
> stating that the file format specification would be explained and
> released in itself.
> Are you still working on that?
Yes
D. Richard Hip
On May 30, 2008, at 7:52 AM, Ralf Junker wrote:
> This undefined sort order has changed between previous versions and
> might do so again in the future.
I would change "might" in the previous sentence to "probably". ;-)
D. Ric
ll not slow it down. The
ORDER BY will simply prevent some future version of SQLite from using
some newer algorithm that returns results in a different order.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.or
describe above, and then verify that the transaction automatically
rolls back to its original state. We have done so since version 3.0.0.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
se confirm this is ok and also which address I should send it to
> (if
> other than the one you're using for this list).
>
No one will see the database besides me. I will delete it once the
bug is fixed.
Send to the address below.
D.
org
using fossil:
http://www.sqlite.org/docsrc
http://tdbc.tcl.tk/
http://3dcanvas.tcl.tk/fossil
http://www.fossil-scm.org/ (Fossil is self-hosting)
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-us
On May 28, 2008, at 11:25 AM, Jens Miltner wrote:
> s there any work being done trying to either minimize the
> synchronization needed or provide a memory allocator that doesn't do
> all the alerting
Yes. This has been requested before and will appear soon.
D. Richard Hipp
[EMAIL
On May 27, 2008, at 12:50 PM, Nicolas Williams wrote:
> On Mon, May 26, 2008 at 11:20:27AM -0400, D. Richard Hipp wrote:
>> SQLite already allows three different names for the rowid: "rowid",
>> "oid", "_rowid_". If all three names are taken
itten this part
> yet due
> to sqlite_sequence corruption, so at this point we're only reading
> from the
> table, not updating/inserting into it).
>
> Our app is using sqlite 3.5.9. I'm still using sqlite3.exe 3.5.7
> but I see
> the same corrupted data in both.
>
>
truncate or overwrite the journal header
(depending on journaling mode)
The difference between FULL and NORMAL is that NORMAL omits the
fsync() on step 2. That is the only difference. The step-2 fsync is
important on some filesystems, but on ext3 it is probably
unnec
on, the same code compiled with -
DSQLITE_NO_SYNC=1 is between 40 and 70 times faster:
real0m10.479s
user 0m6.736s
sys 0m3.732s
Oh, what a difference a disk cache makes.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-u
resets the last_insert_rowid when a trigger exits does not apply since
the trigger has already existed by the time the FTS virtual table does
its INSERT. (NB: I have not verified this in a debugger - it is just
my theory.)
D. Richard Hipp
[EMAIL PROTECTED]
___
no longer make them unique and they will work like MSSQL.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ppens
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
at means that if Firefox or your system crashes, you
might loss your last 30 seconds of browser history, but nobody really
cares about that really.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
o
serialize access to separate database connections again, just like in
3.4.2.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, and
figure it out. Let us know if you find anything interesting.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
st-insert-rowid. But one can
easily imagine other virtual tables that are more transparent and in
which the programmer would expect the last-insert-rowid to be
updated. How do you specify when the last-insert-rowid is updated and
when it is not?
So it is not at all clear to me whether this behavior is a bug or a
feature. SQLite is doing what the documentation says it ought to do.
The question is, should the specification of what SQLite ought to do
change in order to be less surprising to programmers? And if so, what
would that new specification be?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
OK. How about:
INSERT INTO foo(bar) VALUES(coalesce(?,'default-value'));
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
constraint error.
>
REPLACE INTO foo(bar) VALUES(?)
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
ite for blobclo is
> 10 but why i get this error
>
That limit can be lowered at compile-time and in more recently
versions at run-time. Perhaps turbogears is lowering the limit on you.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-user
On May 19, 2008, at 9:16 PM, Skip Evans wrote:
> D. Richard Hipp wrote:
>> What does this show:
>>
>>SELECT DISTINCT typeof(startyear) FROM bsp_options;
>>SELECT DISTINCT typeof(endyear) FROM bsp_options;
>>
> I pasted those two statements into the
4) NOT NULL DEFAULT '0',
> endyear VARCHAR(4) NOT NULL DEFAULT '0',
> options TEXT NOT NULL,
> productcodesize VARCHAR(10),
> productdesc VARCHAR(200),
> pattern VARCHAR(10)
> );
What does this show:
SELECT DISTINCT typeof(startyear) FROM bsp_options;
SELECT DISTINCT typeo
in, a lightweight and versatile
> PHP/MySQL, AJAX & DHTML development framework.
> http://phpenguin.bigskypenguin.com/
> _______
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
esides on a remote
machine, you should probably use a client/server database engine with
the server located on the same machine where the data lives.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlit
On May 14, 2008, at 2:14 PM, Petite Abeille wrote:
>
> On May 14, 2008, at 8:10 PM, D. Richard Hipp wrote:
>
>> Works for me. Did you compile the shell yourself or use the prebuilt
>> binary?
>
> I did compile it myself. Any additional configuration(s) one shou
On May 14, 2008, at 1:59 PM, Petite Abeille wrote:
> Hello,
>
> On May 14, 2008, at 7:17 PM, D. Richard Hipp wrote:
>
>> There is also a new *experimental* PRAGMA called "journal_mode"
>> which can provide performance improvements under some circumstances.
&
es changes in the VFS layer used to tie SQLite into the
underlying operating system.
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
anybody have any thoughts on this proposed behavior changes for
the sqlite3_close() interface?
D. Richard Hipp
[EMAIL PROTECTED]
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
601 - 700 of 1539 matches
Mail list logo