Subsonic Forum

Can Subsonic read and write to PostgreSQL?

Currently i am working with MS SQL Server and Subsonic. Now i want to move to PostgreSQL. So can Subsonic read and write to PostgreSQL?

Please Reply Soon

Can you give a little more background on what you're trying to achieve?

i want to use PostgreSQL with subsonic? is it work?
how to implement it?

What have you tried so far?

Nothing, i want to know first is it work with PostgreSQL or not

An application is normally written to work with just one database. Subsonic is written to store all information in HSQLDB. To make it store information in another database, you have to alter the source code and build a new release.

During the last year, I've been working from and to on a Subsonic server that is more oriented towards music. I'm not a big fan of HSQLDB so I store all library metadata in PostgreSQL, but I still use HSQLDB for user settings. If that is useful to you, it's all open source, and you can read about it at http://dilerium.se/musiccabinet/.