Oracle Database Sync

Oracle SQL Developer is full of nice feature, damned by a overwhelming options pane, like the one I will describe to you right now.

I will show here a very fast way of comparing different database and auto-generate migration script.

  1. Reverse engineer the source database using Oracle Data Modeler
  2. Now select the right arrow  shown below:
    sync-with-db
  3. Select the destination datasource (more here) when asked.
  4. The compare pane will enable you to compare the databases.
    But the default options will also use schema name to detect different object, so you will not get what you want in every scenario.
    In 50% of my daily job, schema are different, so you must select the options below to fix it:
    Select “Options” and then “Compare options”. Then  de-select “Use schema property” like suggested below:
    magic-option
  5. Push the “Sync new object”. Then push the “DLL Preview” button and inspect the generated database.
  6. Bonus: by default the tool will not include tables to drop. Inspect the two pane ad check the table you want to drop in the left pane.
  7. Refrain launching the script without proper testing. You are migrating your valuable data.

BBC Micro bit: first look

The BBC Micro bit an ARM-based embedded system designed by the BBC for use in computer education in the UK. The device has been given away free […] [to every 11 years old pupil] in the UK, and is also available for purchase by anyone.

This is the wikipedia definition.

micro_bit
The BBC:Micro compared with some coins: very small indeed

With a 5×5 led matrix, two buttons, a compass and a 3-axis accelermeter, this small unit has a lot of interesting suff packed for less then 17€ on Amazon


The core is an ARM CortexM with 16KB of RAM and 256KB of static flash for the code.

The Microbit web site offers a very huge set of videos and teaching material. But to regster you need to got an authorization code, because the site seems teacher-oriented, at least for publishing code samples.

It is not very easy to search for code samples, even if there is a bizzarre “site” index, who rememebrs me a 1995 web site :)

The micro:bit is plug and play: when you connect it on a PC  USB, a magic drive will appear. Simply copy your “hex” code on it and…no other steps are needed!

Comparing with an Arduino uno:

Pros

  1. Four different web editor (Microsoft Blocks, Microsoft Touch Develop, Code Kingdoms JavaScript and MicroPython) to start.
    No C language knowledge required.
    Install nothing and get ready in seconds.
    Very easy upload procedure (is a simple drive copy!)
  2. A lot more RAM then arduino (16Ks vs 2kBs)
  3. 3-more pin on the bottom and +3V and GND to attach extra leds/sensor and so on
  4. MicoPython-ready
    Very good collections of examples and demo at https://github.com/bbcmicrobit/micropython.The python runtime has a good hardware coverage too.
  5. Low power: only 3Volt needed for operation (Arduino needs at least double as far as I know, anyway can work in a wider range and can output 3.xV and 5V).
  6. Quite aggressive price.

Cons

  1. Very difficult to download an off-line editor. The online editors use a custom format to save your code. In general the platform seems a bit too close for “ordinary” people. Arduino is much more open. Anyway the micropython is open source and only need a free account on ARM web site (mbed.org). Also my attempt to build the python editor was unsuccessful. The python editor lacks compilation checks anyway.
    I was able to build Micropython with a bit of work on MacOSX
  2. Very very tiny.  For a 6/7 years old child is only “small”, for an adult is “tiny”.
  3. To access the smaller pins like I2C you need additional stuff and/or precise soldering

Anyway I was very impressed. Every Europe school should get one.

 

The End of the Apple Magic?

I have just read what Apple shown at the WWDC 2016.

In the 1985 Windows 1.0 was born. In a snap, the IBM compatible system evolved, and the competitive advantage of the Macintosh dried up and disappeared.

IBM PC was cheaper and way more open.

Like in the 1985, now in the 2016 the iPhone revolution has come to an end. After the Retina Display introduction, no real new feature was introduced. The apple Watch was beaten by competition.

Two years passed with no true innovation (i.e. Apple Watch is not a revolution).

The last MusicApp removed the beautiful cover navigation, and try to sell you the apple music rent service all the time, instead of let me play the music I have already bought.

If the WWDC2016 breaking news is a new file system, it is a very poor gift. I am writing this note on a Windows 10 PC. It is not a shining operating system it freeze a bit and has still a very ugly backup engine, but MacOSX is not the “most advanced operating system” anymore, like it used be in 2000.

MacOSX is the oldest one nowadays.

Historically Apple system are very closed. The reason is simple: when you go to your shareholders and ask for money, you can show you have a competitive advantage, a strong set of feature no one can take apart from you. But Apple lost this war in 1985, when the high pricey Macs cannot compete with open IBMs clones.

To be fair, IBM could open to clone market because its business was on high-end server, and Microsoft alliance will help to sell more IBM PCs.

Continue reading “The End of the Apple Magic?”