My Blog

SQLite Database Browser on Cloud

1-click AWS Deployment    1-click Azure Deployment



Overview

SQLite Database Browser is an open source tool that allows you to create, design and edit SQLite database files. Features include the ability to create and modify databases, tables, indexes and records, search for records as well as import and export data. It also contains a log showing all the SQL commands that have been issued by the user and by the application itself.

When you open SQLite Database Browser, start by opening an existing database or creating a new database. Once you’ve loaded a database, you can view the database structure, browse data and execute SQL commands using the appropriate tabs.

to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface.

SQLite is owned by SQLite (https://sqlite.org/index.html) and they own all related trademarks and IP rights for this software.

SQLite Database Browser on Cloud runs on Amazon Web Services (AWS) and Azure and is built to to allow non-technical users to create, modify and edit SQLite databases using a set of wizards and a spreadsheet-like interface.

Cognosys provides hardened images of SQLite Database Browser on all public cloud i.e. AWS marketplace and Azure

SQLite Database Browser on Cloud For AWS



Features

Major Features Of SQLite Database Browser 

  • Transactions  are atomic, consistent, isolated, and durable (ACID) even after system crashes and power failures.
  • Zero-configuration – no setup or administration needed.
  • A complete database is stored in a single cross-platform disk file. Great for use as an application file format
  • Supports terabyte-sized databases and gigabyte-sized strings and blobs.
  • Simple, easy to use API.
  • Written in ANSI-C. TCL bindings included. Bindings for dozens of other languages available separately.
  • Well-commented source code with 100% branch test coverage.
  • Available as a single ANSI-C source-code file that is easy to compile and hence is easy to add into a larger project.
  • Self-contained: no external dependencies.
  • Cross-platform: Android, *BSD, iOS, Linux, Mac, Solaris, VxWorks, and Windows (Win32, WinCE, WinRT) are supported out of the box. Easy to port to other systems.
  • Sources are in the public domain. Use for any purpose.
  • Comes with a standalone command-line interface (CLI) client that can be used to administer SQLite databases.

AWS

Installation Instructions For Windows

Note: How to find PublicDNS in AWS

Step 1) RDP  Connection: To connect to the deployed instance, Please follow Instructions to Connect to Windows  instance on AWS Cloud

1) Connect to the virtual machine using following RDP credentials:

  • Hostname: PublicDNS  / IP of machine
  • Port : 3389

Username: To connect to the operating system, use RDP and the username is Administrator.
Password: Please Click here to know how to get password .

Step 2) Click the Windows “Start” button and select “All Programs” and then point to SQLite Database Browser

Step 3) Other Information:

1.Default installation path: will be in your root folder “C:\Program Files\DB Browser for SQLite”

2.Default ports:

  • Windows Machines:  RDP Port – 3389
  • Http: 80
  • Https: 443

Configure custom inbound and outbound rules using this link

Installation Step by Step Screenshots

Videos

SQLite Database Browser on Cloud

Related Posts