glossary.rst.txt 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440
  1. .. _glossary:
  2. Glossary
  3. ========
  4. From Wikipedia, the free encyclopedia
  5. .. glossary::
  6. .htaccess
  7. the default name of Apache's directory-level configuration file.
  8. .. seealso:: <https://en.wikipedia.org/wiki/.htaccess>
  9. ACL
  10. Access Control List
  11. Blowfish
  12. a keyed, symmetric block cipher, designed in 1993 by `Bruce Schneier <https://en.wikipedia.org/wiki/Bruce_Schneier>`_.
  13. .. seealso:: <https://en.wikipedia.org/wiki/Blowfish_(cipher)>
  14. Browser
  15. a software application that enables a user to display and interact with text, images, and other information typically located on a web page at a website on the World Wide Web.
  16. .. seealso:: <https://en.wikipedia.org/wiki/Web_browser>
  17. bzip2
  18. a free software/open-source data compression algorithm and program developed by Julian Seward.
  19. .. seealso:: <https://en.wikipedia.org/wiki/Bzip2>
  20. CGI
  21. Common Gateway Interface is an important World Wide Web technology that
  22. enables a client web browser to request data from a program executed on
  23. the web server.
  24. .. seealso:: <https://en.wikipedia.org/wiki/Common_Gateway_Interface>
  25. Changelog
  26. a log or record of changes made to a project.
  27. .. seealso:: <https://en.wikipedia.org/wiki/Changelog>
  28. Client
  29. a computer system that accesses a (remote) service on another computer by some kind of network.
  30. .. seealso:: <https://en.wikipedia.org/wiki/Client_(computing)>
  31. column
  32. a set of data values of a particularly simple type, one for each row of the table.
  33. .. seealso:: <https://en.wikipedia.org/wiki/Column_(database)>
  34. Cookie
  35. a packet of information sent by a server to a World Wide Web browser and then sent back by the browser each time it accesses that server.
  36. .. seealso:: <https://en.wikipedia.org/wiki/HTTP_cookie>
  37. CSV
  38. Comma-separated values
  39. .. seealso:: <https://en.wikipedia.org/wiki/Comma-separated_values>
  40. DB
  41. look at :term:`Database`
  42. Database
  43. an organized collection of data.
  44. .. seealso:: <https://en.wikipedia.org/wiki/Database>
  45. Engine
  46. look at :term:`Storage Engines`
  47. PHP extension
  48. a PHP module that extends PHP with additional functionality.
  49. .. seealso:: <https://en.wikipedia.org/wiki/Software_extension>
  50. FAQ
  51. Frequently Asked Questions is a list of commonly asked question and their
  52. answers.
  53. .. seealso:: <https://en.wikipedia.org/wiki/FAQ>
  54. Field
  55. one part of divided data/columns.
  56. .. seealso:: <https://en.wikipedia.org/wiki/Field_(computer_science)>
  57. Foreign key
  58. a column or group of columns in a database row that points to a key column
  59. or group of columns forming a key of another database row in some
  60. (usually different) table.
  61. .. seealso:: <https://en.wikipedia.org/wiki/Foreign_key>
  62. GD
  63. Graphics Library by Thomas Boutell and others for dynamically manipulating images.
  64. .. seealso:: <https://en.wikipedia.org/wiki/GD_Graphics_Library>
  65. GD2
  66. look at :term:`GD`
  67. GZip
  68. GZip is short for GNU zip, a GNU free software file compression program.
  69. .. seealso:: <https://en.wikipedia.org/wiki/Gzip>
  70. host
  71. any machine connected to a computer network, a node that has a hostname.
  72. .. seealso:: <https://en.wikipedia.org/wiki/Host_(network)>
  73. hostname
  74. the unique name by which a network-attached device is known on a network.
  75. .. seealso:: <https://en.wikipedia.org/wiki/Hostname>
  76. HTTP
  77. Hypertext Transfer Protocol is the primary method used to transfer or
  78. convey information on the World Wide Web.
  79. .. seealso:: <https://en.wikipedia.org/wiki/HyperText_Transfer_Protocol>
  80. HTTPS
  81. a :term:`HTTP`-connection with additional security measures.
  82. .. seealso:: <https://en.wikipedia.org/wiki/HTTPS>
  83. IEC
  84. International Electrotechnical Commission
  85. IIS
  86. Internet Information Services is a set of internet-based services for
  87. servers using Microsoft Windows.
  88. .. seealso:: <https://en.wikipedia.org/wiki/Internet_Information_Services>
  89. Index
  90. a feature that allows quick access to the rows in a table.
  91. .. seealso:: <https://en.wikipedia.org/wiki/Database_index>
  92. IP
  93. "Internet Protocol" is a data-oriented protocol used by source and
  94. destination hosts for communicating data across a packet-switched
  95. internetwork.
  96. .. seealso:: <https://en.wikipedia.org/wiki/Internet_Protocol>
  97. IP Address
  98. a unique number that devices use in order to identify and communicate with each other on a network utilizing the Internet Protocol standard.
  99. .. seealso:: <https://en.wikipedia.org/wiki/IP_Address>
  100. IPv6
  101. IPv6 (Internet Protocol version 6) is the latest revision of the
  102. Internet Protocol (:term:`IP`), designed to deal with the
  103. long-anticipated problem of its predecessor IPv4 running out of addresses.
  104. .. seealso:: <https://en.wikipedia.org/wiki/IPv6>
  105. ISAPI
  106. Internet Server Application Programming Interface is the API of Internet Information Services (IIS).
  107. .. seealso:: <https://en.wikipedia.org/wiki/Internet_Server_Application_Programming_Interface>
  108. ISP
  109. An Internet service provider is a business or organization that offers users
  110. access to the Internet and related services.
  111. .. seealso:: <https://en.wikipedia.org/wiki/Internet_service_provider>
  112. ISO
  113. International Standards Organization
  114. .. seealso:: `ISO organization website <https://www.iso.org/about-us.html>`_
  115. .. seealso:: <https://en.wikipedia.org/wiki/International_Organization_for_Standardization>
  116. JPEG
  117. a most commonly used standard method of lossy compression for photographic images.
  118. .. seealso:: <https://en.wikipedia.org/wiki/JPEG>
  119. JPG
  120. look at :term:`JPEG`
  121. Key
  122. look at :term:`Index`
  123. LATEX
  124. a document preparation system for the TeX typesetting program.
  125. .. seealso:: <https://en.wikipedia.org/wiki/LaTeX>
  126. Mac
  127. Apple Macintosh is a line of personal computers designed, developed, manufactured, and marketed by Apple Inc.
  128. .. seealso:: <https://en.wikipedia.org/wiki/Macintosh>
  129. macOS
  130. the operating system which is included with all currently shipping Apple Macintosh computers in the consumer and professional markets.
  131. .. seealso:: <https://en.wikipedia.org/wiki/MacOS>
  132. mbstring
  133. The PHP `mbstring` functions provide support for languages represented by multi-byte character sets, most notably UTF-8.
  134. If you have troubles installing this extension, please follow :ref:`faqmysql`, it provides useful hints.
  135. .. seealso:: <https://www.php.net/manual/en/book.mbstring.php>
  136. Media type
  137. A media type (formerly known as MIME type) is a two-part identifier
  138. for file formats and format contents transmitted on the Internet.
  139. .. seealso:: <https://en.wikipedia.org/wiki/Media_type>
  140. MIME
  141. Multipurpose Internet Mail Extensions is
  142. an Internet Standard for the format of e-mail.
  143. .. seealso:: <https://en.wikipedia.org/wiki/MIME>
  144. module
  145. modular extension for the Apache HTTP Server httpd.
  146. .. seealso:: <https://en.wikipedia.org/wiki/Apache_HTTP_Server>
  147. mod_proxy_fcgi
  148. an Apache module implementing a Fast CGI interface; PHP can be run as a CGI module, FastCGI, or
  149. directly as an Apache module.
  150. .. seealso:: <https://en.wikipedia.org/wiki/Mod_proxy>
  151. MySQL
  152. a multithreaded, multi-user, SQL (Structured Query Language) Database Management System (DBMS).
  153. .. seealso:: <https://en.wikipedia.org/wiki/MySQL>
  154. MySQLi
  155. the improved MySQL client PHP extension.
  156. .. seealso:: `PHP manual for MySQL Improved Extension <https://www.php.net/manual/en/book.mysqli.php>`_
  157. .. seealso:: <https://en.wikipedia.org/wiki/MySQLi>
  158. mysql
  159. the MySQL client PHP extension.
  160. .. seealso:: <https://www.php.net/manual/en/book.mysql.php>
  161. OpenDocument
  162. an open standard for office documents.
  163. .. seealso:: <https://en.wikipedia.org/wiki/OpenDocument>
  164. OS X
  165. look at :term:`macOS`.
  166. .. seealso:: <https://en.wikipedia.org/wiki/MacOS>
  167. PDF
  168. Portable Document Format is a file format developed by Adobe Systems for
  169. representing two-dimensional documents in a device-independent and
  170. resolution-independent format.
  171. .. seealso:: <https://en.wikipedia.org/wiki/PDF>
  172. PEAR
  173. the PHP Extension and Application Repository.
  174. .. seealso:: `PEAR website <https://pear.php.net/>`_
  175. .. seealso:: `Wikipedia page for PEAR <https://en.wikipedia.org/wiki/PEAR>`_
  176. PCRE
  177. Perl-Compatible Regular Expressions is the Perl-compatible regular
  178. expression functions for PHP
  179. .. seealso:: <https://www.php.net/pcre>
  180. .. seealso:: `PHP manual for Perl-Compatible Regular Expressions <https://www.php.net/pcre>`_
  181. .. seealso:: <https://en.wikipedia.org/wiki/Perl_Compatible_Regular_Expressions>
  182. PHP
  183. short for "PHP: Hypertext Preprocessor", is an open-source, reflective
  184. programming language used mainly for developing server-side applications
  185. and dynamic web content, and more recently, a broader range of software
  186. applications.
  187. .. seealso:: <https://en.wikipedia.org/wiki/PHP>
  188. port
  189. a connection through which data is sent and received.
  190. .. seealso:: <https://en.wikipedia.org/wiki/Port_(computer_networking)>
  191. primary key
  192. A primary key is an index over one or more fields in a table with
  193. unique values for every single row in this table. Every table should have
  194. a primary key for easier accessing/identifying data in this table. There
  195. can only be one primary key per table and it is named always **PRIMARY**.
  196. In fact, a primary key is just an :term:`unique key` with the name
  197. **PRIMARY**. If no primary key is defined MySQL will use first *unique
  198. key* as primary key if there is one.
  199. You can create the primary key when creating the table (in phpMyAdmin
  200. just check the primary key radio buttons for each field you wish to be
  201. part of the primary key).
  202. You can also add a primary key to an existing table with `ALTER` `TABLE`
  203. or `CREATE` `INDEX` (in phpMyAdmin you can just click on 'add index' on
  204. the table structure page below the listed fields).
  205. RFC
  206. Request for Comments (RFC) documents are a series of memoranda
  207. encompassing new research, innovations, and methodologies applicable to
  208. Internet technologies.
  209. .. seealso:: <https://en.wikipedia.org/wiki/Request_for_Comments>
  210. RFC 1952
  211. GZIP file format specification version 4.3
  212. .. seealso:: :rfc:`1952`
  213. Row (record, tuple)
  214. represents a single, implicitly structured data item in a table.
  215. .. seealso:: <https://en.wikipedia.org/wiki/Row_(database)>
  216. Server
  217. a computer system that provides services to other computing systems over a network.
  218. .. seealso:: <https://en.wikipedia.org/wiki/Server_(computing)>
  219. Storage Engines
  220. MySQL can use several different formats for storing data on disk, these
  221. are called storage engines or table types. phpMyAdmin allows a user to
  222. change their storage engine for a particular table through the operations
  223. tab.
  224. Common table types are InnoDB and MyISAM, though many others exist and
  225. may be desirable in some situations.
  226. .. seealso:: `MySQL doc chapter about Alternative Storage Engines <https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html>`_
  227. .. seealso:: <https://en.wikipedia.org/wiki/Database_engine>
  228. socket
  229. a form of inter-process communication.
  230. .. seealso:: <https://en.wikipedia.org/wiki/Unix_domain_socket>
  231. SSL
  232. Secure Sockets Layer, (now superseded by TLS) is a cryptographic protocol
  233. which provides secure communication on the Internet.
  234. .. seealso:: <https://en.wikipedia.org/wiki/Transport_Layer_Security>
  235. Stored procedure
  236. a subroutine available to applications accessing a relational database system
  237. .. seealso:: <https://en.wikipedia.org/wiki/Stored_procedure>
  238. SQL
  239. Structured Query Language
  240. .. seealso:: <https://en.wikipedia.org/wiki/SQL>
  241. table
  242. a set of data elements (cells) that is organized, defined and stored as
  243. horizontal rows and vertical columns where each item can be uniquely
  244. identified by a label or key or by its position in relation to other
  245. items.
  246. .. seealso:: <https://en.wikipedia.org/wiki/Table_(database)>
  247. tar
  248. a type of archive file format, from "Tape Archive".
  249. .. seealso:: <https://en.wikipedia.org/wiki/Tar_(computing)>
  250. TCP
  251. Transmission Control Protocol is one of the core protocols of the
  252. Internet protocol suite.
  253. .. seealso:: <https://en.wikipedia.org/wiki/Internet_protocol_suite>
  254. TCPDF
  255. PHP library to generate PDF files.
  256. .. seealso:: <https://tcpdf.org/>
  257. .. seealso:: <https://en.wikipedia.org/wiki/TCPDF>
  258. trigger
  259. a procedural code that is automatically executed in response to certain events on a particular table or view in a database
  260. .. seealso:: <https://en.wikipedia.org/wiki/Database_trigger>
  261. unique key
  262. A unique key is an index over one or more fields in a table which has a
  263. unique value for each row. The first unique key will be treated as
  264. :term:`primary key` if there is no *primary key* defined.
  265. URL
  266. Uniform Resource Locator is a sequence of characters, conforming to a
  267. standardized format, that is used for referring to resources, such as
  268. documents and images on the Internet, by their location.
  269. .. seealso:: <https://en.wikipedia.org/wiki/URL>
  270. Web server
  271. A computer (program) that is responsible for accepting HTTP requests from clients and serving them web pages.
  272. .. seealso:: <https://en.wikipedia.org/wiki/Web_server>
  273. XML
  274. Extensible Markup Language is a W3C-recommended general-purpose markup
  275. language for creating special-purpose markup languages, capable of
  276. describing many different kinds of data.
  277. .. seealso:: <https://en.wikipedia.org/wiki/XML>
  278. ZIP
  279. a popular data compression and archival format.
  280. .. seealso:: <https://en.wikipedia.org/wiki/Zip_(file_format)>
  281. Zlib
  282. an open-source, cross-platform data compression library by `Jean-loup Gailly <https://en.wikipedia.org/wiki/Jean-Loup_Gailly>`_ and `Mark Adler <https://en.wikipedia.org/wiki/Mark_Adler>`_.
  283. .. seealso:: <https://en.wikipedia.org/wiki/Zlib>
  284. Content Security Policy
  285. The HTTP `Content-Security-Policy` response header allows web site administrators
  286. to control resources the user agent is allowed to load for a given page.
  287. .. seealso:: <https://en.wikipedia.org/wiki/Content_Security_Policy>
  288. .. seealso:: <https://developer.mozilla.org/en/docs/Web/HTTP/CSP>