Within the Tools menu, you have instant access to SQLiteStudio’s other useful tools namely a SQL editor, a DDL history viewer, a SQL function editor, and a collations editor. With the help of the same menu, you can also import data using various file formats such as CSV and custom text files, as well as export. Base 2, Navicat for SQLite, and DB Browser for SQLite are probably your best bets out of the 9 options considered. 'Easy data import' is the primary reason people pick Base 2 over the competition. This page is powered by a knowledgeable community that helps you make an informed decision.
SQLite Management Tools: a comprehensive table for multiple operating systems but not updated since 2011. The following table describes a few tried by one member of this wiki. The page SQLite Managers for Mac OS looks into some for the Mac.
List of tools that allow for the design of a database.
#1 How to Import Photos from Android to Mac with Android File Transfer? Android File Transfer is. Android photo transfer for mac. Drag Android File Transfer to Applications. Use the USB cable that came with your Android device and connect it to your Mac. Double click Android File Transfer. Browse the files and folders on your Android device and copy files. Transfer photos from Android to Mac using dr.fone - Phone Manager (Android) Moving photos from.
dModelAid
dModelAid is the perfect modeling tool for documenting a complex database design in a simple, interactive diagram. It offers smart visualization features to help you design the database structure and to identify potential errors before any code has been written. Your database project gets documented along the way, simplifying the learning process for new employees, team members and/or substitutes.
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
Vertabelo
Vertabelo gives the user the power of visual design of database online. It provides perfect UI to create database quickly and easily manage tables, views, references, etc.
Mac Install Sqlite
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
DeZign for Databases
DeZign for Databases uses ERD and data models to graphically design databases and automatically generates the most popular databases.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
DbDesigner.net
DbDesigner with a friendly and fast UI helps in designing database without writing SQL.
| Desktop/Cloud: | Cloud |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
Moon Modeler
Moon modeler is a visual database design tool for both relational and noSQL databases. The key features include the visual design of hierarchical structurs, MongoDB script generation, various display modes, possibility to add custom notes to diagram and more. For PostgreSQL, MariaDB and MongoDB reverse engineering features are available.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
DBeaver
DBeaver is a free multi-platform database tool for developers, SQL programmers, database administrators and analysts.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
Model Xtractor
Model Xtractor is a software utility designed to inspect modeling for tradition or enhanced ER models, with support for most relational database platforms.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
ERBuilder Data Modeler
ERBuilder Data Modeler allows developers to graphically design databases by using entity relationship diagrams, and automatically generates the most popular SQL databases.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
Adminer
Adminer is a tool for managing contents of MySQL databases, formerly known as phpMinAdmin. It is a full-featured database management tool written in PHP.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
DB Browser for SQLite
DB Browser for SQLite (DB4S) is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
TablePlus
TablePlus is a native tool with an intuitive interface that you can use to create, query, edit and save your databases in a very fast and secure way.
What type of game do you want to release?. To answer which of these game engines is best for your needs, you first need to answer these five questions:. Where do you want to release your games?. Unreal for mac os x 10.10. How much game development experience do you have?.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
Navicat Data Modeler
Navicat Data Modeler is a powerful and cost-effective database design tool which helps to build high-quality conceptual, logical and physical data models. It allows to visually design database structures, perform reverse/forward engineering processes, import models from ODBC data sources, generate complex SQL/DDL, print models to files, and much more.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
Toad Data Modeler
Toad Data Modeler enables developers, DBAs, and designers to create, maintain and document quality database designs and structures across various database platforms.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
DbVisualizer
DbVisualizer is the universal database tool for developers, DBAs and analysts. It is aimed to simplify database development and management for database administrators and developers.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
RazorSQL
RazorSQL is an SQL query tool, database browser, SQL editor, and database administration tool for Windows, macOS, Mac OS X, Linux, and Solaris.
| Desktop/Cloud: | Desktop |
|---|---|
| Generate DDL scripts: | |
| Free edition: | |
| ER Diagram: |
(Please consider sponsoring us on Patreon 😄)
Windows
Our latest release (3.12.0) for Windows:
Note - If for any reason the standard Windows release does not work(e.g. gives an error), try a nightly build (below).
Nightly builds often fix bugs reported after the last release. 😄
macOS
Our latest release (3.12.0) for macOS:
Homebrew
If you prefer using Homebrew for macOS, our latest release can be installed via Homebrew Cask:
Nightly builds
Sims get to work for mac. Download nightly builds for Windows and macOS here:
Linux
DB Browser for SQLite works well on Linux.
Arch Linux
Arch Linux provides a package through pacman.
Fedora
Install for Fedora (i386 and x86_64) by issuing the following command:
openSUSE
Debian
Note that Debian focuses more on stability rather than newest features. Therefore packages will typically contain some older version, compared to the latest release.
Update the cache using:
Install the package using:
Ubuntu and Derivatives
Stable release
For Ubuntu and derivaties, @deepsidhu1313provides a PPA with the latest release here:
To add this ppa just type in these commands in terminal:
Then update the cache using:
Install the package using:
Ubuntu 14.04.X, 15.04.X, 15.10.X and 16.04.X are supported for now (untilLaunchpad decides to discontinue building for any series).
Ubuntu Precise (12.04) and Utopic (14.10) are not supported:
- Precise does not have a new enough Qt package in its repository by default,which is a dependency
- Launchpad does not support Utopic any more, which has reached its End ofLife
Nightly builds
Nightly builds are available here:
To add this ppa, type these commands into the terminal:
Then update the cache using:
Install the package using:
Other Linux
Sqlite Tools For Mac Versions
On others, compile DB4S using the instructionsin BUILDING.md.
FreeBSD
DB Browser for SQLite works well on FreeBSD, and there is a port for it (thanksto lbartoletti 😄). DB4S can be installedusing either this command:
or this command:
Snap packages
Snap Nightlies
Snap Stable