Home » Databases » Sybase » ASE » Native support of SQLite in Sybase PowerBuilder and PowerDesigner?

Native support of SQLite in Sybase PowerBuilder and PowerDesigner?

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:

  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


  1. Roland Smith says:

    I have successfully tested connecting to a SQLite database from PowerBuilder. Just install the ODBC driver from http://www.ch-werner.de/sqliteodbc. I also found a nice graphical designer at http://sqliteadmin.orbmu2k.de. Theoretically you should be able to add entries to pbodb###.ini to allow the PB Database Painter to create tables. I haven’t had time to look into this.

Leave a Reply

Your email address will not be published. Required fields are marked *


Facebook login by WP-FB-AutoConnect