- Joined
- Dec 13, 2006
- Messages
- 11,353
- Reaction score
- 3,179
Since I was doing some database work today for several of my sites, I thought I would share a couple of very nice tools to use:
Navicat - Navicat is what I use to attach to my database and run queries. The nice part about this tool is that it allows me to create querys by simply selecting tables and fields (no code writing). I can test those queries and then use them in my programming. Very nice, but does cost $179 (I use Navicat for MySQL since that is my database type)
DBDesigner 4 - DBDesigner is what I use to create my databases. It is a database design software that allows you to model your database and then create the SQL code to create the database (I use Navicat to run the SQL code). Very nice.... FREE.
Anyone else use anything different?
Navicat - Navicat is what I use to attach to my database and run queries. The nice part about this tool is that it allows me to create querys by simply selecting tables and fields (no code writing). I can test those queries and then use them in my programming. Very nice, but does cost $179 (I use Navicat for MySQL since that is my database type)
DBDesigner 4 - DBDesigner is what I use to create my databases. It is a database design software that allows you to model your database and then create the SQL code to create the database (I use Navicat to run the SQL code). Very nice.... FREE.
Anyone else use anything different?