best practice for connecting to an external database wi...

At a glance

The post is seeking suggestions on the best practice for connecting an external database with multiple tables. The community members discuss the use of a token auth variable, whether it should be hardcoded or bound as a variable, and the benefits of using a separate variable for the token. They also discuss the ability to reuse the token variable across different pages and endpoints, and how this can be simplified with global data variables. While there is no explicitly marked answer, the community members provide guidance on the recommended approach and the potential future improvements to the global data variable feature.

JJeremy

I'm looking for suggestions on the best practice.

If I need to connect an external db and lots of tables, should I be adding each one like this? I've created my token auth as a property and bind that into my header value.

Attachment

18 comments

NNotMy_RealName

I had a similar question recently.

As I understand it, this will mask the token as the variable will be server-side and not exposed on the front-end.

However, it isn't a global variable, so, currently, you would have to add the data variable into each component you're using to make the call.

BBogdan

Auth token is masked whether you hardcode it in resource or bind as variable

BBogdan

Unless you bind this variable to some attribute or html embed

JJeremy

Bogdan, is what I'm doing the recommended way?

BBogdan

The recommended way to structure project until it feels good 🙂

BBogdan

But seriously separate variable may just simplify access to token if you need to change it often

BBogdan

In marketplace it is especially important as some kind of documentation so user can change all these named parts with own.

JJeremy

Ok, thanks. This isn't for a marketplace but a personal project. Documentation would be really nice though.

BBogdan

With global data variables separate variable will make more sense when token is reused in different endpoints

BBogdan

and on different pages

BBogdan

For now variable can be reused only within page

JJeremy

I've seen that in the roadmap, it will be a very cool feature when it's ready.

JJeremy

Thanks for the info.

JJeremy

@TrySound, I just tried copy/paste a collection from one page into a new one. The collection accesses the data through an API endpoint. It appears that I'd need to recreate the connection on the new page for it to work. Will the global data variables allow me to do this action?

BBogdan

Yeah, global variable with resource will be copied as is

BBogdan

I mean collection will be copied as is

BBogdan

And will reuse global variable with resource

JJeremy

gotcha, that's how I assumed it would work. Thank you.

Add a reply

Join the Webstudio community

best practice for connecting to an external database with multiple tables