{"repo":"IlluminusLimited/pgdice","free":true,"listed":false,"github":"https://github.com/IlluminusLimited/pgdice","clone":"git clone https://github.com/IlluminusLimited/pgdice.git","description":"Postgres partitioning built on top of https://github.com/ankane/pgslice","language":"Ruby","stars":11,"topics":["postgres","partitioning","sharding","partition-table","database"],"license":"MIT","category":"databases-storage","readme_excerpt":"PgDice PgDice is a utility for creating and maintaining partitioned database tables that builds on top of the excellent gem https://github.com/ankane/pgslice PgDice is intended to be used by scheduled background jobs in frameworks like Sidekiq where logging and clear exception messages are crucial. Maintenance status This project is stable and used daily in production. Installation Add this line to your application's Gemfile: And then execute: $ bundle Or install it yourself as: $ gem install pgdice Usage Configuration You must configure PgDice before you can use it, otherwise you won't be able to perform any manipulation actions on tables. This is an example config from a project using Sidekiq Configuration Parameters - database url - Required : The postgres database url to connect to. - This is required since pgslice requires a postgres url . - PgDice will throw an error if this value is not a valid postgres url. - logger factory - Optional: A factory that will return a logger to use. - Defaults to proc { Logger.new(STDOUT) } - approved tables - Optional: (but not really) The tables to allow modification on. - If you want to manipulate database tables with this gem you're going to need to provide this data. - See the Approved Tables Configuration section for more. - dry run - Optional: Boolean value to control whether changes are executed on the database. - Defaults to false - true will make PgDice log out the commands but not execute them. - batch size - Optional: Maximum ","default_branch":null,"files":null,"tree":[],"storefront":"/r/IlluminusLimited","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/IlluminusLimited/pgdice/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."}