Can I query wpDataTables (especially, if it manages an external table/database) from another website (or mobile app)?
Reason: I am planning to host some independent database/tables on a WP-site. Can I query these tables from another site through wpDataTables backend-code or do I need to use own code?
If that works: how is authentication handled? Is there anything like an access-token, or does it use WP's authentication?
I couldn't find anything in the documentation about that.
It is possible to create wpDataTable from separate MySQL table. If you set-up separate MySQL table you will use this database for all your tables. In the next release we will implement feature that you can set separate database connection per table. Also we will add support for PostgreSQL and MS SQL.
You can read more about separate database connection at this link from our documentation.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
ah well - yes this looks pretty good... I saw that video already, but it's not really what I'm intending to do... But your next feature (using different connections per table) comes **very** close - so thanks for that hint.
And while we're at it: Is support for SQLite also something you have in your pipeline? That would be very helpful as well. Currently I'm using the SQLiteIntegration plugin quite often, which makes moving a WP-site a no-brainer (but the plugin itself is a bit abandonned)
Anyway - I think I will give wpDataTables a spin for my next project (and if the multi-connection feature comes, there will certainly follow some more :))
You are welcome. Unfortunately for now we don't have SQLite integration in our backlog but this is something that we will think on if there will be more users that request this feature.
Can I query wpDataTables (especially, if it manages an external table/database) from another website (or mobile app)?
Reason: I am planning to host some independent database/tables on a WP-site. Can I query these tables from another site through wpDataTables backend-code or do I need to use own code?
If that works: how is authentication handled? Is there anything like an access-token, or does it use WP's authentication?
I couldn't find anything in the documentation about that.
Thanks in advance
Andy
Hi Andy Fuchs,
Thank you for the inquiry.
It is possible to create wpDataTable from separate MySQL table. If you set-up separate MySQL table you will use this database for all your tables. In the next release we will implement feature that you can set separate database connection per table. Also we will add support for PostgreSQL and MS SQL.
You can read more about separate database connection at this link from our documentation.
You can try our sandbox site: Front-end & Back-end - you can find a fully functional version there to try out all plugin features.
Hi Milos,
ah well - yes this looks pretty good... I saw that video already, but it's not really what I'm intending to do... But your next feature (using different connections per table) comes **very** close - so thanks for that hint.
And while we're at it: Is support for SQLite also something you have in your pipeline? That would be very helpful as well. Currently I'm using the SQLiteIntegration plugin quite often, which makes moving a WP-site a no-brainer (but the plugin itself is a bit abandonned)
Anyway - I think I will give wpDataTables a spin for my next project (and if the multi-connection feature comes, there will certainly follow some more :))
Thank you for your support!
Andy
Hi Andy Fuchs,
You are welcome. Unfortunately for now we don't have SQLite integration in our backlog but this is something that we will think on if there will be more users that request this feature.