New answers tagged spatial-database
geoAlchemy is supposed to do the job using GeometryColumns. However, I was not able to make it work on Windows/Python 2.7/sqlalchemy 0.9.6 due to AttributeError: type object 'ColumnProperty' has no attribute 'ColumnComparator'
You could use PostgreSQL/PostGIS. QGIS support is not in question. As for latest MapInfo v12.5 supported versions and ODBC drivers are: http://reference.mapinfo.com/software/mapinfo_pro/english/12.5/MapInfoProfessionalInstallGuide.pdf
Postgis is surely a good idea for your task. You can use SQL queries to filter the data to a dataset you want. Another option is to use a spatialite database. The data will be stored in one single file, which makes it more portable (either for homework, different OS or backup reasons). Spatialite uses SQL queries in the same way.
Top 50 recent answers are included