-->
Definition
SQLite Viewer Tool is free to download to view SQLite files like.db,.db3, SQLite, SQLite3. Read, View and analyze SQLite DB created by browser cache and cookies, smartphone application and website data. SQLite Reader Viewer enables user to view SQLite database file in Hex view format. Aryson SQLite Database Viewer Best Free Tool to View & Open SQLite Database File. Aryson SQLite Database Viewer is a professional SQLite DB Browser utility that helps you to view or open SQLite Database on the local system. When Database (.db,.sqlite,.db3,.sqlite3) file of SQLite becomes corrupted due to any reason, then this software will.
- SQLite databases store data in tables, which may contain multiple fields of various data types such as text or integers. Developers can access and modify this data using SQL queries or 'CRUD' (create, read, update, delete) operations. Since databases are self-contained, updates to the database are fully contained within the SQLITE file.
- Vienna is an open source Mac OSX RSS reader with support for RSS/Atom feeds, article storage and management via a SQLite database, written in Objective-C and Cocoa. Feeds can be accessed directly, or through a syncing service supporting the Open Reader API, like BazQux.com, FeedHQ.org, InoReader.com or TheOldReader.com. Development now happens.
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Provides methods for reading the result of a command executed against a SQLite database.
Properties
| Depth | Gets the depth of nesting for the current row. Always zero. |
| FieldCount | Gets the number of columns in the current row. |
| Handle | Gets a handle to underlying prepared statement. |
| HasRows | Gets a value indicating whether the data reader contains any rows. |
| IsClosed | Gets a value indicating whether the data reader is closed. |
| Item[Int32] | Gets the value of the specified column. |
| Item[String] | Gets the value of the specified column. |
| RecordsAffected | Gets the number of rows inserted, updated, or deleted. -1 for SELECT statements. |
Methods
| Close() | Closes the data reader. |
| Dispose(Boolean) | Releases any resources used by the data reader and closes it. |
| GetBoolean(Int32) | Gets the value of the specified column as a Boolean. |
| GetByte(Int32) | Gets the value of the specified column as a Byte. |
| GetBytes(Int32, Int64, Byte[], Int32, Int32) | Reads a stream of bytes from the specified column. Not supported. |
| GetChar(Int32) | Gets the value of the specified column as a Char. |
| GetChars(Int32, Int64, Char[], Int32, Int32) | Reads a stream of characters from the specified column. Not supported. |
| GetDataTypeName(Int32) | Gets the declared data type name of the specified column. The storage class is returned for computedcolumns. |
| GetDateTime(Int32) | Gets the value of the specified column as a DateTime. |
| GetDateTimeOffset(Int32) | Gets the value of the specified column as a DateTimeOffset. |
| GetDecimal(Int32) | Gets the value of the specified column as a Decimal. |
| GetDouble(Int32) | Gets the value of the specified column as a Double. |
| GetEnumerator() | Gets an enumerator that can be used to iterate through the rows in the data reader. |
| GetFieldType(Int32) | Gets the data type of the specified column. |
| GetFieldValue<T>(Int32) | Gets the value of the specified column. |
| GetFloat(Int32) | Gets the value of the specified column as a Single. |
| GetGuid(Int32) | Gets the value of the specified column as a Guid. |
| GetInt16(Int32) | Gets the value of the specified column as a Int16. |
| GetInt32(Int32) | Gets the value of the specified column as a Int32. |
| GetInt64(Int32) | Gets the value of the specified column as a Int64. |
| GetName(Int32) | Gets the name of the specified column. |
| GetOrdinal(String) | Gets the ordinal of the specified column. |
| GetSchemaTable() | Returns a System.Data.DataTable that describes the column metadata of the System.Data.Common.DbDataReader. |
| GetStream(Int32) | Retrieves data as a Stream. If the reader includes rowid (or any of its aliases), aSqliteBlob is returned. Otherwise, the all of the data is read into memory and aMemoryStream is returned. |
| GetString(Int32) | Gets the value of the specified column as a String. |
| GetTextReader(Int32) | Retrieves data as a TextReader. |
| GetTimeSpan(Int32) | Gets the value of the specified column as a TimeSpan. |
| GetValue(Int32) | Gets the value of the specified column. |
| GetValues(Object[]) | Gets the column values of the current row. |
| IsDBNull(Int32) | Gets a value indicating whether the specified column is DBNull. |
| NextResult() | Advances to the next result set for batched statements. |
| Read() | Advances to the next row in the result set. |
Free Sqlite Reader Mac Update
Applies to
Frequently Asked Questions
Listed Commonly Asked Questions and Answers
How to View SQLite Database using Sqlite Forensics Explorer?“I have some SQLite .db files of my android phone, Is it possible to open and view their contents with this application?”
Yes, SQLite database viewer is capable to support .db files created in android smart phones.
Follow the Below Steps to View SQLite db File:
- Step 1: Launch SysTools SQLite Viewer
- Step 2: Click on Add File button to select SQLite db file or journal file
- Step 3: Now browse the SQLite database files from destination folder
- Step 4: Again Click on Add button to View selected database files
- Step 5: Software Will scan and preview the content of selected files.
“We have earlier worked with the old version of SQLite and have a DB3 file. Just wanted to know if the software will work with those files as well”
Yes, you can view all the versions of SQLite Database Engine files in our free SQLite database viewer. The file format that are supported by our tool to view SQLite files are: *.db, *.db3, *.sqlite, *.sqlite3.
Is it possible to export an SQLite database file to a different file type?Yes, the Pro version of the software allows exporting SQLite database into; Access Database (MDB), SQL, & SQLite. You need to purchase the licensed version of the SQLite database viewer to export.
Can I look for a specific component from a heavy SQLite database file?“I needed to look for a particular table, but the database is too large to sort it out manually. Is there an option using which I can search for the item without any trouble.”
Db Browser For Sqlite
Yes, the free SQLite database viewer comes with a search box. Use a specific keyword / phrase that is relevant to what you are looking for & proceed. All the matching results will get listed.
Is there an option in the tool to sort a database according to fields ?Yes, you can view corrupt database components too. The tool has an inbuilt scanning option, it reads & scans the database internally, line by line, & accumulates the distorted line to show the free preview of the repaired SQLite database.
Is there any file size limitation enforced to view SQLite database?“My SQLite database file consists of all the old as well as new data. I wanted to know whether there is a size limitation for using SQLite format 3 viewer freeware?”
No, there is no such kind of limitation. The software is tested under rigorous conditions. Even a corrupt database of 1 Terabyte size is loaded and previewed successfully with the help of software.