{{Infobox software | name = Skipper (former ORM Designer) | logo = | logo_size = frameless | screenshot = | caption = | developer = Inventic, s.r.o. | released = December 2009 | programming language = | operating system = Cross-platform<ref>[http://help.orm-designer.com/en/supported-platforms Supported platforms] {{webarchive|url=https://web.archive.org/web/20140530062217/http://help.orm-designer.com/en/supported-platforms |date=2014-05-30 }}</ref> | language = English, Czech | genre = Visualization software | license = Proprietary software | website = {{URL|http://www.skipper18.com}} }}
'''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.<ref name="jic">{{cite web |url=http://www.jic.cz/orm-designer |title=ORM Designer |accessdate=2014-07-15 |url-status=dead |archiveurl=https://web.archive.org/web/20140222032046/http://www.jic.cz/orm-designer |archivedate=2014-02-22 }}</ref><ref name="phparch">{{Cite web|url=http://www.phparch.com/2010/05/orm-designer/|title = ORM Designer|date = 12 May 2010}}</ref><ref name="phpmagazine">{{cite web |url=http://php5.phpmagazine.net/2010/09/orm-designer-reviewed.html |title=PHP5 Magazine: ORM Designer Reviewed |website=php5.phpmagazine.net |access-date=6 June 2022 |archive-url=https://web.archive.org/web/20100916182607/http://php5.phpmagazine.net/2010/09/orm-designer-reviewed.html |archive-date=16 September 2010 |url-status=dead}}</ref><ref name="cheatsheet">{{cite web |url=http://www.symfony2cheatsheet.com/#doctrine |title= Symfony2 cheat sheet|website=www.symfony2cheatsheet.com |url-status=usurped |archive-url=https://web.archive.org/web/20140703152651/http://www.symfony2cheatsheet.com/ |archive-date=2014-07-03}}</ref> Skipper is developed by Czech company '''Inventic, s.r.o.''' based in Brno,<ref name="jic"/> and was known as '''ORM Designer''' prior to rebranding in 2014.<ref name="rebrand">{{Cite web|url=http://blog.skipper18.com/2014/06/press-release-skipper/|title = Press Release: Skipper Skipper - the ORM Designer Blog}}</ref>
== Overview == * Generates visual model from the schema definition files<ref name="jic"/><ref name="phparch" /><ref name="phpmagazine"/> * Repetitive import/export of schema definitions in supported formats (XML, YML, PHP annotations)<ref name="jic"/><ref name="phparch" /><ref name="phpmagazine"/> * Schema definition files are automatically generated from the visual model<ref name="jic"/><ref name="phparch" /><ref name="phpmagazine"/> * Visual representation uses ER diagram extended by concepts of inheritance and many-to-many<ref name="jic"/><ref name="phparch" /><ref name="phpmagazine"/> * Supports customization using .xml configuration files and JavaScript<ref name="jic"/><ref>{{cite web |url=http://help.orm-designer.com/en/extending-orm-attributes |title=Extending ORM Attributes {{pipe}} ORM Designer |accessdate=2014-07-15 |url-status=dead |archiveurl=https://web.archive.org/web/20140610104119/http://help.orm-designer.com/en/extending-orm-attributes |archivedate=2014-06-10 }}</ref><ref>{{cite web |url=http://help.orm-designer.com/en/extending-scripts |title=Extending script files {{pipe}} ORM Designer |accessdate=2014-07-15 |url-status=dead |archiveurl=https://web.archive.org/web/20140223135052/http://help.orm-designer.com/en/extending-scripts |archivedate=2014-02-23 }}</ref> * Does not support direct connections to the database<ref>{{cite web |url=http://help.orm-designer.com/en/mysql-workbench |title=MySQL Workbench {{pipe}} ORM Designer |accessdate=2014-07-15 |url-status=dead |archiveurl=https://web.archive.org/web/20140419204544/http://help.orm-designer.com/en/mysql-workbench |archivedate=2014-04-19 }}</ref> * Crude and simplistic visual representation and menus<ref>{{cite web |url=http://stacktrace.dev-krtcs.net/2013/04/05/orm-designer/ |title=ORM Designer – Quick Review « Stacktrace('dev-KRTCS.net') |accessdate=2014-07-15 |url-status=dead |archiveurl=https://web.archive.org/web/20140221205201/http://stacktrace.dev-krtcs.net/2013/04/05/orm-designer/ |archivedate=2014-02-21 }}</ref>
== 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.<ref name="insides">{{cite web |url=http://blog.orm-designer.com/2014/01/magic-behind-orm-designer/ |title=Magic behind ORM Designer {{pipe}} ORM Designer Blog |accessdate=2014-07-15 |url-status=dead |archiveurl=https://web.archive.org/web/20140426002150/http://blog.orm-designer.com/2014/01/magic-behind-orm-designer/ |archivedate=2014-04-26 }}</ref>
== Supported ORM frameworks == Frameworks supported for visual model and schema files generation:<ref>{{cite web |url=http://help.orm-designer.com/en/supported-platforms |title=Supported Platforms {{pipe}} ORM Designer |accessdate=2014-07-15 |url-status=dead |archiveurl=https://web.archive.org/web/20140530062217/http://help.orm-designer.com/en/supported-platforms |archivedate=2014-05-30 }}</ref> *Doctrine2 *Doctrine *CakePHP
== 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.<ref name="internal">{{cite web |url=http://blog.orm-designer.com/2009/12/new-tool-orm-designer/ |title=New tool – ORM Designer {{pipe}} ORM Designer Blog |accessdate=2014-07-15 |url-status=dead |archiveurl=https://web.archive.org/web/20140223135048/http://blog.orm-designer.com/2009/12/new-tool-orm-designer/ |archivedate=2014-02-23 }}</ref><ref name="goaleurope">{{Cite web |url=http://goaleurope.com/2013/08/21/czech-orm-designer-raises-funding-from-angel-investor/ |title=goaleurope.com/ORM-Designer-raises-funding-from-angel-investor |access-date=2014-07-15 |archive-date=2014-07-26 |archive-url=https://web.archive.org/web/20140726102451/http://goaleurope.com/2013/08/21/czech-orm-designer-raises-funding-from-angel-investor/ |url-status=dead }}</ref> Application was reworked and optimized in January 2013, and released as '''ORM Designer 2'''.<ref name="insides"/><ref>{{Cite web|url=http://byznys.ihned.cz/c1-60215550-mladi-programatori-z-brna-zdrazili-svuj-software-trojnasobne-prodeje-zustaly-stejne|title = Mladí programátoři z Brna zdražili svůj software trojnásobně. Prodeje zůstaly stejné|date = 10 July 2013}}</ref> In May 2013 ORM Designer became part of the South Moravian Innovation Center Incubator program (support program for innovative technological startups).<ref name="goaleurope"/><ref>{{Cite web|url=http://www.tyinternety.cz/2013/03/12/clanek/do-jic-innovation-parku-se-hlasi-41-firem-nejlepsi-vyberou-rostock-vsiansky-a-berdar/|title=Do JIC Innovation parku se hlásí 41 firem, nejlepší vyberou Rostock, Všianský a Berdár|date=12 March 2013}}</ref><ref>{{Cite web |url=http://www.jic.cz/companies-in-the-jic-innovation-park#inventic |title=Companies in the Innovation Park |access-date=2014-07-15 |archive-date=2014-02-25 |archive-url=https://web.archive.org/web/20140225130438/http://www.jic.cz/companies-in-the-jic-innovation-park#inventic |url-status=dead }}</ref> In June 2014, ORM Designer version 3 was released and rebranded under the name of Skipper<ref name="rebrand"/>
== See also == *List of object-relational mapping software *Comparison of object-relational mapping software *Object-relational mapping *Database abstraction layer
== References == {{Reflist|colwidth=40em}}
== External links == *{{Official website|www.skipper18.com}} *{{usurped|1=[https://web.archive.org/web/20140703152651/http://www.symfony2cheatsheet.com/ Symfony cheatsheet]}}
{{DEFAULTSORT:Skipper}} Category:Object–relational mapping Category:Programming tools Category:Computer graphics Category:Graphics software that uses Qt