Updates from thebigdog Toggle Comment Threads | Keyboard Shortcuts

  • thebigdog 19:56 on Tuesday, 23 February 2010 Permalink | Log in to leave a Comment
    Tags: database, dbvisualizer, mysql, postgresql, , sqlite   

    Product Review: DBVisualizer 7 

    I finally got my hands on a copy of the DBVisualizer. I have been ready to try version 7 out for a long time. It has some new features that I am really excited to try out. I have not used the product since version 5; yet, there are some killer things that I wanted to try out. I have been looking for a db tool that has some great Object management, searching and Graphing capabilities.

    First, let me talk a little about what has prompted me to get my hands on this great tool. DBVisualizer is a database tool that is written in Java and can run on various platforms; meaning I can run it on windows, linux and mac – and I do. It is fantastic to have a tool that I can run on all three and use it daily for all my database development. I do a lot of database development with a few different databases. As I work on mulitple databases, I find it difficult to move between different tools to perform similar tasks. Currently, I am working with the following databases: Oracle, MySQL, PostgreSQL and Sqlite. I do, every once in a while, access MS SQL Server and DB2. It is rare, but the occasion does arise. What I find frustrating is to have tools for each one or running stuff on the command line all the time. Don’t get me wrong, I love the command line, yet I do my job is a lot easier when I have one tool to handle all the different databases that I work with on a daily basis. For this reason, I have been eager to give DBVisualizer a spin.

    When I first started up DBVisualizer it was great to have database drivers already configured for me. That was one of the issues with previous version that they did not come with some preconfigured drivers that would allow me to get my database connections up and going. It was very easy to get MySQL, PostgreSQL, and SQLite up and running. I did have to get Oracle configured (that might be an issue with Oracle that it does not come pre-configured due to restrictions on the bundling the driver with the product). Either way I got it installed and configured.

    One new feature that I throughly enjoy is the concept of profiles for each database type. For example, there is a profile for MySQL, PostgreSQL and SQLite. This allows me to custom tailer my connections for my database types or I can have it use the auto detection to decide which one to use. I wish I had all the time to go into the other options that can be configured with the connection. There are setting for the type of connection with regards to the type of database I am working with: development, test, or production. I can also configure any JDBC options as well. The connection hooks come in handy for anything that I need to run right when the connection is made and when the connection is going to be disconnected. There are tons of other configuration items; you just have to check it out for yourself.

    I really like the additional of folders in the Database Tab. This has allowed me to organize my databases into folders and groups. I like to put all my database types in a specific folder. The Scripts Tab has really been useful for storing all my scripts that I tend to run over and over again. The Favorites Toolbar is a great addition for all my databases that I constantly access throughout the day.
    For some the Query Builder might be a one feature that is amazing. For me, I am not a big fan of the Query Builder; it is there for the using and it works great. For some, this might be just the thing that you need for your database development work.

    Another great feature that I have come to enjoy is the References Graph that can generate a graph based on the references between your tables. This has really helped me out to see a representation of the database in a nice simple graph, which I can then export or print.

    Sometimes as I am designing the database I need to do many different administrative tasks on the databases. DBVisualizer offers various actions that allow me to perform these tasks and they are accessed at different levels depending on the database object type that I am working with. These actions have really saved me time exporting and restoring a database.

    Another new feature that I wanted to check out was the Procedure Editor. I tried it out on creating some MySQL procedures and only felt that it lacked in the debugging of a procedure. That is it! It provides a clean and intuitive interface for creating functions and procedures. It is fantastic to use the same tool for creating functions and stored procedures in different databases. Then I was able to execute that code and test it out. I wish that it had line by line debugging of the procedure as that would save me some time and effort of some of the code that I was writing.

    Overall, I have been very impressed with DBVisualizer. The product is clean, stable and allows me to accomplish my tasks regardless of the database that I am connected with. There are a few items that I would love to see added to the product. Namely procedure debugging and integration with a content repository system like svn, cvs and or git. I have some projects that are database ones and it would be nice to work with them as a project instead of just opening files up and running the contents. Since this is a java based project and it uses JDBC drives, I would love to see some integration with some of the new cloud databases like CouchDB or some of the new ones coming out. That might already be in the works for the next version; just a thought.

     
  • thebigdog 12:23 on Monday, 15 June 2009 Permalink | Log in to leave a Comment  

    10 Advanced PHP Tips (Revisted) 

    Here is a an article that I think a few of us might enjoy. This article talks about 10 Advanced PHP Tips Revisited. Check out the article @ Smashing Magazine.

     
  • thebigdog 14:16 on Friday, 10 April 2009 Permalink | Log in to leave a Comment  

    Hate Reading and Writing HTML? 

    If you find that you are hate reading and writing HTML because it is so verbose, then check out this article.

     
  • thebigdog 15:35 on Friday, 28 April 2006 Permalink | Log in to leave a Comment  

    8 Free Apress eBooks 

    There are currently 8 ebooks available for free download from Apress. Check out the titles at Apress.

     
  • thebigdog 21:31 on Monday, 10 April 2006 Permalink | Log in to leave a Comment  

    Using PHP + MySQL with Dates and Times 

    With the recent discussion on the mailing list about dates and times and how they are stored in a MySQL database; I figured this article would provide some additional information on how others use dates and times. The article offers code examples and provides some clear logic and why not to use the normal timestamp for everything.

    Check out the article @ PHPit!

     
  • thebigdog 17:02 on Thursday, 6 April 2006 Permalink | Log in to leave a Comment  

    Great Article on Dovecot 

    Here is a great article on setting up a secure imap/pop3 server with Dovecot. After using Courier for a while I moved to Dovecot after a few conversations with some guys on #utah and dataw0lf. Since then i have never looked back!

    Read the article @ Linux.com

     
  • thebigdog 23:17 on Wednesday, 5 April 2006 Permalink | Log in to leave a Comment  

    CSS Pushpin Header by Cody Lindley 

    Cody Lindley gives a cool little example of how to add scrolling capabilities to your data grids with css and provides some great examples.

    Check it out @ Cody Lindley!

     
  • thebigdog 20:18 on Wednesday, 22 March 2006 Permalink | Log in to leave a Comment  

    Zend Eclipse PHP IDE (Plugin) 

    Zend has a preview release of the new eclipse plugin for PHP. Here is the link to check out the instructions for adding it to your eclipse version. If you have the UPHPU this will not work as the Zend Eclipse PHP IDE plugin requires that you have the full Eclipse SDK with the WST Plugin.

    http://www.zend.com/phpide/
    If you have the UPHPU Eclipse version you can upgrade your version to the eclipse SDK by using the update manager in eclipse.

    Help -> Sofware Updates -> Find and Install. Then you need to grab pretty much all the stuff in there that is for the SDK.

    Once you have the SDK then you can add the WebTools package that is required for the Zend Eclipse PHP IDE by setting up a new remote download site with the following values:

    Name: WebTools
    URL: http://download.eclipse.org/webtools/updates/

    Then you can add the Zend Remote Update site with the following values:

    Name: PHP IDE
    Value: http://downloads.zend.com/phpide/

    That will allow you to download and install the plugins. If you need any additional help i will be on irc to answer any install questions.

     
  • thebigdog 18:01 on Monday, 20 March 2006 Permalink | Log in to leave a Comment  

    UPHPU Eclipse for PHP Development 

    I have completed the UPHPU Eclipse versions for PHP development. Basically, I have stripped all the Java fluff and added various plugins for PHP development.

    You can download the following versions:
    Linux Mac Windows

    Let me know if you have any issues or problems.

     
  • thebigdog 21:29 on Friday, 27 January 2006 Permalink | Log in to leave a Comment  

    My little toolbox 

    I just finished reading an article on Linux.com that talks about useful tools that a system administrator uses. This is a great article to read and glean if you are doing any system administration with your PHP development. At work and as a contractor I can only stress the importance that a developer needs to be familiar with system administration. You can check out the article here.

    Here are some command line tools that i use almost on a daily bases to help out with system administration tasks.

    • find
    • xargs
    • sed
    • awk
    • nmap
    • netstat
    • bash shell scripting
    • column
    • expand
    • split
    • comm
    • sort
    • diff
    • dig
    • dsplit
    • du
    • df
    • free
    • grep
    • screen

    These are just some of the ones that I use. One point I would like to make is that by becoming familiar with additional commands you will start to become more proficient in your system admin tasks; obviously resulting in a sharper developer.

     
c
compose new post
j
next post/next comment
k
previous post/previous comment
r
reply
e
edit
o
show/hide comments
t
go to top
l
go to login
h
show/hide help
shift + esc
cancel