Support for PostgreSQL?

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

carlgundel Avatar

Posts: 975

meerkat
Senior Member
****

meerkat Avatar

Posts: 250

carlgundel
Administrator
*****
Creator of Run BASIC

carlgundel Avatar

Posts: 975

Post by carlgundel on Jun 11, 2025 9:37:25 GMT -5

meerkat Avatar
Happens to be one of my favoriate. I love their triggers.
But I can live without it. Not a big deal.

Rather see time on memory leaks, and stuff like lof() fail on large files etc..
Just my personal pref. I'll be happy with anything...



The memory leaks are related to using the RUN statement?

Do you have a simple example of LOF() not working properly? I did a quick search here and didn't see a previous mention.
meerkat
Senior Member
****

meerkat Avatar

Posts: 250

Post by meerkat on Jun 11, 2025 10:47:31 GMT -5

Here is a section of a program with some debug.
print "265---";DB$
open DB$ for input as #a ' see if the file is sqlite format
print "267 DB:";DB$
print "--------";lof(#a)
a$ = "x"
if lof(#a) > 12 then
a$ = input$(#a,13)
a$ = lower$(a$)
end if
close #a

Debug results..

265---c:\rbp101\projects\ancestry_project\data\ancestry.db
267 DB:c:\rbp101\projects\ancestry_project\data\ancestry.db

Runtime Error in program 'ionSql': print "--------";lof(#a)
AllocationFailure

carlgundel
Administrator
*****
Creator of Run BASIC

carlgundel Avatar

Posts: 975

Post by carlgundel on Jun 12, 2025 6:55:43 GMT -5

meerkat Avatar

Debug results..

265---c:\rbp101\projects\ancestry_project\data\ancestry.db
267 DB:c:\rbp101\projects\ancestry_project\data\ancestry.db

Runtime Error in program 'ionSql': print "--------";lof(#a)
AllocationFailure


It fails with an allocation error. It does this for all files?
meerkat
Senior Member
****

meerkat Avatar

Posts: 250

carlgundel
Administrator
*****
Creator of Run BASIC

carlgundel Avatar

Posts: 975

Post by carlgundel on Jun 12, 2025 9:21:13 GMT -5

meerkat Avatar
No.. Here is the debug output of another file that is ok.

265---c:\rbp101\projects\foodbank_project\data\foodBank.db
267 DB:c:\rbp101\projects\foodbank_project\data\foodBank.db
--------3473297

Directory shows:
ancestry.db size = 172,789 KB
fooBank.db size = 3,392 KB

Would it be okay if you could email me one of the files that doesn't work?
meerkat
Senior Member
****

meerkat Avatar

Posts: 250

Post by meerkat on Jun 12, 2025 11:40:56 GMT -5

carlgundel Avatar
meerkat Avatar
No.. Here is the debug output of another file that is ok.

265---c:\rbp101\projects\foodbank_project\data\foodBank.db
267 DB:c:\rbp101\projects\foodbank_project\data\foodBank.db
--------3473297

Directory shows:
ancestry.db size = 172,789 KB
fooBank.db size = 3,392 KB
Would it be okay if you could email me one of the files that doesn't work?



It's on it's way..
carlgundel
Administrator
*****
Creator of Run BASIC

carlgundel Avatar

Posts: 975

StefanPendl
Global Moderator
*****

StefanPendl Avatar

Run for BASIC ...
Posts: 945

[b]Stefan[/b] - [a href=http://stefanpendl.runbasichosting.com/]Homepage[/a][br][br][b]Please give credit if you use code I post, no need to ask for permission.[/b][br][br]Run BASIC 1.01, Fire-/Waterfox (IE11, Edge), Windows 10 Professional x64, Intel Core i7-4710MQ 2.5GHz, 16GB RAM