AnySQL.net English

    After some research of MySQL, Yong Huang gave me a excellent advice to add a new feature in AnySQL, to display in the form mode other than grid mode. This feature is very useful when display few rows with lots of columns. Let's get some objects for testing.

ASQL> select * from tab where rownum < 5;

TNAME      TABTYPE CLUSTERID
---------- ------- ---------
BONUS      TABLE
CLU_A      CLUSTER
CR_5043802 TABLE
DEPT       TABLE

4 rows returned.

    Then we are required to display the object information from table "USER_OBJECTS", by adding one of patterns ("/g","/G","\G","\g") to the standard select statement, the row will be displayed in form mode. As following.

ASQL> select * from user_objects where object_name='BONUS'/g;

OBJECT_NAME                   : BONUS
SUBOBJECT_NAME                : null
OBJECT_ID                     : 637961
DATA_OBJECT_ID                : 637961
OBJECT_TYPE                   : TABLE
CREATED                       : 2007-05-16 22:03:27.0
LAST_DDL_TIME                 : 2007-05-16 22:03:27.0
TIMESTAMP                     : 2007-05-16:22:03:27
STATUS                        : VALID
TEMPORARY                     : N
GENERATED                     : N
SECONDARY                     : N

1 rows returned.

    Download patch if you want to enjoy it!

    Oracle will release 11g soon, from the white paper, we can see that Oracle made some big changes to the compress tables, it will support for OLTP system, and help you to save about 50% of the storage. Because of CPU are faster and faster, but IO are really slowly improved compare to the CPU technology. So I have to enable the compress table support for my data recovery tool -- AUL/MyDUL. This is really a big challenge for me.

    I spent some time to continue the oracle log format research, and now I can basically extract the SQL from the redo log file (Sample). Because Oracle 11g will support open-recovery standby database, so this research have less and less value to me to convert it to a useful disaster recovery tools. I have very less resource and cannot get it done by personal. So I decide to open source it, anybody have experience of the open source? I want somebody to join the development, or anybody have fun?

    Is open source good for a people who are busy in making the live.