Internal SQLite files – tool to design tables or access the content of a table

Tagged:
  • digitalysator
        Has successfully completed the online course Introduction
        Has successfully completed the online course Intermediate (200)
        Has successfully completed the online course Advanced (300)
      5 years 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
          Has successfully completed the online course Introduction
          Has successfully completed the online course Intermediate (200)
          Has successfully completed the online course Advanced (300)
        5 years 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
            Has successfully completed the online course Introduction
            Has successfully completed the online course Intermediate (200)
            Has successfully completed the online course Advanced (300)
          5 years ago #18071
          Up
          0
          Down
          ::

          Hi tg,

           

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

           

           

          digitalysator
              Has successfully completed the online course Introduction
              Has successfully completed the online course Intermediate (200)
              Has successfully completed the online course Advanced (300)
            5 years 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
                Has successfully completed the online course Introduction
                Has successfully completed the online course Intermediate (200)
                Has successfully completed the online course Advanced (300)
                Has successfully completed the online course Basics (100)
              4 years 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

            Viewing 5 posts - 1 through 5 (of 5 total)

            You must be logged in to reply to this topic.