[cvsnt] Re: CVSNT 2.6 database engine?

[Peter Crowther]

[via cranky WebMail, apologies for formatting]

From: cvsnt-bounces at cvsnt.org on behalf of Bo Berglund 
>>> I can see a size problem with storing files because at least MSDE2000 
>>> is limited to a 2Gb total database size. 
>> 
>>At the moment all the data is in the RCS files.. it'll end up in the 
>>database in the 3.0 timeframe...  

>OK, so the body of the files will be stored as text in the database 
>then? What about binary files? We have binaries that now have RCS 
>files in the 150-200 Mb range and it makes operations on these files 
>real slow. Keeping the admin data in the database would probably get 
>rid of all that speed problem. Could you not store the binaries in the 
>file system with pointers in the database? 

Ick :-).  Can I have a system that only requires *one* method of backup please? Preferably one that scales well to large repositories, allows me to do online backup and gives me a consistent point-in-time view of the repository, removes all of that foo with AV blocking access to the files... in fact, MSSQL will do me fine!

Also note that SQL Server 2005 Express will be out in the 2.5 timeframe - free (for some uses), and with a significantly higher limit per database.  Also the freebie Oracle versions... there are several choices.

Tony, out of interest, why are you having to work with custom mySQL APIs?  Speed?  Or is there something magic that I should know about and don't?

- Peter