Redundancy between db_name and prefacing every table with the name of the database? about condenser HOT 2 OPEN

Also, wildcard db names or regex would be a killer feature. We have a lot of tables that end in _log. It would be nice to be able to indicate that all tables ending in _log could be ignored.

from condenser.

I agree it is redundant to also have to require the database name prefix on every table for MySQL. It is a byproduct of supporting PostgreSQL, where a database can contain multiple schemas, in which case each table would need to have the schema prefix as it can be different. However this isn't true for MySQL as schema and database are synonymous and you can only connect to one at a time.

The project could definitely be refactored to not have to specify the database/schema prefix for every table on MySQL, however we don't have the bandwidth to take on new features for this project currently, but do welcome contributions. If you want to make the change and submit a PR we would be happy to review and merge it.

Supporting wild card or regexes for table names would be interesting and possibly a bit more complicated. At least MySQL lets you add special characters to your table name, for example hello_.* is a valid table name in MySQL. There would need to be a way to differentiate regex expressions from verbatim table names. Would welcome a PR to add support for it though.

from condenser.