You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@baremaps.apache.org by GitBox <gi...@apache.org> on 2023/01/16 13:00:55 UTC
[GitHub] [incubator-baremaps] julsbreakdown opened a new issue, #571: How to use multi database
julsbreakdown opened a new issue, #571:
URL: https://github.com/apache/incubator-baremaps/issues/571
Hello.
How would you proceed to use multiple Postgis databases? In our setup, we can have up to 3dbs.
- can baremaps studio be the solution ?
- load multiple instances of baremaps?
- or can that be a feature // evolution ?
Thanks
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] How to use multi database [incubator-baremaps]
Posted by "bchapuis (via GitHub)" <gi...@apache.org>.
bchapuis commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-2047284796
Cool, I created #845 to discuss the single tileset with multiple databases case and #846 for the ability to serve multiple tilesets.
BTW, the voting process to release apache baremaps 0.7.3-rc1 just started and you are welcome to check the release artifacts and add you vote.
https://lists.apache.org/thread/cvz3y3rqsnv37zqx8b7vo65f6lpbtjm6
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-baremaps] julsbreakdown commented on issue #571: How to use multi database
Posted by GitBox <gi...@apache.org>.
julsbreakdown commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-1397294536
@bchapuis
Thanks for the feedback
I will try and send you a short document with examples, workflows and such.
Have a great evening
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] How to use multi database [incubator-baremaps]
Posted by "julsbreakdown (via GitHub)" <gi...@apache.org>.
julsbreakdown commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-2041998770
Yes we have considered it, but starting several instances of Baremaps seemed kinda of overkill. But if you think it is better of, we will probably go this way
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] How to use multi database [incubator-baremaps]
Posted by "bchapuis (via GitHub)" <gi...@apache.org>.
bchapuis closed issue #571: How to use multi database
URL: https://github.com/apache/incubator-baremaps/issues/571
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-baremaps] bchapuis commented on issue #571: How to use multi database
Posted by GitBox <gi...@apache.org>.
bchapuis commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-1397186214
I see, this is an interesting use case. The current architecture revolves around the cli and the idea was to start one process per service. We could evolve toward an architecture where all the services are managed by a process, but I guess that this would require to develop an admin interface to register and configure tilesets (e.g. geoserver). Do not hesitate to further describe your idea or to add exemples. I guess this is something which is difficult to get right.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-baremaps] bchapuis commented on issue #571: How to use multi database
Posted by GitBox <gi...@apache.org>.
bchapuis commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-1384221234
I would say that it depends on the use case. I think you could already use baremaps with several databases when importing data (see the workflows). Given a few minor modifications, it should be possible to configure the Hikari connection pool to connect to replicas of the same database (this would be a great addition to the project). Finally, given more important modifications, it may be possible to generate vector tile layers coming from different databases. Could you provide more information about what you want to achieve?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] How to use multi database [incubator-baremaps]
Posted by "julsbreakdown (via GitHub)" <gi...@apache.org>.
julsbreakdown commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-2046715713
And yes you are correct.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-baremaps] julsbreakdown commented on issue #571: How to use multi database
Posted by GitBox <gi...@apache.org>.
julsbreakdown commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-1384975128
We would like to serve one or more vector tiles that can be from one or more databases
ATM we are using :
`pathtobaremaps/baremaps/bin/baremaps map serve --database "${JDBC_URL}" --tileset "${TILESET_PATH}" --style "${STYLE_PATH}"`
What we would like is to have one instance of baremaps severing n vector tiles from n databases.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] How to use multi database [incubator-baremaps]
Posted by "bchapuis (via GitHub)" <gi...@apache.org>.
bchapuis commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-2041989726
@julsbreakdown It is not possible to have multiple tilesets or multiple databases on a single instance yet. It should be straightforward to implemnet, but I'm a bit worried about having multiple connection pools in the same JVM. Have you concidered starting several processes?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] How to use multi database [incubator-baremaps]
Posted by "bchapuis (via GitHub)" <gi...@apache.org>.
bchapuis commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-2045517739
Not sure how to interpret the laugh emoji ;)
The discussion has spanned over a long period of time, and I have a limited understanding of your use case. My current impression is that you'd like to serve several tilesets, each of which may involve one or more databases and may potentially be associated with one or more stylesheets. This scenario is not as simple as it sounds, and things could go sideways. I'd love to break things down and, for instance, start by implementing multi-database support with a single tileset or multi-tileset with a single database. Does this make sense? What would be your priority.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] How to use multi database [incubator-baremaps]
Posted by "bchapuis (via GitHub)" <gi...@apache.org>.
bchapuis commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-1819291777
The current configuration format for workflows allows to use databases. What is missing is the ability to create vector tiles from several databases. @julsbreakdown if this is something you need, I suggest to log another issue That describes this use case.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] How to use multi database [incubator-baremaps]
Posted by "julsbreakdown (via GitHub)" <gi...@apache.org>.
julsbreakdown commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-2039807064
@bchapuis
Sorry, did not see your response..
So is it possible to have multiple tilesets on one instance?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] How to use multi database [incubator-baremaps]
Posted by "julsbreakdown (via GitHub)" <gi...@apache.org>.
julsbreakdown commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-2046711460
It was meant to be 'joy' !
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
Re: [I] How to use multi database [incubator-baremaps]
Posted by "bchapuis (via GitHub)" <gi...@apache.org>.
bchapuis commented on issue #571:
URL: https://github.com/apache/incubator-baremaps/issues/571#issuecomment-2045019193
I think we can open a new issue and discuss the feature and its implementation.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@baremaps.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org