Support other RelationalDB

[rongfengliang]

Is your feature request related to a problem?

currently from the source code I see signoz only support SQLite database . maybe we can support more other database

Describe the solution you'd like

we can use jmoiron/sqlx package and some configuration for support more database

Thank you for your feature request – we love each and every one!

[pranay01]

@rongfengliang Curious to know. whats the use case for supporting more databases? As of now SQLite is primarily used to store internal metadata like dashboards layout, alert config, etc

[rongfengliang]

@pranay01 Thanks. with sqlite for dashboard and alert . if we have multi instance of query service maybe not good for share message

[ankitnayan]

@rongfengliang that is right. We have added the apis in an interface so that other databases like Postgres can implement them. We shall need non-embedded db when running multiple query-service instances querying the same relational DB as you mentioned already.

We shall pick this up if some users face this issue. Currently, I don't see a need to run multiple query-services as query-service is not under heavy load usually.

[dwelch2344]

I’d prefer to use a standalone db like Postgres, 1 bc we already have it for other operational concerns, and 2 because I have better access and backup tools.

I’d be willing to help contribute the Postgres impl / driver / dialect as needed, if someone would be willing to spec it out and help me get up to speed

[ngudbhav]

Is this still under development?