Hot answers tagged

11 votes

Tool to Visualize SQL Database Schema

The screenshot you show comes from WWW SQL Designer: free and open source (New BSD License) online demo retrieve (import) schema from existing database. cross-platform (web application) Description ...
user avatar
8 votes

Tool to Visualize SQL Database Schema

Try MySQL Workbench - it is free: http://dev.mysql.com/downloads/workbench/ Screen shots of the visual design: http://www.mysql.com/products/workbench/design/ Platforms: Windows, Linux, Mac OS X
user avatar
7 votes

Tool to Visualize SQL Database Schema

SchemaCrawler is a free, open source, and platform independent command-line tool that can generate database diagrams from an MySQL database. You can exclude tables and columns from the diagram using ...
user avatar
6 votes

Tool to Visualize SQL Database Schema

You can try DbVisualizer. Most of its features I have described in my answer to a related post, so you can take a look. In general it is a free Java-based tool for database management, that supports ...
user avatar
5 votes

mysql database visualization software for windows 7

There are plenty of these, and G.I.Y.F. But, what's wrong with the classic MySql workbench? In addition to allowing you to graphically create a new data base schema (and generate code to create it), ...
user avatar
4 votes
Accepted

Is there any software that allows me to make the join automatically for mysql?

Taken from the Ubuntu SE, you can use OpenOffice/LibreOffice which a query designer as part of their database package. I've never used it, but here's a quick guide from the linked wiki page: ...
user avatar
  • 441
3 votes
Accepted

Free options to MySQL Query Analyzer

The one that I know is TOra, which seems to do what you ask for (and much more). TOra is an open-source multi-platform database management GUI that supports accessing most of the common database ...
user avatar
  • 1,770
3 votes

Database/Scripting Language suggestion for a project involving heavy inserts?

To address your first issue: I am experienced with PHP as a server side script and MYSQL. I am confused on the database side ? When you were developing in PHP, MySQL was the tool you used to manage ...
user avatar
  • 31
3 votes

Program to import a Microsoft Excel spreadsheet into a MySQL table

I wrote an application for importing an Excel spreadsheet into MySQL. It meets all your other requirements except specifying columns to import, but it will import everything very fast and you can ...
user avatar
  • 798
3 votes

Data inside MySQL tables comparison tools

Many years ago I used SQL Delta for this purpose. I assume it's still good. A single license is $185 though.
user avatar
  • 161
3 votes

MySQL client for iOS?

Below is a list of SQL clients that I have tried in the past, all seem to have a limitation in one area, whilst being stronger in others. MySQL Editor Pro seems to be your best bet, IMHO. Hope this ...
user avatar
3 votes

Simple HTML5 drag/drop uploader WITH registration

I modified this script here, Mini AJAX File Upload Form to fit your requirements of clients/guest inputting their email before they get to the upload form. You can download it here, mini-upload-form....
user avatar
  • 7,554
3 votes

Split mySQL tables into databases by prefix

You can do it with bash and mysql(dump). I don't have a MySQL right now to test it, but should be something like the following: mysql -uUSER -p SRC_DB -e 'show tables' | tail -n+2 | grep '^PREFIX' | ...
user avatar
  • 266
2 votes

OS X MySQL client?

You may like my app SQLPro for MySQL (App Store). The app supports all the features you requested except being free/open source. If you are a student, I can happily provide a free license key. You ...
user avatar
  • 141
2 votes

Report Generator based on MySQL Backend

Look at http://qlrmanager.com which is closed source, but inexpensive. It's also very extensible and fully featured.
user avatar
  • 206
2 votes

Report Generator based on MySQL Backend

With these requirements your options are very limited, for PHP and open source, you can use PHPJasperXML, which it's an implementation of Jasper Reports for PHP, if you can relax the PHP requirement, ...
user avatar
2 votes
Accepted

GUI MySQL program

You can do that with the official MySql Workbench. You can also do much, much more, so why choose anything other than the official (and free) tool? This image (from http://www.mysql.com/common/...
user avatar
2 votes

Data inside MySQL tables comparison tools

If you're looking for a distributed version control system for databases, check out Klonio. Its like Git/GitHub for databases. The user interface/commands have been modelled similar to Git, so you can ...
user avatar
  • 131
2 votes

Data inside MySQL tables comparison tools

Here are some suggestions for you You should take a look at Devart's database compare tools for MySQL from it's official website DbForge Data Compare for MySQL serves for comparing and ...
user avatar
  • 1,447
2 votes

Visual database design tool for MySQL 4.*

I would suggest HeidiSQL for this, I've used it in a few projects involving MySQL and it works great: Built-in SQL code editor and graphical browser for almost every object in the server. Not ...
user avatar
  • 751
2 votes

What programming language and technologies can you advise to use in my project?

Advantages Spring Framework Greate security Easy packaging And distribution You can make an installer (any can install your software) Advantages php Framework Easy bugs fixes (you don't need to re-...
user avatar
2 votes

Is there any software that allows me to make the join automatically for mysql?

I would suggest using python and the mysql connector library: Example Code: import datetime import mysql.connector cnx = mysql.connector.connect(user='scott', database='employees') cursor = cnx....
user avatar
  • 31.1k
2 votes

Search engine for MySQL product database with ~15k items

A look at Apache Solr or ElasticSearch might be useful. You can install them yourself or you can use some SaaS provider offering them.
user avatar
2 votes

Database software recommendation

MySql is a good choice for your usability and it is available on Amazon Cloud too.You could use PHP as a server side language to get the website up and running. Both PHP and MySql are reliable ...
user avatar
  • 37
2 votes

Technology stack for a Linux hosted web application

I'm a fan of the LAMP stack being, in my case: Linux (you've got Ubuntu) Apache MySQL (one of the requirements) PHP There's loads of free IDEs out there for PHP, you can use Eclipse, Netbeans or many ...
user avatar
  • 441
2 votes

Image Gallery Recommendations For Website

Check out Gallery3 it meets all you feature requests except for the feature request Responsive UI. Though there might be a responsive layout out there. These feature requests are met: Search (...
user avatar
2 votes
Accepted

MySQL Workbench equivalent with possibility of two-factor authentication

I am actually looking at this same issue myself, per my boss wants GUI access to our databases for himself and the developers at my company. I have found that Jetbrain's Datagrip works for 2FA (key ...
user avatar
2 votes

MySQL Workbench equivalent with possibility of two-factor authentication

Annoying that MySQL Workbench still lacks this in 2021: But, luckily, SSH tunnels can help. Simply SSH to the server using whatever client, then create the necessary tunnel. Since Ubuntu 20.04 LTS ...
user avatar
  • 121
2 votes
Accepted

GUI-based version control tool for MySQL

Providing that you, or your organisation, are ready to pay for it there is Datical DB which is a commercial tool built on top of Liquidbase and provides, amongst other stuff, a GUI interface. The web ...
user avatar
  • 31.1k
2 votes

Portable convert excel to mysql

Try https://sqlizer.io (I work here) which converts Excel (xls and xlsx) files to SQL databases. It's free for small databases (under 5000 rows) then costs $15. You have to tell it which worksheet and ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible