› Foros › PC › Software libre
FuckingFreaky escribió:Buenas...
El caso es que en la universidad he dado SQL y ORACLE - PL/SQL... y ya ando yo con mi preocupación de siempre...
1. ¿Cuál es el estándar de SQL? Es PL/SQL un estándar ó tan sólo SQL?
Por lo que tengo entendido Oracle está muy extendido en la empresa, y también me pregunto...
2. ¿qué otras bases de datos son importantes? Porque por lo que tengo entendido MySQL para cosas muy muy grandes tampoco es muy apta, y sobre PostgreSQL, pos ni idea.
3. ¿Son MySQL y PostgreSQL libres de alguna forma? Lo digo porque son las que más extendidas veo en este mundillo... Utilizan SQL totalmente estándar ó también tienen sus cosillas?
4. ¿Un buen libro para afianzar SQL que se fije en lo estándar?
Gracias!!!
Saludos!
http://www.devx.com/ escribió:Cox Communications uses MySQL to manage information related to its cable modem business. NASA uses MySQL to store information about public contracts. Slashdot, a widely read online publication, uses MySQL to store all of the information related to its site. The Associated Press uses MySQL to serve various types of information, including access to the U.S. Census and Olympic results.
MySQL AB, the company that owns and produces MySQL, has two licenses available for its database product:
1. GNU General Public License (GPL) for GPL projects. If your project is 100 percent GPL in its distribution, you can use this license. To fully comply, you must distribute your application, along with the source code. You also can use this license if you don't intend to ever distribute your project internally or externally.
2. Commercial License for commercial applications. An example of the use for this license is when you don't want to distribute the source code for your application. This includes database drivers as well. You can't use the MySQL database drivers with a commercial application unless it's either distributed under the GPL license or you have a Commercial License.
PostgreSQL has a much simpler licensing scheme. It is released under the Berkley License, which allows for any use as long as a copy of the Berkley License is included with it. This means that you can release a commercial product that uses PostgreSQL or is a derivative of PostgreSQL without including source code.
$cat /usr/portage/licenses/POSTGRESQL
PostgreSQL Database Management System
(formerly known as Postgres, then as Postgres95)
Portions Copyright (c) 1996-2001, The PostgreSQL Global Development Group
Portions Copyright (c) 1994, The Regents of the University of California
Permission to use, copy, modify, and distribute this software and its
documentation for any purpose, without fee, and without a written agreement
is hereby granted, provided that the above copyright notice and this
paragraph and the following two paragraphs appear in all copies.
IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR
DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING
LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS
DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGE.
THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES,
INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY
AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS
ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO
PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
SQL - Structured Query Language
Esto me pasa por pasar de las introducciones y hacer mis fantásticas deducciones .SQL - Structured Query Language