| Subject | Re: Store large amount of Binary Data in FB |
|---|---|
| Author | psantosl |
| Post date | 2007-06-27T22:08:42Z |
Hi,
As some of you already know "we" (www.plasticscm.com) use Firebird
as database backend for Plastic SCM version control system. We store
*everything* on Firebird databases with very good performance.
Our largest test using an embedded Fb database (on windows) reached
100GB with almost no performance hit...
Plastic is *FREE* for OSS projects.
We've just implemented SQL Server backend due to customer's requests
and, to be honest, it can't compare to the good old Fb. SQLS keeps
locking until you install version 2005... crazy!
Performance? Well, Plastic is about three times faster than SVN
doing forced update (which means downloading "everything") and
slower just finding changes (although is already fixed won't be
released yet... testing cycle... you know :-P). Checking in big
files is also much, much faster in Plastic...
You may be thinking now: why on earth are you storing even file
content inside a database? Well, we full "transactional support" by
default, which is a cool feature for a version control system... And
about reliability? Well, I can tell you we've never (NEVER) lost
data or had a corrupted repository, not even months before our first
official release when the project was yet at its infancy...
Cheers,
pablo
--- In firebird-support@yahoogroups.com, "Rick Debay" <rdebay@...>
wrote:
notify the sender by return e-mail and delete this message from your
system. Any unauthorized use or dissemination of this message in
whole or in part is strictly prohibited. Please note that e-mails
are susceptible to change. RxStrategies, Inc. shall not be liable
for the improper or incomplete transmission of the information
contained in this communication or for any delay in its receipt or
damage to your system. RxStrategies, Inc. does not guarantee that
the integrity of this communication has been maintained nor that
this communication is free from viruses, interceptions or
interference.
As some of you already know "we" (www.plasticscm.com) use Firebird
as database backend for Plastic SCM version control system. We store
*everything* on Firebird databases with very good performance.
Our largest test using an embedded Fb database (on windows) reached
100GB with almost no performance hit...
Plastic is *FREE* for OSS projects.
We've just implemented SQL Server backend due to customer's requests
and, to be honest, it can't compare to the good old Fb. SQLS keeps
locking until you install version 2005... crazy!
Performance? Well, Plastic is about three times faster than SVN
doing forced update (which means downloading "everything") and
slower just finding changes (although is already fixed won't be
released yet... testing cycle... you know :-P). Checking in big
files is also much, much faster in Plastic...
You may be thinking now: why on earth are you storing even file
content inside a database? Well, we full "transactional support" by
default, which is a cool feature for a version control system... And
about reliability? Well, I can tell you we've never (NEVER) lost
data or had a corrupted repository, not even months before our first
official release when the project was yet at its infancy...
Cheers,
pablo
--- In firebird-support@yahoogroups.com, "Rick Debay" <rdebay@...>
wrote:
>repositories
> Use open source Subversion for personal document management
> http://articles.techrepublic.com.com/5100-3513_11-6167205.html
>
> TortoiseSVN, Windows Explorer client for Subversion
> RapidSVN, cross-platform client for Subversion
> ViewCVS, Web application for browsing Subversion and CVS
> http://opensourcesmall.biz/category/book/09-document-management/off of
>
> Testimonial for Subversion and TortiseSVN (windows front end for
> subversion)
> http://ask.slashdot.org/article.pl?sid=06/06/05/1922209#15476388
>
> I don't know if Subversion can use anything but BerkelyDB for its
> backend, yet. If anyone knows, please post as we'd like to move
> CVS as soon, and use Subversion ourselves for documents.McDonald
>
> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Alan
> Sent: Monday, June 25, 2007 6:01 PMin FB
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] Store large amount of Binary Data
>documentations
> > > I am trying to create a software in which all the
> > > thatand may be privileged. If you have received it by mistake please
> > are generated in our organization should be stored.
> >
> > Don't reinvent the wheel. Find an existing document management
> > system, and install it with Firebird as its database.
>
> agreed - use Subversion! it's made specifically for such a task.
> Alan
>
> Disclaimer: This message (including attachments) is confidential
notify the sender by return e-mail and delete this message from your
system. Any unauthorized use or dissemination of this message in
whole or in part is strictly prohibited. Please note that e-mails
are susceptible to change. RxStrategies, Inc. shall not be liable
for the improper or incomplete transmission of the information
contained in this communication or for any delay in its receipt or
damage to your system. RxStrategies, Inc. does not guarantee that
the integrity of this communication has been maintained nor that
this communication is free from viruses, interceptions or
interference.
>