Direction of FastAPI Radar

[doganarif]

I would like to receive ideas and feedback!

[acelee0621]

Hi there,
Thank you for creating fastapi-radar! It's a great tool for monitoring FastAPI applications. I'm currently using it in a project with an asynchronous database setup using aiosqlite and SQLAlchemy's AsyncEngine (create_async_engine("sqlite+aiosqlite:///./db.sqlite3")). I followed the configuration instructions in the README, setting up Radar with a synchronous db_engine (create_engine("sqlite:///./db.sqlite3")) as shown in the example.
However, I noticed that the database query monitoring feature does not capture any queries in the dashboard. I suspect this is because my application executes queries using an asynchronous AsyncSession and AsyncEngine, while fastapi-radar seems to expect a synchronous Engine for query capture (based on the QueryCapture implementation in the source code).
Could you confirm whether fastapi-radar currently supports monitoring queries executed through an asynchronous AsyncEngine? If not, are there plans to add support for asynchronous database engines, or is there a recommended workaround to enable query monitoring in an async setup? For reference, I'm running the application with uvicorn --workers 1 to avoid any concurrency issues.
Any guidance or suggestions would be greatly appreciated. Thank you!

[qinsehm1128]

您好， 感谢您创建 fastapi-radar！它是一款非常棒的 FastAPI 应用程序监控工具。我目前正在一个项目中使用它，该项目使用 aiosqlite 和 SQLAlchemy 的 AsyncEngine (create_async_engine("sqlite+aiosqlite:///./db.sqlite3")) 设置了一个异步数据库。我按照 README 中的配置说明，按照示例所示，使用同步 db_engine (create_engine("sqlite:///./db.sqlite3")) 设置了 Radar。 然而，我注意到数据库查询监控功能并没有在仪表板中捕获任何查询。我怀疑这是因为我的应用程序使用异步 AsyncSession 和 AsyncEngine 执行查询，而 fastapi-radar 似乎需要使用同步 Engine 来捕获查询（基于源代码中的 QueryCapture 实现）。 您能否确认 fastapi-radar 目前是否支持监控通过异步 AsyncEngine 执行的查询？如果没有，是否有计划添加对异步数据库引擎的支持，或者是否有推荐的解决方法来在异步设置中启用查询监控？作为参考，我正在使用 uvicorn --workers 1 运行该应用程序，以避免任何并发问题。 非常感谢您的指导或建议。谢谢！

是这样的,因为根本没有挂载,我准备将事件钩子变成自动判断同步/异步引擎,但是这样可能会对现有代码进行破坏性更改,我先尝试一版pr让作者看一下~

[qinsehm1128]

I would like to receive ideas and feedback!

Hello author. Just as the friend above said, asynchronous support is currently lacking. I wonder if you have any plans for asynchronous support in the future? If you have a plan for asynchronous support, I won't do any development here for now. If you don't have such an idea, I will provide you with a pr and need your help to test the robustness in multiple database environments. Is it feasible? In the future, I also want to add a hook for listening to asynchronous httpx requests

[qinsehm1128]

This is my implementation demo using an asynchronous engine. If there are any problems with my code, I will actively solve them.

[qinsehm1128]

I have another idea... I'm very sorry. Maybe I talk too much... I also want to implement in-code plugins or logru log acquisition... I wonder if it's feasible? Because I have been using apm + OpenTelemetry before We have implemented full-link tracking/log collection, but I think maintaining such a large system is a very time-consuming task, so I want to integrate it into our project. Of course, there is another issue: this might slow down the entire fastapi's running speed and go against the lightweight theme of this project. So I'm very conflicted...

[doganarif]

Hey @qinsehm1128, both of your ideas are amazing. Let me activate the project for this repository so that we can create a roadmap.

[doganarif]

Hey @qinsehm1128, I can operate the roadmap. I was busy for some days, but I'll start creating the roadmap tomorrow.

[doganarif]

In the meantime, if you have time, you can focus on acquiring logs. This will also be a valuable feature for production use.

[qinsehm1128]

与此同时，如果您有时间，可以专注于获取日志。这对于生产环境来说也是一个很有价值的功能。

This is fine. Just recording logs is fine at all

[qinsehm1128]

In the meantime, if you have time, you can focus on acquiring logs. This will also be a valuable feature for production use.

I have developed a scheduling ai that splits the input content and calls the automatic coding project of the cli through the set roles. Would you be interested to have a look? Because I feel it's not comprehensive enough and the content is somewhat complex and beyond my ability

[qinsehm1128]

与此同时，如果您有时间，可以专注于获取日志。这对于生产环境来说也是一个很有价值的功能。

我开发了一个调度AI，可以拆分输入内容，并通过设定的角色调用cli的自动编码项目。你有兴趣看看吗？因为我觉得它不够全面，内容也比较复杂，超出了我的能力范围。

This is a simple process, but there are still many imperfections, which are due to my lack of experience and my first exposure to a complete agent development process

[qinsehm1128]

Brother, what have you been doing lately? Are you busy with work? I don't even have time to go back to GitHub to check

[doganarif]

Hey,

Yes, unfortunately, I'm fully booked these days.

[qinsehm1128]

Yes, unfortunately, I'm fully booked these days.

Don't worry, wait for you to maintain it when you have time.