Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Implement support for PostgreSQL DB type #28

Open
rtamalin opened this issue Jun 27, 2024 · 1 comment
Open

Implement support for PostgreSQL DB type #28

rtamalin opened this issue Jun 27, 2024 · 1 comment
Assignees
Labels

Comments

@rtamalin
Copy link
Collaborator

Currently we are using SQLite3 as on SQL DB backend which is fine for initial developer testing.

However, for a production deployment we will need to support for database solutions that can be shared between multiple telemetry server instances.

As a first past we need to add support for using a PostgreSQL DB backend for the Staging, Operational and Telemetry DBs.

The main differences between SQLite3, and PostgreSQL, at least from the perspective of our current relatively simple SQL schemas and usage patterns, are:

  1. SQLite3 uses ? as the placeholder for provided arguments in an SQL statement, whereas PostgreSQL using $1, $2, and so on for it's placeholders.
  2. Table schema specifications for types and constraints may be slightly different
  3. DB Config settings will need to be able to specify credentials.
@rtamalin rtamalin self-assigned this Jun 27, 2024
@rtamalin
Copy link
Collaborator Author

PR #32 makes a start at implementing this but there is still more work to do.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

1 participant