It's a solution to a specific problem
If small and fast is more important than rich feature support (eg: foreign key constraints, some triggers, some join syntax, etc.), and if you can do all permissions through filesystem configuration and application code, then you can use it. It's great for embedded, standalone and single-user systems.
===
Kip Hawley is still an idiot.
===
Purveyor of Doc Hope's [link|http://DocHope.com|fresh-baked dog biscuits and pet treats].
[link|http://DocHope.com|http://DocHope.com]