Connecting a Dash App to Postgres Raw SQL & Pandas vs Ibis library

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