Documentation Source Text

Check-in [f6681985cd]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Comment:More typo fixes in quirks.html
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: f6681985cd814f13795d4f87dff09308d1af6834925f13130e8b7aac5b2ea08d
User & Date: drh 2019-07-11 16:31:53
Remove obsolete and unsupported BNF and TEXT representations of the grammar. check-in: b02f76d76f user: drh tags: trunk
More typo fixes in quirks.html check-in: f6681985cd user: drh tags: trunk
Fix typos in the quirks document. check-in: 596c4951a0 user: drh tags: trunk
Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to pages/

    21     21   If you are an SQLite user whose has stumbled over some quirk of
    22     22   SQLite that is not mentioned here, please send us an email so that
    23     23   we can document the problem.
    24     24   
    25     25   <h1>SQLite Is Embedded, Not Client-Server</h1>
    26     26   
    27     27   <p>
    28         -When ever comparing SQLite to other SQL database engines like
           28  +Whenever comparing SQLite to other SQL database engines like
    29     29   SQL Server, PostgreSQL, MySQL, or Oracle, it is important first of all
    30     30   to realize that SQLite is not intended as a replacement or competitor to
    31     31   any of those systems.  SQLite is [serverless].  There is no separate
    32         -server process that manages the database.  An application interact
    33         -with the database engine using function calls, not be sending messages
           32  +server process that manages the database.  An application interacts
           33  +with the database engine using function calls, not by sending messages
    34     34   to a separate process or thread.
    35     35   
    36     36   <p>
    37     37   The fact that SQLite is embedded and [serverless] instead of being
    38     38   client/server is a feature, not a bug.
    39     39   
    40     40   <p>
   140    140   Which format you use, is entirely up to your application.
   141    141   
   142    142   <h1>Foreign Key Enforcement Is Off By Default</h1>
   143    143   
   144    144   <p>SQLite has parsed foreign key constraints for time out of mind,
   145    145   but added the ability to actually enforce those constraints much later,
   146    146   with [version 3.6.19] ([dateof:3.6.19]).  By the time foreign key constraint
   147         -enforcement was added, there where already countless millions of databases
          147  +enforcement was added, there were already countless millions of databases
   148    148   in circulation that contained foreign key constraints, some of which
   149    149   were not correct.  To avoid breaking those legacy databases, foreign key
   150    150   constraint enforcement is turned off by default in SQLite.
   151    151   
   152    152   <p>Applications can activate foreign key enforcement at run-time using
   153    153   the [PRAGMA foreign_keys] statement.  Or, foreign key enforcement can
   154    154   be activated at compile-time using the