LewisC’s An Expert’s Guide To Oracle Technology

Looks like I have a new boss. Actually, it looks like my boss’s boss has a new boss.

I’d like to personally welcome Ed Boyajian to EnterpriseDB. Looks like he has quite a bit of experience with OSS and monetizing software solutions. He’s been an executive at Redhat for a long time. 6 years in his last position but in many other positions before that.

We (EnterpriseDB employees) have known this was coming for a while now. I knew Andy and the board were looking when I was hired. I just now learned the name of the chosen, though.

I’ve added quite a bit to the site over the last couple of nights. I have firmed up the menus. I’ve converted all of the pages to server side includes (SSI). This makes it dramatically easier to maintain.
I’ve also started adding the real content. This site will take a long time to be complete. Actually, [...]

LewisC’s An Expert’s Guide To Oracle Technology

The datastore in Postgres (which is what Advanced Server is based on) is quite a bit different than the way Oracle stores data. Gone are the usual logical storage components. Data blocks, extents and segments just don’t exist in a Postgres database. Actually, segments do exist when a table gets bigger than 1GB but that’s a story for a different entry.

Postgres stores data as files and directories. Tablespaces are directories and tables (and indexes) are files inside that directory. Postgres ships with two tablespaces installed by default: pg_default and pg_global. The tablespaces cannot be changed or dropped.

LewisC’s An Expert’s Guide To Oracle Technology

Sun just announced MySQL Workbench, a new database design tool for MySQL developers and DBAs. I’m a data modeling tool junkie. I like to play with any I can get my hands on. I’ve used almost every modeling tool that’s been built. My all time favorite is probably Erwin.

I decided to download MySQL Workbench and give it a try. Since I was playing with it, I figured I should write about it and while I am writing about it, I might as well write about a couple of other tools, that I have personally used, that you might like.

TOAD Data Modeler

The TOAD Data Modeler from Quest used to have a free version.