Database work and Ajax

new BookmarkLockedFalling
carlgundel
Administrator
*****
Creator of Run BASIC

carlgundel Avatar

Posts: 975

carlgundel
Administrator
*****
Creator of Run BASIC

carlgundel Avatar

Posts: 975

Post by carlgundel on Mar 24, 2025 19:37:01 GMT -5

carlgundel Avatar
Just to give people an update...

What I'm working on right now is to make sure that the database stuff works.

-The locking problem with SQLite (this has a fix)
-Support for MySQL
-Support for ODBC

Also, there are Ajax features that need to be brought up to date.

The database code is updated and for SQLite3 the lock test monster program runs successfully without hanging.

-Carl
meerkat
Senior Member
****

meerkat Avatar

Posts: 250
Member is Online

carlgundel
Administrator
*****
Creator of Run BASIC

carlgundel Avatar

Posts: 975

Post by carlgundel on Mar 25, 2025 12:42:27 GMT -5

meerkat Avatar
That's great news!

The only other real killer for me was the memory leaks. As a work around I stop RB and restart it when memory gets too big to handle. It's annoying to the users, but it keeps it running.

Thanks for the update..

I can only speculate at this time about memory leaks, but we can dig into that later on.
meerkat
Senior Member
****

meerkat Avatar

Posts: 250
Member is Online

Post by meerkat on Mar 26, 2025 5:27:17 GMT -5

If I remember it seems to be the RUN command. When returning from a Run command it leaves a lot of memory tied up.
It's been a long time ago, but I remember writing a couple simple programs with one program RUNning another. After it returned you could see memory jump. I'll look around and see if I can find it.
carlgundel
Administrator
*****
Creator of Run BASIC

carlgundel Avatar

Posts: 975

meerkat
Senior Member
****

meerkat Avatar

Posts: 250
Member is Online

Post by meerkat on Aug 10, 2025 18:42:06 GMT -5

meerkat Avatar
That's great news!

The only other real killer for me was the memory leaks. As a work around I stop RB and restart it when memory gets too big to handle. It's annoying to the users, but it keeps it running.

Thanks for the update..


Been a long time ago, and not sure why I had to find a work around to the RUN command. I suspect RB expects the RUNNED program to end with the end command and that is when it knows to clean up the RUNNED program. Since I had to use JavaScript to end the RUNNED program, or display a [Exit] button in the Parent that goes to a tag in the parent. So RB doesn't know it ended and doesn't clean it up..
Maybe a flush command would help. For example;
run incdir$;prog,ドル#include
render #include
Maybe a flush #include command to clean up #include would help..

I don't know if this is even the problem.
Just speculating...
Dan
metro
Full Member
***

metro Avatar

Posts: 207

Post by metro on Aug 10, 2025 20:44:00 GMT -5

meerkat Avatar
meerkat Avatar
That's great news!

The only other real killer for me was the memory leaks. As a work around I stop RB and restart it when memory gets too big to handle. It's annoying to the users, but it keeps it running.

Thanks for the update..
Been a long time ago, and not sure why I had to find a work around to the RUN command. I suspect RB expects the RUNNED program to end with the end command and that is when it knows to clean up the RUNNED program. Since I had to use JavaScript to end the RUNNED program, or display a [Exit] button in the Parent that goes to a tag in the parent. So RB doesn't know it ended and doesn't clean it up..
Maybe a flush command would help. For example;
run incdir$;prog,ドル#include
render #include
Maybe a flush #include command to clean up #include would help..

I don't know if this is even the problem.
Just speculating...
Dan

This may not be relevant to what Dan has eluded to above just throwing it out there.

I realize I am a complete noob with RB and it just could be me, BUT I am finding RB hangs from time to time and I get a pop-up from win11(64) "Process Monitor Emergency: No Space left.(Not Responding)"
I have to kill RB through Task Manager.
Sure it could be problems with my coding!

I have a main program running 3 child programs. to END I do use "END" in the main program, not sue if that leaves the 3 child programs still using memory!
Last Edit: Aug 10, 2025 20:46:14 GMT -5 by metro
Intel Core2 QUAD CPU @2.54 x 4 Mint Linux 19.3 Mate