search

lovasoa / SQLpage

SQL-only webapp builder, empowering data analysts to build websites and applications quickly
https://sql.ophir.dev
MIT License
877 stars 62 forks source link

Multiple Databases #66

Open jahelo opened 10 months ago

jahelo commented 10 months ago

I really like the Idea and functionality so far. I would love to have the possibility to connect to multiple different databases and servers to gather data for displaying in my application. This would make it a lot easier to give some self service to less technical colleagues.

lovasoa commented 10 months ago

Hi, and thank you for getting in touch ! This feature is definitely on the radar. For previous discussion about it and ideas of how to work with multiple databases on the current version of SQLPage, see https://github.com/lovasoa/SQLpage/discussions/48

jahelo commented 10 months ago

Thank you for your fast reply. I basically figured out the same by linking the servers. It is not sexy, but it works for my case!

lovasoa commented 10 months ago

Let's keep this open, this is a feature I want to add to sqlpage at some point anyway :)

srcarvalho12 commented 2 months ago

Wouldn't using the "USE database_name" function solve the problem?

lovasoa commented 2 months ago

The easiest way to connect to multiple databases today is to open a connection from one database instance to another. More information on this discussion thread: https://github.com/lovasoa/SQLpage/discussions/48