SQLite - Historial de revisiones

Rosarino en 05:41 5 may 2021

2021-05-05T05:41:06Z

Javiermartin jc: Revertidos los cambios de Carlos idict (disc.) a la última edición de Gllopez

2013-01-10T23:02:53Z

Revertidos los cambios de Carlos idict (disc.) a la última edición de Gllopez

Carlos idict en 22:01 10 ene 2013

2013-01-10T22:01:00Z

Gllopez: /* C */

2011-04-27T18:50:22Z

‎C

Gllopez: /* TCL */

2011-04-27T18:48:47Z

‎TCL

Gllopez: /* C */

2011-04-27T18:42:35Z

‎C

Gllopez: /* TCL */

2011-04-27T18:40:59Z

‎TCL

Maarus en 00:18 22 abr 2011

2011-04-22T00:18:16Z

Mostrar los cambios

Gllopez en 13:53 14 abr 2011

2011-04-14T13:53:14Z

Gllopez en 12:35 14 abr 2011

2011-04-14T12:35:37Z

@@ Línea 23: / Línea 23: @@
 }}
-'''SQLite''' es una biblioteca escrita en leguaje [[C]] que implementa un [[Sistema de gestión de bases de datos]] transaccionales [[SQL]] auto-contenido, sin servidor y sin configuración. El código de SQLite es de dominio público y libre para cualquier uso, ya sea comercial o privado. Actualmente es utilizado en gran cantidad de aplicaciones incluyendo algunas desarrolladas como proyectos de alto nivel.
+'''SQLite''' es una biblioteca escrita en [[lenguaje C]] que implementa un [[sistema de gestión de bases de datos]] transaccionales [[SQL]] auto-contenido, sin servidor y sin configuración. El código de SQLite es de dominio público y libre para cualquier uso, ya sea comercial o privado. Actualmente es utilizado en gran cantidad de aplicaciones incluyendo algunas desarrolladas como proyectos de alto nivel.
 == Historia  ==
@@ Línea 192: / Línea 192: @@
 *[http://www.sqlite.org/quickstart.html SQLite In Five Minutes Or Less]
-[[Category:Sistemas_de_gestión_de_bases_de_datos]][[Category:Software_Libre]]
+[[Categoría: Software libre]]

@@ Línea 96: / Línea 96: @@
 == Usos no aconsejados de SQLite  ==
-*Aplicaciones Cliente-servidor.
+*Aplicaciones [[Cliente-servidor]].
 *Sitios web con gran cantidad de transacciones.
 *Bases de datos muy grandes (SQLite soporta hasta 2 terabytes).

@@ Línea 96: / Línea 96: @@
 == Usos no aconsejados de SQLite  ==
-*Aplicaciones [[Cliente-servidor]].
+*Aplicaciones Cliente-servidor.
 *Sitios web con gran cantidad de transacciones.
 *Bases de datos muy grandes (SQLite soporta hasta 2 terabytes).

@@ Línea 136: / Línea 136: @@
 static int callback(void *NotUsed, int argc, char **argv, char **azColName){
-int i;
+	int i;
-for(i=0; i<argc; i++){
+	for(i=0; i<argc; i++){
-printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
+		printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
-−
+	}
-printf("\n");
+	printf("\n");
-return 0;
+	return 0;
+}
 int main(int argc, char **argv){
-sqlite3 *db;
+	sqlite3 *db;
-char *zErrMsg = 0;
+	char *zErrMsg = 0;
-int rc;
+	int rc;
-if( argc!=3 ){
+	if( argc!=3 ){
-fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
+		fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
-exit(1);
+		exit(1);
-−
+	}
-rc = sqlite3_open(argv[1], &db);
+	rc = sqlite3_open(argv[1], &db);
-if( rc ){
+	if( rc ){
-fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
+		fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
-sqlite3_close(db);
+		sqlite3_close(db);
-exit(1);
+		exit(1);
-−
+	}
-rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);
+	rc = sqlite3_exec(db, argv[2], callback, 0, &zErrMsg);
-if( rc!=SQLITE_OK ){
+	if( rc!=SQLITE_OK ){
-fprintf(stderr, "SQL error: %s\n", zErrMsg);
+		fprintf(stderr, "SQL error: %s\n", zErrMsg);
-sqlite3_free(zErrMsg);
+		sqlite3_free(zErrMsg);
-−
+	}
-sqlite3_close(db);
+	sqlite3_close(db);
-return 0;
+	return 0;
+}
 </syntaxhighlight>

@@ Línea 116: / Línea 116: @@
 #!/usr/bin/tclsh
 if {$argc!=2} {
-puts stderr "Usage: %s DATABASE SQL-STATEMENT"
+    puts stderr "Usage: %s DATABASE SQL-STATEMENT"
-exit 1
+    exit 1
+}
 load /usr/lib/tclsqlite3.so Sqlite3
 sqlite3 db [lindex $argv 0]
 db eval [lindex $argv 1] x {
-foreach v $x(*) {
+    foreach v $x(*) {
-puts "$v = $x($v)"
+        puts "$v = $x($v)"
-−
+    }
-puts ""
+    puts ""
+}
 db close

@@ Línea 131: / Línea 131: @@
 === C  ===
-<div style="text-align: left;" class="mw-geshi" dir="ltr"><div class="cpp source-cpp"><pre class="de1"><span class="co2">#include &lt;stdio.h&gt;</span> <span class="co2">#include &lt;sqlite3.h&gt;</span> &nbsp; <span class="kw4">static</span> <span class="kw4">int</span> callback<span class="br0">(</span><span class="kw4">void</span> <span class="sy2">*</span>NotUsed, <span class="kw4">int</span> argc, <span class="kw4">char</span> <span class="sy2">**</span>argv, <span class="kw4">char</span> <span class="sy2">**</span>azColName<span class="br0">)</span><span class="br0">{</span> <span class="kw4">int</span> i<span class="sy4">;</span> <span class="kw1">for</span><span class="br0">(</span>i<span class="sy1">=</span><span class="nu0">0</span><span class="sy4">;</span> i<span class="sy1">&lt;</span>argc<span class="sy4">;</span> i<span class="sy2">++</span><span class="br0">)</span><span class="br0">{</span> <span class="kw3">printf</span><span class="br0">(</span><span class="st0">"%s =&nbsp;%s<span class="es1">\n</span>"</span>, azColName<span class="br0">[</span>i<span class="br0">]</span>, argv<span class="br0">[</span>i<span class="br0">]</span> <span class="sy4">?</span> argv<span class="br0">[</span>i<span class="br0">]</span> <span class="sy4">:</span> <span class="st0">"NULL"</span><span class="br0">)</span><span class="sy4">;</span> <span class="br0">}</span> <span class="kw3">printf</span><span class="br0">(</span><span class="st0">"<span class="es1">\n</span>"</span><span class="br0">)</span><span class="sy4">;</span> <span class="kw1">return</span> <span class="nu0">0</span><span class="sy4">;</span> <span class="br0">}</span> &nbsp; <span class="kw4">int</span> main<span class="br0">(</span><span class="kw4">int</span> argc, <span class="kw4">char</span> <span class="sy2">**</span>argv<span class="br0">)</span><span class="br0">{</span> sqlite3 <span class="sy2">*</span>db<span class="sy4">;</span> <span class="kw4">char</span> <span class="sy2">*</span>zErrMsg <span class="sy1">=</span> <span class="nu0">0</span><span class="sy4">;</span> <span class="kw4">int</span> rc<span class="sy4">;</span> &nbsp; <span class="kw1">if</span><span class="br0">(</span> argc<span class="sy3">!</span><span class="sy1">=</span><span class="nu0">3</span> <span class="br0">)</span><span class="br0">{</span> <span class="kw3">fprintf</span><span class="br0">(</span><span class="kw2">stderr</span>, <span class="st0">"Usage:&nbsp;%s DATABASE SQL-STATEMENT<span class="es1">\n</span>"</span>, argv<span class="br0">[</span><span class="nu0">0</span><span class="br0">]</span><span class="br0">)</span><span class="sy4">;</span> <span class="kw3">exit</span><span class="br0">(</span><span class="nu0">1</span><span class="br0">)</span><span class="sy4">;</span> <span class="br0">}</span> rc <span class="sy1">=</span> sqlite3_open<span class="br0">(</span>argv<span class="br0">[</span><span class="nu0">1</span><span class="br0">]</span>, <span class="sy3">&amp;</span>db<span class="br0">)</span><span class="sy4">;</span> <span class="kw1">if</span><span class="br0">(</span> rc <span class="br0">)</span><span class="br0">{</span> <span class="kw3">fprintf</span><span class="br0">(</span><span class="kw2">stderr</span>, <span class="st0">"Can't open database:&nbsp;%s<span class="es1">\n</span>"</span>, sqlite3_errmsg<span class="br0">(</span>db<span class="br0">)</span><span class="br0">)</span><span class="sy4">;</span> sqlite3_close<span class="br0">(</span>db<span class="br0">)</span><span class="sy4">;</span> <span class="kw3">exit</span><span class="br0">(</span><span class="nu0">1</span><span class="br0">)</span><span class="sy4">;</span> <span class="br0">}</span> rc <span class="sy1">=</span> sqlite3_exec<span class="br0">(</span>db, argv<span class="br0">[</span><span class="nu0">2</span><span class="br0">]</span>, callback, <span class="nu0">0</span>, <span class="sy3">&amp;</span>zErrMsg<span class="br0">)</span><span class="sy4">;</span> <span class="kw1">if</span><span class="br0">(</span> rc<span class="sy3">!</span><span class="sy1">=</span>SQLITE_OK <span class="br0">)</span><span class="br0">{</span> <span class="kw3">fprintf</span><span class="br0">(</span><span class="kw2">stderr</span>, <span class="st0">"SQL error:&nbsp;%s<span class="es1">\n</span>"</span>, zErrMsg<span class="br0">)</span><span class="sy4">;</span> sqlite3_free<span class="br0">(</span>zErrMsg<span class="br0">)</span><span class="sy4">;</span> <span class="br0">}</span> sqlite3_close<span class="br0">(</span>db<span class="br0">)</span><span class="sy4">;</span> <span class="kw1">return</span> <span class="nu0">0</span><span class="sy4">;</span> <span class="br0">}</span></pre></div></div>
+<syntaxhighlight lang='c'>
 == Aplicaciones para el trabajo con bases de datos SQLite  ==

@@ Línea 113: / Línea 113: @@
 === TCL  ===
-<div style="text-align: left;" class="mw-geshi" dir="ltr"><div class="bash source-bash"><pre class="de1"><span class="co0">#!/usr/bin/tclsh</span> <span class="kw1">if</span> <span class="br0">{</span><span class="re1">$argc</span><span class="sy0">!</span>=<span class="nu0">2</span><span class="br0">}</span> <span class="br0">{</span> puts stderr <span class="st0">"Usage:&nbsp;%s DATABASE SQL-STATEMENT"</span> <span class="kw3">exit</span> <span class="nu0">1</span> <span class="br0">}</span> load <span class="sy0">/</span>usr<span class="sy0">/</span>lib<span class="sy0">/</span>tclsqlite3.so Sqlite3 sqlite3 db <span class="br0">[</span>lindex <span class="re1">$argv</span> <span class="nu0">0</span><span class="br0">]</span> db <span class="kw3">eval</span> <span class="br0">[</span>lindex <span class="re1">$argv</span> <span class="nu0">1</span><span class="br0">]</span> x <span class="br0">{</span> foreach v <span class="re1">$x</span><span class="br0">(</span><span class="sy0">*</span><span class="br0">)</span> <span class="br0">{</span> puts <span class="st0">"<span class="es2">$v</span> = <span class="es2">$x</span>(<span class="es2">$v</span>)"</span> <span class="br0">}</span> puts <span class="st0">""</span> <span class="br0">}</span> db close</pre></div></div>
+<syntaxhighlight lang='bash'>
 === C  ===
 <div style="text-align: left;" class="mw-geshi" dir="ltr"><div class="cpp source-cpp"><pre class="de1"><span class="co2">#include &lt;stdio.h&gt;</span> <span class="co2">#include &lt;sqlite3.h&gt;</span> &nbsp; <span class="kw4">static</span> <span class="kw4">int</span> callback<span class="br0">(</span><span class="kw4">void</span> <span class="sy2">*</span>NotUsed, <span class="kw4">int</span> argc, <span class="kw4">char</span> <span class="sy2">**</span>argv, <span class="kw4">char</span> <span class="sy2">**</span>azColName<span class="br0">)</span><span class="br0">{</span> <span class="kw4">int</span> i<span class="sy4">;</span> <span class="kw1">for</span><span class="br0">(</span>i<span class="sy1">=</span><span class="nu0">0</span><span class="sy4">;</span> i<span class="sy1">&lt;</span>argc<span class="sy4">;</span> i<span class="sy2">++</span><span class="br0">)</span><span class="br0">{</span> <span class="kw3">printf</span><span class="br0">(</span><span class="st0">"%s =&nbsp;%s<span class="es1">\n</span>"</span>, azColName<span class="br0">[</span>i<span class="br0">]</span>, argv<span class="br0">[</span>i<span class="br0">]</span> <span class="sy4">?</span> argv<span class="br0">[</span>i<span class="br0">]</span> <span class="sy4">:</span> <span class="st0">"NULL"</span><span class="br0">)</span><span class="sy4">;</span> <span class="br0">}</span> <span class="kw3">printf</span><span class="br0">(</span><span class="st0">"<span class="es1">\n</span>"</span><span class="br0">)</span><span class="sy4">;</span> <span class="kw1">return</span> <span class="nu0">0</span><span class="sy4">;</span> <span class="br0">}</span> &nbsp; <span class="kw4">int</span> main<span class="br0">(</span><span class="kw4">int</span> argc, <span class="kw4">char</span> <span class="sy2">**</span>argv<span class="br0">)</span><span class="br0">{</span> sqlite3 <span class="sy2">*</span>db<span class="sy4">;</span> <span class="kw4">char</span> <span class="sy2">*</span>zErrMsg <span class="sy1">=</span> <span class="nu0">0</span><span class="sy4">;</span> <span class="kw4">int</span> rc<span class="sy4">;</span> &nbsp; <span class="kw1">if</span><span class="br0">(</span> argc<span class="sy3">!</span><span class="sy1">=</span><span class="nu0">3</span> <span class="br0">)</span><span class="br0">{</span> <span class="kw3">fprintf</span><span class="br0">(</span><span class="kw2">stderr</span>, <span class="st0">"Usage:&nbsp;%s DATABASE SQL-STATEMENT<span class="es1">\n</span>"</span>, argv<span class="br0">[</span><span class="nu0">0</span><span class="br0">]</span><span class="br0">)</span><span class="sy4">;</span> <span class="kw3">exit</span><span class="br0">(</span><span class="nu0">1</span><span class="br0">)</span><span class="sy4">;</span> <span class="br0">}</span> rc <span class="sy1">=</span> sqlite3_open<span class="br0">(</span>argv<span class="br0">[</span><span class="nu0">1</span><span class="br0">]</span>, <span class="sy3">&amp;</span>db<span class="br0">)</span><span class="sy4">;</span> <span class="kw1">if</span><span class="br0">(</span> rc <span class="br0">)</span><span class="br0">{</span> <span class="kw3">fprintf</span><span class="br0">(</span><span class="kw2">stderr</span>, <span class="st0">"Can't open database:&nbsp;%s<span class="es1">\n</span>"</span>, sqlite3_errmsg<span class="br0">(</span>db<span class="br0">)</span><span class="br0">)</span><span class="sy4">;</span> sqlite3_close<span class="br0">(</span>db<span class="br0">)</span><span class="sy4">;</span> <span class="kw3">exit</span><span class="br0">(</span><span class="nu0">1</span><span class="br0">)</span><span class="sy4">;</span> <span class="br0">}</span> rc <span class="sy1">=</span> sqlite3_exec<span class="br0">(</span>db, argv<span class="br0">[</span><span class="nu0">2</span><span class="br0">]</span>, callback, <span class="nu0">0</span>, <span class="sy3">&amp;</span>zErrMsg<span class="br0">)</span><span class="sy4">;</span> <span class="kw1">if</span><span class="br0">(</span> rc<span class="sy3">!</span><span class="sy1">=</span>SQLITE_OK <span class="br0">)</span><span class="br0">{</span> <span class="kw3">fprintf</span><span class="br0">(</span><span class="kw2">stderr</span>, <span class="st0">"SQL error:&nbsp;%s<span class="es1">\n</span>"</span>, zErrMsg<span class="br0">)</span><span class="sy4">;</span> sqlite3_free<span class="br0">(</span>zErrMsg<span class="br0">)</span><span class="sy4">;</span> <span class="br0">}</span> sqlite3_close<span class="br0">(</span>db<span class="br0">)</span><span class="sy4">;</span> <span class="kw1">return</span> <span class="nu0">0</span><span class="sy4">;</span> <span class="br0">}</span></pre></div></div>

@@ Línea 82: / Línea 82: @@
 *Rendimiento de base de datos: SQLite realiza operaciones de manera eficiente y es más rápido que [[MySQL]] y [[PostgreSQL]].
 *Portabilidad: se ejecuta en muchas plataformas y sus bases de datos pueden ser fácilmente portadas sin ninguna configuración o administración.
-*Estabilidad: SQLite es compatible con ACID, reunión de los cuatro criterios de Atomicidad, Consistencia, Aislamiento y Durabilidad.
+*Estabilidad: SQLite es compatible con [[ACID]], reunión de los cuatro criterios de Atomicidad, Consistencia, Aislamiento y Durabilidad.
 *SQL: implementa un gran subconjunto de la ANSI – 92 SQL estándar, incluyendo sub-consultas, generación de usuarios, vistas y triggers.
-*Interfaces: cuenta con diferentes interfaces del API, las cuales permiten trabajar con C++, PHP, Perl, Python, Ruby, Tcl, groovy, etc.
+*Interfaces: cuenta con diferentes interfaces del API, las cuales permiten trabajar con [[C++]], [[PHP]], [[Perl]], [[Python]], [[Ruby]], [[Tcl]], [[groovy]], [[Qt]] ofrece el [[Plugin|plugin]] qsqlite, etc.
 *Costo: SQLite es de dominio público, y por tanto, es libre de utilizar para cualquier propósito sin costo y se puede redistribuir libremente.

@@ Línea 178: / Línea 178: @@
 == Enlaces externos ==
 *[http://www.sqlite.org/download.html Descargas desde el sitio oficial]
 *[http://www.sqlite.org/cintro.html Introducción a la interfaz C/C++]
 *[http://www.sqlite.org/tclsqlite.html La interfaz TCL para SQLite]
 *[http://www.sqlite.org/lang.html SQL entendido por SQLite]
 == Fuente ==
-[http://usuarios.pntic.mec.es/sqlite.php Usuarios SQlite]
+*[http://usuarios.pntic.mec.es/sqlite.php Usuarios SQlite]
-[http://www.sqlite.org/famous.html Well-Known Users of SQLite]
+*[http://www.sqlite.org/famous.html Well-Known Users of SQLite]
-[http://www.sqlite.org/ommited.html SQL Features That SQLite Does Not Implement]
+*[http://www.sqlite.org/ommited.html SQL Features That SQLite Does Not Implement]
-[http://www.sqlite.org/features.html SQLite Features]
+*[http://www.sqlite.org/features.html SQLite Features]
-[http://www.sqlite.org/whentouse.html Appropriate Uses For SQLite]
+*[http://www.sqlite.org/whentouse.html Appropriate Uses For SQLite]
-[http://www.sqlite.org/datatype3.html Datatypes In SQLite Version 3]
+*[http://www.sqlite.org/datatype3.html Datatypes In SQLite Version 3]
-[http://www.sqlite.org/quickstart.html SQLite In Five Minutes Or Less]
+*[http://www.sqlite.org/quickstart.html SQLite In Five Minutes Or Less]
 [[Category:Solicitada]]