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

Support for SQL and NoSQL databases. #72

Open
palak-463 opened this issue Jan 8, 2025 · 0 comments · May be fixed by #82
Open

Support for SQL and NoSQL databases. #72

palak-463 opened this issue Jan 8, 2025 · 0 comments · May be fixed by #82
Assignees
Labels
feature request New feature or request

Comments

@palak-463
Copy link

Is your feature request related to a problem? Please describe
Currently, Lotus does not support dynamic data sources. This limitation makes it challenging to use Lotus in projects that rely on real-time or dynamically changing datasets stored in SQL or NoSQL databases. Fetching data from these databases, converting it into CSV or Excel before getting it loaded into a Pandas data frame, and then processing it with Lotus adds unnecessary overhead and limits real-world usability. The process is time consuming and takes up memory space.

Describe the solution you'd like
Support for SQL and NoSQL databases for better integration of LOTUS in projects which require real time data monitoring.

Describe alternatives you've considered
Tried to use external libraries SQLAlchemy and PyMongo to fetch data from databases, converting it to a Pandas data frame, and then using Lotus.

Additional context
The process of using external sources is complex, prone to errors, and would take up a significant amount of time and computational space.

@palak-463 palak-463 added the feature request New feature or request label Jan 8, 2025
@StanChan03 StanChan03 self-assigned this Jan 13, 2025
@StanChan03 StanChan03 linked a pull request Jan 16, 2025 that will close this issue
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
feature request New feature or request
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants