Best SQL library to use with local desktop app

[wakhshti via Digitalmars-d]

what is best (SQLite?) @small @local @offline database library to 
use in D?

and also what about a simple GUI library ? (once there was a 
library named DFL, but i never could get it to run).