I want to see how many data can be pulled to show on table and create a table when I'm using a postgres database.
I have my postgres db setup and I can connect to it via tools such as DBeaver however I am not able to connect to it via wpDataTable. It says missing driver. I installed ODBC driver on my mac but still nothing. I also setup a db on elephantsql.com, added my data, and i'm still not able to connect to it via wpDataTable.
I have tried all 3 driver types with no success. 1) Why can everything else connect to them without driver setup but wpDataTable can't?
2) Anyway around it?
3) anyone knows how many data can be pulled and displayed if I used postgres? (since google sheets is only 2,000-3,000 data)?
wpDataTables uses drivers from your server to connect to separate databases, the plugin itself doesn't need drivers.
Can you please check if you have the following drivers installed, and activated?
These drivers need to be installed and activated on the server where your WordPress website is. After you install and activate those drivers, it should work fine.
If you're not sure how to install the drivers, please reach out to your hosting provider.
You can also test the connection on our sandbox site, but please note that if you add your connection there, everyone browsing the sandbox site will be able to see it, so my advice is to create a test database with dummy data, just to verify that the connection is working.
I have the server running locally and I have it live via ngrok. I can connect to it via DBeaver but when I do it on the demo site it is running an error. Could you help me out on this please? I'm just trying to see how many data can you wpDataTable fetch and graph if connection is via postgres
I have even tried to connect to a database on ElephantSQL and still can not get it to connect.
on my local db that I'm making live with ngrok I edited the `.confg` file and allow all connections by changing the IP address to `0.0.0.0` and still getting the same error
If you have a live server and can provide the database credentials in a private ticket, I'll gladly test the connection from my local environment. I haven't run into a separate DB that I couldn't connect to if it allowed external connections.
As for the amount of data - the separate DB connection doesn't actually slow down the plugin, so you would be able to pull large tables from it, and create tables with hundreds of thousands of rows in wpDataTables without issues. The loading times may increase a bit, depending on your hosting plan and server's performance, but it should work just as it works with WP Connection.
is it possible to SSH to the server and use it as a local connection? This is before I do a private ticket for the connection. I have change the config file of postgres file and all but still can not connect.
The postgres database is installed on a ubuntu cloud computer. There is no `host` address for the postgres as I believe that is a `tcp` thing. Is it possible have a ssh and then use local connection? If not how would you get the `host` address?
Do you also have a recommendation on using mysql or postgres for massive amounts of data? And what type of computer cpu and ram recommendation you'd recommend for something with half a million data points?
How do you install and activate the drivers that need to be installed where wordpress is installed? Is there a list of `apt` command lines that you could provide or point me toward the right direction? Or any plugins I might need?
I ran and installed all the commands you had listed below except I didn't run the additional command to set up MsSql. I was wondering if that was really important or what was it needed for? It mentioned maybe needing productions key and so on `sudo apt-get install mssql-server -y.`
I want to see how many data can be pulled to show on table and create a table when I'm using a postgres database.
I have my postgres db setup and I can connect to it via tools such as DBeaver however I am not able to connect to it via wpDataTable. It says missing driver. I installed ODBC driver on my mac but still nothing. I also setup a db on elephantsql.com, added my data, and i'm still not able to connect to it via wpDataTable.
I have tried all 3 driver types with no success.
1) Why can everything else connect to them without driver setup but wpDataTable can't?
2) Anyway around it?
3) anyone knows how many data can be pulled and displayed if I used postgres? (since google sheets is only 2,000-3,000 data)?
Thank you
Hello logan
Thank you for your purchase.
wpDataTables uses drivers from your server to connect to separate databases, the plugin itself doesn't need drivers.
Can you please check if you have the following drivers installed, and activated?
These drivers need to be installed and activated on the server where your WordPress website is. After you install and activate those drivers, it should work fine.
If you're not sure how to install the drivers, please reach out to your hosting provider.
You can also test the connection on our sandbox site, but please note that if you add your connection there, everyone browsing the sandbox site will be able to see it, so my advice is to create a test database with dummy data, just to verify that the connection is working.
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
Oh that makes more sense.
I have the server running locally and I have it live via ngrok. I can connect to it via DBeaver but when I do it on the demo site it is running an error. Could you help me out on this please? I'm just trying to see how many data can you wpDataTable fetch and graph if connection is via postgres
My successful connectin on DBeaver:
Error I'm getting on demo site you provided:
I have even tried to connect to a database on ElephantSQL and still can not get it to connect.
on my local db that I'm making live with ngrok I edited the `.confg` file and allow all connections by changing the IP address to `0.0.0.0` and still getting the same error
Hi again logan
I don't know if it's going to work with ngrok.
If you have a live server and can provide the database credentials in a private ticket, I'll gladly test the connection from my local environment. I haven't run into a separate DB that I couldn't connect to if it allowed external connections.
As for the amount of data - the separate DB connection doesn't actually slow down the plugin, so you would be able to pull large tables from it, and create tables with hundreds of thousands of rows in wpDataTables without issues. The loading times may increase a bit, depending on your hosting plan and server's performance, but it should work just as it works with WP Connection.
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
is it possible to SSH to the server and use it as a local connection? This is before I do a private ticket for the connection. I have change the config file of postgres file and all but still can not connect.
The postgres database is installed on a ubuntu cloud computer. There is no `host` address for the postgres as I believe that is a `tcp` thing. Is it possible have a ssh and then use local connection? If not how would you get the `host` address?
Do you also have a recommendation on using mysql or postgres for massive amounts of data?
And what type of computer cpu and ram recommendation you'd recommend for something with half a million data points?
How do you install and activate the drivers that need to be installed where wordpress is installed?
Is there a list of `apt` command lines that you could provide or point me toward the right direction? Or any plugins I might need?
I ran and installed all the commands you had listed below except I didn't run the additional command to set up MsSql. I was wondering if that was really important or what was it needed for? It mentioned maybe needing productions key and so on
`sudo apt-get install mssql-server -y.`
I was able to connect to it on my server but not the WPdataTable Sandbox.
Hey Logan.
I'm glad to hear you were able to connect to it from your server.
I just tried using our sandbox, and I wasn't able to, so it seems we're missing some drivers there. Sorry about that.
As for mssql, you don't have to install it if you don't need it.
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