Professional paper

Using SQL in the open source programmes

Ladislav Havaš orcid.org/0000-0002-5051-4486 ; Veleučilište u Varaždinu, Varaždin, Hrvatska
Matija Lesar orcid.org/0000-0001-6711-9282 ; Veleučilište u Varaždinu, Varaždin, Hrvatska

Abstract

The term “open source” refers to the source code available to the general public for use, which means that anyone can use it and modify it for personal or business purposes. There are several different open source licenses that should cover all users, but one can also easily write your own license and give it to the confirmation. What also should be mentioned is the Open Source Initiative (OSI), a non-profit corporation, dedicated to managing and promoting the Open Source Definition criteria, that is, license conditions for the benefit of the community. Nowadays more and more people and companies are turning to the open source.
Some of the most widely known open source projects are PHP (Hypertext Processor), Apache and MySQL, which were used in this project. PHP is a server-side scripting language for dynamic generation of HTML (HyperText Markup Language) code. Currently, it is one of the most used and most widespread server-side scripting languages used to create web applications. In running PHP, the Apache web server is mostly used, which stands as a web hosting provider. Apache has greatly contributed to the initial spread of the World Wide Web, and in 2009 it became the first web server to surpass the 100 million website milestone. MySQL is the world’s most used open source relation database. It is used widely, and is also a database that is most frequently used with PHP. MySQL is most commonly used in the combination known as LAMP (Linux, Apache, MySQL,PHP).

Keywords

open source; PHP; Apache; MySQL; Linux

Hrčak ID:

94801

URI

https://hrcak.srce.hr/94801

Publication date:

15.12.2012.

Article data in other languages: croatian

Visits: 3.509 *