[SciPy-Dev] using sqlite for storing submissions

Surya Kasturi suryak@ieee....
Mon Jul 15 11:13:54 CDT 2013


On Mon, Jul 15, 2013 at 6:06 PM, Surya Kasturi <suryak@ieee.org> wrote:

>
>
>
> On Mon, Jul 15, 2013 at 5:46 PM, Andreas Hilboll <lists@hilboll.de> 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
>
>
> http://stackoverflow.com/questions/913067/sqlite-as-a-production-database-for-a-low-traffic-site
>
>
>> 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
>> machine.
>>
>> I didnt get you
>
>
>> Just my 2ct.
>>
>> -- Andreas.
>>
>> _______________________________________________
>> SciPy-Dev mailing list
>> SciPy-Dev@scipy.org
>> http://mail.scipy.org/mailman/listinfo/scipy-dev
>>
>
>
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...
URL: http://mail.scipy.org/pipermail/scipy-dev/attachments/20130715/d099f21c/attachment.html 


More information about the SciPy-Dev mailing list