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.
SQLite Database Browser on Cloud For AWS
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.
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”
- Windows Machines: RDP Port – 3389
- Http: 80
- Https: 443
Configure custom inbound and outbound rules using this link
Installation Step by Step Screenshots