I am discussing a new project with a perspective client that wishes to have a table on his WordPress site using data imported from his Firebase database.
Does this plugin allow connection to an external database or is there an add-on or other method of integrating?
Right now I am thinking this is not possible and that I need to pull the data with the Firebase API and the create the table that way?
But looking for a simpler method so the client can make minor changes over time
With wpDataTables you can connect multiple databases, and use SQL queries to create tables from the tables in those databases. You can read more about this in our documentation.
If you know your way around SQL, you can easily create SQL Query based tables, or if you're new to this, you can even try with our query constructor, which acts as a helper, trying to ‘guess’ what you want.
We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.
After looking closer to the specs of what my client is wanting I decided it is going to be easier to just import the data from Firebase and create the tables via code since the Firebase database doesn't use SQL tables.
I am discussing a new project with a perspective client that wishes to have a table on his WordPress site using data imported from his Firebase database.
Does this plugin allow connection to an external database or is there an add-on or other method of integrating?
Right now I am thinking this is not possible and that I need to pull the data with the Firebase API and the create the table that way?
But looking for a simpler method so the client can make minor changes over time
Thoughts?
Thanks ernie
Hello ernie
Thank you for your interest in our plugin.
With wpDataTables you can connect multiple databases, and use SQL queries to create tables from the tables in those databases. You can read more about this in our documentation.
If you know your way around SQL, you can easily create SQL Query based tables, or if you're new to this, you can even try with our query constructor, which acts as a helper, trying to ‘guess’ what you want.
We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need. Play around with the resulting query to achieve better results.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Thanks for the reply.
After looking closer to the specs of what my client is wanting I decided it is going to be easier to just import the data from Firebase and create the tables via code since the Firebase database doesn't use SQL tables.
Will keep you in mind next time though
Alright ernie.
Fair enough. If you need any assistance from us, please let me know.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables