ମୁକ୍ତ
ମୁକ୍ତ
ସିଷ୍ଟମ୍‌ ଆବଶ୍ୟକତାଗୁଡିକ

ବିବରଣୀ

Open Sqlite databases and explore the internal organisation of various objects such as schema, tables and indices. To understand how Sqlite3 data is organised, please see [Database file format](https://www.sqlite.org/fileformat.html) from Sqlite website. # Applications: - Viewing internal organisation of Sqlite databases for software development and troubleshooting - Studying the format of Sqlite databases for academic purposes - Forensic investigators may use it to view data from deleted pages # Features - Opening Sqlite databases, displaying first page (containing header and schema root) - Opening internal pages which may be a B-Tree page, Freelist page or Overflow page - Exploring root, internal and leaf pages of B-Tree pages hierarchically. - Parsing and displaying cell content for B-Tree pages - Exploring Freelist (deleted) trunk and leaf pages # Usage Download any sqlite database, and Open it with this application (Import to Sqlite Page Explorer). Alternatively, on clicking the `Open database` button, the user can select the database file to explore. A sample database (chinook.db) has been provided. It can be selected from application specific subfolder under the Downloads folder of your device. The application opens the header, finds out the page size and provides links for the user to expand the `Header` and `Page 1`. The first page invariably contains the header and the schema (definitions of tables and indices). If the schema fits into the first page, the definitions can be seen on the `Page details` section in the form of table under `Cells` heading. For exploring data of tables and indices, the `Open` button against each table/index under `Cells` section may be clicked. This opens the `root` page of the table or index. Further exploration can be carried out from there by clicking on buttons in the `Page details` sections. If the schema spills over more than one page, the first page contains links to the different pages in which schema information is stored. These links can be seen in the `Page details` section under `Cells` heading and `Open` button against `Right most pointer` just above `Cells`. For each page, the page content in bytes is shown in `Hex`, `Decimal` and `Text` representations. It is also possible to open a random page from the database by entering page number and clicking on the `Open:` button at the bottom. # About Sqlite (from their website) SQLite is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine. SQLite is the most used database engine in the world. SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format. SQLite database files are a recommended storage format by the US Library of Congress.

ସ୍କ୍ରିନ୍‌ସଟ୍‌ଗୁଡିକ

ଅତିରିକ୍ତ ସୂଚନା

ପ୍ରକାଶକଙ୍କ ଦ୍ଵାରା

Siara Logics (India)

କୋପୀରାଇଟ୍

(c) 2018-19 Siara Logics (cc)

ଦ୍ଵାରା ବିକଶିତ

Arundale Ramanathan

ରିଲିଜ୍‌ ତାରିଖ

08-07-19

ଆନୁମାନିକ ଆକାର

20.64 MB

ବୟସ ମୂଲ୍ୟାୟନ

3 ଏବଂ ଉର୍ଦ୍ଧ୍ଵ ବୟସ୍କଙ୍କ ପାଇଁ


ଏହି ଆପ୍ଲିକେସନ୍ କରିପାରିବ

ଆପଣଙ୍କର ଇଣ୍ଟରନେଟ୍‍ ସଂଯୋଗକୁ ପ୍ରବେଶ କରନ୍ତୁ
ଆପଣଙ୍କର ଇଣ୍ଟରନେଟ୍‍ ସଂଯୋଗକୁ ପ୍ରବେଶ କରନ୍ତୁ ଏବଂ ଏକ ସର୍ଭର୍‌ ଭାବେ କାର୍ଯ୍ୟ କରନ୍ତୁ.

ସଂସ୍ଥାପନକରଣ

ଆପଣଙ୍କର Microsoft ଏକାଉଣ୍ଟ୍ ସାଇନ୍ ଇନ୍ କରିବା ବେଳେ ଏହି ଆପ୍ଲିକେସନ୍ ପ୍ରାପ୍ତ କରନ୍ତୁ ଏବଂ ଦଶଟି Windows 10 ଡିଭାଇସ୍‌ ପର୍ଯ୍ୟନ୍ତ ସଂସ୍ଥାପନ କରନ୍ତୁ.

ସମର୍ଥିତ ଭାଷା

English (United States)



ଏହି ଉତ୍ପାଦ ରିପୋର୍ଟ କରନ୍ତୁ

ସାଇନ୍‌ ଇନ୍‌ Microsoft କୁ ଏହି ଆପ୍ଲିକେସନ୍‌ ରିପୋର୍ଟ କରିବାକୁ