News for hackers. Stuff that matters.
Re:SQLite 3.8.0 Release with next-generation query planner by viraptor on Tuesday August 27, 2013 @12:52AM (#6281521)
> As for permissions, its better to let the OS handle that than some half-baked database permissions system.

Sorry, but that doesn't make sense. For example: if you want your application to be able to add new rows, but not delete them (for audits actually) you cannot do this with OS permissions. Only database-layer permissions will make it possible.

There are many other examples of such use-cases. You simply cannot use OS/apparmor/selinux/whatever external to the database to grant/revoke per-table access.

> Root accounts/passwords are a wtf in a production environment because they destroy auditability.

On this side however - why would anyone know / have access to your root account? Applications should never have it. Servers should never have it (in a form different than the hash). Only people should have it.

Re:SQLite 3.8.0 Release with next-generation query planner by lmz on Tuesday August 27, 2013 @02:47AM (#6281875)
Interestingly, there is SELinux integration for Postgres: http://wiki.postgresql.org/wiki/SEPostgreSQL