Skipper is a visualization tool and code/schema generator for PHP ORM frameworks like Doctrine2, Doctrine, Propel, and CakePHP, which are used to create database abstraction layer. Skipper is developed by Czech company Inventic, s.r.o. based in Brno, and was known as ORM Designer prior to rebranding in 2014.
Overview
- Generates visual model from the schema definition files789
- Repetitive import/export of schema definitions in supported formats (XML, YML, PHP annotations)101112
- Schema definition files are automatically generated from the visual model131415
- Visual representation uses ER diagram extended by concepts of inheritance and many-to-many161718
- Supports customization using .xml configuration files and JavaScript192021
- Does not support direct connections to the database22
- Crude and simplistic visual representation and menus23
Architecture
Skipper was built on the Qt framework. Import/export of the schema definitions uses XSL transformations powered by LibXslt library. Imported source files are first converted to XML format: no conversion for XML, simple conversion for YML, creating the Abstract Syntax Tree and its subsequent conversion to XML for PHP annotations. The import/export scripts are configured in JavaScript and can be freely customized.24
Supported ORM frameworks
Frameworks supported for visual model and schema files generation:25
History
Skipper was created as an internal tool for the web applications developed by Inventic. It was first published as a commercial tool under the name ORM Designer in 2009.2627 Application was reworked and optimized in January 2013, and released as ORM Designer 2.2829 In May 2013 ORM Designer became part of the South Moravian Innovation Center Incubator program (support program for innovative technological startups).303132 In June 2014, ORM Designer version 3 was released and rebranded under the name of Skipper33
See also
- List of object-relational mapping software
- Comparison of object-relational mapping software
- Object-relational mapping
- Database abstraction layer
External links
References
"ORM Designer". Archived from the original on 2014-02-22. Retrieved 2014-07-15. https://web.archive.org/web/20140222032046/http://www.jic.cz/orm-designer ↩
"ORM Designer". 12 May 2010. http://www.phparch.com/2010/05/orm-designer/ ↩
"PHP5 Magazine: ORM Designer Reviewed". php5.phpmagazine.net. Archived from the original on 16 September 2010. Retrieved 6 June 2022. https://web.archive.org/web/20100916182607/http://php5.phpmagazine.net/2010/09/orm-designer-reviewed.html ↩
"Symfony2 cheat sheet". www.symfony2cheatsheet.com. Archived from the original on 2014-07-03. https://web.archive.org/web/20140703152651/http://www.symfony2cheatsheet.com/ ↩
"ORM Designer". Archived from the original on 2014-02-22. Retrieved 2014-07-15. https://web.archive.org/web/20140222032046/http://www.jic.cz/orm-designer ↩
"Press Release: Skipper Skipper - the ORM Designer Blog". http://blog.skipper18.com/2014/06/press-release-skipper/ ↩
"ORM Designer". Archived from the original on 2014-02-22. Retrieved 2014-07-15. https://web.archive.org/web/20140222032046/http://www.jic.cz/orm-designer ↩
"ORM Designer". 12 May 2010. http://www.phparch.com/2010/05/orm-designer/ ↩
"PHP5 Magazine: ORM Designer Reviewed". php5.phpmagazine.net. Archived from the original on 16 September 2010. Retrieved 6 June 2022. https://web.archive.org/web/20100916182607/http://php5.phpmagazine.net/2010/09/orm-designer-reviewed.html ↩
"ORM Designer". Archived from the original on 2014-02-22. Retrieved 2014-07-15. https://web.archive.org/web/20140222032046/http://www.jic.cz/orm-designer ↩
"ORM Designer". 12 May 2010. http://www.phparch.com/2010/05/orm-designer/ ↩
"PHP5 Magazine: ORM Designer Reviewed". php5.phpmagazine.net. Archived from the original on 16 September 2010. Retrieved 6 June 2022. https://web.archive.org/web/20100916182607/http://php5.phpmagazine.net/2010/09/orm-designer-reviewed.html ↩
"ORM Designer". Archived from the original on 2014-02-22. Retrieved 2014-07-15. https://web.archive.org/web/20140222032046/http://www.jic.cz/orm-designer ↩
"ORM Designer". 12 May 2010. http://www.phparch.com/2010/05/orm-designer/ ↩
"PHP5 Magazine: ORM Designer Reviewed". php5.phpmagazine.net. Archived from the original on 16 September 2010. Retrieved 6 June 2022. https://web.archive.org/web/20100916182607/http://php5.phpmagazine.net/2010/09/orm-designer-reviewed.html ↩
"ORM Designer". Archived from the original on 2014-02-22. Retrieved 2014-07-15. https://web.archive.org/web/20140222032046/http://www.jic.cz/orm-designer ↩
"ORM Designer". 12 May 2010. http://www.phparch.com/2010/05/orm-designer/ ↩
"PHP5 Magazine: ORM Designer Reviewed". php5.phpmagazine.net. Archived from the original on 16 September 2010. Retrieved 6 June 2022. https://web.archive.org/web/20100916182607/http://php5.phpmagazine.net/2010/09/orm-designer-reviewed.html ↩
"ORM Designer". Archived from the original on 2014-02-22. Retrieved 2014-07-15. https://web.archive.org/web/20140222032046/http://www.jic.cz/orm-designer ↩
"Extending ORM Attributes | ORM Designer". Archived from the original on 2014-06-10. Retrieved 2014-07-15. https://web.archive.org/web/20140610104119/http://help.orm-designer.com/en/extending-orm-attributes ↩
"Extending script files | ORM Designer". Archived from the original on 2014-02-23. Retrieved 2014-07-15. https://web.archive.org/web/20140223135052/http://help.orm-designer.com/en/extending-scripts ↩
"MySQL Workbench | ORM Designer". Archived from the original on 2014-04-19. Retrieved 2014-07-15. https://web.archive.org/web/20140419204544/http://help.orm-designer.com/en/mysql-workbench ↩
"ORM Designer – Quick Review « Stacktrace('dev-KRTCS.net')". Archived from the original on 2014-02-21. Retrieved 2014-07-15. https://web.archive.org/web/20140221205201/http://stacktrace.dev-krtcs.net/2013/04/05/orm-designer/ ↩
"Magic behind ORM Designer | ORM Designer Blog". Archived from the original on 2014-04-26. Retrieved 2014-07-15. https://web.archive.org/web/20140426002150/http://blog.orm-designer.com/2014/01/magic-behind-orm-designer/ ↩
"Supported Platforms | ORM Designer". Archived from the original on 2014-05-30. Retrieved 2014-07-15. https://web.archive.org/web/20140530062217/http://help.orm-designer.com/en/supported-platforms ↩
"New tool – ORM Designer | ORM Designer Blog". Archived from the original on 2014-02-23. Retrieved 2014-07-15. https://web.archive.org/web/20140223135048/http://blog.orm-designer.com/2009/12/new-tool-orm-designer/ ↩
"goaleurope.com/ORM-Designer-raises-funding-from-angel-investor". Archived from the original on 2014-07-26. Retrieved 2014-07-15. https://web.archive.org/web/20140726102451/http://goaleurope.com/2013/08/21/czech-orm-designer-raises-funding-from-angel-investor/ ↩
"Magic behind ORM Designer | ORM Designer Blog". Archived from the original on 2014-04-26. Retrieved 2014-07-15. https://web.archive.org/web/20140426002150/http://blog.orm-designer.com/2014/01/magic-behind-orm-designer/ ↩
"Mladí programátoři z Brna zdražili svůj software trojnásobně. Prodeje zůstaly stejné". 10 July 2013. http://byznys.ihned.cz/c1-60215550-mladi-programatori-z-brna-zdrazili-svuj-software-trojnasobne-prodeje-zustaly-stejne ↩
"goaleurope.com/ORM-Designer-raises-funding-from-angel-investor". Archived from the original on 2014-07-26. Retrieved 2014-07-15. https://web.archive.org/web/20140726102451/http://goaleurope.com/2013/08/21/czech-orm-designer-raises-funding-from-angel-investor/ ↩
"Do JIC Innovation parku se hlásí 41 firem, nejlepší vyberou Rostock, Všianský a Berdár". 12 March 2013. http://www.tyinternety.cz/2013/03/12/clanek/do-jic-innovation-parku-se-hlasi-41-firem-nejlepsi-vyberou-rostock-vsiansky-a-berdar/ ↩
"Companies in the Innovation Park". Archived from the original on 2014-02-25. Retrieved 2014-07-15. https://web.archive.org/web/20140225130438/http://www.jic.cz/companies-in-the-jic-innovation-park#inventic ↩
"Press Release: Skipper Skipper - the ORM Designer Blog". http://blog.skipper18.com/2014/06/press-release-skipper/ ↩