Le samedi 24 Juillet 2004 23:29, D. Richard Hipp a écrit : > M. Fioretti wrote: > > > >>The main drawback of SQLite is that it doesn't support ALTER > >>TABLE. It's a big limitation for simple users when building a > >>database. If this fonctionnality (and a few others) could be add in > >>a near future, SQLite would probably become the first choice for > >>OOo. > >> > > > > ALTER TABLE will probably start appearing (in stages) over the > next several months. Rename table and rename column will appear > first. Then add column and drop column. Finally add and drop > constraints. > Why has it not been added for SQLite 3 ? It's perhaps the more wanted SQLite feature, and we can't understand why it isn't yet implemented. > > > > 2) > > > >>So I hope that SQLite developpers will be able to work together with > >>OOo developpers to write an embeded OOo driver for SQLite (not > >>ODBC), and then to store SQLite database in the future OOo base file > >>format. > > > > Storing an SQLite database as part of a larger file is problematic. > (1) The SQLite database section needs to be contiguous and it > needs to be growable. So at the very least, it would need to be > at the end of the larger file. (2) If stored as part of a larger > file, standard tools (such as sqlite3.exe) would not be able to > read it since they would not know where to look for the start of > the database. (3) SQLite needs a separate rollback journal file > in order to support ACID transactions. Perhaps these objections > could be overcome if I better understood the problem. > I and a few other independant OOo users have tested OOo with SQLite and HSQLDB. Our goal is that these test results help the OOo dba developpers to make the choice of the next OOo embedded database. Our tests show that SQLite has very good performance, and that HSQLDB is very very slow when making requests. This is perhaps because of the slow interface (via jni) between HSQLDB (java) and OOo (C++). SQLite doesn't have this drawback and is very fast with the ODBC driver. Despite of this reality, it seems that OOo dba developpers are going to choose HSQLDB (perhaps because Sun loves java ?). We think it would be a bad choice for OOo. SQLite is already a standard and is already used by many applications. SQLite must not loose the opportunity to be integrated in one of the biggest and more used open source application.
We are not programmers and we don't know if it's possible to store a SQLite database in a OOo file. The first step would be certainly to developp a native OOo driver for SQLite. This would allow all OOo users to use external SQLite databases within OOo without the ODBC driver, and to make it in a much easier and integrated way than today. We hope such a driver will be part of OOo 2.0. In a second time it could be interessant to find a solution for OOo to store the SQLite database in its own file. Yves
