; g3.ADDED_DATE,
> g3.NUMERIC_VALUE,
> g4.ENTRY_ID,
> g4.READ_CODE,
> g4.TERM_TEXT,
> g4.START_DATE,
> g4.ADDED_DATE,
> g4.NUMERIC_VALUE
> from
> A3TestB67_J t1
> left join GROUP_2 g2 on (t1.PATIENT_ID = g2.PID)
> left join GROUP_3 g3 on (t1.PATIENT_ID = g3.PID
> > Try setting sqlite3_int64 to just "int" and compiling with
> > -DSQLITE_32BIT_ROWID=1. That might work.
> > --
> > D. Richard Hipp <[EMAIL PROTECTED]>
>
> "So apparently your compiler cannot cast a double to type xlong_t."
> That's because I did the earlier xlong stuff by hand. I can try
Your INSERT OR REPLACE statement is in error.
You have fewer columns in your SELECT clause than are specified
in your INSERT column name list. You should have seen an error like
this in SQLite version 3.3.12:
SQL error: X values for Y columns
Assuming PATIENT_ID is the sole unique key for A3
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> There is one important problem though that I just discovered.
> Just found out that the maximum number of tables in a join is 32!
> So, with my base table that is only 31 to add.
Let's do some grepping...
#define BMS (sizeof(Bitmask)*8)
...
/* T
> I wonder what the reason was to limit the number of table joins to 32.
http://www.sqlite.org/cvstrac/chngview?cn=3622
Finding fabulous fares is fun.
Let Yahoo! FareChase search your favorite travel sites
--- "Anderson, James H (IT)" <[EMAIL PROTECTED]> wrote:
> The following works fine in sybase, but because in sqlite "update" does
> not support "from" it doesn't work. Is there another way of doing this?
>
> Thanks,
>
> Jim
>
> update C1_credDerivEvent
>set CDEvent = a.CDEvent || ',' || b.CD
--- chueng alex1985 <[EMAIL PROTECTED]> wrote:
> I don't think so. If the field has been indexed, searching speed will be
> imprved very much. The query "f1 = value1 OR f1 = value2 OR f1=value3 OR
> ..." will be faster if the field f1 has been indexed. On the other hand, the
> clause "f1 in (value1
t;[EMAIL PROTECTED]> wrote:
> Thanks, Joe! That looks like it might be the solution.
>
> -Original Message-
> From: Joe Wilson [mailto:[EMAIL PROTECTED]
> Sent: Friday, February 02, 2007 9:58 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Another sybase co
Is UPDATE OR REPLACE always equivalent to just UPDATE?
Food fight? Enjoy some healthy debate
in the Yahoo! Answers Food & Drink Q&A.
http://answers.yahoo.com/dir/?link=list&sid=396545367
-
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > Is UPDATE OR REPLACE always equivalent to just UPDATE?
>
> No. UPDATE is the same as UPDATE OR ABORT. Try replacing
> the UPDATE OR REPLACE in the following script with just
> UPDATE to see the
--- Dennis Cote <[EMAIL PROTECTED]> wrote:
> On 2/3/07, Tom Shaw <[EMAIL PROTECTED]> wrote:
> > SQLSTATE[HY000]: General error: 1 SQL logic error or missing database
> > and
> > SQLSTATE[HY000]: General error: 8 attempt to write a readonly database
>
> Tom what wrapper are you using to access sqli
http://www.mail-archive.com/sqlite-users@sqlite.org/msg19628.html
--- Alex Cheng <[EMAIL PROTECTED]> wrote:
> I encountered a problem. I have two servers (A and B) which host two same
> DBs, each of them may be modified. If the DB has been modified on server A,
> the DB on server B should also kee
--- Shane Harrelson <[EMAIL PROTECTED]> wrote:
> On 2/5/07, Dennis Cote <[EMAIL PROTECTED]> wrote:
> > Shane Harrelson wrote:
> > > Perform 50 transactions of 1000 inserts each (5 total).
> > >
> >
> > Shane,
> >
> > Is this your normal usage pattern? Inserting records in blocks of around
> >
--- Andrew Teirney <[EMAIL PROTECTED]> wrote:
> If you are interested in the "BEGIN SHARED" transaction i posted a
> simple patch to this mailing list within the last month if i recall
> correctly.
http://www.mail-archive.com/sqlite-users@sqlite.org/msg21260.html
Do you find that using this BE
--- Shane Harrelson <[EMAIL PROTECTED]> wrote:
> On 2/5/07, Joe Wilson <[EMAIL PROTECTED]> wrote:
> > > Yes, it's typical. Each database instance is typically composed of
> > > around 50k records, all inserted in a single pass. If I could do
> > >
> Would there be any benefit to "pre-sorting" in this scenario?
somewhat related discussion:
http://www.mail-archive.com/sqlite-users@sqlite.org/msg19111.html
Sucker-punch spam with award-winning protection.
Are the corrupted attachments prior to the CVSTrac upgrade recoverable
into the current SQLite Trac system?
http://www.sqlite.org/cvstrac/tktview?tn=2208
If not, could you please post the old Trac attachment table in a
compressed database on sqlite.org?
thanks.
___
> I understand that I'm experiencing thrashing, but I'm curious as to why I'm
> experiencing it. My understanding is that the row_id PRIMARY KEY column has
> an index on it by default. Inserting into this index doesn't cause
> thrashing, but inserting into the secondary index does. I hoped that
> e
Nice job on the new driver.
The new DSN parameter LoadExt=module1.dll,module2.dll for dynamically
loadable sqlite extension modules is particularly useful.
The SQLite+TCC extension is very cool.
Thanks.
--- Christian Werner <[EMAIL PROTECTED]> wrote:
> Version 0.72 of the SQLiteODBC Driver is
--- David M X Green <[EMAIL PROTECTED]> wrote:
> I'm trying sqlite3 run on WinXP by console using
> (1) cygwin bash &
> (2) bash run on rxvt.
> I find sqlite3 - interactive does not work well with .help.
> With just bash only part of the help printed to the screen; though the second
> attempt
Hi Christian,
I'm not sure what this patch to SQLite 3.3.12 does.
Is it fixing a bug or extending SQLite for use in your ODBC driver?
Should a ticket be created for it in SQLite CVSTrac?
thanks.
# patch: parse foreign key constraints on virtual tables
patch -d sqlite3 -p1 <<'EOD'
diff -ur sqlite
The sqlite autoconf stuff has been neglected for a while...
http://marc.10east.com/?l=sqlite-users&m=116760371614235&w=2
Consider making a ticket for this issue and mentioning it in this autoconf meta
ticket:
http://www.sqlite.org/cvstrac/tktview?tn=2133
--- Mike Frysinger <[EMAIL PROTECTED
It does not appear that the recent INSERT checkin speeds up bulk inserts
on already populated tables with many indexes:
[3643] Add a new algorithm for handling INSERT
which reduces fragmentation on a VACUUM
http://www.sqlite.org/cvstrac/chngview?cn=3643
http://www.sqlite.org/cvstr
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> Trying to update my mmdd integers to months with a SELECT CASE
> statement:
>
> SELECT CASE
> (CAST(DATE_OF_BIRTH / 100 AS INTEGER) - CAST(DATE_OF_BIRTH / 1 AS
> INTEGER) * 100)
> WHEN 1 THEN UPDATE A2IDC21_J SET DATE_OF_BIRTH = 'January'
> WHE
--- P Kishor <[EMAIL PROTECTED]> wrote:
> On 2/18/07, Neil McLeod <[EMAIL PROTECTED]> wrote:
> > I just started using SQLite, and it seems my timestamps are all 5 hours
> > ahead of time (i.e. "select current_time" gives me 0:47 when it is actually
> > 19:47 here). I guess this is GMT. Is there a w
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- P Kishor <[EMAIL PROTECTED]> wrote:
> > > On 2/18/07, Neil McLeod <[EMAIL PROTECTED]> wrote:
> > > > I just started using SQLite, and it seems my timestamps are all 5 hours
> 1) need to know if sqlite can help me cut down on the number of little db's
Sure.
> 2) can I use it for a message store and have it run faster than a 1
> message per file system?
What does that mean? Is "file system" a unit of time?
You can store messages in BLOBs or as TEXT in an SQLite ta
--- [EMAIL PROTECTED] wrote:
> A double is sufficient to store the current time to with about
> 25 microseconds. If you use 'now' to get the current time, the
> date functions try to capture the current time to this precision.
> That is implemented in the os_XXX.c layer. It's system dependent.
>
Can you post the schema of the tables in the SELECT?
--- Matt Froncek <[EMAIL PROTECTED]> wrote:
> I have a program generator that creates ORs in SQL nested. This causes a
> stack overflow in SQLite. Has this been addressed or will it be? If so what
> version was it addressed. I am not sure how to
--- "Shan, Zhe (Jay)" <[EMAIL PROTECTED]> wrote:
> If to use SQLite to create a database in Linux, the database file will
> be granted permission 644 as default.
> Is this value hardcoded in the current version? Is it possible to
> change this default vaule, say to 664 or something else?
man umask
--- [EMAIL PROTECTED] wrote:
> The default maximum stack depth is 100. If you are planning
Have you given any consideration to a variable sized yystack?
Parser memory used might be less in typical cases considering
sizeof(yyStackEntry)*100 = 2000 bytes on x86.
The yyParser struct would need a
--- "Shan, Zhe (Jay)" <[EMAIL PROTECTED]> wrote:
> I've tried umask, but it does not work for SQLite.
Here are the default permissions used with open()'s O_CREAT flag:
src/os_os2.h:# define SQLITE_DEFAULT_FILE_PERMISSIONS 0600
src/os_unix.c:# define SQLITE_DEFAULT_FILE_PERMISSIONS 0644
But uma
> Any suggestions?
If you know that you will likely only perform per-site queries then
you want all the readings for a given site contiguous in the database
file (or files). You can accomplish that in many ways, as you've outlined.
Hopefully your reading_id's always increase as time goes forward
They're probably harmless.
Even so, can you post the file name/line of one example of each of the
following 3 warnings as they seem odd:
warning C4047: 'initializing' : '__int64 (__cdecl *)(struct Mem *)' differs
in levels of indirection from 'char *(__cdecl *)(const char *,char *)'
warning C41
call any
> ** of the APIs above provided that the pointer is not NULL. But
> ** before calling APIs that follow, extension should check the
> ** sqlite3_libversion_number() to make sure they are dealing with
> ** a library that is new enough to support that API.
>
The suggested changes the web site recommends are incorrect:
loadext.c
Comment out the following lines is loadext.c by adding 2 back slashes ("//")
to the start of the
line. This prevents errors due to our changes.
sqlite3_changes,
sqlite3_close,
sqlite3_last_insert_rowid,
sqlite3_libver
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> Downloaded it from the one you pointed to me:
You're confusing me with someone else.
Here's a way to build sqlite3.dll without Microsoft tools using the
official sources:
Grab and install MinGW and MSYS (google for it),
download http://sqlite.org/sq
--- RB Smissaert <[EMAIL PROTECTED]> wrote:
> Could try with MinGW and MSYS and it may give less warnings, but would it
> produce a dll that is any better? If possible I want to avoid installing
> more software when I already have VC6++.
It's completely up to you. How much time do you want to spen
--- Adam Megacz <[EMAIL PROTECTED]> wrote:
> INSERT INTO "foo" (a,b,c) VALUES (x,y,z)
>
> So, question: is there a way to get the .dump command to emit dumps in
> the latter form?
Not to my knowledge.
It would be nice if .dump could optionally omit PRAGMAs as well.
___
--- Adam Megacz <[EMAIL PROTECTED]> wrote:
> Using sqlite 3.3.10 I'm experiencing a strange situation where .dump
> appears to repeat the last few lines of the dump (not including the
> final "COMMIT") twice.
>
> Has anybody else experienced this?
I've never seen this before. Does it happen with
--- Dan Kennedy <[EMAIL PROTECTED]> wrote:
> On Tue, 2007-02-27 at 10:48 +0100, Michael Schlenker wrote:
> > Hi all,
> >
> > for some uses its nice to query the PRAGMA and the sqlite_master table
> > with a single query instead of multiple PRAGMA statements.
> >
> > Could the Pragmas to query th
> > 2007/2/27, Jakub Ladman <[EMAIL PROTECTED]>:
> > > Dear Friends
> > > Please let me know what should i do with this?
> > >
> > > SQLite version 3.3.13
> > > Enter ".help" for instructions
> > > sqlite> create table tbl1(one varchar(10), two smallint);
> > > SQL error: database is locked
> > > s
On second thought, instead of -D__DJGPP__, comment out the following
lines in src/os_unix.c instead:
/* #ifdef __DJGPP__ */
# define fcntl(A,B,C) 0
/* #endif */
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> I suspect file locking via fcntl() is not working in your embedded libc.
I don't have access to Windows 95, but you might try finding the highest
version of sqlite3 that did work on 95 and then diff'ing the code (probably
os_win.c) in the next version to see what change broke it and then attach
it to the ticket you've already created. The problem is likely something
t
What sort of SQL statements will benefit most from this change?
Large delete operations or vacuum? What about query speed?
Bored stiff? Loosen up...
Download and play hundreds of games for free on Yahoo! Games
--- Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> woj <[EMAIL PROTECTED]> wrote:
> > Now, when I run a query:
> > SELECT Mieszalnia.IdMat, Mieszalnia.Partia, Mieszalnia.Kont,
> > Mieszalnia.Uk, Max(Mieszalnia.Data) FROM Mieszalnia;
> > I always get:
> > IdMat Partia KontUk Data
> > 6
--- [EMAIL PROTECTED] wrote:
> Is there something that the SQLite core can do better?
Perhaps exclusive locks on journal files would help avoid this problem.
Or are the -journal and etilqs_* files supposed to be sharable by other
sqlite processes?
http://www.backupassist.com/BackupAssist/faq.ht
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- [EMAIL PROTECTED] wrote:
> > > Is there something that the SQLite core can do better?
> >
> > Perhaps exclusive locks on journal files would help avoid this problem.
> > Or are t
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> There's also this - CreateFileTransacted():
>
> http://msdn2.microsoft.com/en-us/library/aa363859.aspx
>
> which has the argument:
>
> dwShareMode
> ...
> If this parameter is 0 (zero) and CreateFile
I noticed that one of the sqlite contrib files had 1500 downloads in a single
day this past week, which is around 100X normal. I'm guessing it was a robot.
I see that Google and many other websites' robots.txt prefer this form:
Disallow: /contrib/download/
over this form:
Disallow: /contri
Are you mixing Cygwin and MinGW libraries and/or header files?
--- timm2 <[EMAIL PROTECTED]> wrote:
> Using dev-c++ 4.9.9.2-wx-beta-6.8 with mingw 3.4.2 I have got the error:
>
> sqlite3.A(.text+0x44):fake: multiple definition of `atexit'
> C:/../lib/gcc/mingw32/3.4.2/../../../crt2.o(.text+0x260)
I haven't heard of Dev-Cpp.
If you use MinGW gcc from http://mingw.org/ and MSYS, you shouldn't have any
problems.
--- timm2 <[EMAIL PROTECTED]> wrote:
> I use MMinGW as it was installed by Dev-Cpp, I think, thera are no Cygwin
> files.
> Tim
>
> > Are you mixing Cygwin and MinGW libraries and/
--- Dennis Cote <[EMAIL PROTECTED]> wrote:
> You could also improve the locality in the database file further by
> running a vacuum command after it has been created. this will move the
> pages around so that the page of the table are contiguous and so are the
> pages of the index, rather than h
--- [EMAIL PROTECTED] wrote:
> Gerry Snyder <[EMAIL PROTECTED]> wrote:
> > Chris Jones wrote:
> > > Hi all,
> > >
> > > I have a very simple schema. I need to assign a unique identifier to a
> > > large collection of strings, each at most 80-bytes, although typically
> > > shorter.
> > >
> > > T
--- turnleftjohn <[EMAIL PROTECTED]> wrote:
> improved dramatically. So I attempted the creation of the index off hours on
> the production system, and after 4 hours no index. I can't detect any
> activity at all. The journal file and the .db file just sit at the same size
> for 4 hours. Why is t
--- turnleftjohn <[EMAIL PROTECTED]> wrote:
> the production system, and after 4 hours no index. I can't detect any
> activity at all. The journal file and the .db file just sit at the same size
> for 4 hours. Why is this failing? It seems like it is just sitting there
> doing nothing. When I c
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> >
> > See also: Changes to support fragmentation analysis in sqlite3_analyzer.
> > http://www.sqlite.org/cvstrac/chngview?cn=3634
> >
>
> I'm not real sure those patches are w
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> >
> > As for the stats from sqlite3_analyzer, they seem to be in the right
> > ballpark.
> > But I'm not sure its heuristic accounts for rows that are significantly
> > larger
>
What operations/work patterns will benefit most from
PRAGMA locking_mode = EXCLUSIVE?
Can you roughly quantify the speedups in such cases?
TV dinner still cooling?
Check out "Tonight's Picks" on Yahoo! TV.
h
--- Dennis Cote <[EMAIL PROTECTED]> wrote:
> Dennis Volodomanov wrote:
> > Is doing a SELECT EXISTS (...) faster than a SELECT COUNT (... LIMIT 1)
> > or would it be the same (I would expect them to be the same, but that's
> > only my guess)?
> >
> I would expect them to be very nearly the same.
--- Alberto Simões <[EMAIL PROTECTED]> wrote:
> I have a database with three tables (bigrams, trigrams and
> tetragrams). Basically, they are:
>TABLE( A, B, Count) IDX(A,B) IDX(B)
>TABLE( A, B, C, Count) IDX(A,B,C) IDX(B) IDX(C)
>TABLE( A, B, C, D, Count) IDX (A,B,C,D) IDX(B) IDX(C
--- Alberto Simões <[EMAIL PROTECTED]> wrote:
> The tables are related but they are already being created in parallel
> (three tables). I was joining them just because it was easier to move.
> But given the new, erm, big size, I think I'll maintain them split.
>
> Joe Wi
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> > improved dramatically. So I attempted the creation of the index off hours on
> > the production system, and after 4 hours no index. I can't detect any
> > activity at all. The journal file and the .db file just sit at
--- Dennis Volodomanov <[EMAIL PROTECTED]> wrote:
> Yes, after timing both I found that SELECT EXISTS is actually a tiny bit
> faster, which does matter when multiplied by thousands of executions in
> a row.
>
> Unfortunately, I still cannot get it as fast as I want - it takes
> approximately 1500
Congratulations. This is a big milestone.
The single "sqlite3.c" source file release will certainly simplify
embeddeding.
I guess the single translation unit thing is why GCC is busy working
on link-time optimization (and why LLVM is faster in some cases).
--- [EMAIL PROTECTED] wrote:
> When y
Assuming you're running on multi-core machines, spread the work over a few
threads/connections.
--- Dennis Volodomanov <[EMAIL PROTECTED]> wrote:
> Oops - that last sentence I wrote actually doesn't make sense :) I know
> what prepared statements are as I'm using them (doh!). I might have a
> prob
AFAIK The behavior you're looking for is not well defined by the JDBC API:
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/Statement.html#addBatch(java.lang.String)
Perhaps some JDBC drivers implement the behavior you expect, but
--- [EMAIL PROTECTED] wrote:
> If you insert records in order of ascending integer primary
> key, then the inserts will be very fast. If you insert records
> where the integer primary key is randomized, inserts will be
> reasonably fast until the size of your table exceeds the size
> of your disk
--- [EMAIL PROTECTED] wrote:
> There is a plot of runtime of CVSHEAD versus version 3.3.13
> at
>
>http://www.sqlite.org/relspeed-20070326-ephemeral.gif
>
> Any value less than
> 1.0 means that performance has improved. The test script is
>
>http://www.sqlite.org/cvstrac/fileview?f=sql
--- Charles Cazabon <[EMAIL PROTECTED]> wrote:
> I'm using sqlite (through the pysqlite wrapper, but this behaviour seems
> unrelated to the wrapper) in an application on various platforms. One process
> create an sqlite database and starts writing data to it; another process opens
> the sqlite da
--- Charles Cazabon <[EMAIL PROTECTED]> wrote:
> I'm using sqlite (through the pysqlite wrapper, but this behaviour seems
> unrelated to the wrapper) in an application on various platforms. One process
> create an sqlite database and starts writing data to it; another process opens
> the sqlite da
> I'd have thought so, too. I've confirmed fdatasync shows up in the symbols in
> the compiled sqlite library, and that two instances of the `sqlite3` SQL shell
> don't show the problem. Unfortunately, two minimal Python programs don't show
> the problem either.
>
> That points to the applicatio
erformance when the disk caches are cold. Linux
> kernel 2.6 seems to get no benefit, 2.4 gets more. This is somewhat
> of a special case, though, as fts2 segment merges are merging streams
> from different locations together, like an external sort.
>
> -scott
>
>
>
--- [EMAIL PROTECTED] wrote:
> It has already been reported that Apple Mail keeps all its metadata
> in an SQLite database. (There was quite a stir in the Mac community
> a few weeks ago when somebody discovered and blogged that you could
> substantially increase the speed of Apple Mail by running
--- Mitchell Vincent <[EMAIL PROTECTED]> wrote:
> Yes, I know about creating a function but I'm wondering if I can hook
> into the already-existing Windows API function for it. Currency
> formatting is quite complicated (much more than just storing a
> currency "symbol") and Windows has already don
--- Dan Kennedy <[EMAIL PROTECTED]> wrote:
> I checked the code and conflict handling mechanisms (OR ERROR,
> OR ABORT, OR REPLACE) do not apply to virtual tables.
...
> Something to think about anyhow... Do we want conflict handling
> for FTS (and other virtual modules)?
It would be nice if any
--- [EMAIL PROTECTED] wrote:
> It may be more difficult to implement this in a backwards-compatible
> way such that older versions of SQLite can rollback a journal created
> by a newer version if it encounters one.
I wonder if there are many projects that have different versions of
SQLite updatin
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > --- [EMAIL PROTECTED] wrote:
> > > It may be more difficult to implement this in a backwards-compatible
> > > way such that older versions of SQLite can rollback a journal created
> >
Unfortunately, the sqlite3 commandline shell is not part of the test suite
despite its widespread use as an administrative tool for sqlite databases.
http://marc.info/?l=sqlite-users&m=117253099812346&w=2
But you know this already - you're the same guy as this previous post. :-)
--- Travis Day
> What is worse is that VACUUM didn't really help that much. It takes
> forever, and it doesn't really "fix" the fragmentation either.
That used to be the case, but VACUUM is vastly improved in the latest
version of SQLite.
___
--- Mike Johnston <[EMAIL PROTECTED]> wrote:
> Are there any significant performance benefits by limiting the number of
> columns in a single
> table select statement? Does joining (<5 tables) make a significant
> difference to that answer?
If you need the columns, you don't have much choice b
--- [EMAIL PROTECTED] wrote:
> Consider this query:
>
>SELECT a, b FROM t1 UNION SELECT b, a FROM t1 ORDER BY a,b;
>
> Is the query above equalent to:
>
> (1) SELECT a, b FROM t1 UNION SELECT b, a FROM t1 ORDER BY 1,2;
>
> Or is it the same as:
>
> (2) SELECT a, b FROM t1 UNION S
--- "Andrey A. Lapin" <[EMAIL PROTECTED]> wrote:
> I develop database in which information on the traffic (headings of packets
> MAC, TCP/IP) is stored.
> Processing of queries occurs slowly.
> For example, quantity of records in a database of 17 million lines and its
> size 3 Gb.
> How to increase
--- DragonK <[EMAIL PROTECTED]> wrote:
> I'm having the following problem: a sqlite database file is on an NTFS
> filesystem, in a directory with no permissions to create new files, but only
> to modify the original database. By using filemon i've noticed some access
> denied errors when sqlite at
--- [EMAIL PROTECTED] wrote:
> I'm using cygwin under windows XP.
> gcc version 3.4.4
>
> I unzipped the sqlite-3.3.16.tar.gz to the directory sqlite-3.3.16.
>
> Executed the following:
>
> cd sqlite-3.3.16
> mkdir build
> cd build
> ./configure
> make
>
> The resulting sqlite3.exe is 4 times b
--- Miha Vrhovnik <[EMAIL PROTECTED]> wrote:
> > strip sqlite3.exe
> is not ok at least for DLL, because it strips everything even reallocation
> info.
> strip --strip-unneeded sqlite3.dll
The GNU toolchain's strip command corrupts the reallocation information for
MinGW DLLs, so I would not rec
> I've used SQLite-3.3.4 for quite a while, mostly the Tcl binding.
> A few days ago I installed 3.3.15 and the Tcl binding worked fine.
> Tonight I downloaded 3.3.16 and compiled it without any errors
> or warnings and then installed it. When I tried to execute sqlite3
> the following error appere
> I've used SQLite-3.3.4 for quite a while, mostly the Tcl binding.
> A few days ago I installed 3.3.15 and the Tcl binding worked fine.
> Tonight I downloaded 3.3.16 and compiled it without any errors
> or warnings and then installed it. When I tried to execute sqlite3
> the following error appere
--- [EMAIL PROTECTED] wrote:
> Ulrich =?iso-8859-1?q?Sch=F6bel?= <[EMAIL PROTECTED]> wrote:
> > On Saturday 21 April 2007 15:40, Joe Wilson wrote:
> > >
> > > Apply this patch to fix this problem.
> > >
> >
> > Thanks for the patch, but t
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> In general, sqlite3.so is backwards compatible, but not necessarily
> forward compatible. So you can upgrade an older binary to use a more
> recent 3.x sqlite3.so release, but not the other way around.
I meant to to say:
In general
I noticed that sqlite tar.gz downloads prior to
http://sqlite.org/sqlite-3.3.10.tar.gz
are missing. So historical releases are not available except by CVS.
Is this intentional?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam pro
--- Ulrich Schöbel <[EMAIL PROTECTED]> wrote:
> Thanks for the patch, but there is still something wrong in the
> linking stage.
>
> I have 3 instances of SQLite on my system:
> The first is 3.2.1, installed with the system and not used, at least
> not by me, library in /usr/lib.
> The second is i
--- [EMAIL PROTECTED] wrote:
> Joe Wilson <[EMAIL PROTECTED]> wrote:
> > I noticed that sqlite tar.gz downloads prior to
> >
> > http://sqlite.org/sqlite-3.3.10.tar.gz
> >
> > are missing. So historical releases are not available except by CVS.
> &
This libtool --tag problem does not seem to be unique to sqlite.
http://lists.freebsd.org/pipermail/freebsd-questions/2005-November/104076.html
I think it's a question for the freebsd port maintainers.
--- snowcrash <[EMAIL PROTECTED]> wrote:
> hi,
>
> building v3.3.16 from src on osx works fi
The test script itself has the test.db open, and as result Windows cannot
delete an open file. It worked on UNIX because you can delete anything at
any time whether it is open, running, locked or whatever.
If you apply this patch, exclusive2.test will run to completion on cygwin
without error. It
a better patch...
Index: test/exclusive2.test
===
RCS file: /sqlite/sqlite/test/exclusive2.test,v
retrieving revision 1.4
diff -u -3 -p -r1.4 exclusive2.test
--- test/exclusive2.test16 Apr 2007 15:02:20 - 1.4
+++ test
What's an ads1.2?
--- [EMAIL PROTECTED] wrote:
> Dose anybody compile the sqlite3 in the ads1.2 environment?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
-
Try compiling with sqlite3.c from http://sqlite.org/sqlite-source-3_3_17.zip
It is already pre-generated and does not require generating the parser from
the .y file.
See: http://www.sqlite.org/cvstrac/wiki?p=TheAmalgamation
--- [EMAIL PROTECTED] wrote:
> arm developer suite v1.2
> support arm7,
> When I try to use the header I get errors
>
> [C++ Error] sqlite3.h(1778): E2232 Constant member
> 'sqlite3_index_info::nConstraint' in class without constructors
It appears it is trying to compile the sqlite header file as if it were C++.
Lemme guess - you're using the almalgomated sqlite3.
I wrote too quickly - sqlite3.h correctly uses __cplusplus for extern "C".
But the almalgomated sqlite3.c cannot be compiled from a C++ compiler
for the reasons described below.
--- Joe Wilson <[EMAIL PROTECTED]> wrote:
> > When I try to use the header I get error
1 - 100 of 764 matches
Mail list logo