antonnazarov / apricot

Apricot DB: database ERD- design tool with Reverse Engineering
GNU General Public License v3.0
20 stars 2 forks source link

apricot DB 2.6.2 unable to find and open a sqlite database file #14

Open devescovil opened 2 months ago

devescovil commented 2 months ago

Hi Anton, I would like to use your tool to document the SQLite databases of some applications that I have made when retired and that now, being 80 years old, I will have to leave in care of younger programmers. This happens: using Apricot 2.6.2: I define a new project and declare SQlite as the database structure. Below I active the function of "Reverse Engineering" and in the dialog of "connect to SQLite database" I place the file browser on the folder that really contains the SQLite Database File but the file does not appear and therefore I cannot select it. Keep in mind that the connection dialog specifically provides for SQLite as a type of file to be searched. Evidently something went wrong or in the way of using the procedure or in the behavior of the software. Could you kindly help me solve the problem? thank you in advance!

devescovil commented 2 months ago

I think I understand the problem! The connection dialogue is looking for a file with "db" extension and not "sqlite"! This is not easily understandable because "sqlitebrowser", the most used tool for managing the SQLite databases, places for default ".sqlite" as extension of the database files created by its procedures! Anyway thank you!