Beginer needs help for a simple mysql query app

Questions and Answers Database-SQL
1

hi, im fresh new to strapi and i have difficulties to find which solution / tutorial / documentation to follow for my first simple app :

i have data already in a mysql database, i need to create some pages to present or summarize those data

how to create some simple public read only pages that can call the various needed queries and present the results

i did try this crud tutorial How to Build a Simple CRUD Application Using Flutter and Strapi but idk if its beginer issue or as other people rant maybe its not me :slight_smile: How to Build a Simple CRUD Application Using Flutter and Strapi - #8 by fgdvlp

thanks

PS: also on latest strapi various starters seems not working, am i right ?

System Information
  • Strapi Version: v4.0.0
  • Operating System:
  • Database:
  • Node Version:
  • NPM Version:
  • Yarn Version:
2

up :no_mouth:
up :no_mouth:
up :no_mouth:

3

how to access a mysql database

not the local one of strapi

but another external one

thx

4

for now i did create a subdir for nodejs scripts (called by the OS cron)

then i just can have a normal use of the mysql lib

i guess there is a way to do this inside strapi (then i could use the strapi cron)

var mysql      = require('mysql');
var connection = mysql.createConnection({  host     : 'localhost',  user     : 'me',  password : 'secret',  database : 'my_db'});
connection.connect();
connection.query('SELECT 1 + 1 AS solution', function (error, results, fields) {  if (error) throw error;  console.log('The solution is: ', results[0].solution);});
connection.end();