WoDaC gnome theme on Ubuntu
Mar 22nd
WoDaC 0.2 is pretty and nice idea for a dark theme. The original color scheme is based on pink color, but you will not have big problems if you choose another color scheme.
The size of toolbar incons are small (16×16), because i have created this theme for laptop with 1280×800 resolution.
The only requirement is Aurora GTK Engine 1.4
Aurora is an excellent Gtk 2 theme engine. It looks very great. The latest version of Aurora Gtk Engine is 1.4. Here I’ll show you how you can install it on Ubuntu 8.10 “Intrepid Ibex”.
Installing Aurora Gtk Engine
- Install build tools and all of the dependencies:
sudo aptitude install build-essential libgtk2.0-dev
- Download Aurora Gtk Engine 1.3 from here and save it to ~/Desktop folder.
- Extract the tarball files:
cd ~/Desktop tar jxvf Aurora-1.3.tar.bz2 tar zxvf aurora-1.3.tar.gz
- Configure, make and install:
cd aurora-1.3/ ./configure --prefix=/usr --enable-animation make sudo make install
Installing Aurora themes
You can run the following commands:
cd ../
tar jxvf gtkrc_themes.tar.bz2
sudo cp -r Aurora/ Aurora-looks/ Aurora-Midnight/ /usr/share/themes/
Using Aurora themes
- Click System → Appearance menu command.
- In Theme tab, click Customize button.
- Select Aurora Controls from Customize Theme window.
Installing WoDaC o.2
- Download theme from here
- Extrac the tarball files:
- Copy theme files to /usr/share/themes/
MySQL Workbench
Mar 21st
MySQL Workbench was recently rewritten from scratch and is now available in both free and commercial versions. The free version is not feature-crippled, but the commercial version includes some plug-ins that help automate tasks so that they require less manual work. At the time of this writing, the new version of the MySQL Workbench tool is still in beta.
It’s super-easy to use and I’ll just copy its feature list:
- Cairo based diagramming canvas which allows output to different targets such as OpenGL, Win32, X11, Quartz, PostScript, PDF etc
- visual representation of tables, views, stored procedure/functions and foreign keys
- live database and SQL script file reverse-engineering
- database/model synchronization
- SQL script generation
- extensible architecture
- export as SQL CREATE script
- import DBDesigner4 models
- support for MySQL 5 features
- selectable notations for diagram
For me, it’s a very useful tool for importing an SQL script, visually modifying it, and exporting a working SQL script. It’s also a cinch to just create ER diagrams in 5 damn minutes that look decent and map out foreign key relationships.
I’ve used DBD4 in the past as well as Aqua Data Studio and this tool gets me more excited. If you design or work with MySQL databases, you should check it out (see screenshots). Right now it’s Windows-only but they plan on releasing Linux and OSX in June, 2008.
Overall, very nice work MySQL — this tool is light years ahead of its predecessors.
MySQL developer tools
Mar 19th
MySQL Query Browser
MySQL Query Browser is a database querying tool that combines the simplicity of a Web-browser-like interface with powerful features like multiple result sets on tab sheets, query history, storing query “bookmarks”, editing and comparing resultsets, SQL script debugging, and more.
MySQL Query Browser can be used for tasks such as running queries, creating tables and stored procedures, exporting data, and browsing database structures. It has integrated documentation on MySQL’s SQL commands and functions. It is most useful for those who develop and query MySQL databases.
[http://www.mysql.com/products/tools/]
MySQL Administrator
MySQL Administrator is a powerful visual administration console for MySQL, which allows the user to easily administer their MySQL environment, and gain better visibility of how their databases are operating. It is available with native GUI interfaces for Windows, Linux, and Mac OS X.
MySQL Administrator is focused on server administration and is therefore most useful for DBAs, not developers or analysts. It helps automate tasks such as creating backups, creating users and assigning privileges, and viewing server logs and status information. It includes some basic monitoring functionality, such as graphing status variables, but is not as flexible as the interactive monitoring tools presented later in this post. It also doesn’t record the statistics for later analysis, which many other monitoring tools are designed to do.
[http://www.mysql.com/products/tools/]
MySQL Migration Toolkin
MySQL Migration Toolkit is a software pack to convert any data source to MySQL and vice versa. It includes the following utilities:
- Access-to-MySQL – migrates MS Access database to MySQL server;
- DBF-to-MySQL – moves DBase (dbf) databases to MySQL server;
- Excel-to-MySQL – converts MS Excel spreadsheet into MySQL database;
- MSSQL-to-MySQL – migrates MS SQL database to MySQL server;
- MySQL-to-Access – converts MySQL database into MS Access format;
- MySQL-to-DBF – converts MySQL databases into DBase (dbf) format;
- MySQL-to-Excel – converts MySQL database into MS Excel spreadsheet;
- MySQL-to-MSSQL – migrates MySQL database to MS SQL server;
- MySQL-to-Oracle – migrates MySQL database to Oracle server;
- Oracle-to-MySQL – migrates Oracle database to MySQL server.