{"repo":"orsinium-labs/ecto_sqlite3_extras","free":true,"listed":false,"github":"https://github.com/orsinium-labs/ecto_sqlite3_extras","clone":"git clone https://github.com/orsinium-labs/ecto_sqlite3_extras.git","description":"Helpful queries and Phoenix Live Dashboard integration for SQLite. Must-have for SQLite-powered Elixir projects.","language":"Elixir","stars":38,"topics":["dashboard","database","ecto","elixir","liveview","metrics","observability","phoenix","sqlite","sqlite3"],"license":"MIT","category":"databases-storage","readme_excerpt":"Ecto SQLite3 Extras Helpful queries and Phoenix Live Dashboard integration for SQLite. It's like ecto psql extras but for SQLite instead of PostgreSQL. Installation The package can be installed by adding ecto sqlite3 extras to your list of dependencies in mix.exs : Integrating with Phoenix Live Dashboard When you have ecto sqlite3 extras in the list of dependencies for your Phoenix project that uses ecto sqlite3, the Phoenix Live Dashboard will automatically show the tables produced by ecto sqlite3 extras in the \"Ecto Stats\" tab. Magic! Using from Elixir If you don't have Phoenix Live Dashboard on the environment you want to inspect, you can use ecto sqlite3 extras directly from the iex shell. Available queries 1. total size . The total size of all tables and indices. It's a summary table, it has only 2 columns: name and value . Rows: 1. cells : The number of cells in the DB. Each value stored in the DB is represented as at least one cell. So, the number of cells correlates with the number of records in the DB. 1. payload size : How much space the actual useful payload takes in the DB. 1. unused size : How much space in the DB is reserved, not used yet, and can be used later to store more data. This is a surplus that occurs because SQLite allocates space for data in chunks (\"pages\"). 1. vacuum size : How much space is unused and cannot be used for future data. You can run VACUUM command to reduce it. 1. page size : The total space occupied by all pages. Each page is a single ","default_branch":null,"files":null,"tree":[],"storefront":"/r/orsinium-labs","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/orsinium-labs/ecto_sqlite3_extras/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}