VIDEO: PostgreSQL at 10 TB and beyond

If you’re interested in large databases and PostgreSQL, Chris Travers at Edument has been kind enough to share his experiences with such a setup (YouTube)

Share Button

How to install PostgreSQL 9 on Ubuntu Linux 10.04/10.10

Very easy, just add a repository and run apt-get install postresql-9.0 🙂

Dctr Watson explains how:

Installing PostgreSQL 9.0 on Ubuntu 10.04

Share Button

Why oh why can’t we have PostgreSQL’s CREATE [TEMPORARY] SEQUENCE in Sybase ASE?

I know you can simulate it by creating a temp table with an identity column, delete old rows, getSybase the max, etc but still… PostgreSQL’s create sequence would be very handy…  btw, Oracle has it too

It would allow us to do things like pgTAP with ease..  Check out the slides for pgTAP 🙂

just my opinion… grrrr

I’ve created ISUG enhancement request # 3449 for this.

Share Button

unable to create a SQL UDF in Sybase ASE using a case statement

create function ok (@boolean bit)
returns varchar(2000) as
declare @output_string varchar(2000)
select @output_string = case when @boolean = 1 then "" else "not " end
set @output_string = @output_string + "ok"
return @output_string

Msg 156, Level 15, State 2
Server ‘DBADEV1’, Procedure ‘ok’, Line 7
Incorrect syntax near the keyword ‘end’.
I’m trying to write an ASE implementation of TAP. A rudimentary TAP implementation for PostgreSQL is at
I’ve been able to use case in SQL UDFs before – see
Adaptive Server Enterprise/15.0.2/EBF 15654 ESD#4/P/Linux Intel/Linux 2.4.21-47.ELsmp i686/ase1502/2528/32-bit/FBO/Sat Apr 5 05:18:42 2008
I’m just missing something blindingly simple… I just know it.

Share Button

Native support of SQLite in Sybase PowerBuilder and PowerDesigner?

What I would love to see is native support for SQLite.

It is the most installed embedded database on the planet hands down.  Don’t believe me?  You know that Firefox web browser, Thunderbird newsreader, most Adobe products, Miro, etc all have it embedded?  – reference

We use it extensively at work as:

  1. staging for mass data imports/exports/conversions
  2. local application ‘cache’ for large data sets
  3. projects that don’t require all the features of Sybase ASE (or Oracle for that matter)

One of the best features is that the database itself in platform independent… copy the db on to AIX from your Windows box … then on to your old Amiga … then on to your windows mobile device.  Getting the point?  🙂

I really wish Sybase would make it so that the Sybase ASE databases were truly platform and character set/sort order independent… but that is in another dream 😉

Not a blurb in the PowerDesigner/PowerBuilder manuals or anything

Share Button