Using sqlite-web as direct access for storing data unique for my HA environment. Here usage of DML via sqlite-web

[lehmanro2]

Problem/Motivation

(Why the issue was filed)

Expected behavior

(What you expected to happen)

Actual behavior

(What actually happened)

Steps to reproduce

(How can someone else make/see it happen)

Proposed changes

(If you have a proposed change, workaround or fix,
describe the rationale behind it)

[lehmanro2]

(Why the issue was filed)
I am accustumed to SQL and I like Your addon. On a test environment of HA I struggle along to develop and test diverse SQL-statements.
When succesful, I want to transfer them all into my productiv HA. But I am missing something like a SQL-script import. So I have to copy every statement and to proceed one after the other in the query-form .
Is there something to do this? Or must it be developed?

[github-actions]

There hasn't been any activity on this issue recently, so we clean up some of the older and inactive issues.
Please make sure to update to the latest version and check if that solves the issue. Let us know if that works for you by leaving a comment 👍
This issue has now been marked as stale and will be closed if no further activity occurs. Thanks!

[lehmanro2]

Recently there was an Update for HA SQLITE-WEB Feb-2025, but I am still missing a possibility to import a sql-file (ascciitext.sql where I can import DDL and DML statements, perhaps each seperatet by a semicolon. It would be much easier to transfer and execute sql-statements which where testet under an other platform before.
The next question: is there a UI for directly Input/Update like a sheet. So it's not so difficult to do every change via sql. Sorry, I am German and hope that You can understand my conversation :-)