Showing posts with label SQLite. Show all posts

DBeaver – Free Database Manager With Support For MySQL, MSSQL, Oracle, SQLite & More

For anyone working with multiple database engines, regularly switching between different apps to manage them can be a pain.
DBeaver is a free database management application which works with many different engines including MySQL, MSSQL, Oracle, SQLite, Sybase, Firebird and much more.
As the application is built with Java, it works in all major operating systems(Windows, Mac & Linux).
DBeaver
It can handle all the major tasks like metadata editing (tables, columns, keys, indexes), custom SQL execution, users management, multiple connections, etc.
We can draw ER diagrams for database modeling, and, the app is soon to be open sourced.

Desktop-Like Web-Based MySQL Admin App: MyWebSQL

For MySQL users, phpMyAdmin -the popular MySQL admin tool-, is probably one of the most-used apps unless you are fan of a desktop MySQL admin tool.
MyWebSQL is an exciting open source alternative to both as it is a web-based MySQL (and SQLite) manager with a desktop-like c.
It is built with PHP and, with the help of a completely Ajaxed interface, tasks can be accomplished pretty quickly.
MyWebSQL
Creating, editing and deleting tables or records are easily done in a grid mode which also makes working with multiple items at the same time possible. Also, shortcuts for any actions exist inside context menus to make browsing faster.
There are other must-have features like import-export, SQL editor (with syntax highlighting), repair tables, search, process manager, etc.

MyWebSQL is a multilanguage app with lots of ready-to-use languages and has a themable interface.
Imho, what is missing the most is the ability to manage multiple server connections with a single login and scheduled tasks (which I hope would exist in the future versions).

Free Mac OS X Database Client That Supports SQL & NoSQL

Induction is an open source and free tool for understanding and communicating relationships in data.

It can be used to explore rows/columns, run queries and visualize the data in several ways.
Induction
The tool has support for many databases including PostgreSQL, MySQL, SQLite, Redis and MongoDB. Also, any others can be added by writing new adapters.
Induction is currently in alpha and not a full-featured client yet but has a roadmap to become one.