.dat
select date('now');
.let f system echo "words-`cat .dat`.txt"
.once -let f
select word from words order by 1;
The system call argument maybe just 'todaysfile' which executes.
3. the .load command do
Logical expression always false
---
\ext\misc\ieee754.c line 89:
else if( m==0 && e>1000 && e<1000 )
Bye Martin Strunz
___
sqlite-users mailing list
sqlite-users@mailin
error".
Can you tell me if I am doing something wrong, or if there is a good reason for
this habbit?
All the programs connect to database at startup and close the databaseconnection
on program close.
Thanks for your help
Martin
___
sqlite-users ma
ead dump.sql
Error: near line 4: near "table": syntax error
The table name in the insert statement is not properly quoted.
I think that this behavior is related to the change (3) at
http://www.sqlite.org/src/info/e6eea8d50d
Thanks
Martin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
way to specify a
CREATE TABLE .. CHECK clause
to guard inserting a -mm-dd date into a text field.
Thanks, Martin.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
ciate renaming clear to drop is probably a non-starter for compatibility.
On the other hand, clear currently does do nothing.
Otherwise, thanks to the development team for a tool that just gets better!
Regards, Martin.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
only goes back to August '06) so I guess not too
many people. Presumably your server logs could be checked for non moz4
win98 users, if any. If that's the simplest solution then I'd go for it
and look again when if the attack reappears or if someone complains.
B
Jim Dodgen wrote:
Ha!!
Indeed ;)
Firefox warns that the page is a forgery and DNS fails so it's already
been zapped.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
I've seen some longish SQL queries posted to this list but I was
wondering, how often do 1000+ line queries (as in the SQLite benchmark)
occur in the real world? Do queries of this sort of size exist outside
of initialising tables with a long lists of inserts?
M
restrictive. No benchmarking for you then,
because the 25k line queries in the SQLite benchmark are nearly 2 meg. I
guess they're unusual but even the (more typical?) 100 liners can get up
to about 6-8k.
Martin
---
asn't sure what the problem was.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
w I didn't look into it as the disk getting full in the first place
was caused by a bug in my code. ISTR one of the tests is skipped (or is
it only in the full test?) because it takes ages to fill the disk up.
Have/can you run the suit
Hello everyone:
I reported this problem (http://www.sqlite.org/cvstrac/tktview?tn=2060)
back in November but there doesn't seem to be any progress towards a
solution, and the workaround suggested in the ticket doesn't work for me
because of the way I generate SQL.
I could even try to look into it
w many people (outside of Sun) are using sqlite3 on S9, but
I'd fired the box up for something else so I thought I'd give it a go.
The first is obviously down to the age and unmaintained status of the
autoconf stu
Martin Jenkins wrote:
Build fails on Solaris 9/Ultra5/csw tools
Can't find 'ar' so substitutes and attempts to fun 'false'
TMP FIX: AR=gar ../configure...
Forgot - fdatasync is in librt so most of the executables need $(TLIBS)
added to the end
Martin Jenkins wrote:
corrupt2 tests fail on Solaris 9/Ultra5/csw tools
Test file is not actually corrupted (ie altered at all AFAICS)
Exact same failure on a fresh Debian 3.1r4 install too. All other tests
passed OK.
[EMAIL PROTECTED]:~/dev/sqlite/bld$ uname -a
Linux ultra5b 2.4.27-3
[EMAIL PROTECTED]:~/dev/sqlite/bld$ cat fred
Hello SQLite
Hello SQLite
Hello SQLite
Hello SQLite
blah
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
uilt tcl8.4.9 from source on both machines and all tests pass on both.
So, the failure is a regression in Tcl sometime between 8.4.9 and
8.4.14. I'm going to wimp out and file a bug report rather than spend
any more time pinning down the exact
e files
should be opened with a 'RDWR' flag instead. Making that changes means
the tests pass under Tcl 8.5a5 but I haven't tested the other versions
of Tcl yet. I don't know why the test passed under Tcl8.4.9 either.
Martin
---
Martin Jenkins wrote:
I haven't tested the other versions of Tcl yet.
I have now. s/a/RDRW/ makes corrupt2.test work with Tcl 8.4.9, 8.4.12,
8.4.14 and 8.5a5 on recent versions of Debian/Ubuntu on sparc64 and x86.
M
shed.com/c/a/MySQL/An-Introduction-to-Database-Normalization/
The URL suggests it's for MySQL but it's pretty generic stuff.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
cally ?
Only you can answer the former ;) If you need that access control and
want to use SQLite then I guess separate files is as good as you'll get.
You could provide your own access control mechanism to a single file but
that&
Dan Kennedy wrote:
On Thu, 2007-02-15 at 11:49 +0100, Pavan wrote:
Can anyone tell me what is the difference between sqlite and sqlite3.
Also:
"SQLite - an embedded database library"
"sqlite3 - a shell to allow command line access to
Raised as ticket http://www.sqlite.org/cvstrac/tktview?tn=2232
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[EMAIL PROTECTED] wrote:
Martin Jenkins <[EMAIL PROTECTED]> wrote:
Raised as ticket http://www.sqlite.org/cvstrac/tktview?tn=2232
Thanks. Bug reports are always welcomed.
But this problem was fixed yesterday. When you see problems in
SQLite, especially problems that have been discus
ent if you
wanted to avoid joining with a month table.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
000 records takes about a third of a second
> ...
Will see if doing it with a substr function is any faster.
Would that work on integer numbers?
Dunno, but 80,000 updates a second seems quite good to me. How often do
you need to run this? Premature/excessive optimisati
tens of) seconds for the SQLite shell reading SQL
from a file or the same wrapper executing the statements individually.
For a 100k line bulk insert (e.g., restoring from a .dump to a disk
file) that could mean a slow down from about 25 seconds to over 5500
seconds, or 92 minutes...
M
x27;% + searchtext + "%'
OR note LIKE '% + searchtext + "%'
OR category LIKE '% + searchtext + "%'
OR displayas LIKE '% + searchtext + "%'
OR firstentry LIKE '% + searchtext + "%'
OR lastedit LIKE '% + searc
e and used a view to concatenate the columns
create view v as select pk, first||...||deleted as cols from addr;
you could reduce the select to
select * from addr where pk = (select pk from v where cols like srch);
Martin
---
from all rows where the columns joined together
matches your search text
)
BTW, I don't know how well this performs compared to the FTS extensions.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
is any other app
which assumes that advertised behaviour has been implemented correctly.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
is at the end.
HTH
Martin
Paste this into pp.sql and then "sqlite3 pp.db < pp.sql"
cut
DROP TABLE IF EXISTS Item;
CREATE TABLE Item(_Type, FullName, ListID);
INSERT INTO Item VALUES ('ItemInventory', 'FullNa
Joe Wilson wrote:
So this machine's minimum timer resolution is 0.0155 seconds,
or 15.5 milliseconds.
XP box?
XP & timers: http://www.lochan.org/2005/keith-cl/useful/win32time.html
Martin
-
To unsubscr
l catch on. :)
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[EMAIL PROTECTED] wrote:
Guess you can't please everybody :-) Right now we have some
documentation in the source tree and some on the wiki, which
I suppose is guaranteed to please nobody.
So make the wiki available for download. ;)
M
Matt Froncek wrote:
Martin,
Thank you for looking into this. The SQLite3.exe I tested with was 3.1.3.
And yes the SQL statement works fine as it. If you add one more nested OR to
the SQL statement then it stops working. I don't get a stack overflow like I
do in the ODBC driver I was te
is usually an error"
alarm. You want
> #define uchar unsigned char /* no asterisk here */
or even better
typedef unsigned char uchar;
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
off from the mode argument to open(2) (so, for example, the common umask
default value of 022 results in new files being created with permissions
0666 & ~022 = 0644 = rw-r--r-- in the usual case where the mode is
specified as 0
he file and malloc the right
sized buffer from the outset? Much easier.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
't comment. I'd be surprised though;
the zip file I used as input (no jpegs on that machine) has a zero at
byte 5 and the hundred odd jpegs I looked at on this machine all had a
zero at byte 4.
Martin
-
To uns
e's one at news.gmane.org.
Shout again if this didn't help. ;)
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
then I'll have a look and see if I can
find some VC6 project files for you. If I do I'll mail them straight to
you rather than clutter up the list. If they work I suppose they could
be uploaded somewhere.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
RB Smissaert wrote:
Now what do I do make it compile a dll called SQLite3VB.dll?
I think it defaults to the project name, but have a look at the Link tab
in the Project|Settings dialog (Alt-F7) - there's an edit box titled
"Output file name" which might do what you
K
in the other, so the compiler warns and it's up to you to check. If the
int/long variable only holds small numbers it's not significant but the
compiler can't tell what numbers will be stored and so it's back to you.
This explanation is brief and fairly rushed so may it not be completely
rigorous in places but I hope it helps a bit.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ries on the website - have you tried hacking that to
see if it will work on your system?
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
mxs wrote:
I had to google around to find out what is wxWidgets
...
I decided I'd like to try Python and SQLite
Check out wxPython too.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
oved completely, which also
suggests that the order is significant.
On that basis I'd expect to see the line
...
sqlite3_changes,
...
replaced with
...
0, // sqlite3_changes,
...
and not
...
// sqlite3_changes,
...
I can't comment on why Todd chose to re
nd got 500 warnings (signed/unsigned
mismatch, oddities in M$ headers, unreferenced parameter NotUsed ;)) but
not a C4028 in sight. VC6 is pretty old now - what version are you
using? And which sqlite source are you building
e says he lifted most of it from another site. ;)
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
1" at
the end of the line and rebuild your DLL. I can't say for sure because I
don't actually use VC6++ much - I bought a 2nd hand copy a couple of
years ago so I could compile Python/wxPython but they&
RB Smissaert wrote:
Will give that a try and see if it gives any less warnings.
OK, but as Dennis suggested and Dr Hipp has confirmed this isn't the way
to go. I was assuming the VB thing was a bit of a hack and didn't really
read enough of the C code
actually runs to do that thing can be changed,
possibly at runtime. You can disable entries by setting them to 0 (if
the infrastructure knows about it) but if you swap list entries around
(or delete them) things will break. That's where the VB DLL instruct
program
code, meaning the crash occurs some time later and far away from the
actual bug location. M$ have something called DEP in XP which is meant
to prevent this kind of thing, but it needs a reasonably up to date CPU.
We might
quot;, "import sqlite3")
print "%d us per connection" % (t.timeit(1) * 100/1)
265 us per connection
The C times will be faster, but not by much.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
inux Makefile like I suggested?
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Jakub Ladman wrote:
You want "make -f Makefile.linux-gcc"
This
> make Makefile.linux-gcc
Will try to build "Makefile.linux-gcc" from a file called "Makefile"
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ecute one statement at a time.
>>> c.executescript("begin; create table t(a); end")
Traceback (most recent call last):
File "", line 1, in
ProgrammingError: you did not provide a complete SQL statement
>>> c.ex
the above is TTBOMK.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
the new triggers, indexes etc
end transaction
drop the old table
vacuum the database
NB: I haven't tried or tested the above. ;)
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
connect)
So the difference in connect times between a database with 1 table and
10 tables is about 25%, fairly trivial 250us. With 100 tables connect
time is 3ms, worse by a factor of 4 but still not bad. With 1000 tables
the 33ms connect time becomes significant, but I wou
Martin Jenkins wrote:
So the difference in connect times between a database with 1 table and
10 tables is ...
It appears that adding indexes (and triggers?) increases the time at
about the same rate as adding tables. That is a connect/first select to
a database with 1 table and 3 indexes
l tables looked like
"tXXX(a INT, b INT, c FLOAT, d TEXT)"
and to add the indexes I just added a UNIQUE constraint to a, b & d. It
would be good to have some results from a real database.
Best Regards,
Martin
---
27;re nearly there. The compile has completed, and it's failed at the
link stage. You need to add "-ldl" to the end of the recipe so the
linker can find dlopen et al.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
hine? As
you've effectively made a effectively new port it would be a good idea
to try and get the tests working - they should pinpoint any areas which
aren't working. A list of failing tests should make it easier to track
the problem down than a "database l
te has over 20,000 tests in it, so it's well worth getting it going
on a port to a new platform.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
of years of testing in half an hour. If you
test the library and it passes, you can draw a line at the interface and
build on a solid foundation. If you don't test and you get odd bugs a
month down the line you'll never know if it's a porting problem or
tests with triggers is very different from tests without--are triggers
completely parsed and compiled every time a connection is opened?
I don't know. I'd assume that triggers were part of the "schema" and
would be parsed when (or shortly after) a
chema of "create table t(a,b,c)".
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
bor queries.
We also urgently need such a module, and think about implementing it on our
own. I would appreciate if efforts could be synchronized.
Best Martin
- Ursprüngliche Mail
Von: Michael Schlenker <[EMAIL PROTECTED]>
An: sqlite-users@sqlite.org
Gesendet: Dienstag, de
Cesar Rodas wrote:
The URL is ok, I opened here...
Works fine in .uk too
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Windows so how about something like:
create table t1 (id INTEGER PRIMARY KEY, name TEXT);
create table t1raw (id INTEGER, name TEXT);
.import imp3.csv t1raw
insert into t1(name) select name from t1raw;
drop table t1raw;
Martin
---
might
just mask the problem until later.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
half the cost of the printed version.
http://www.apress.com/ecommerce/cart.html?act=add&bid=10130
The printed contains details of how to get a PDF version for $10US, but
that's a bit Catch 22 here. ;)
Martin
--
Stef Mientki wrote:
so it was indeed a stupid question !
No, it was a well phrased question with a simple answer.
A stupid question is when the message is "I CANT OPEN A DATABSE!!! WHY
[EMAIL PROTECTED] IT WORK? IS IT A BUG!!!" and nothing else. ;)
mj
--
sy to dump both databases to text files
as (say) SQL and diff the text files?
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
it appears under /proc (/proc/config.gz?) - I don't suppose they've
done that?
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
I'll guess the odds of any patch being accepted are
significantly improved if the patch both passes and extends the test suite.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ot back. I
don't think that's a realistic test - the time it takes SQLite to find
the pages/data will be a tiny fraction of the time it will take to read
that data off the disk. You can't compare performance against reading
"records" out of the flat file beca
Chris Jones wrote:
realized that the unix "sort"
If I'd known you were on 'nix I'd have suggested using 'sort' and/or
'md5sum' about 12 hours ago. ;)
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
P Kishor wrote:
Mac/Unix person meself, but the Windows XP sort is pretty darn good as
well.
I'll take a look. Last time I used it it was useless. Win9x days? these
days (especially for a one off) I'd probably go straight to doing it in
Python to avoid x-platform syntax issues
ntext. Igor confirmed
that SQLite didn't behave like that and suggested possible explanations
for what you saw. If you don't like the answer, ask better questions.
Anyway, I thought you Ozzies liked a bit of direct speaki
transactions. I fixed the wrapper (locally) by adding an
sqlite_reset(). I think there's a new API (sqlite_prepare_v2()?) which
has the same effect. If you can't search (say) gmane then post a tiny
code snippet and someone who uses the C API more than I do will spot t
quot;v2" interface is recommended."""
you should NOT have to call sqlite3_reset() after an error. Perhaps
someone with experience of the C API could comment?
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
to start the boot process
yet, so I could be talking (more) nonsense (than usual). ;)
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
e sqlite3_reset. I still think the
docs imply something else though, but it's been one of those weeks. ;)
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
have.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
John Stanton wrote:
Perl would not do a good job. You need to use the Sqlite page
structures and they are defined in C terms.
But Tcl might. The test suite pokes about with SQLite internals.
Martin
-
To unsubscribe
d reviews and Celko seems well regarded.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
and I reckon
learning that SQL would be a lot easier than learning to use and/or
coding against the BTree interface.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[EMAIL PROTECTED] wrote:
Martin Jenkins <[EMAIL PROTECTED]> wrote:
Very true. Furthermore, the B-Tree interface layer is not a part
of the published API and as such it is subject to change without
notice and between point releases.
I nearly said that the B-Tree interface was unpub
fangles wrote:
When I have text pasted into an sqlite string field, it is stored okay but
when I retrieve a string, it is truncated at the first CR (0D).
Hi fangles,
Did you get this sorted?
Martin
-
To unsubscribe
Pavan wrote:
Does SQLite handle multiple request handling ?
Yes.
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
have to change if we would
also store the utf-chars as little endian?
I appreciate your help.
Martin
___
Der frühe Vogel fängt den Wurm. Hier gelangen Sie zum neuen Yahoo! Mail:
http://mail.yahoo.de
I use a twist on the various versions listed so far: "es cue el-ait".
Hearing "sequel" for SQL always makes me cringe.
Dennis Cote wrote:
I have a simple question; how do you pronounce SQL and SQLite?
--
Martin Pelletier
Informatique / Software Development
Infodev
consistent. ;)
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
P Kishor wrote:
On 4/5/07, Dan Baker <[EMAIL PROTECTED]> wrote:
pronounced sequel-lite by its creator..."
obviously the database is more ACID-compliant and consistent than the
database's creator. ;-)
I suspect the "sea-quell" pronunciation is a hangover from battleship
days at General Dyna
disagrees
can send me a WAV of how they say "XQP" for my consideration. ;)
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
[EMAIL PROTECTED] wrote:
www.wipro.com
Would this be Wipro, the outsourcing company?
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
l be 1000s of nodes in the data structure and it
will be searched millions of times. The data is not in any ordered form.
File system cache and plenty of RAM?
Martin
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
1 - 100 of 673 matches
Mail list logo
