Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
| Comment: | Fix a typo in the whentouse.html page. Fix formatting problems in quickstart. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
491dfd2cee14d6d1e5dd3b9c2c2548d6 |
| User & Date: | drh 2008-02-19 16:16:52 |
|
2008-02-21
| ||
| 19:49 | Updates to the "most deployed SQL database" page. (check-in: 4f5e61a933 user: drh tags: trunk) | |
|
2008-02-19
| ||
| 16:16 | Fix a typo in the whentouse.html page. Fix formatting problems in quickstart. (check-in: 491dfd2cee user: drh tags: trunk) | |
|
2008-02-06
| ||
| 16:06 | Updates to the download page. (check-in: 2599ad51da user: drh tags: trunk) | |
Changes to pages/quickstart.in.
77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 |
int main(int argc, char **argv){
sqlite3 *db;
char *zErrMsg = 0;
int rc;
if( argc!=3 ){
fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
exit(1);
}
rc = <b>sqlite3_open</b>(argv[1], &db);
if( rc ){
fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
sqlite3_close(db);
exit(1);
}
rc = <b>sqlite3_exec</b>(db, argv[2], callback, 0, &zErrMsg);
if( rc!=SQLITE_OK ){
fprintf(stderr, "SQL error: %s\n", zErrMsg);
sqlite3_free(zErrMsg);
}
<b>sqlite3_close</b>(db);
return 0;
}
</pre></blockquote>
</li>
</ul>
|
| | | |
77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 |
int main(int argc, char **argv){
sqlite3 *db;
char *zErrMsg = 0;
int rc;
if( argc!=3 ){
fprintf(stderr, "Usage: %s DATABASE SQL-STATEMENT\n", argv[0]);
exit(1);
}
rc = <b>sqlite3_open</b>(argv[1], &db);
if( rc ){
fprintf(stderr, "Can't open database: %s\n", sqlite3_errmsg(db));
sqlite3_close(db);
exit(1);
}
rc = <b>sqlite3_exec</b>(db, argv[2], callback, 0, &zErrMsg);
if( rc!=SQLITE_OK ){
fprintf(stderr, "SQL error: %s\n", zErrMsg);
sqlite3_free(zErrMsg);
}
<b>sqlite3_close</b>(db);
return 0;
}
</pre></blockquote>
</li>
</ul>
|
Changes to pages/whentouse.in.
29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
achieve simplicity, SQLite has had to sacrifice other characteristics that some people find useful, such as high concurrency, fine-grained access control, a rich set of built-in functions, stored procedures, esoteric SQL language features, XML and/or Java extensions, tera- or peta-byte scalability, and so forth. If you need some of these features and do not mind the added complexity that they bring, then SQLite is probably not the database for you. SQLite is not intended to be an enterprise database engine. It not designed to compete with Oracle or PostgreSQL. </p> <p> The basic rule of thumb for when it is appropriate to use SQLite is this: Use SQLite in situations where simplicity of administration, implementation, and maintenance are more important than the countless |
| |
29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
achieve simplicity, SQLite has had to sacrifice other characteristics
that some people find useful, such as high concurrency, fine-grained
access control, a rich set of built-in functions, stored procedures,
esoteric SQL language features, XML and/or Java extensions,
tera- or peta-byte scalability, and so forth. If you need some of these
features and do not mind the added complexity that they
bring, then SQLite is probably not the database for you.
SQLite is not intended to be an enterprise database engine. It is
not designed to compete with Oracle or PostgreSQL.
</p>
<p>
The basic rule of thumb for when it is appropriate to use SQLite is
this: Use SQLite in situations where simplicity of administration,
implementation, and maintenance are more important than the countless
|