{"repo":"anykeyh/clear","free":true,"listed":false,"github":"https://github.com/anykeyh/clear","clone":"git clone https://github.com/anykeyh/clear.git","description":"Advanced ORM between postgreSQL and Crystal","language":"Crystal","stars":284,"topics":["crystal","orm","postgres","sql","database","crystal-language"],"license":"MIT","category":"databases-storage","readme_excerpt":"Clear Clear is an ORM built specifically for PostgreSQL in Crystal. It's probably the most advanced ORM for PG on Crystal in term of features offered. It features Active Record pattern models, and a low-level SQL builder. You can deal out of the box with jsonb, tsvectors, cursors, CTE, bcrypt password, array, uuid primary key, foreign constraints... and other things ! It also has a powerful DSL to construct where and having clauses. The philosophy beneath is to please me (and you !) with emphasis made on business code readability and minimal setup. The project is quite active and well maintened, too ! Resources - Online Manual and Getting Started - Auto-generated API Documentation - Changelog Why to use Clear ? In few seconds, you want to use Clear if: - [X] You want an expressive ORM. Put straight your thought to your code ! - [X] You'd like to use advanced Postgres features without hassle - [X] You are aware of the pros and cons of the Active Records pattern You don't want to use Clear if: - [ ] You're not willing to use PostgreSQL - [ ] You're looking for a minimalist ORM / Data Mapper - [ ] You need something which doesn't evolve, with breaking changes. Clear is still in alpha but starting to mature ! Features - Active Record pattern based ORM - Expressiveness as mantra - even with advanced features like jsonb, regexp... - - Proper debug information - Log and colorize query. Show you the last query if your code crash ! - If failing on compile for a good reason, give prope","default_branch":null,"files":null,"tree":[],"storefront":"/r/anykeyh","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/anykeyh/clear/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."}