Howdy, Stranger!
We are about to switch to a new forum software. Until then we have removed the registration on this forum.
Categories
- All Categories 25.7K
- Announcements & Guidelines 13
- Common Questions 30
- Using Processing 22.1K
- Programming Questions 12.2K
- Questions about Code 6.4K
- How To... 4.2K
- Hello Processing 72
- GLSL / Shaders 292
- Library Questions 4K
- Hardware, Integration & Other Languages 2.7K
- Kinect 668
- Arduino 1K
- Raspberry PI 188
- Questions about Modes 2K
- Android Mode 1.3K
- JavaScript Mode 413
- Python Mode 205
- Questions about Tools 100
- Espanol 5
- Developing Processing 548
- Create & Announce Libraries 211
- Create & Announce Modes 19
- Create & Announce Tools 29
- Summer of Code 2018 93
- Rails Girls Summer of Code 2017 3
- Summer of Code 2017 49
- Summer of Code 2016 4
- Summer of Code 2015 40
- Summer of Code 2014 22
- p5.js 1.6K
- p5.js Programming Questions 947
- p5.js Library Questions 315
- p5.js Development Questions 31
- General 1.4K
- Events & Opportunities 288
- General Discussion 365
In this Discussion
- PhiLho November 2013
JavaScript Mode: Retrieving data from MySQL and visualize them
I've designed a data acquisition project which consisted of two Processing applications.
The first one is a standalone application (executable). I use this to capture data sent from an ATmega328P microcontroller system through serial port. At the initial testing stage, I've successfully saved them into a CSV file. But now, I would like to save them into a database by using MySQL, to be later picked by a web application. There's a library called BezierSQLib that it seems up to the task. I've also had a working XAMPP installation.
The second one is web application, built by JavaScript mode. All I want to do is using this application to retrieve data from MySQL and visualize them. But I'm wondering, can this be achieved? If so, what is the practical method to use? To be honest, I'm new to this JavaScript mode and had a limited knowledge over MySQL databases, especially how it connects to Processing application.
As a side note, all those applications and XAMPP installation are supposed to run from my computer (local server).
Comments
If you run in JS mode, you cannot use a Java library like Bezier SQLib.
The solution is to make Ajax calls from JS to the server (and back): the JS requests the server to do the SQL operations, the server can answer with the result. So you need to write some server-side code (PHP or other).