SQLiteViewer 1.9.6.7
   TC      SQLite.   *.db, *.db3, *.sqlite, *.sqlite3  *.fossil.

   2,  sqlite3.dll  .
  ,    :
http://www.sqlite.org/datatype3.html

         (        ):
http://www.sqlite.org/tempfiles.html#walfile
http://www.sqlite.org/wal.html


 
   ()    " " ("AS IS")      .                 .


 

 1.0:
 *  .

 1.5:
 *      SQLite;
 +    DetectString: sqlite (      );
 *  .

 1.6:
 +      (   1000    );
 +        ;
 +      ;
 +   ;
 *  .

 1.6.1:
 *   ;
 *  .

 1.6.2:
 +            .

 1.7:
 +   BLOB     ;
 +    (  ini-);
 + SQLiteViewer.ini   :
   [SQLiteViewer]
   ShowTablesPanel=0 - /   (  0)
   BlobAsText=1 - /  BLOB-   (  1)
   BlobAsTextLimit=150 -     BLOB- (20..255,   150);
 *  .

 1.7.5:
 + SQLiteViewer.ini   :
   [SQLiteViewer]
   FixDrawErrors=1 -     
   FixScrollError=0 -          
   FixDrawScrollError=0 -   FixScrollError=1       (   - )
   GridOddRowOtherColor=1 -     
   GridOddRowColor=$00F4F4F4 -   .

 1.7.6:
 *     lsplugin.ini   .

 1.8:
 *   SQLite;
 *       "  " (PRAGMA query_only);
 *       ;
 +         (Record View);
 * BlobAsTextLimit     2000  (20..2000,   150);
 + SQLiteViewer.ini   :
   [SQLiteViewer]
   ShowTablesCombobox=1 - /    (  1)
   StringLengthLimit=255 -      (20..2000,   255)
  ! .      Blob  (   )      -  .
   SkipSystemTables=0 -        (  "sqlite_") (  0);
 *  .

 1.8.1:
 *  .

 1.8.2:
 *   SQLite;
 *    Delphi XE4    64- ;
 +       SQL;
 *         ,      ;
 *  .

 1.8.3:
 *   SQLite;
 +  ,    "WITHOUT ROWID" (https://www.sqlite.org/withoutrowid.html).

 1.8.4:
 *   SQLite;
 +    DetectString: sqlite3  fossil (      ).

 1.8.5:
 *   SQLite;
 +          LIKE (   TC ( ) - F7).

 1.8.6:
 *   SQLite;
 *                  (F7);
 +   .
 
 1.8.7:
 *   SQLite;
 +   "Not Contain" ( )  "Just Not Null" (  ).
 
 1.9.0:
 *   SQLite;
 +    (VIEW);
 + SQLiteViewer.ini   :
   [SQLiteViewer]
   AddVIEWs=1 -     ;
 +   (  Setup...);
 *  .

 1.9.1:
 *   SQLite;
 +     (  );
 *  .

 1.9.2:
 *   SQLite;
 + SQLiteViewer.ini   :
   [SQLiteViewer]
   DatabaseReadOnly=1 -         (  1);
 *  .

 1.9.3:
 *    TAB      64- TC;
 + SQLiteViewer.ini   :
   [SQLiteViewer]
   SpecialCheckQuery=0 -         (DatabaseReadOnly=0)      "select",          (  0).

 1.9.5:
 *   SQLite;
 + SQLiteViewer.ini   :
   [SQLiteViewer]
   FixDateTimeField=1 -     DATETIME (  1).

 1.9.6:
 *   SQLite;
 +            (DatabaseReadOnly=0).

 1.9.6.1:
 *   SQLite;
 +    (  ) (  ).

 1.9.6.2:
 *   .

 1.9.6.3:
 *   SQLite;
 *  .

 1.9.6.4:
 *  .

 1.9.6.5:
 +        (  );
 *  .

 1.9.6.6:
 * BlobAsTextLimit     20000  (20..20000,   150).     !;
 * StringLengthLimit     20000  (20..20000,   255).     !;
 *    .

 1.9.6.7:
 + SQLiteViewer.ini   :
   [SQLiteViewer]
   FontName= -  ,
   FontSize= -  ;
 *  .


---
     !
ProgMan13, (ProgMan13@mail.ru)