I am using SQLite for a internal project. I has been under heavy use for
over 18 months. It is a CGI application/web service constructed of
31,000 lines of PERL and embedded SQL. It has worked flawlessly. Even
upgrades (currently 3.3.5) have been pretty smooth.
SQLite rules!
thanks to DRH
On Jul 14, 2006, at 23:43 UTC, Kees Nuyt wrote:
> The syntax descriptions about PRAGMA synchronous= could shed
> some light. http://www.sqlite.org/pragma.html#modify
> Note: The default for the "synchronous" PRAGMA is version
> dependent.
That's interesting. What is "the F_FULLFSYNC syncing meth
On Jul 15, 2006, at 00:27 UTC, Will Leshner wrote:
> Since I happen to know this is being done with REALbasic, are you
> calling COMMIT yourself, explicitly, or are you calling the Commit
> method? I suppose there could be a bug in the REALbasic plugin that is
> somehow preventing a commit from ha
On 7/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Yet my observations indicate that the database hadn't written anything to disk
in two days (or if it had, it somehow decided to roll back the last two days'
worth after the crash). Any insight on that?
It really sounds like you've nev
On Fri, 14 Jul 2006 16:59:55 -0600, you wrote:
>On Jul 14, 2006, at 22:53 UTC, Kees Nuyt wrote:
>
>> How many SQL commands are in your typical transaction?
>
>One.
>
>> Do you start them with a "BEGIN" ?
>
>No, I'm using implicit transactions.
Ok, I see.
>> If you never do a "BEGIN", every SQL c
On Jul 14, 2006, at 22:53 UTC, Kees Nuyt wrote:
> How many SQL commands are in your typical transaction?
One.
> Do you start them with a "BEGIN" ?
No, I'm using implicit transactions.
> If you never do a "BEGIN", every SQL command is
> one transaction, and "COMMIT" has no meaning.
Yes, I'm a
On Fri, 14 Jul 2006 16:37:49 -0600, you wrote:
>On Jul 14, 2006, at 22:22 UTC, Will Leshner wrote:
>
>> COMMIT should write the data to disk. Did you check errors after the
>> COMMIT to be sure there wasn't some kind of error?
>
>Yes, I checked, no error was ever reported. Also, I very clearly ha
On Jul 14, 2006, at 22:22 UTC, Will Leshner wrote:
> COMMIT should write the data to disk. Did you check errors after the
> COMMIT to be sure there wasn't some kind of error?
Yes, I checked, no error was ever reported. Also, I very clearly had all my
data accessible while the app was running, b
On 7/14/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
It's acting as though all the changes were held in memory, or somehow
journaled, and when the crash happened, the changes were all lost or rolled
back. What I need is a way to force the database to save its data to disk
while my app is
I've just lost a couple of days' worth of data when my app crashed. (Well, the
data wasn't a total loss thanks to backup plans, but the database itself
essentially reverted to its state of 2 days ago.) This is despite my app doing
a COMMIT after every modification of the DB.
It's acting as th
I think I found the problem.
I used a version of pysqlite compiled against sqlite3.2.8.
When used with the shared library from any sqlite 3.3.x version, every
sql operation eats all memory.
Thank you all for the help
On 7/14/06, Eduardo <[EMAIL PROTECTED]> wrote:
At 17:43 13/07/2006, you wrote
At 17:43 13/07/2006, you wrote:
Even the smallest sql statement (like PRAGMA temp_store = 1) triggers
this behaviour when using sqlite 3.3.x. I forgot to mention that I
connect to a :memory: database and then attach 2 database to the
connection.
Perhaps the 2 database attached are converted to
Thanks Martin for the quick response.
However, that was the original query and that didn't work. I've even tried
using alias on that (SELECT error as x. tt.error=x) to no avail.
I did tried setting the statement before to tt.error=error and that yields
me an output but the value of total
You can add Orb (www.orb.com) to the list.
Mike
-Ursprüngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 14. Juli 2006 17:04
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] Major projects using SQLite
=?iso-8859-1?Q?Jon_Garc=EDa_de_Salazar_Bilbao?=
=?iso-8859-1?Q?Jon_Garc=EDa_de_Salazar_Bilbao?= <[EMAIL PROTECTED]> wrote:
>
> Could you give examples of some major software projects using SQLite?
* Apple OS-X
* Solaris 10
* Firefox
* Monotone
* SymbianOS (used in cellphones)
* YUM
* America Online (AOL)
* PHP
* Philips MP3 players
* POPFile
*
Jon García de Salazar Bilbao wrote:
Hi,
Could you give examples of some major software projects using SQLite?
Thanks, Jon.
Trolltech's qtopia mobile phone platform is using sqlite for pim,
contacts, and document metainfo.
http://www.trolltech.com/products/qtopia
On Fri, 2006-07-14 at 15:16 +0100, Martin Jenkins wrote:
> Jon García de Salazar Bilbao wrote:
> > Hi,
> > Could you give examples of some major software projects using SQLite?
> > Thanks, Jon.
>
> Solaris 10 - http://blogs.sun.com/roller/page/eric_boutilier/20050405
>
> Martin
http://fedoraproj
Vivek R uttered:
Hi ,
I am New bee to the group and SQLite. Can anyone explain me How to port the
SQLite to DVD or Consumer products or any other Embedded Systems. Where I
can look for it ? What and all things to be considered while porting. Which
is the best version to port to consumer product
Jon García de Salazar Bilbao wrote:
Hi,
Could you give examples of some major software projects using SQLite?
Thanks, Jon.
FireFox 2.0..
--
Craig Morrison
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
http://pse.2cah.com
Controlling pseudoephedrine purchases.
http://www.mtsprofessional.com/
Many, many PHP based sites (Including parts of PHP.net itself IIRC)..
http://www.php.net/sqlite
- James
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: 14 July 2006 15:16
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Major projects using SQLite
Jon García d
Jon García de Salazar Bilbao wrote:
Hi,
Could you give examples of some major software projects using SQLite?
Thanks, Jon.
Solaris 10 - http://blogs.sun.com/roller/page/eric_boutilier/20050405
Martin
On 7/14/06, Jon García de Salazar Bilbao <[EMAIL PROTECTED]> wrote:
Hi,
Could you give examples of some major software projects using SQLite?
I created an events management website for a local convention.
sqlite was used for the storage and management of all the events at
the convention.
Hi,
Could you give examples of some major software projects using SQLite?
Thanks, Jon.
- PLEASE NOTE
---
This message, along with any attachments, may be confidential or legally privileged.
It is intended only for
Robert Wallner wrote:
Even the smallest sql statement (like PRAGMA temp_store = 1) triggers
this behaviour when using sqlite 3.3.x. I forgot to mention that I
connect to a :memory: database and then attach 2 database to the
connection.
I've been using the apsw and pysqlite wrappers for some tim
No doubt Igor or one of the others will be able to explain *why* your
SQL fails but changing line 1 from
> 1: SELECT testlog.error,
to
> 1: SELECT error,
works with Python 2.5 using the built-in sqlite (3.3.4) on XP and with
Python 2.4 and pysqlite (2.8.16) on Debian Sarge.
Martin
John Cr
"Alexei Alexandrov" <[EMAIL PROTECTED]> wrote:
> Still I can't understand why sqlite3_column_text returns (unsigned
> char *), but sqlite3_bind_text takes (const char *). What am I
> missing?
>
Why does signed vs. unsigned char matter to you?
Perhaps the interface could be more consistent. But
[EMAIL PROTECTED] wrote:
> Hi at all, I wanna use sqlite3 with masm but i could not found the
> sqlite3 struct. I only found typedef struct sqlite3 sqlite3; in
> sqlit3.h. Can someone help me?
struct sqlite3 is an opaque structure. Treat it like a void*.
--
D. Richard Hipp <[EMAIL PROTECTED]>
Pasquale Imbemba <[EMAIL PROTECTED]> wrote:
> Hi,
>
> is there any news about when this bug (read:
> http://www.sqlite.org/lang_expr.html) will be fixed?
>
It isn't a bug. That is the way LIKE works. But you
can change the behavior using:
PRAGMA case_sensitive_like=ON;
--
D. Richard Hipp
Still I can't understand why sqlite3_column_text returns (unsigned
char *), but sqlite3_bind_text takes (const char *). What am I
missing?
On 6/30/06, Alexei Alexandrov <[EMAIL PROTECTED]> wrote:
>
> Perhaps because it is returning UTF8 and that needs to be unsigned, not
signed?
>
Hmm, why sql
Hi at all, I wanna use sqlite3 with masm but i could not found the
sqlite3 struct. I only found typedef struct sqlite3 sqlite3; in
sqlit3.h. Can someone help me?
Greetings, cusDom
Hi ,
I am New bee to the group and SQLite. Can anyone explain me How to port the
SQLite to DVD or Consumer products or any other Embedded Systems. Where I
can look for it ? What and all things to be considered while porting. Which
is the best version to port to consumer product which runs VxWorks.
Hi,
is there any news about when this bug (read:
http://www.sqlite.org/lang_expr.html) will be fixed?
Cheers
Pasquale
Which is the best encoding for Indic Scripts? For Malayalam?
If UTF16, then what is the specification for defining a text field?
I use Windows XP with Service Pack2; SQLite336, SQLitedll336 and SQLiteODBC68
Regards, Hussain
On 6/28/06, RohitPatel <[EMAIL PROTECTED]> wrote:
> FWIW, if Windo
33 matches
Mail list logo