Hi Rick, I can’t switch, it is an OpenCart webshow i’ve integrated with a cash-register & invoice system, so I’m stuck with MySQL or Maria-DB…
Met vriendelijke groeten, Warm Regards,  Ton Kuypers +32 (0) 477 739 530 Steenweg op Leopoldsburg 100 • B-2490 • Balen • Belgium www.publishingtools4u.com > On 15 Oct 2025, at 06:57, harrison--- via use-livecode > <[email protected]> wrote: > > You could try using PostgreSQL instead of Maria-DB. I have used it, it is > free, and it works great with LiveCode! > > Good luck! > > Rick > >> On Oct 14, 2025, at 3:00 PM, Ton Kuypers via use-livecode >> <[email protected]> wrote: >> >> Hi all, >> >> I have a problem I can't seem to solve... >> >> I'm running a mySQL server locally on my Mac, version 5.7.23. When I try to >> retrieve using a direct link from LiveCode Community 9.6.3, everything works >> perfectly. >> Remote my provider switched to version Maria-db 10.6.23 and there's a >> "small" issue. >> >> When using a php page to extract the data, everything comes in, a little >> slow, but all data is there. >> But when using the same direct option from LiveCode, only a part of the data >> comes in. Blazing fast, but the data stops after a "random" amount of >> chars... >> The first query direct gives 5.523 chars, php returns 5.472 chars >> The second query via a direct livecode query retrieves 419.530 chars, the >> PHP pages returns 2.664.296 chars >> And a third query returns 1355 characters direct and 10.231 through php... >> >> So I upgraded to Maria-DB on my Mac: same problem as remote >> Removed this installation and installed the latest version of MySQL: cannot >> use this version, because the mysql_native_password does no longer exist, so >> I can’t login anymore. >> So I removed that version as well and went back to MySql 8.0.42. Login works >> again, but als the problem with the chopped off data is back, same as the >> remote Maria-DB version. >> >> I need a working remote database, preferably the latest Maria-DB version as >> installed, but I need to be able to get all the data, using the direct >> connection commands in LiveCode… PHP work fine, but is is slowwwwwwwwww >> >> Anybody a suggestion? >> >> >> Met vriendelijke groeten, >> Warm Regards, >> >>  >> >> Ton Kuypers >> +32 (0) 477 739 530 >> >> Steenweg op Leopoldsburg 100 • B-2490 • Balen • Belgium >> www.publishingtools4u.com >> >> >> >> >> >> _______________________________________________ >> use-livecode mailing list >> [email protected] >> Please visit this url to subscribe, unsubscribe and manage your subscription >> preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
