Documentation Source Text
Check-in [909c2b99c55b9c3bc1c0bc2a376ed7dc933d43c9]
Not logged in

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

Overview
SHA1 Hash:909c2b99c55b9c3bc1c0bc2a376ed7dc933d43c9
Date: 2014-06-04 11:37:33
User: drh
Comment:Fix typos.
Tags And Properties
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/cli.in

618
619
620
621
622
623
624
625
626
627
628
629
630
631
632

<p>The final line of the example (the ".system c:/work/dataout.csv")
has the same effect as double-clicking on the c:/work/dataout.csv file
in windows.  This will typically bring up a spreadsheet program to display
the CSV file.  That command only works as shown on Windows.  The
equivalent line on a Mac would be ".system open /work/dataout.csv".
On Linux and other unix systems you will need to enter something like
".system libreoffice /work/dataout.csv", substituting your perferred
CSV viewing program for "libreoffice".

<h3>Converting An Entire Database To An ASCII Text File</h3>

<p>Use the ".dump" command to convert the entire contents of a
database into a single ASCII text file.  This file can be converted
back into a database by piping it back into <b>sqlite3</b>.</p>







|







618
619
620
621
622
623
624
625
626
627
628
629
630
631
632

<p>The final line of the example (the ".system c:/work/dataout.csv")
has the same effect as double-clicking on the c:/work/dataout.csv file
in windows.  This will typically bring up a spreadsheet program to display
the CSV file.  That command only works as shown on Windows.  The
equivalent line on a Mac would be ".system open /work/dataout.csv".
On Linux and other unix systems you will need to enter something like
".system libreoffice /work/dataout.csv", substituting your preferred
CSV viewing program for "libreoffice".

<h3>Converting An Entire Database To An ASCII Text File</h3>

<p>Use the ".dump" command to convert the entire contents of a
database into a single ASCII text file.  This file can be converted
back into a database by piping it back into <b>sqlite3</b>.</p>

Changes to pages/faq.in

517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
...
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
...
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
  update, your database is safe.  The database is safe even if your OS
  crashes or takes a power loss.  The crash-resistance of SQLite has
  been extensively studied and tested and is attested by years of real-world 
  experience by billions of users.</p>

  <p>That said, there are a number of things that external programs or bugs
  in your hardware or OS can do to corrupt a database file.  See
  <a href="howtocorrupt.html">How To Corrupt An SQLite DAtabase File</a> for
  further information.

  <p>Your can use <a href="pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> 
  to do a thorough but time intensive test of the database integrity.</p>

  <p>Your can use <a href="pragma.html#pragma_quick_check">PRAGMA quick_check</a> to do a faster 
  but less thorough test of the database integrity.</p>
................................................................................

faq {
  Does SQLite support foreign keys?
} {
  <p>
  As of version 3.6.19, SQLite supports [foreign key constraints].  But enforcement
  of foreign key constraints is turned off by default (for backwards compatibility).
  To enable foreign key constraint enforcements, run 
  [PRAGMA foreign_keys|PRAGMA foreign_keys=ON] or compile with
  [SQLITE_DEFAULT_FOREIGN_KEYS | -DSQLITE_DEFAULT_FOREIGN_KEYS=1].
}

faq {
  I get a compiler error if I use the SQLITE_OMIT_... 
  compile-time options when building SQLite.
................................................................................
  application, that might change the ECCN in your particular case.
}

faq {
  My query does not return the column name that I expect.  Is this a bug?
} {
  If the columns of your result set are named by AS clauses, then SQLite
  is guaranteed to use the identifer to the right of the AS keyword as the
  column name.  If the result set does not use an AS clause, then SQLite
  is free to name the column anything it wants.
  See the [sqlite3_column_name()] documentation for further information.
}

# End of questions and answers.
#############







|







 







|







 







|







517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
...
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
...
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
  update, your database is safe.  The database is safe even if your OS
  crashes or takes a power loss.  The crash-resistance of SQLite has
  been extensively studied and tested and is attested by years of real-world 
  experience by billions of users.</p>

  <p>That said, there are a number of things that external programs or bugs
  in your hardware or OS can do to corrupt a database file.  See
  <a href="howtocorrupt.html">How To Corrupt An SQLite Database File</a> for
  further information.

  <p>Your can use <a href="pragma.html#pragma_integrity_check">PRAGMA integrity_check</a> 
  to do a thorough but time intensive test of the database integrity.</p>

  <p>Your can use <a href="pragma.html#pragma_quick_check">PRAGMA quick_check</a> to do a faster 
  but less thorough test of the database integrity.</p>
................................................................................

faq {
  Does SQLite support foreign keys?
} {
  <p>
  As of version 3.6.19, SQLite supports [foreign key constraints].  But enforcement
  of foreign key constraints is turned off by default (for backwards compatibility).
  To enable foreign key constraint enforcement, run 
  [PRAGMA foreign_keys|PRAGMA foreign_keys=ON] or compile with
  [SQLITE_DEFAULT_FOREIGN_KEYS | -DSQLITE_DEFAULT_FOREIGN_KEYS=1].
}

faq {
  I get a compiler error if I use the SQLITE_OMIT_... 
  compile-time options when building SQLite.
................................................................................
  application, that might change the ECCN in your particular case.
}

faq {
  My query does not return the column name that I expect.  Is this a bug?
} {
  If the columns of your result set are named by AS clauses, then SQLite
  is guaranteed to use the identifier to the right of the AS keyword as the
  column name.  If the result set does not use an AS clause, then SQLite
  is free to name the column anything it wants.
  See the [sqlite3_column_name()] documentation for further information.
}

# End of questions and answers.
#############