Strapi helps Flutter develop international apps-organize Sqlite database and pictures

Use DBeaver software or your own custom database management software to open Strapi's sqlite database file.

You can see that the locale field distinguishes the internationalized data. In addition, there is no cover image field in the vegettables

Analysis of the database shows that the picture is associated with the vegettables upload_file and upload_file_morph

Write in the sql editor

SELECT
    v.id,
    v.name,
    v.desc,
    v.locale,
    uf.hash,
    uf.ext, 
    v.created_at,
    v.updated_at
from
    vegetables v
LEFT OUTER JOIN upload_file_morph ufm on
    v.id = ufm.related_id
LEFT OUTER JOIN upload_file uf on
    ufm.upload_file_id = uf.id;

Test success! Create a view based on the above code.

Next, analyze the pictures. In the Strapi project, the pictures are uploaded to the [project_root]/strapi/public/uploads folder.

Modify pubspec.yaml add the following configuration

flutter: 
  assets: 
    - assets/db/
    - strapi/public/uploads/  
  uses-material-design: true

---

: Data Modeling
Next: Use Sqlite database