[SciPy-Dev] using sqlite for storing submissions
Mon Jul 15 11:13:54 CDT 2013
On Mon, Jul 15, 2013 at 6:06 PM, Surya Kasturi <firstname.lastname@example.org> wrote:
> On Mon, Jul 15, 2013 at 5:46 PM, Andreas Hilboll <email@example.com> wrote:
>> On 15.07.2013 17:39, Surya Kasturi wrote:
>> > Hi all,
>> > [idea]
>> > Right now we are using Hg for storing submissions inside static root..Is
>> > not totally good on a cloud platform with limited resources..its not
>> > fast too (takes lot of server load)
>> > I rather would like to use SQLite separately for storing submissions (I
>> > agree that using Postgre SQL for it is expensive on cloud)..
>> > What do you guys say?
>> > we dont have to provide all revisions as a Hg repo when downloading..
>> > people can employ some tools to compare if they want...
>> I disagree. Using SQLite in a production server environment causes
>> nothing but pain (at least to my experience). I would assume using some
>> DVCS for storing revisions should be the most natural way to do so, and
>> I would hope that there's some webapp libraries availble to show diff's
>> etc, though I don't have any direct experience with this.
> Showing diff is one idea I had too but we can figure out something within
> database too (I guess... dont know for sure).
> If we are not a busy site.. with very huge traffic and only using SQLite
> partly, it should work nicely
>> Oh, and I personally don't see the need to have spyce running on a
>> "cloud platform" (depending on what you mean by that, of course). If you
>> have one single server, then you don't need all the
>> distributed-whatsoever and can concentrate on having everything on one
>> I didnt get you
>> Just my 2ct.
>> -- Andreas.
>> SciPy-Dev mailing list
Truly, I barely have experience with databases, queries etc.. but I guess,
its not bad experimenting things..
couchDB does some fantastic stuff.. May be there are other technologies we
can use.. (searching!!)
I personally don't feel right using repos in static data.. just feel that
its very complex that way..
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the SciPy-Dev