I would like to start up a project outside of the wiki that will use the SMW data.
Now i could work with exporting to CSV & then import the data again, but i thought it would be cleaner to query the original database instead.
I know SMW uses temporary tables, so it it might not be wise to ignore the optimization from SMW. Other ideas are very welcome as well.
> Now i could work with exporting to CSV & then import the data again, but i > thought it would be cleaner to query the original database instead.
It's a lot better to use one of SMWs interfaces rather then directly accessing the datastore used. You can use one of SMWs export formats or it's ask API . Or you can use one of several extensions that provide export or synchronization features. A last option is to write some PHP that talks directly to SMWs store, but there is no good documentation on this.