tortoise / tortoise-orm

Familiar asyncio ORM for python, built with relations in mind
https://tortoise.github.io
Apache License 2.0
4.38k stars 356 forks source link

why are there three files for one database? #1573

Closed MorTazaFarYabi closed 1 month ago

MorTazaFarYabi commented 3 months ago

why does tortoise orm create 3 files for one sqlite database? (I could not find any explanations for it online) I have a deployed project that uses tortoise orm and I need to remove a row from one of the tables manually. Seeing as there are three files the question is which file should I delete that row from?

vlakius commented 2 months ago

This is how Asynchronous SQLite works -> https://www.sqlite.org/asyncvfs.html

TLDR: when you save some data it doesnt write it directly to the database. it write a sort of "log" file and the execute the data modification in a separate thread leaving the main thread free to receive other request