[digitalysator]

5 years, 6 months ago #18035

How can I read or display the content of table within Simplifier internal SQLite database?

To get the sqlite files of the Simplifier instance I need access to the server file system to update the database or to download the actual sqlite database. And I need knowledge of the folder structure. So this is a kind of hacky way to get the file into a useful external db tool.

Is there a functionality to get or set the files directly within the Simplifier backend?

[digitalysator]

5 years, 6 months ago #18036

Up

1

Down

::

Additional remark:

The tool DB Browser for SQLite (https://sqlitebrowser.org) is useful to easily design and fill tables outside the Simplifier instance.

The perfect solution would be to integrate a similar functionality for Simplifier.

Could you tell me if a functionality like that is planned for a future Simplifier version?

[jonas.rausch]

5 years, 6 months ago #18071

Up

0

Down

::

Hi tg,

 

The next big Version of simplifier will offer an integrated DB Designer for the Simplifier Backend

 

 

[digitalysator]

5 years, 6 months ago #18073

Up

0

Down

::

Hi Jonas,

sounds great!

Please keep us up-to-date if you have any new information about the functionality details.

[Armin Winkler]

4 years, 10 months ago #21921

Up

0

Down

::

Hello tg / digitalysator,

 

meanwhile it is way easier to upload / download a SQLite file to your SQL connector of type SQLite. You can simply change the file in the connector configuration! Additionally, in the upcoming 5.5 release due for end of July, the aforementioned DB designer will be heavily extended as to make use of external tools like the one you linked in this thread unnecessary.

 

Regards,

Armin