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

Paul Chaignon 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.


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



More information about the Owasp-hackademic-challenges mailing list