Re: suggestions to add REST API to MySQL / MariaDB tables

2023-02-25 Thread David Schwartz via PLUG-discuss
I found this doc for MySQL: https://dev.mysql.com/doc/mysql-router/8.0/en/ Has anybody worked with this? (There’s a section at the end that supports a REST router.) I also found this 3rd-party service for managing members: Memberful.com It has a REST interface that uses GraphQL and seems to

Re: suggestions to add REST API to MySQL / MariaDB tables

2023-02-24 Thread David Schwartz via PLUG-discuss
The hosting provider got back to me and said that they can set me up with a restricted shell access on any of my accounts. Also, cPanel has a way to support npm built into it. They’re not sure if the built-in support for REST routing on MySQL is enabled or not; they need me to be more

Re: suggestions to add REST API to MySQL / MariaDB tables

2023-02-24 Thread Thomas Scott via PLUG-discuss
> Some may ask, “Why not some cloud service, like AWS or …?” My only answer is: because this is what I know right now. Convince me otherwise. I'm biased, but I'd use - spin up a VPC, attach a database vm, and a front-end vm, and only expose the front-end vm. Then you have a private network to the

Re: suggestions to add REST API to MySQL / MariaDB tables

2023-02-24 Thread David Schwartz via PLUG-discuss
That’s certainly the simplest way, and it’s probably fine for an intranet that’s behind a firewall, but it’s not safe for a a public-facing application, which is what this is. But thanks for the reminder. -David Schwartz > On Feb 24, 2023, at 7:34 AM, techli...@phpcoderusa.com wrote: > >

Re: suggestions to add REST API to MySQL / MariaDB tables

2023-02-24 Thread Stephen Partington via PLUG-discuss
Are you talking about windows user authentication or just it all happens to live there? Take a look at nextcloud and some of its modules the nature of it being open source might help with code ideas. And it is php. On Fri, Feb 24, 2023, 12:03 PM T Zack Crawford via PLUG-discuss <

Re: suggestions to add REST API to MySQL / MariaDB tables

2023-02-24 Thread T Zack Crawford via PLUG-discuss
I'm not sure I'm understanding the question, but your application server can talk to the SQL server using python SQLAlchemy. If your web application is a python flask application, that process could be easy. I'm not sure what steps are needed to configure your MySQL server to be accessible

Re: suggestions to add REST API to MySQL / MariaDB tables

2023-02-24 Thread Keith Smith via PLUG-discuss
David, Seems like what you are attempting would be routine. (remote MySql) I found this :: https://stackoverflow.com/questions/27916503/lamp-setup-with-remote-mysql Hope it helps. Keith On 2023-02-24 03:00, David Schwartz via PLUG-discuss wrote: I’m building a web app that requires a

suggestions to add REST API to MySQL / MariaDB tables

2023-02-24 Thread David Schwartz via PLUG-discuss
I’m building a web app that requires a membership with various levels. There will be a front-end (the web app) and a back-end on a Windows server. I’m thinking about putting the user DB on separate server. I have this tool that lets me build apps using php and MySQL really easily to handle my