RLB3.COM

8.3 upcoming Highlights

8.3 has numerous highlights just as previous versions, but we shall focus on our favorite ones.

• Support Security Service Provider Interface (SSPI) for authentication on Windows - which presumably will allow PostgreSQL databases to enjoy the same single signon you get with Microsoft SQL Server 7-2005.
• GSSAPI with Kerberos authentication as a new and improved authentication scheme for single signon
• Numerous performance improvements - too many to itemize
• The new QUERY functionality in plpgsql which offers a simpler way of returning result sets
• Scrollable cursors in PLPgSQL
• Improved shared buffers on windows
• TSearch - Full Text Search is now integrated into PostgreSQL instead of being a contrib module
• Support for SQL/XML and new XML datatype
• ENUM datatype
• New add-on feature to PgAdmin III - a PL debugger most compliments of EnterpriseDB

source

Simple things to do to make working with postgresql better...

Its day three, and I’m bored. We have barly written any code. I hope today we get more in-depth. Also so of the language constucts the choose for there database library is strange. For example:

// Traverse the items in startqueue to find items older than removeDays
    if (FetchRecord("DB_GTE", "Q_ISTAT_DB_QID_QSTIME_IDX", searchItem, resultItem))
    {
        do
        {
            if (resultItem.CurrentQID != searchItem.CurrentQID)
            {
                break;
            }

            if (resultItem.QStartTime <= checkDate)
            {
                // if item is to be deleted, then push it onto an array of items to delete
                itemsToDeleteArray.push(resultItem.ItemID);
            }
            else
            {
                // if item is too new to delete, then stop looping
                break;
            }
        } while (NextRecord("Q_ISTAT_DB_QID_QSTIME_IDX", resultItem, errbuf));
    }

I never thought I would see the day. Mysql 5 has gone gamma.

KirbyBase is a simple, pure-Ruby, flat-file database management system. This seems pretty slick. I wonder if there is something like this for perl?