{"repo":"compositephp/db","free":true,"listed":false,"github":"https://github.com/compositephp/db","clone":"git clone https://github.com/compositephp/db.git","description":"Fast and Lightweight PHP 8.1+ DataMapper and Table Gateway with automatic data caching, smart entities, migrations and many more","language":"PHP","stars":83,"topics":["database","datamapper","doctrine","entity","fast","hydration","lightweight","mysql","php","php81"],"license":"MIT","category":"databases-storage","readme_excerpt":"What is Composite DB Composite DB is lightweight and fast PHP DataMapper and Table Gateway which allows you to represent your SQL tables scheme in OOP style using full power of PHP 8.1+ class syntax. It also gives you CRUD, query builder and automatic caching out of the box, so you can start to work with your database from php code in a minutes! Overview: Features Requirements Installation Quick example Documentation Features Lightweight - easier entity schema, no getters and setters, you don't need attributes for each column definition, just use native php class syntax. Speed - it's 1.5x faster in pure SQL queries mode and many times faster in automatic caching mode (see benchmark). Easy caching - gives you CRUD operations caching out of the box and in general it's much easier to work with cached \"selects\". Strict types - Composite DB forces you to be more strict typed and makes your IDE happy. Hydration - you can serialize your Entities to plain array or json and deserialize them back. Flexibility - gives you more freedom to extend Repositories, for example it's easier to build sharding tables. Code generation - you can generate Entity and Repository classes from your SQL tables. Division of responsibility - every Entity has its own Repository class, and it's the only entry point to make queries to your table. It also has many popular features such as: Query Builder - build your queries with constructor, based on doctrine/dbal Migrations - synchronise your php entities with","default_branch":null,"files":null,"tree":[],"storefront":"/r/compositephp","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/compositephp/db/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."}