search

sqlpage / SQLPage

Fast SQL-only data application builder. Automatically build a UI on top of SQL queries.
https://sql-page.com
MIT License
1.67k stars 99 forks source link

Multiple Databases #66

Open jahelo opened 1 year ago

jahelo commented 1 year 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 1 year 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 1 year 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 1 year ago

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

srcarvalho12 commented 7 months ago

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

lovasoa commented 7 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