[Owasp-hackademic-challenges] [dev-features] Sqlite as a db
paul.chaignon at gmail.com
Sun Jan 18 17:36:37 UTC 2015
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
More information about the Owasp-hackademic-challenges