When using a database to store data and utilising raw SQL with Pandas pd.read_sql, is there any performance gain to be had by using Ibis instead?
The docs reference Ibis because it uses SQLAlchemy internally.
Is Pandas mandatory as most examples use it?
Hello @ctrl-alt-del,
Plotly is working on something to allow for px to take other data arguments than a pandas dataframe. This should be available in version 3.0.
In the case of AG grid, it was a mainstay to use pandas because it’s widespread use. However, when it comes to the rowData, it’s not a dataframe, it’s an array of dictionaries. So it’s not restricted to a specific dataframe.
1 Like