Skipper (computer software)

Last updated
Skipper (former ORM Designer)
Developer(s) Inventic, s.r.o.
Initial releaseDecember 2009
Operating system Cross-platform [1]
Available inEnglish, Czech
Type Visualization software
License Proprietary software
Website 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. [2] [3] [4] [5] Skipper is developed by Czech company Inventic, s.r.o. based in Brno, [2] and was known as ORM Designer prior to rebranding in 2014. [6]

Contents

Overview

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. [11]

Supported ORM frameworks

Frameworks supported for visual model and schema files generation: [12]

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. [13] [14] Application was reworked and optimized in January 2013, and released as ORM Designer 2. [11] [15] In May 2013 ORM Designer became part of the South Moravian Innovation Center Incubator program (support program for innovative technological startups). [14] [16] [17] In June 2014, ORM Designer version 3 was released and rebranded under the name of Skipper [6]

See also

Related Research Articles

Jakarta XML Binding is a software framework that allows Java EE developers to map Java classes to XML representations. JAXB provides two main features: the ability to marshal Java objects into XML and the inverse, i.e. to unmarshal XML back into Java objects. In other words, JAXB allows storing and retrieving data in memory in any XML format, without the need to implement a specific set of XML loading and saving routines for the program's class structure. It is similar to xsd.exe and XmlSerializer in the .NET Framework.

<span class="mw-page-title-main">Object–role modeling</span> Programming technique

Object–role modeling (ORM) is used to model the semantics of a universe of discourse. ORM is often used for data modeling and software engineering.

Hibernate ORM is an object–relational mapping tool for the Java programming language. It provides a framework for mapping an object-oriented domain model to a relational database. Hibernate handles object–relational impedance mismatch problems by replacing direct, persistent database accesses with high-level object handling functions.

A web framework (WF) or web application framework (WAF) is a software framework that is designed to support the development of web applications including web services, web resources, and web APIs. Web frameworks provide a standard way to build and deploy web applications on the World Wide Web. Web frameworks aim to automate the overhead associated with common activities performed in web development. For example, many web frameworks provide libraries for database access, templating frameworks, and session management, and they often promote code reuse. Although they often target development of dynamic web sites, they are also applicable to static websites.

<span class="mw-page-title-main">Symfony</span> PHP web application framework for MVC applications

Symfony is a free and open-source PHP web application framework and a set of reusable PHP component libraries. It was published as free software on October 18, 2005, and released under the MIT License.

<span class="mw-page-title-main">CakePHP</span> Open-source web framework in PHP

CakePHP is an open-source web framework. It follows the model–view–controller (MVC) approach and is written in PHP, modeled after the concepts of Ruby on Rails, and distributed under the MIT License.

Jakarta PersistenceAPI is a Jakarta EE application programming interface specification that describes the management of relational data in enterprise Java applications.

Entity Framework (EF) is an open source object–relational mapping (ORM) framework for ADO.NET. It was originally shipped as an integral part of .NET Framework, however starting with Entity Framework version 6.0 it has been delivered separately from the .NET Framework.

Propel is a free, open-source (MIT) object–relational mapping toolkit written in PHP. It is also an integral part of the PHP framework Symfony and was the default ORM up to, and including version 1.2.

Language Integrated Query is a Microsoft .NET Framework component that adds native data querying capabilities to .NET languages, originally released as a major part of .NET Framework 3.5 in 2007.

The following tables compare general and technical information for a number of available database administration tools. Please see individual product articles for further information. This article is neither all-inclusive nor necessarily up to date.

The Doctrine Project is a set of PHP libraries primarily focused on providing persistence services and related functionality. Its most commonly known projects are the object–relational mapper (ORM) and the database abstraction layer it is built on top of.

JBoss Developer Studio (JBDS) is a development environment created and currently developed by JBoss and Exadel.

Quick Objects is an object–relational mapping tool for Microsoft .NET Framework, a built in framework for business logic and validation. The architecture for Quick Objects is different from other ORM tools. Focus of Quick Objects to provide the advantages of code reuse, code generation and object relational mapping in a single tool set.

RedBeanPHP is an independent, free, BSD licensed, open-source object–relational mapping (ORM) software written by Gabor de Mooij. It is a stand-alone library, not part of any framework. RedBeanPHP is an on-the-fly object relational mapper, this means there is no upfront configuration. The system relies on conventions entirely and adapts the database schema to fit the needs of the program. This way, it strikes a balance between NoSQL and traditional RDBMS solutions.

<span class="mw-page-title-main">Software Ideas Modeler</span>

Software Ideas Modeler is a CASE and an UML tool. The modeler supports all 14 diagram types specified in UML 2.5. It also supports among others the following diagrams and standards:

Stylus Studio is an integrated development environment (IDE) for the Extensible Markup Language (XML). It consists of a variety of tools and visual designers to edit and transform XML documents and legacy data such as electronic data interchange (EDI), comma-separated values (CSV) and relational data.

<span class="mw-page-title-main">Business Intelligence Markup Language</span>

Business Intelligence Markup Language (BIML) is a domain-specific XML dialect for defining business intelligence (BI) assets. Biml authored BI assets can currently be used by the BIDS Helper add-on for Microsoft SQL Server Business Intelligence Development Studio (BIDS) and the Varigence Mist integrated development environment; both tools translate Biml metadata into SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) assets for the Microsoft SQL Server platform. However, emitters can be created to compile Biml for any desired BI platform.

Oracle TopLink is a mapping and persistence framework for Java developers. TopLink is produced by Oracle and is a part of Oracle's OracleAS, WebLogic, and OC4J servers. It is an object-persistence and object-transformation framework. TopLink provides development tools and run-time functionalities that ease the development process and help increase functionality. Persistent object-oriented data is stored in relational databases which helps build high-performance applications. Storing data in either XML or relational databases is made possible by transforming it from object-oriented data.

References

  1. ↑ Supported platforms Archived 2014-05-30 at the Wayback Machine
  2. 1 2 3 4 5 6 7 "ORM Designer". Archived from the original on 2014-02-22. Retrieved 2014-07-15.
  3. 1 2 3 4 5 "ORM Designer". 12 May 2010.
  4. 1 2 3 4 5 "PHP5 Magazine: ORM Designer Reviewed". php5.phpmagazine.net. Archived from the original on 16 September 2010. Retrieved 6 June 2022.
  5. ↑ "Symfony2 cheat sheet". www.symfony2cheatsheet.com. Archived from the original on 2014-07-03.
  6. 1 2 "Press Release: Skipper Skipper - the ORM Designer Blog".
  7. ↑ "Extending ORM Attributes | ORM Designer". Archived from the original on 2014-06-10. Retrieved 2014-07-15.
  8. ↑ "Extending script files | ORM Designer". Archived from the original on 2014-02-23. Retrieved 2014-07-15.
  9. ↑ "MySQL Workbench | ORM Designer". Archived from the original on 2014-04-19. Retrieved 2014-07-15.
  10. ↑ "ORM Designer – Quick Review « Stacktrace('dev-KRTCS.net')". Archived from the original on 2014-02-21. Retrieved 2014-07-15.
  11. 1 2 "Magic behind ORM Designer | ORM Designer Blog". Archived from the original on 2014-04-26. Retrieved 2014-07-15.
  12. ↑ "Supported Platforms | ORM Designer". Archived from the original on 2014-05-30. Retrieved 2014-07-15.
  13. ↑ "New tool – ORM Designer | ORM Designer Blog". Archived from the original on 2014-02-23. Retrieved 2014-07-15.
  14. 1 2 goaleurope.com/ORM-Designer-raises-funding-from-angel-investor
  15. ↑ "Mladí programátoři z Brna zdražili svůj software trojnásobně. Prodeje zůstaly stejné". 10 July 2013.
  16. ↑ "Do JIC Innovation parku se hlásí 41 firem, nejlepší vyberou Rostock, Všianský a Berdár". 12 March 2013.
  17. ↑ "Companies in the Innovation Park". Archived from the original on 2014-02-25. Retrieved 2014-07-15.
This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.