saleem-mirza / serilog-sinks-sqlite

A Serilog sink that writes to SQLite
Apache License 2.0
56 stars 44 forks source link

Feature Request - Add support for custom log table columns #45

Open neozhu opened 1 year ago

neozhu commented 1 year ago

I would like to suggest a new feature for the serilog-sinks-sqlite project. Can we add the ability to define custom log table columns, similar to the columnOptions feature in serilog-sinks-postgresql? https://github.com/b00ted/serilog-sinks-postgresql This would make it easy to switch between different types of databases for storing logs.

My use case is that I have a web project that needs to support different databases (MS SQL Server, MySQL, PostgreSQL, and SQLite). Currently, the corresponding serilog-sinks for these databases all support custom columns. Therefore, I have been using serilog-sinks-sqlite in my project. However, it does not support custom columns, so I am unable to query logs correctly when switching to SQLite.

Thank you for your time and consideration. Best regards,