# Skipper (computer software)

> Mediated Wiki article. Canonical URL: https://mediated.wiki/source/Skipper_(computer_software)
> Markdown URL: https://mediated.wiki/source/Skipper_(computer_software).md
> Source: https://en.wikipedia.org/wiki/Skipper_(computer_software)
> Source revision: 1288757372
> License: Creative Commons Attribution-ShareAlike 4.0 International (https://creativecommons.org/licenses/by-sa/4.0/)

{{Infobox software
| name                 = Skipper (former ORM Designer)
| logo                 = 
| logo_size            = frameless
| screenshot           = 
| caption              = 
| developer            = [Inventic, s.r.o.](/source/Inventic%2C_s.r.o.)
| released      = December 2009
| programming language = 
| operating system     = [Cross-platform](/source/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](/source/Visualization_software)
| license              = [Proprietary software](/source/Proprietary_software)
| website              = {{URL|http://www.skipper18.com}}
}}

'''Skipper''' is a visualization tool and [code/schema generator](/source/Automatic_programming) for PHP [ORM frameworks](/source/O%2FR_mapper) like [Doctrine2](/source/Doctrine_(PHP)), [Doctrine](/source/Doctrine_(PHP)), Propel, and [CakePHP](/source/CakePHP), which are used to create [database abstraction layer](/source/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](/source/ER_diagram) extended by concepts of [inheritance](/source/Inheritance_(object-oriented_programming)) and [many-to-many](/source/Many-to-many_(data_model))<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](/source/Qt_(framework)). Import/export of the schema definitions uses [XSL](/source/XSLT) transformations powered by [LibXslt](/source/LibXslt) library. Imported source files are first converted to XML format: no conversion for XML, simple conversion for YML, creating the [Abstract Syntax Tree](/source/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](/source/Doctrine_(PHP))
*[Doctrine](/source/Doctrine_(PHP))
*[CakePHP](/source/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](/source/List_of_object-relational_mapping_software)
*[Comparison of object-relational mapping software](/source/Comparison_of_object-relational_mapping_software)
*[Object-relational mapping](/source/Object-relational_mapping)
*[Database abstraction layer](/source/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

---
Adapted from the Wikipedia article [Skipper (computer software)](https://en.wikipedia.org/wiki/Skipper_(computer_software)) by Wikipedia contributors ([contributor history](https://en.wikipedia.org/wiki/Skipper_(computer_software)?action=history)). Available under [Creative Commons Attribution-ShareAlike 4.0 International](https://creativecommons.org/licenses/by-sa/4.0/). Changes may have been made.