/usr/share/doc/sqliteman/en/ch02.html is in sqliteman-doc 1.2.2-0ubuntu6.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | <html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Chapter 2. Sqlite Specific Issues</title><link rel="stylesheet" href="kde-default.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.67.2"><meta name="keywords" content="Sqliteman, SQL, Sqlite, development, database"><link rel="start" href="index.html" title="The Sqliteman Handbook"><link rel="up" href="index.html" title="The Sqliteman Handbook"><link rel="prev" href="ch01.html" title="Chapter 1. Introduction"><link rel="next" href="ch03.html" title="Chapter 3. Start the Application"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Chapter 2. Sqlite Specific Issues</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="ch01.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="ch03.html">Next</a></td></tr></table><hr></div><div class="chapter" lang="en"><div class="titlepage"><div><div><h2 class="title"><a name="sqlite-specs"></a>Chapter 2. Sqlite Specific Issues</h2></div></div></div><p>
The text in this chapter is take from
<a href="http://www.sqlite.org/" target="_top">Sqlite home page</a>.
Read more documentation there for deeper understanding of Sqlite
features.
</p><p>
SQLite is a small C library that implements a self-contained, embeddable,
zero-configuration SQL database engine.
</p><div class="caution" style="margin-left: 0.5in; margin-right: 0.5in;"><h3 class="title">Caution</h3><p>
It's strongly recommended to read and understand the Sqlite
documentation. Sqlite can be confusing for a programmer from the world
of the <span class="emphasis"><em>real databases</em></span> (like Postgresql, Oracle,
MS SQL Server etc.).
</p></div><p>Features include:</p><div class="itemizedlist"><ul type="disc"><li><p>Transactions are atomic, consistent, isolated, and durable (ACID)
even after system crashes and power failures.</p></li><li><p>Zero-configuration - no setup or administration needed.</p></li><li><p>Implements most of SQL92.
(<a href="http://www.sqlite.org/omitted.html" target="_top">Features not supported</a>)</p></li><li><p>A complete database is stored in a single disk file.</p></li><li><p>Database files can be freely shared between machines with
different byte orders.</p></li><li><p>Supports databases up to 2 tebibytes in size.</p></li><li><p>Strings and BLOBs up to 2 gibibytes in size.</p></li><li><p>Small code footprint: less than 250KiB fully configured or less
than 150KiB with optional features omitted.</p></li><li><p><a href="http://www.sqlite.org/speed.html" target="_top">Faster</a> than popular client/server database
engines for most common operations.</p></li><li><p>Simple, easy to use <a href="http://www.sqlite.org/capi3.html" target="_top">API</a>.</p></li><li><p><a href="http://www.sqlite.org/tclsqlite.html" target="_top">TCL bindings</a> included.
Bindings for many other languages
<a href="http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers" target="_top">available separately.</a></p></li><li><p>Well-commented source code with over 95% test coverage.</p></li><li><p>Self-contained: no external dependencies.</p></li><li><p>Sources are in the <a href="http://www.sqlite.org/copyright.html" target="_top">public domain</a>.
Use for any purpose.</p></li></ul></div><p>
Sqlite specific properties affect <span class="application">Sqliteman</span> feature set. E.g.
Sqlite does not support foreign keys so there is a dedicated dialog
for FK triggers creating.
</p></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="ch01.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="ch03.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Chapter 1. Introduction </td><td width="20%" align="center"><a accesskey="h" href="index.html">Contents</a></td><td width="40%" align="right" valign="top"> Chapter 3. Start the Application</td></tr></table></div></body></html>
|