Greetings,
I have an application that uses SQLite 3.3.2 right now, and I'm
looking to move to 3.5.2. The problem I have right now is that 3.5.2
can't open the 3.3.2 formatted database files. I know that the file
format changed, and then changed back, but I thought there was still a
way to get
Arun Bhalla wrote:
2) In order to help diagnose the problem, we ran some unit tests, and we
had some unusual results:
c) On a Linux/x86 VM (running under Windows), some tests fail. I
don't have the specifics at the moment, but that would be cause for
alarm, particularly the failures are
Given the following table:
BEGIN TRANSACTION;
CREATE TABLE chain( a integer, b integer);
INSERT INTO "chain" VALUES(1,2);
INSERT INTO "chain" VALUES(2,3);
INSERT INTO "chain" VALUES(3,4);
INSERT INTO "chain" VALUES(2,8);
INSERT INTO "chain" VALUES(1,5);
COMMIT;
select * from chain where ( a=2
Arun Bhalla <[EMAIL PROTECTED]> wrote:
> Hello there,
>
> I have a couple related questions:
>
> 1) Is anyone aware of any recent cases of SQLite DB corruption?
All known database corruption issues are described at
http://www.sqlite.org/cvstrac/wiki?p=DatabaseCorruption
Additional
Hello there,
I have a couple related questions:
1) Is anyone aware of any recent cases of SQLite DB corruption? We
upgraded from SQLite 3.3.6 to SQLite 3.4.1 a few months ago. In the
last couple days, we've encountered a couple cases of SQLite reporting
that a DB file had become corrupted
Most languages have the ability to kick off different threads that run in
the background. You can have a writer thread that dumps the queue and then
sleeps for another minute and then continues the loop. I don't know PHP,
but a quick search found that it does have a Thread class which I
Given the following table:
BEGIN TRANSACTION;
CREATE TABLE chain( a integer, b integer);
INSERT INTO "chain" VALUES(1,2);
INSERT INTO "chain" VALUES(2,3);
INSERT INTO "chain" VALUES(3,4);
INSERT INTO "chain" VALUES(2,8);
INSERT INTO "chain" VALUES(1,5);
COMMIT;
select * from chain where ( a=2
I am using sqlite3 in a DAQ device. Data can be viewed on the unit using a
Rails enabled web server.
The data is being stored to the database every 1 to 5 seconds. I wanted to
leave the the database open for as long as teh application is running and
then use a IMMEDIATE, PREPARE-INSERT(x),
Hi All,
I could use your help in finding an optimal query for the following:
DATA:
BEGIN TRANSACTION;
CREATE TABLE chain(interger a, integer b);
INSERT INTO "chain" VALUES(1,2);
INSERT INTO "chain" VALUES(2,3);
INSERT INTO "chain" VALUES(3,4);
INSERT INTO "chain" VALUES(2,8);
INSERT INTO
[EMAIL PROTECTED] wrote:
> The new look for the SQLite website is now in place,
> if you haven't already noticed:
>
> http://www.sqlite.org/
>
> Even though the new look is "in place" you should
> understand this as a work in progress, not a done
> deal. I am still looking for suggestions,
[EMAIL PROTECTED] wrote:
Martin Pelletier <[EMAIL PROTECTED]> wrote:
Hello,
I am trying to optimise an SQLite database running on Windows. One of
the things I'm looking at is page size. However, a page on sqlite.org
(http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows)
Martin Pelletier <[EMAIL PROTECTED]> wrote:
>
> On a side note, that comment on the page
> (http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows) should
> really be clarified to reflect what you just told me. It is clearly told
> that the page_size cannot be changed, but the bit about
FredAt wrote:
Samuel R. Neff wrote:
You could maintain a queue in memory of all the data to be written, have
each page view queue up the new data and have a single db writer thread
that
dequeues items and writes to the db. That way you get the benefit of
writing directly to the db, but do
Martin Pelletier <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am trying to optimise an SQLite database running on Windows. One of
> the things I'm looking at is page size. However, a page on sqlite.org
> (http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows) mentions
> this:
>
> "Just a
Dear Fred,
I am using SQLite always in conjunction with PHP for web applications.
To give you an idea about the possibilities :
a. web application for law office :
- holds history for approx. 10.000 files with regards to accounting and
timesheets referenced to those files
- holds complete
FredAt <[EMAIL PROTECTED]> wrote:
> > It generally works better to append logging information to a file
> > (since this avoids the overhead of updating indices and doing
> > atomic commits) then transfering the information into an RDBMS
> > (SQLite or other) for analysis.
> >
>
> So, I guess I
I use static libraries and gcc. Just use --enable-static and you should
get the link library created.
A.J.Millan wrote:
Hi all:
Instead the supplied DLL, I would like to statically link the SQLite
library in a new project, and I wonder if someone has build a SQLite
static library xxx.a
> It generally works better to append logging information to a file
> (since this avoids the overhead of updating indices and doing
> atomic commits) then transfering the information into an RDBMS
> (SQLite or other) for analysis.
>
So, I guess I could write to a flatfile and then run a daily
Hello,
I am trying to optimise an SQLite database running on Windows. One of
the things I'm looking at is page size. However, a page on sqlite.org
(http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows) mentions
this:
"Just a note that you must also perform this command [PRAGMA
Samuel R. Neff wrote:
>
>
> You could maintain a queue in memory of all the data to be written, have
> each page view queue up the new data and have a single db writer thread
> that
> dequeues items and writes to the db. That way you get the benefit of
> writing directly to the db, but do not
You could maintain a queue in memory of all the data to be written, have
each page view queue up the new data and have a single db writer thread that
dequeues items and writes to the db. That way you get the benefit of
writing directly to the db, but do not have the extra overhead on each page
Size should not be a problem.
Thank you very much!
--
View this message in context:
http://www.nabble.com/Would-SQLite-be-a-good-choice-tf4821074.html#a13794433
Sent from the SQLite mailing list archive at Nabble.com.
Hi,
the colors of the links are reversed: By default,
links that have not been visited are blue and visited
links are purple. The sqlite website makes visited links
green and unvisited links purple.
This is *very* confusing.
Michael
FredAt <[EMAIL PROTECTED]> wrote:
> Hello All,
>
> I have used SQLite off and on in Windows applications I have written and I
> really like it. However, what I am now considering doing is using a SQLite
> database to log access to one of my websites - I need to get a great deal
> more
Hi all:
Instead the supplied DLL, I would like to statically link the SQLite
library in a new project, and I wonder if someone has build a SQLite static
library xxx.a using minGW in Windows and the sources/headers contanied in
the sqlite-source-3_5_2.zip
Any tips on that are welcome.
25 matches
Mail list logo