Hot answers tagged

15

I love Sequel Pro: It supports just about everything I would ever need in a MySQL client - and I much prefer it to the command line. It supports connecting in just about every way, here's the login screen: A great GUI is presented for each table on the schema tab: Full command line access to the DB is available: One can even manage users (if one has ...


10

You don't run a forum on apache alone, you need a php and mysql install too. You aren't going to need phpmyadmin unless you're directly working on the database or for initial install. I used phpmyadmin for my first install but I do it correctly these days. Simple Machine Forums is what I tend to use - it's freeware with no ads, works on shared hosting, or ...


9

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 from the website: This tool allows you to draw and create database schemas (E-R diagrams) directly in browser, without the need for any external programs ...


8

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


6

You can use MySQL Workbench: free works on Windows/Linux/Mac straightforward to install ( it's a desktop application, not a web interface. No need for PHP. syntax highlighting auto completion SQL documentation on the side in addition to the SQL Editor, you can design visually database (usual EER) and administer the database. SQL Editor: Visual Database ...


6

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 regular expressions. It is free and open-source. Example diagram: Sualeh Fatehi, SchemaCrawler


5

For a purely programmatic solution, I'd recommend the Oracle provided Python-MySQL Connector. It is GPL licensed or you can purchase a different license as well. I have only used it a bit so I can't comment on ease of use for advanced functionality but simple queries work fine and fast. There is also quite good documentation including some examples ...


5

I've always like PHPBB (from a management standpoint - though I haven't dealt with more than hmm 3 or 4k registered users (ie a max of a hundred active users)) To run down your features: No ads: Yep none of that ugly stuff. Fully customisable or an option to choose from various themes Open-Source and fully customizable - and has a massive amount of themes/...


5

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 a large number of databases. It does support database schema visualization. Here is an image taken from their website:


5

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), it will import from an existing database and allow you to examine it's structure. This is the standard tool for all MySql manipulation, from the developers of ...


4

I have always liked MyBB as a free forum board choice. It combines a great default UI and an excellent looking Admin Panel. I prefer MyBB over others because of the easy to use UI for myself, the administrator, and the users. Features Nope, no ads Runs on php 5.1.0+ and phpmyadmin compatible (so yes on apache assuming you have php, and MySQL 4.0+ ...


4

The official Oracle product Download MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X. ...


4

An interface is a rather broad term, but if you are looking to manage your SQL databases with a GUI, SQuirreL is the most powerful and versatile option. It's not pretty, but once it's set up, it's one of the best tools out there. I have used it for Oracle, Microsoft, MySQL and PostgreSQL databases with no issues. It's a Java application, so it doesn't ...


4

You can simply export the spreadsheet in Microsoft Excel as a CSV, then use MySQL Workbench's import function: This solution supports support cells containing line breaks and support cells containing '. However, it doesn't support all special characters as the Excel to CSV export will mangle the special characters that aren't ASCII characters. To perform an ...


3

MySQL / MariaDB includes a nice utility called mysqldump which does the job quite handily when coupled with cron. Everybody and their brother has written a howto on scripting mysqldump from cron. Make sure to investigate the --single-transaction option and how to store the username / password in a user options file rather than passing them as command line ...


3

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 your data. Your app used it for creating, reading, updating or deleting (CRUD) records/entities/rows of information. If you were given an instance/virtual ...


3

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 ignore or remove columns you don't want easily enough. In my biased opinion it is simply the most accurate, easiest and fastest way to import Excel spreadsheets ...


3

I'm developing a database explorer with a focus on breadth, not depth. It is written in Python 2, which is likely already installed on your server. Right now it won't let you run arbitrary queries , but that is high on the feature list. Squeal now supports running arbitrary SQL queries! Note that the application is in a very early stage of development. ...


3

I would use MySQL as RDBMS and MySQL Workbench as IDE: free works on Windows/Linux/Mac straightforward to install (to make it simpler you could even install MySQL on some server, and just have your interns connect to it) syntax highlighting auto completion SQL documentation on the side in addition to the SQL Editor, you can design visually database (usual ...


3

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 helps. MySQL ODBC (FREE, but basic and limited) Description With MySQL ODBC you can finally manage MySQL servers any where , any time . This software ...


3

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


3

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 platforms in use, including Oracle, MySQL, and Postgres, as well as limited support for any target that can be accessed through Qt's ODBC support. TOra has ...


3

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.zip. The script will validate and sanitize the email address. I made comments in the index.php file (it's simple). If you have any questions, ask away:) Here is ...


3

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: Selecting the Create View command from the Tables tab page of a database document, you see the View Design window that resembles the Query Design window ...


3

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' | xargs mysqldump --no-create-db -uUSER -p SRC_DB > CREATE_DB_DST.sql where: USER is a user with read access in SRC_DB SRC_DB is the database you want to ...


2

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 just need to find my email :) A few neat things this tool offers are: The ‘database tree’ provides multiple levels of detail, including tables, columns, indexes ...


2

The application I have used the most for accessing MySQL remote and local databases and designing MySQL databases has been MySQL Workbench. Here is the feature list. It is available as a commercial and community version. Version 6 was released last year; however, their older version, 5.x is still available as well which is helpful in some cases depending ...


2

I'd give them sqlite - it's perfect for beginning situations like this: The DB is in a single file, making it really easy to start using, and really easy to reset if you screw it up. The DB engine is a single executable - just type sqlite3 <db file name> to get started. Imports from CSV are pretty easy. Supports the usual set of SQL operations. The ...


2

I would recommend phpMyAdmin - works with MySQL (also MarioDB & Drizzle though I can't comment on the those). It does require PHP and MySQL/MarioDB/Drizzle - WAMP has it pre-setup through the installer if you want a simple Windows installation solution. With phpMyAdmin you have full console abilities and also a very very easy to play with learn from/use ...


2

One solution is to add auto-saving in the IDE and auto-loading in the browser. Auto-saving in the IDE: you can use Eclipse + some autosave plugins like Save dirty Editor Eclipse Plugin or Smart Save Auto-loading the browser: I use Auto-Reload on Google Chrome Since your pages are in PHP you'll need some PHP server on your machine. I often use WAMP on ...


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