I just tried this with MYSQL-8 and while the list populates there are no tables shown ..the actual tables, the graphic for tables is there. For grins and giggles I fired up a copy of MYSQL 5.7 and dbplot connected and queryied great. So there seems to be a compatablility issue with MYSQL-8 ? As far I a remember the security is set up the same between them. Heck, I copied the 5.7 setup over to 8 iirc. Anyway a picture of what I mean.. notice no PLUS ( + ) next to the tables and clicking does not do...
I just tried this with MYSQL-8 and while the list populates (left) there are no tables shown ..the actual tables the graphic for tables is there. For grins and giggles I fired up a copy of MYSQL 5.7 and dbplot connected and queryied great. So there seems to be a compatablility issue with MYSQL-8 ? As far i a remeber the security is set up the same between them heck I copied the 5.7 setup over to 8 iirc. anyway a picture of what i mean.. notice no PLUS ( + ) next to the tables and clickking does not...
I just tried this with MYSQL-8 and while the list populates (left) there are no tables shown ..the actual tables the graphic for tables is there. For grins and giggles I fired up a copy of MYSQL 5.7 and dbplot connected and queryied great. So there seems to be a compatablility issue with MYSQL-8 ? As far i a remeber the security is set up the same between them heck I copied the 5.7 setup over to 8 iirc. anyway a picture of what i mean.. notice no PLUS ( + ) next to the tables
I just tried this with MYSQL-8 and while the list populates (left) there are no tables shown ..the actual tables the graphic for tables is there. For grins and giggles I fired up a copy of MYSQL 5.7 and dbplot connected and queryied great. So there seems to be a compatablility issue with MYSQL-8 ? As far i a remeber the security is set up the same between them heck I copied the 5.7 setup over to 8 iirc. anyway a picture of what i mean.. notice no PLUS ( + ) next to the tables
Hi, is it possible to increase the query timeout ? It seems to default to 30s and there's no option to change it. Thanks
After 5 years this bug still seems to be there, any solutions ?
Thank you, Chris. That is definitely false alarm since only Baidu found the issue while the other top security tools (Norton, AVG, Kaspersky, etc.) don't find anything. Also, I would not trust Baidu antivirus tool. You can find many articles sharing the same view.
Just a heads-up: the installer gets a trojan warning from VirusTotal. It's only from one scanner, but still... Win32.Trojan.WisdomEyes.16070401.9500.9950 https://www.virustotal.com/#/file/7abbdbe4a149b9dc6fb53485e24837512faef0dafb9eeb0ff4fd759f0742ab2c/detection
CSV query is not supported in DBPlot. I planed to have it sometimes in the near future. Please check again in few weeks.
Hi, I tried to run a SQL query different from "SELECT * FROM..." based on a csv file, but I don't see any result different respect to the standard "SELECT * FROM..." query. I would like to use more advanced features, such as GROUP BY and SUM, but I can't find a way to do it. Is it a bug, an unsupported feature or my mistake? Thanks and regards
To remove the limit, you can change the query. Remove the "Limit 1000" or "Top 1000" from the query and it will show all rows in your dataset.
Hey, iam trying to extend the limit in DBplot which is currently limited by 1000. I have a File with 10.000 rows. Hope anyone could help me .
Steffen, Have you tried to use up/down arrow key yet? Pete On Fri, Mar 11, 2016 at...
Hi Mr. Dbplot, nice work so far, but I can't select all columns, because I can't...
But now, I can't generate a report with my view ! Only with my tables.
But now, I can't generate a report with my view ! Only with my tables.
Thanks for using the tool Gmarco. The max & min & avg are not available at the moment....
Hallo I find your tool very useful. Im using it to plot CSV files that are current...
Hallo I find your tool very useful. Im using it to plot CSV files that are current...
Petaris, Interesting question. I have not thought about such use case. Unfortunately...
Is there a way to set the Units of an axis? For example, if I want my axis to be...
Great Pete! Regards Ralf
Ralf, I actually got both emails you sent. They are in the Spam email... I will get...
Ralf, I have not received your emails till now... FYI, the "." is ignored by GMAIL...
Sure Pete, in the thread "graph questions" you had a dot between hngo and deals -...
Dan, The issue is that DBPlot was built against the old version of mysql connector...
Ralf, I didn't receive them... Could you resend them to hngodeals@gmail.com? Thanks...
Hi Pete, sent to you already by mail. Please confirm, that you got my mails from...
Hi, There seems to be a problem returning queries from tables in MySQL with columns...
Thanks Ralf. That would be very helpful. Pete
No problem Pete, these are measurement values from PLC log data. I will send you...
Hello, I was working on a project that needs Python to do some predictive analytics....
Ralf, THanks for your points. All of them are valid. There is a bug with save permanently...
Ralf, THanks for your points. All of them are valid. There is a bug with save permanently...
Seems that the "Save permanently" option is designed to do what I have in mind at...
Sure, come up with this tomorrow. Thanx for helping Ralf
Hi, if I have big data graph, then "Save Permanently" of Chart Customization Form...
Ralf, Could it be possible for me to look at your Excel-line style diagrams? Please...
Got it: with line chart type I can set "marker style" in series options to get addional...
Hello Pete, thanx for clarification. To get the Excel-type line-diagram I tried to...
Point and fast point are similar in terms of representation. "Fast" here is for perfomance....
Very appreciated Pete - thanx a lot! Ralf
Hi, could someone please explain to me what the difference is between the chart types...
Ralf, THanks for the explaination. Hope I could fix the issues you mentioned. Pe...
Hi Pete, it's pretty much simple: I have two differrent ranged measurement values...
Ralf, I see what you are trying to do.Unfortunately at this moment, DBPlot could...
Hello Pete, thanx for responding, glad that this forum is still alive :-)) Well,...
Ralf, 1 and 2 are known issues. I will try to address it as soon as I can. For 3,...
Ralf, Thanks for your info. I did know about this issue but I have not got chance...
Hi, in respect to my formerly written topic "Date/Time data type and representation...
Hi, I'm new to dbplot and fiddled around a while and my most needs are pretty much...
Sure I could help. I just tested connecting to PostgreSQL on my local and things...
Hello all, I am a newbie at this stuff. I have a small database which is being filled...
Tim, The report feature is designed to plot the entire datatable. I understand your...
Tim, Sorry for the delay. I was busy with the new website for the tool as well as...
Works for me!
Hi, if i create a new Report i can choose from the Tables in my DB, views do however...
Hi, i have rather large tables and would like to repetedly DBPlot a subsection of...
Column and color
Home
Changes 04/21/2014 (v2.5.3) - Improvements: + Remove query pane from the graph page...
Changes 04/15/2014 (v2.5.1) - Improvements: + Left double click will display the...
Changes 04/10/2014 (v2.5.0) 1. New features: Report: Simple Database report Add "New...
Changes 04/10/2014 (v2.5.0) - New features: + Report: Simple Database report + Add...
Also look at the case where users hit "Execute" button twice in a row while the previous...
If running the query directly then long query (tested ~10s) still runs
Make real data points bold or active when cursor hovers on
Copy plot to the clipboard
Stop the query
Doug, The top panel is called Connection manager. You can select the data and plot...
I tried to plot but I got a message saying that plotting directly from the dB file...
I tried to plot but I got a message saying that plotting directly from the dB file...
Dough, Can you select your data? (Right click, select data from the table). If you...
See my edit - I made some progreess....
Hi, I played with it a bit more and made some progress. It turns out that I needed...
Thanks Dough. I'll try to see what's wrong asap. HNgo
I'll email a screen shot of what I see and a copy of the SQLite file. Doug.
Doug, Thanks for your info. My colleagues and I use the tool with MySQL and SQLite...
Doug, Thanks for your info. My colleagues and I use the tool win MySQL and SQLite...
Don, Thanks for your info. My colleagues and I use the tool win MySQL and SQLite...
Tried it out tonight on a SQLite file (v2.4.8), but nothing happened. I could load...
Chart - Y column values overlap
Connection panel Treeview collapses