Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Fix typos. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA1: |
909c2b99c55b9c3bc1c0bc2a376ed7dc |
User & Date: | drh 2014-06-04 11:37:33.969 |
Context
2014-06-04
| ||
14:17 | Add the SQLITE_SOURCE_ID and sha1 sum for version 3.8.5. (check-in: 98333ba617 user: dan tags: trunk) | |
11:37 | Fix typos. (check-in: 909c2b99c5 user: drh tags: trunk) | |
11:26 | Add news for the 3.8.5 release and set the date to today. (check-in: e047b026ae user: drh tags: trunk) | |
Changes
Changes to pages/cli.in.
︙ | ︙ | |||
618 619 620 621 622 623 624 | <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 | | | 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 | 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 | | | | 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 | 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> <p>Depending how badly your database is corrupted, you may be able to recover some of the data by using the CLI to dump the schema and contents to a file and then recreate. Unfortunately, once humpty-dumpty falls off the wall, it is generally not possible to put him back together again.</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. |
︙ | ︙ | |||
626 627 628 629 630 631 632 | 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 | | | 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 | 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. ############# |
︙ | ︙ |