Re: [sqlite] SQLite: which platforms are supported?
"Alexei Alexandrov" <[EMAIL PROTECTED]> wrote: > > A side note: from previous experience with some other DB engines I > know that sometimes alignment issues are not minor at all. They can be > deeply in on-disk format and sometimes it is difficult to avoid them > without having to change the on-disk format. SQLite uses a byte-order and alignment independent on-disk format so that SQLite databases can be freely copied between machines with different processor and memory architectures. SQLite *never* stores an in-memory data structure directly to disk. So any alignment issues that might come up (and they do from time to time) are easily fixed. -- D. Richard Hipp <[EMAIL PROTECTED]>
Re: [sqlite] SQLite: which platforms are supported?
> > From your subsequent posts, I presume that you are figuring out > for yourself that there are no showstoppers, though perhaps some > minor alignment issues on ia64. > > I personally test each release on ix86 Linux (currently SuSE 9.2), > on Win2K (running under VMWare on the afore mentioned SuSE box) > and on MacOS 10.4 on a G5. That's all the hardware I have access > to. Yes, it seems that there are no showstoppers so far. Your test package is a great thing and I really like it. Though, I hardly will be able to use it on Windows x86_64/ia64 because I'm not sure that there is TCL available for those architecture on Windows. A side note: from previous experience with some other DB engines I know that sometimes alignment issues are not minor at all. They can be deeply in on-disk format and sometimes it is difficult to avoid them without having to change the on-disk format. This is why I'm checking it out early in the game. So far, it seems to be OK. Thanks to you for that. P.S. As kind of access to additional hardware have you ever heard about HP testdrive machines? You can take a look at it here: http://www.testdrive.hp.com/accounts/register.shtml -- Alexei Alexandrov
Re: [sqlite] SQLite: which platforms are supported?
"Alexei Alexandrov" <[EMAIL PROTECTED]> wrote: > Hi, > > We consider using SQLite for some of our applications and I would like to a= > sk > whether there are existing cases of using SQLite on the following OSes: > > - Mac > - Windows > - Linux > > and with following architectures > > - x86 > - x86_64 > - ia64 > > I just would like to get some information about whether there are any > showstoppers or serious problems that we can face with if we try to > use SQLite on those platforms. > From your subsequent posts, I presume that you are figuring out for yourself that there are no showstoppers, though perhaps some minor alignment issues on ia64. I personally test each release on ix86 Linux (currently SuSE 9.2), on Win2K (running under VMWare on the afore mentioned SuSE box) and on MacOS 10.4 on a G5. That's all the hardware I have access to. -- D. Richard Hipp <[EMAIL PROTECTED]>