I am currently processing text/html data and I wish to store my results in some sort of database. My current setup is Pydev with Eclipse.
What is the best non-distributed database to use with my current development environment?
What is the best library in python to use to interface with suggested database?
If you won't be using the database itself from multiple locations at once then you can use the built-in sqlite3 module with a SQLite database.
"Best" of course depends on your needs, and aside from "text/html data" you haven't given us anything to go on. One might say that a relational database is not the best way to store text/HTML data, but again without more info who could really say?
Given that you limited the answers to "SQL" in your title, however, I can at least suggest that the sqlalchemy package is quite possibly the "best" way to get to the database.
Ignacio's suggestion of using SQLite as the underlying database is also a good starting point -- and an ending point, as he hints, if an "embedded" database suffices for your needs. If you use sqlalchemy to get to it, you can keep the SQL out of your code, and if the need arises you can trivially swap SQLite out for a more powerful solution (e.g. PostgreSQL).