The next release of Live Dashboard will have SQLite support

This page summarizes the projects mentioned and recommended in the original post on /r/elixir

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • ecto_sqlite3

    An Ecto SQLite3 adapter.

  • One of the most appealing features of Elixir for me was that it has a self-contained ecosystem. All you need to deploy a production-ready application is the application itself and PostgreSQL. No need for Redis, k8s, Kafka, Nginx, and all that stuff. But can we also go without PostgreSQL (and without losing the power of SQL)? For my first Elixir project, I picked SQLite which doesn't require running a separate service and works great with Ecto, thanks to ecto_sqlite3. And imagine my disappointment when Phoenix Live Dashboard didn't show any fancy stats as it does for PostgreSQL.

  • phoenix_live_dashboard

    Realtime dashboard with metrics, request logging, plus storage, OS and VM insights

  • One of the most appealing features of Elixir for me was that it has a self-contained ecosystem. All you need to deploy a production-ready application is the application itself and PostgreSQL. No need for Redis, k8s, Kafka, Nginx, and all that stuff. But can we also go without PostgreSQL (and without losing the power of SQL)? For my first Elixir project, I picked SQLite which doesn't require running a separate service and works great with Ecto, thanks to ecto_sqlite3. And imagine my disappointment when Phoenix Live Dashboard didn't show any fancy stats as it does for PostgreSQL.

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

    WorkOS logo
  • ecto_sqlite3_extras

    Helpful queries and Phoenix Live Dashboard integration for SQLite. Must-have for SQLite-powered Elixir projects.

  • So, I fixed it. I made ecto_sqlite3_extras (like ecto_psql_extras but for SQLite) and the next release of Phoenix Live Dashboard will include integration with the project. If you have an SQLite-powered Phoenix application, wait for the next release of the dashboard, upgrade, add ecto_sqlite3_extras into the list of dependencies, and your dashboard will now include nice stats for the SQLite database.

  • ecto_psql_extras

    Ecto PostgreSQL database performance insights. Locks, index usage, buffer cache hit ratios, vacuum stats and more.

  • So, I fixed it. I made ecto_sqlite3_extras (like ecto_psql_extras but for SQLite) and the next release of Phoenix Live Dashboard will include integration with the project. If you have an SQLite-powered Phoenix application, wait for the next release of the dashboard, upgrade, add ecto_sqlite3_extras into the list of dependencies, and your dashboard will now include nice stats for the SQLite database.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts