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.