[Owasp-hackademic-challenges] [dev-features] Sqlite as a db
spyros.gasteratos at owasp.org
Sun Jan 18 17:42:19 UTC 2015
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.
> 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.
>> 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?
>> Owasp-hackademic-challenges mailing list
>> Owasp-hackademic-challenges at lists.owasp.org
> Owasp-hackademic-challenges mailing list
> Owasp-hackademic-challenges at lists.owasp.org
More information about the Owasp-hackademic-challenges