Best Free Database Development Tool

LyteRAD CE

Building complete database applications could'nt be easier than this. Zero code tools have been around for a while, but this is probably the best of its kind for building small light weight database applications. The CE edition is free and comes with an embedded maintenance free database, so that you can focus on building applications and forget about database administration. The widget pallette allows you to build quite complex applications with little effort. And to top it off LyteRAD also connects to industry standard databases for higher reliability and robustness.

You can download the tool here

http://www.lytecube.com/index.html

For more information visit www.lytecube.com

have you try heidiSQL(MySQL), SquirrelSQL, AnySQL Maestro?

MySQL Workbench is a good tool, too.

I tried LyteRAD CE and found it is a good start but has major deficiencies.

The reporting is inadequate. Even though it has a wizard to set the size, etc of columns, it doesn't work - all columns are set the same. Data doesn't wrap when it is longer than the column and there is no way to set for that.

The application is written in Java and takes a long time to load.

With further development, this could be a good tool. But, as it stands, it is not ready for prime time.

DBEdit 2
A light weight database editing tool for Oracle, DB2 and MySQL. Free and open source.
http://dbedit2.sourceforge.net/

Best free RAD for MySQL is SQLYog Community edition.

Why not use SQL-Express ?

I have just discovered Toad by Quest. It is excellent and totally free. Create either local or online databases, compare and synchronize them, etc etc. Just the job and very easy to use. http://www.quest.com/toad-for-mysql/

According to information on their website, the free edition is limited to 10 fields in a table, and a maximum of 2000 records. See http://www.lytecube.com/products/lyteRAD/featr_matrix.html for a full comparison between the free and paid editions.

Do you have any other recommendations ?

Post new comment

  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <b> <address> <blockquote> <br> <caption> <center> <code> <dd> <del> <div> <dl> <dt> <em> <font> <h2> <h3> <h4> <h5> <h6> <hr> <i> <img> <li> <ol> <p> <pre> <span> <strong> <sub> <sup> <table> <tbody> <td> <tfoot> <th> <thead> <tr> <u> <ul> <tr>
  • Lines and paragraphs break automatically.

More information about formatting options