Why can't I work with sqlite database (Navicat)?

Question

SQLite

When working with the sqlite database file through Navicat, strange situations arise.
Download sqlite. Run sqlite3.exe.
Created a DB . open main.dbAn empty main.db file appeared in the folder.
Closed sqlite3.exe.
Opened Navicat. New connection->SQLite. (I already worked with MySQL with Navicat - there were no particular problems.)
Specified the path to main.db. Opened the database through Navicat.
I created a table there, a couple of fields, etc. Saved.
I'm writing a simple php query - show the value of a field... it says there is no table. I look in Navicat - there is a table (I just created it).
I look at the main.db file - 0 KB! I open it with a notepad - it's empty ....
I decide to do everything again. Everything closed.
Deleted the main.db file. Removed the connection in Navicat.
Run sqlite3.exe. Created a new database . open main.dbAn empty main.db file appeared in the folder. Closed sqlite3.exe.
Opened Navicat. New connection->SQLite. Opened the database through Navicat. And I see my tables there.
But this is a new database. Weird.
Understood nothing. I decided to create a Navicat database in another place. On drive C.
Opened Navicat. New connection->SQLite->New SQLite 3 Path C:\main.db.
Navicat has a connection. Created there the table saved.
I am looking for the main.db file on the C drive - it is not there.
In Navicat Connections->Edit connection->Open "explorer" it is on the disk. 8 KB lies next to the folders Windows, Program Files...
What am I doing wrong and why can't I work with the sqlite database (Navicat)?
Video with "mistake"
https://cloud.mail.ru/public/KjPY/GhjAYy6gt

Answer 1

Understood. Navicat did not work correctly. Reinstalling helped.