René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Managed databases with any accessible server","articleBody":"[Managed databases](https://docs.sqlc.dev/en/latest/howto/managed-databases.html) only work using database servers hosted by sqlc Cloud. I'm going to add support for using managed databases with any database server you can access.\r\n\r\nDatabase servers will be configured in a separate `servers` collection in the configuration file.\r\n\r\n```yaml\r\nversion: \"2\"\r\nservers:\r\n  - uri: postgres://localhost:5432/postgres\r\n```\r\n\r\nEach entry will have a mandatory `uri` field and an optional `name`. I may add an optional `engine` field if the URI scheme isn't enough to infer the engine type.\r\n\r\n```yaml\r\nversion: \"2\"\r\nservers:\r\n  - uri: postgres://localhost:5432/postgres\r\nsql:\r\n  - engine: \"postgresql\"\r\n    queries: \"query.sql\"\r\n    schema: \"schema.sql\"\r\n    database:\r\n      managed: true\r\n    gen:\r\n      go:\r\n        package: \"tutorial\"\r\n        out: \"tutorial\"\r\n        sql_package: \"pgx/v5\"\r\n```\r\n\r\nWhen using a database server not hosted by sqlc Cloud, sqlc will automatically create databases as needed based on the schema for the associated query set. All operations against these databases will be read-only, so they can be created once and re-used.\r\n\r\n","author":{"url":"https://github.com/kyleconroy","@type":"Person","name":"kyleconroy"},"datePublished":"2024-06-05T00:22:38.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/3415/sqlc/issues/3415"}