7/18/2017 11:03 AM | |
Posts: 14 Rating: (9) |
Hi, that depends on your project, your database etc. but if you want to use the database sqlite3 I would recommend node-red, because there exist nodes that allow you to send SQL queries to the database, so all you have to do is write a function that builds the SQL command as a string. However if you need more flexibility I would recommend to write a program in C++ with eclipse, there exists a huge library for sqlite3, but that's just because I learned programming with C/C++. It is more work, but if offers more possibilities. JavaScript offers you the possibility to use the tool "sequelize", which allows you to communicate with the database with JavaScript objects, but I didn't try it yet. I don't know what possibilities Python offers, maybe there is someone else that can list the advantages/disadvantages. I created a simple application example for people who want to get started with databases and used node-red and a C++ program, it can be found here. It documents how to install the nodes for node-red sqlite3 communication and how to integrate the sqlite3 library in a C++ program etc. |
This contribution was helpful to1 thankful Users |
7/18/2017 11:31 AM | |
Joined: 5/22/2014 Last visit: 4/17/2018 Posts: 32 Rating: (1) |
Hi, one problems that i see with node-red is the fear that if I want to expand my project, i can't because of the lack of some nodes, but in other part, the number of nodes is increasing a lot, what do you think about it? Would be easy to make a visual interface with node-red?
|
7/19/2017 9:04 AM | |
Joined: 5/22/2014 Last visit: 4/17/2018 Posts: 32 Rating: (1) |
Thanks you! Really appreciate your message^^ |
Follow us on