Resource Library

Sign up to get e-mails from Pythian on releases of Webinars, Papers & Books and Software.

 
required fields

Blog

Deferrable constraints in Oracle 11gR2 may lead to logically corrupted data

Alex Fatkulin

I’ve hit a bug in Oracle 11.2.0.1 when working with deferrable constraints which I think is worth sharing as it may have profound consequences under certain scenarios. Let’s start by creating a simple table with a deferrable primary key: SQL> create table def_bug(n number primary key deferrable initially deferred); Table created SQL> insert into def_bug values (1); 1 row inserted SQL> [...]

dpanneur – your friendly DarkPAN/CPAN proxy corner store

Yanick Champoux

CC BY-NC-SA 2.0 There were two things I have wanted to do for some time now. The first was to come up with a way to quickly and easily set up a DarkPAN mirror so that we would have more control over our dependency chain at work. The second was to make a portable CPAN proxy [...]

Log Buffer #182, a Carnival of the Vanities for DBAs

Sheeri Cabral

This is the 182nd edition of Log Buffer, the weekly review of database blogs. Make sure to read the whole edition so you do not miss where to submit your SQL limerick! This week started out with me posting about International Women’s Day, and has me personally attending Confoo (Montreal) which is an excellent conference [...]

Liveblogging at Confoo: Blending NoSQL and SQL

Sheeri Cabral

Persistence Smoothie: Blending NoSQL and SQL – see user feedback and comments at http://joind.in/talk/view/1332. Michael Bleigh from Intridea, high-end Ruby and Ruby on Rails consultants, build apps from start to finish, making it scalable. He’s written a lot of stuff, available at http://github.com/intridea. @mbleigh on twitter NoSQL is a new way to think [...]