How to figure out what DB instance you are using when using isql (Sybase)

Today a coworker taught me how to figure out what database instance I am using when using the isql command line tool connecting to Sybase. This involves two query statements: select dbid from master..sysprocesses where spid = @@spid The above statement will display the dbid of the database instance you are using. Next using this […]

JavaOne 2010 Related Links

Here are some information that I found on the net about JavaOne 2010. Feel free to comment with additional resources. To start, Oracle posted some video highlights. If you have JavaOne login, you can view the full versions at On Demand site. If not, you can still see some of the contents here. Beyond that, […]

First impression on package mangement on Mac OS X

Ok. I’ve only used a Mac for a couple days, they were certainly long days with many steep learning experiences. Here are some of my comments: On Mac OS X, you have several options to install an application. You can use pre-packaged binaries such as Universal Binary or a platform specific installable binary for your […]

my.cnf for MySQL

Thanks to to folks at AFP548.com for the tip on my.cnf file. It worked for me beautifully.

MySQL to Postgres migration links

I just started looking into MySQL to Postgres migration. One of the differences between the two is LAST_INSERT_ID() for MySQL and CURRVAL(‘serial_variable’) for Postgres. Although there were many pages with examples about these, I found this page useful at explaining how to use the function. This page appears to be a good resource that lists […]

eSKUeL & dbengine: Web Admin interfaces for MySQL

I just gave a quick try for both eSKUeL & dbengine on Ubuntu 6.06. eSKUeL package did not install correctly. So, this isn’t really eSKUeL’s problem. Hope this works in the newer version of Ubuntu. eskuel installs. I tweaked the configuration file (/etc/dbengine.conf) and was able to access the first page at http://localhost/cgi-bin/dbengine.cgi However, it […]

Simiple mysql notes

After reading this manual, here are a few quick notes. mysql -h localhost -u root -p create DATABASE dbname; quit mysql –user=root -p dbname < dumpfile.sql

SQL: LEFT JOIN tables

Today, I found a need to show all rows in a table and add associated information from another table. After reading a SQL reference manual on LEFT JOIN, I gave it a try and it met my needs. Here is the general format: SELECT field1, field2 FROM table1 LEFT JOIN table2 ON condition1 WHERE condition2 […]

Import a CSV file to MySQL via phpMyAdmin

I was given access to an existing instance of MySQL via phpMyAdmin. My task was to import a CSV file using the import feature on phpMyAdmin. First, I went to the the main phpMyAdmin page. Next, I clicked on the database instance that I am interested. Then, I click on the table that I want […]

Comments on generating a web app from database tables

You think Hibernate is cool? Checkout what NetBeans 5.5 rc1 can do out-of-the-box. It can do O/R mapping, using bundled Hibernate, Top Link, KODO, or a persistence library of your choice. I am going to briefly describe high level steps on generating a web app from an existing Oracle database and generate simple JSF JSPs […]

Dave's Blogs

bits and pieces of information from Dave's daily life

Database