Getting DB/table information

[selwin]

Hi there, first of all thanks for writing this awesome project.

What are you thoughts on adding a way to get db/table size to this library? I was thinking something along the lines of:

db = DB(profile='default')
db.size  # Returns db size
db.tables.my_table.size  # Returns table size
db.tables.my_table.rows  # Returns number of rows

The ability to run EXPLAIN statements would also be really useful.

[maurobaraldi]

What do you mean by table/db size?

[selwin]

For example, postgresql has "pg_database_size(name)" that returns the disk size used by the DB.

[maurobaraldi]

It's a sysadmin's related feature, I think it's getting out of project focus. Rows count is a good feature.

[maurobaraldi]

This issue can be closed. The pull request 64 already merged, meet the needs of this request.

[selwin]

Well, it depends on how you look at it I suppose. I would think this project's focus is to make it easier to talk to databases and that includes getting information about them or the tables inside.

Just my two cents though ;)