My use of "embedded" means that the whole database runs in the same process as your application. This is how SQLite works. Your application doesn't "connect" to an SQLite database in the usual sense. Your application simply contains SQLite as part of itself. Contrast this with Postgres, where you first need to start a Postgres server and then have your application talk to it.
> Also in this case you are not really using it as an embedded database anymore, which is our original motivation
As by your (and mine) definition, I am indeed using it as an embedded database. It's running inside the process and storing (and persisting) blog-posts.
How do you define embedded?
One of my application is a simple "blog-like" webservice where you can either use a SQLite db or Postgres.
Personally I often prefer SQLite because it doesn't need a thousand configurations and I can just migrate all the content with copying a file.