14 messages in org.openoffice.fr.progRe: [prog] Auto-installer une BDD SQLite
FromSent OnAttachments
Yves ChaufourJun 27, 2004 12:57 pm 
Yves ChaufourJun 27, 2004 1:39 pm 
JovialJun 27, 2004 1:40 pm 
ARGENTE Jean LouisJun 27, 2004 2:57 pm 
Tony GALMICHEJun 28, 2004 3:46 am 
Yves ChaufourJun 28, 2004 12:48 pm 
Yves ChaufourJun 28, 2004 1:11 pm 
Tony GALMICHEJun 28, 2004 10:59 pm 
ARGENTE Jean LouisJun 29, 2004 10:36 am 
ARGENTE Jean LouisJun 29, 2004 1:28 pm 
Yves ChaufourJun 30, 2004 12:23 pm 
ARGENTE Jean LouisJun 30, 2004 5:38 pm 
Sophie GautierJul 1, 2004 12:12 am 
Yves ChaufourJul 1, 2004 12:06 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:Re: [prog] Auto-installer une BDD SQLiteActions...
From:ARGENTE Jean Louis (jl.a@laposte.net)
Date:Jun 29, 2004 1:28:20 pm
List:org.openoffice.fr.prog

Re bonsoir Yves,

[Bon les listes semblent une fois de plus dans le cirage depuis qques heures, nous ne savons quand nos posts passeront :( le nettoyage de scob serait il passe par la ???]

Je t ai repondu tout a l heure, mais j ai oublie un autre post de Marketing sur le meme sujet; des "petites" lignes qui te rendent hommage (pas besoin de rougir ;) , grace a votre boulot a tous et aussi au travail et aux interventions de Sophie, qui le fait savoir, fr.openoffice.org ne passe pas inapercu ;) :

============================== On Mon, 2004-06-28 at 19:03, Alex Fisher wrote:

On Tue, 29 Jun 2004 00:26, Frank Schönheit wrote:

Hi Søren,

Hi Frank.

I took a look around SQLite's site the other day. A couple of comments inline...

We're talking about a 2.0 time frame, and it's improbable that SQLite will have the features we're looking for until then ...

I do not question your evaluation, but please elaborate.

From the top of my head:

- a rather unusual type concept: http://www.sqlite.org/datatypes.html Note that I am not judging this concept here, I just say that it's unusual, and would require some effort to ensure that the rest of

OOo

The problem for OO.o would possibly be more in the way that SQLite allows the storage of any data type in any part of the table *regardless of the defined type for that field*.

- which is used to the stronger type system used in other databases - is not affected. It's simply a certain risk here. - no support for BLOBs (except in a way which requires additional effort on OOo side to implement it properly)

I'm assuming you are referring to the ability to store a BLOB in a text (or int) field. The latest version does boast support for BLOBs however...

- no support for ALTER TABLE

Not sure about that one...

However, I did notice an announcement on the Documentation list where someone announced that they had added a HOW-TO on using SQLite with OO.o. That might be worth checking out, as it could help supply a little more info for you (obviously the writer has had it working...).

I recommend you read the original http://fr.openoffice.org/Documentation/How-to/Bdd/08SQLite.pdf by Yves Chafour and the translation http://documentation.openoffice.org/HOW_TO/data_source/SQLite.pdf by me.

And yes I have it working.

Ciao Frank

-- Documentation Co-Lead "Dinna meddle wi' things ye ken nuthin' aboot!" J.H. =========================

Le lun 28/06/2004 à 21:48, Yves Chaufour a écrit :

Le dimanche 27 Juin 2004 23:57, ARGENTE Jean Louis a écrit :

Bonsoir,

Juste une petite remarque, il semblerait que le choix d une BDD incorporee a OOo 2.0 puisse etre HSQLDB.

Merci pour cette info. Je viens d'aller voir les messages s'y rapportant sur [dev-fr].

...

...

Jean Louis

--------------------------------------------------------------------- To unsubscribe, e-mail: prog@fr.openoffice.org For additional commands, e-mail: prog@fr.openoffice.org