SQLite Browser

SQLite Browser

Source link: https://github.com/sqlitebrowser/sqlitebrowser

DB Browser for SQLite

What it is

DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

It is for users and developers wanting to create databases, search, and edit data. It uses a familiar spreadsheet-like interface, and you don't need to learn complicated SQL commands.

Controls and wizards are available for users to:

  • Create and compact database files
  • Create, define, modify and delete tables
  • Create, define and delete indexes
  • Browse, edit, add and delete records
  • Search records
  • Import and export records as text
  • Import and export tables from/to CSV files
  • Import and export databases from/to SQL dump files
  • Issue SQL queries and inspect the results
  • Examine a log of all SQL commands issued by the application

What it is not

This program is not a visual shell for the sqlite command line tool. It does not require familiarity with SQL commands. It is a tool to be used both by developers and by end users, and it must remain as simple to use as possible in order to achieve its goals.

Nightly builds

Nightly builds for Windows and OSX can be downloaded here:

Windows

Windows releases can be downloaded here:

Note - If for some reason the standard Windows release doesn't work for you (eg it gives an error), try a nightly build. They often fix bugs reported after the last release. :D

MacOS X

DB Browser for SQLite works well on MacOS X.

  • OSX 10.8 (Mountain Lion) - 10.12 (Sierra) are tested and known to work

OSX releases can be downloaded here:

Latest OSX binary can be installed via Homebrew Cask:

brew cask install db-browser-for-sqlite

Linux

DB Browser for SQLite works well on Linux.

Arch Linux

Arch Linux provides a package through pacman.

Fedora

For Fedora (i386 and x86_64) you can install by issuing:

$ sudo dnf install sqlitebrowser

Ubuntu and Derivatives

Stable release

For Ubuntu and derivaties, @deepsidhu1313 provides a PPA with our latest release here:

To add this ppa just type in these commands in terminal:

sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser

Then update the cache using:

sudo apt-get update

Install the package using:

sudo apt-get install sqlitebrowser

Ubuntu 14.04.X, 15.04.X, 15.10.X and 16.04.X are supported for now (until Launchpad decides to discontinue building for any series).

Ubuntu Precise (12.04) and Utopic (14.10) are not supported:

  • Precise doesn't have a new enough Qt package in its repository by default, which is a dependency
  • Launchpad doesn't support Utopic any more, as that has reached its End of Life

Nightly builds

Nightly builds are available here:

To add this ppa just type in these commands in terminal:

sudo add-apt-repository -y ppa:linuxgndu/sqlitebrowser-testing

Then update the cache using:

sudo apt-get update

Install the package using:

sudo apt-get install sqlitebrowser

Other Linux

On others you'll need to compile it yourself using the (simple) instructions in BUILDING.md.

FreeBSD

DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanks to lbartoletti 😄). It can be installed using either this:

# make -C /usr/ports/databases/sqlitebrowser install

or this:

# pkg install sqlitebrowser

Compiling

Instructions for compiling on (at least) Windows, OSX, Linux, and FreeBSD are in BUILDING.

Developer mailing list

For development related discussion about DB4S and DBHub.io:

Twitter

Follow us on Twitter: https://twitter.com/sqlitebrowser

Website

Old project page

Releases

History

This program was developed originally by Mauricio Piacentini ( @piacentini) from Tabuleiro Producoes, as the Arca Database Browser. The original version was used as a free companion tool to the Arca Database Xtra, a commercial product that embeds SQLite databases with some additional extensions to handle compressed and binary data.

The original code was trimmed and adjusted to be compatible with standard SQLite 2.x databases. The resulting program was renamed SQLite Database Browser, and released into the Public Domain by Mauricio. Icons were contributed by Raquel Ravanini, also from Tabuleiro. Jens Miltner ( @jmiltner) contributed the code to support SQLite 3.x databases for the 1.2 release.

Pete Morgan ( @daffodil) created an initial project on GitHub with the code in 2012, where several contributors fixed and improved pieces over the years. René Peinthor ( @rp-) and Martin Kleusberg ( @MKleusberg) then became involved, and have been the main driving force from that point. Justin Clift ( @justinclift) helps out with testing on OSX, and started the new github.com/sqlitebrowser organisation on GitHub.

John T. Haller, of PortableApps.com fame, created the new logo. He based it on the Tango icon set (public domain).

In August 2014, the project was renamed to "Database Browser for SQLite" at the request of Richard Hipp (creator of SQLite), as the previous name was creating unintended support issues.

In September 2014, the project was renamed to "DB Browser for SQLite", to avoid confusion with an existing application called "Database Browser".

Contributors

You can see the list by going to the Contributors tab.

License

DB Browser for SQLite is bi-licensed under the Mozilla Public License Version 2, as well as the GNU General Public License Version 3 or later.

You can modify or redistribute it under the conditions of these licenses.

Source link: https://github.com/sqlitebrowser/sqlitebrowser

Q & A

Will factory resetting make my rooted device unbootable?
How to force Google Photos to sync photos to the cloud?
Rotate screen on HyperV
Unlock full Developer options on Philips PFK5500/12
Whatsapp Databases inside android device

Resources

Syncthing

Syncthing replaces proprietary sync and cloud services with something open, trustworthy and decentralized. Your data is your data alone and you deserve to choose where it is stored, if it is shared with some third party and how it's transmitted over the Internet.

Cloud Storages

PinLock

An Android library which can be used for implementing PIN lock mechanism in Android applications.

Lock Patterns

ScreenshotsNanny

Android library helps take screenshots for publishing on Google Play Store.

Screenshots

ElasticProgressBar

Elastic Progress Bar.

Progress Indicators

Material Camera

Android's video recording APIs are very difficult to figure out, especially since a lot of manufacturers like to mount their camera sensors upside down or sideways. This library is a result of lots of research and experimentation to get video recording to work universally.

Camera

Android Dynamic Loader

Android Dynamic Loader is a plugin system. The host application is like a browser, but instead of loading web pages, it loads plugins which could be run natively on Android system.

Plugin Frameworks

Q & A

Will factory resetting make my rooted device unbootable?
How to force Google Photos to sync photos to the cloud?
Rotate screen on HyperV
Unlock full Developer options on Philips PFK5500/12
Whatsapp Databases inside android device

Topics

2D Engines   3D Engines   9-Patch   Action Bars   Activities   ADB   Advertisements   Analytics   Animations   ANR   AOP   API   APK   APT   Architecture   Audio   Autocomplete   Background Processing   Backward Compatibility   Badges   Bar Codes   Benchmarking   Bitmaps   Bluetooth   Blur Effects   Bread Crumbs   BRMS   Browser Extensions   Build Systems   Bundles   Buttons   Caching   Camera   Canvas   Cards   Carousels   Changelog   Checkboxes   Cloud Storages   Color Analysis   Color Pickers   Colors   Comet/Push   Compass Sensors   Conferences   Content Providers   Continuous Integration   Crash Reports   Credit Cards   Credits   CSV   Curl/Flip   Data Binding   Data Generators   Data Structures   Database   Database Browsers   Date &   Debugging   Decompilers   Deep Links   Dependency Injections   Design   Design Patterns   Dex   Dialogs   Distributed Computing   Distribution Platforms   Download Managers   Drawables   Emoji   Emulators   EPUB   Equalizers &   Event Buses   Exception Handling   Face Recognition   Feedback &   File System   File/Directory   Fingerprint   Floating Action   Fonts   Forms   Fragments   FRP   FSM   Functional Programming   Gamepads   Games   Geocaching   Gestures   GIF   Glow Pad   Gradle Plugins   Graphics   Grid Views   Highlighting   HTML   HTTP Mocking   Icons   IDE   IDE Plugins   Image Croppers   Image Loaders   Image Pickers   Image Processing   Image Views   Instrumentation   Intents   Job Schedulers   JSON   Keyboard   Kotlin   Layouts   Library Demos   List View   List Views   Localization   Location   Lock Patterns   Logcat   Logging   Mails   Maps   Markdown   Mathematics   Maven Plugins   MBaaS   Media   Menus   Messaging   MIME   Mobile Web   Native Image   Navigation   NDK   Networking   NFC   NoSQL   Number Pickers   OAuth   Object Mocking   OCR Engines   OpenGL   ORM   Other Pickers   Parallax List   Parcelables   Particle Systems   Password Inputs   PDF   Permissions   Physics Engines   Platforms   Plugin Frameworks   Preferences   Progress Indicators   ProGuard   Properties   Protocol Buffer   Pull To   Purchases   Push/Pull   QR Codes   Quick Return   Radio Buttons   Range Bars   Ratings   Recycler Views   Resources   REST   Ripple Effects   RSS   Screenshots   Scripting   Scroll Views   SDK   Search Inputs   Security   Sensors   Services   Showcase Views   Signatures   Sliding Panels   Snackbars   SOAP   Social Networks   Spannable   Spinners   Splash Screens   SSH   Static Analysis   Status Bars   Styling   SVG   System   Tags   Task Managers   TDD &   Template Engines   Testing   Testing Tools   Text Formatting   Text Views   Text Watchers   Text-to   Toasts   Toolkits For   Tools   Tooltips   Trainings   TV   Twitter   Updaters   USB   User Stories   Utils   Validation   Video   View Adapters   View Pagers   Views   Watch Face   Wearable Data   Wearables   Weather   Web Tools   Web Views   WebRTC   WebSockets   Wheel Widgets   Wi-Fi   Widgets   Windows   Wizards   XML   XMPP   YAML   ZIP Codes