[Owasp-hackademic-challenges] [dev-features] Sqlite as a db

Spyros spyros.gasteratos at owasp.org
Sun Jan 18 17:42:19 UTC 2015


Great,

I'll open a ticket then.

On 18.01.2015 18:36, Paul Chaignon wrote:
>
> I think it's a good idea. We don't have a database big enough to 
> justify the use of a traditional DBMS.
> It should also improve slightly the performance.
>
>
> Paul
>
>
> On 13/01/2015 19:48, Spyros wrote:
>> Dinis' comments on github gave me the idea of switching our main db 
>> from mysql to sqlite.[1]
>> In the installer we can keep mysql for those who prefer it but add 
>> sqlite as the first option.
>> It seems that we get several advantages over mysql.
>>
>> * It's embedded, as in we can package everything in a .phar which 
>> runs out of the box without the need for an external db.
>>
>> * The user doesn't need to have mysql installed, a simple apache,ngix 
>> or any php-capable web server will do.
>>
>> * The requirements on disk and memory go down by quite a bit. 
>> Especially since we're planning on introducing the sandbox which is 
>> supposed to be quite heavy on memory.
>>
>> It seems more suitable for our small platform since we don't get that 
>> many hits/day to justify a separate database server.
>>
>> What do you think?
>>
>> [1]:https://sqlite.org/about.html
>> _______________________________________________
>> Owasp-hackademic-challenges mailing list
>> Owasp-hackademic-challenges at lists.owasp.org
>> https://lists.owasp.org/mailman/listinfo/owasp-hackademic-challenges
>
> _______________________________________________
> Owasp-hackademic-challenges mailing list
> Owasp-hackademic-challenges at lists.owasp.org
> https://lists.owasp.org/mailman/listinfo/owasp-hackademic-challenges



More information about the Owasp-hackademic-challenges mailing list