Thursday, February 12, 2015

Oracle 12c OCA study guide

I last did an Oracle certification in 2006, that was for 10g. Now I've decided to hit the books and work on achieving Oracle Certified Professional for 12c. But, one step at a time, and the first step is OCA. Below is a comparison between my old 10g book and the new 12c. I haven't done a thorough compare and contrast, but it's from the same publisher, and the text is the same font size. Looks like there's just that much more content!

Sunday, February 08, 2015


"The Schemaverse is a space-based strategy game implemented entirely within a PostgreSQL database. Compete against other players using raw SQL commands to command your fleet. Or, if your PL/pgSQL-foo is strong, wield it to write AI and have your fleet command itself!"

How fantastic is that? I'm still learning so I don't know if it's good as a game, but definitely a neat and educational idea. But it's reminding me of those old school, text-based BBS games I'd play in my teenage years...only controlled by postgres! 

Wednesday, February 04, 2015

Article: Don't use double quotes in PostgreSQL

Another good "why x is bad" article...I hate to overgeneralize, but it's simply true. This is one of those features that could maybe-kinda-sorta hypothetically be a good thing on rare occasion, but I've never seen those occasions.

I added this comment in reply:
Absolutely agreed. Oracle works similarly - when I first used the Oracle Enterprise Manager GUI tool about 11 years ago [correction: actually 12 - what year is it?? :)], I discovered it would, like PGAdmin, add double quotes as a courtesy for you. I could see this tripping up newbies while providing few benefits. They should teach this as fundamental wisdom in school: junk food is bad, drug abuse is bad, quotes in identifiers are bad.

Monday, February 02, 2015

Article: Pagination and OFFSET

An interesting post on why OFFSET is bad:

Also it provides a smarter way to paginate. In short, keep a last_seen_id and simply select "where id < last_seen_id".