I was away for vacation then went into hiding while I brushed up on my Oracle skills for work. All I can say is that I have a lot of material to put into the MyDatabases magazine this week. So much to do it is hard to find time to get any of it done lately. Oh well. The next issue should be out this coming weekend.
I know you can simulate it by creating a temp table with an identity column, delete old rows, get the max, etc but still… PostgreSQL’s create sequence would be very handy… btw, Oracle has it too
just my opinion… grrrr
I’ve created ISUG enhancement request # 3449 for this.
What I would love to see is native support for SQLite. http://www.sqlite.org
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 http://www.sqlite.org/mostdeployed.html
We use it extensively at work as:
- staging for mass data imports/exports/conversions
- local application ‘cache’ for large data sets
- 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 wishwould 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