Friday, January 30, 2009

Create some dynamic data

When you are developing an application with a new database design (or an existing database design, but you didn't get any data), it can be handy to quickly create some test data in your tables.

Sure you can create some data manual to test your input forms, but what if you need more data? Or you want to test the performance with a large amounts of records.

Here's a simple select statement that creates you 25.000 random numbers and strings (you can change the number to whatever number you like):

SELECT rownum RNUM
, ABS(MOD(dbms_random.random,100000)) RANDOM_NBR
, dbms_random.string('A', 20) RANDOM_STR
FROM dual
CONNECT BY level <= 25000

You could also create a little procedure that populates your tables with it as you probably have some relationships going on as well (PK-FK). I just needed a select that generates me huge amount of records to test some charts in APEX with.

Update (thanks to Rob - see comments): dbms_random should not be used anymore, see the 10g and 11g documentation. So the select statement from 10g onwards would be:

SELECT rownum RNUM
, trunc(dbms_random.value(1,100000)) RANDOM_NBR
, dbms_random.string('A', 20) RANDOM_STR
FROM dual
CONNECT BY level <= 25000

Friday, January 23, 2009

Anychart 5.1 released

Today Anychart released version 5.1 of their charting product. I really looked forward to this release as it has some really nice features in!

We are currently working hard to get it compatible with the APEX integration kit, so if you're using this together with our kit, you'll need to wait a bit longer before doing the upgrade.

Here are some of my favorite new features:


Scrolling Support

All X / Y Axes based charts (Bar, Line, Area, Candlestick, etc.) can have Axes with scroll bar. You can also control the scroll barts with Javascript.






Heat Map Chart

Heatmap Charts, allows you to give graphical representation of data where the values taken by a variable in a two-dimensional map are represented as colors.

If you hover the legend the right numbers light up.



2D/3D Funnel Charts

Feature rich Funnel Charts both in 2D and 3D, smart labeling, animation, neck control and man more option.







3D Pie Charts and 3D Doughnut Charts

Nice looking, interactive 3D Pie Charts and 3D Doughnut Charts with Animation and all features of regular flat Pie and Doughnut Charts.






There are a lot of other nice features like Multiple X-Axis Support, One or more Interactive Labels or Tooltips, a combination of any chart type in a Dashboard etc. The complete list of changes you find here.

But as a last one... some people told me they would like to have better performance in their charts. Anychart 5.1 will help you with that!

AnyChart 5.1 is based on a new charting engine, which made it possible to improve performance and decrease rendering and update time dramatically. The new engine also allows to used larger data sets without significant time lags, and this applies to all chart types, including AnyMap extension. The below chart says enough...


PS: If you want to buy Anychart 5.1 you can still use the coupon code APEX15 to get a 15% discount!

Wednesday, January 21, 2009

One day APEX seminar by UK APEX SIG

The UK APEX SIG is kicking off with a one day free seminar on Friday 13th February in the Oracle City Office in London.

There will be five presentation by different speakers and you'll have also time to ask questions to the Experts. Justin Hudd, the organizer behind the event, will start with an introduction, shortly followed by following presentations:

  • Latest & Greatest from Development by David Peake
  • Apex @ Oracle – Learn How Oracle Utilises Application Express by Anthony Rayner
  • What happens on an APEX Page? by Dimitri Gielis (me)
  • Using Apex to Expose your Business to the Web by Matt Nolan & Vincent Migue
  • Dispelling Myths about Application Express by John Scott
We'll finish the day with an Apex Forum where you can ask any question... and then the bar!

I booked my flight to Belgium the following day, so I don't mind still talking about APEX with some drinks and food till late at night ;-)

Hope to see you there! (more info, see agenda)

Update from UKOUG: If you are a UKOUG member you can attend for free. But there is a non-member rate set up of £160 plus VAT. As members of UKOUG you get one space per membership free, then any additional places are charged the members rate of £80 plus VAT.


PS: We got some questions if our 3-day European APEX Training Days of March are still on? The answer is yes! We're handling the last details for the location (will be in Manchester, UK). More information will follow shortly.

Friday, January 16, 2009

JQuery UI, ThemeRoller and transparent datepicker

Recently we had some issues with JQuery UI which didn't render the widgets correctly.

An example of a JQuery UI widget is the datepicker (screenshot), like you can see working on Apex Blogs

If you want to change the look and feel of the date picker (or any other widget) you can do that by creating a new theme on the ThemeRoller site or by selecting one of the gallery.

However while we did that our datepicker became transparent and it looked like it couldn't find the css or the background images anymore. As we already used it in more projects, we were sure our code was right.

Finally we found that a different version of the JQuery UI can get you into that situation. The fix then is to use the version you know your css works with or to download the latest version of JQuery UI and create the theme again from the site and use that instead.