Database

[Tedskayteur]

Is it possible to create a database with macrodroid to use it? If so, how do I proceed?

 

[Dimlos]

I think you can use MariaDB and PostgreSQL with Termux, but I don't think it's easy because you need deep knowledge of SQL.

 

[sampleuserhere]

If you plan to work on the database locally, SQLite with sqlite3 should be sufficient for the job.

I wouldn't go into details on how you to setup the database with SQLite commands, there are many tutorials out there. I would just provide the steps which you need to work with with Macrodroid and Termux.

1. Write empty database file.
2. Write the statements to a file. This is where you input the syntax such as CREATE TABLE, INSERT INTO, or SELECT.
3. Run the following line in Termux.

database_path="database file path"
statement_path="statement file path"
sqlite3 "$datababase_path" ".read $statement_path"

*The file path must be the full path.

To add what Dimlos has warned, not only that you have to have the guts to learn SQLite, you also have to work on setting up Termux as well.

 

[Jacob L]

Click the black plugin tile and search database there are MacroDroid compatible tools there