B4J Question How to update changes and additions to a SQLITE database?

[johnerikson]

How to update changes and additions to a SQLITE database to visualize new data immediately.
In the browser I can click F5.
. Commit is not available in B4J which otherwise might update!

 

[Erel]

It depends. How are you showing the data?

 

[Isaacc]

SQLite might save right away

 

[johnerikson]

Thanks!
In a server-side solution, images are stored by reading metadata from the images and saving the data in tables in SQLITE.
Among other things, a unique identity and save datetime are saved. After a save has been performed, a completion is usually up to date,
which means a search on the save datetime to retrieve the newly stored images, which does not give immediate results,
the fastest to reach them is to log out and log in again! Not pretty.
It is possible to solve in another way 'Save in memory' what I going to do, but I thought that I missed some possible way to do a refresh in the program.

 

[Erel]

There is no caching in SQLite. Assuming that you are correctly handling transactions, then the data is immediately available after it is inserted.

And make sure to read: https://www.b4x.com/android/forum/t...ent-access-to-sqlite-databases.39904/#content

 

[johnerikson]

Thanks!
I know that if I close the connection and then open it again, the data is available.
But can I really do that since many users are running at the same time on the same connection.
Have learned from 'experts'? Closing it can create problems for other users, who also recommend using only one connection for writing for all users, but preferably multiple for reading.
If I can close it without problems even with multi-users, the problem is solved.

Have I learned wrong, can I close the connection without problem?

 

[Erel]

I know that if I close the connection and then open it again, the data is available.

You don't need to close the connection.
Read this tutorial: https://www.b4x.com/android/forum/t...ent-access-to-sqlite-databases.39904/#content

 

[johnerikson]

I follow the descriptions but don't succeed. I need to access the data immediately after saving!
I'm doing a trial with a minimal desk top project, to verify if there's something wrong embedded in the server-project.
I can't be the only one who needs data immediately after saving! I feel as if a 'force out' is missing.

 

[johnerikson]

I have the solution, but then I can't follow the suggestion to use one cooection for writing and several others for reading.
It turns out that if I write and read with the same connection, all the data is up to date!
I change and test, I'll find out if there are any problems