PostgreSQL?

This is a forum to suggest new features for mojoPortal. 

This thread is closed to new posts. You must sign in to post in the forums.
10/28/2004 4:57:52 AM
Gravatar
Total Posts 18439

PostgreSQL?

Lately I've been reading a bit about PostgreSQL. It claims to be and appears to in fact be the most advanced open source database while MySQL claims to be the most popular. Since PostegreSQL has been around quite a bit longer and is more advanced, it begs the question, why isn't PostgreSQL the most popular?

I am thinking of adding a data layer to support PostgreSQL. Anyone else out there who would like this?

11/9/2004 10:58:44 PM
Gravatar
Total Posts 2

Re: PostgreSQL?

MySQL is more porpular because it has better marketing, more books, and has a lower learning curve (this last bit is relative).  It also is not ANSI SQL '99 compliant.

I would also recommend that you make the Forums and Blogs modular.  That is, like the ability to chose the database, why not the ability to chose the Forums and Blogs packages?

I will play with this product on monoforge.

I am impressed with your architectural approach.

Are you using C#?  (Just curious).

Cheers.
11/10/2004 1:54:11 AM
Gravatar
Total Posts 18439

Re: PostgreSQL?

Thanks for the information about MySQL vs PostgreSQL.

This project is in C#, I guess I should make that clear on the home page.

I'm not sure what you mean by the suggestion of being able to choose blogs or forums. They are both features built into the mojoPortal framework you can use them or not use them. I don't see how I could possibly make other blog or forum software integrate easily if that is what you are suggesting since I have no control over how they work or what technologies they use and there is no universal architecture that allows one to mix and match. One would have to write code for each supported blog or forum. That said, all the features in mojoPortal are modular, if someone wants to make a better blog or forums module that does plug in to mojoPortal it is certainly possible however it would seem easier to improve on the ones I've already built. Another option is you can always setup a blog or forum using other software and just link to it from a mojoPortal site.

11/10/2004 3:58:30 PM
Gravatar
Total Posts 2

Re: PostgreSQL?

I understand your architecture better now.  Point well made.  Ok....let me ask another similar question:  What if I have 2+ years of Bloggs and Forum posts in another system, e.g. WordPress and phpBB.  Then how would I migrate my data to mojoPortal?  Is migration even possible?  I know there are many Blogging systems and Forum software out there, so this too can become a difficult thing to realize.  But, it may be worth it for the more popular Blogs and Forums.  Just a thought.  Great software is NOT developed in a vacuum.  I just wanted to pose the questions.  Something, more can be learned from the question, than the answer.

I will definitely kick the tires (so to speak) on mojoPortal.

Good luck. 

-Julio
11/10/2004 4:15:32 PM
Gravatar
Total Posts 18439

Re: PostgreSQL?

I think much of the answer to your question depends on what database your data is in and how well the schema can be mapped to the mojoPortal blog and forum tables. If your data is in MySQL it would be fairly straight forward to write queries to migrate from your current data schema (for someone with good knowledge of MySQL). I'm assuming you're not using MS SQL due to the apps you mention. I don't know what dbs they use but most likely not MS.

I would love to be able to offer a migration wizard or something like that to make it easy for non SQL gurus to do migration from other systems but I have a lot of other features to work on before that.

1/19/2005 4:50:03 PM
Gravatar
Total Posts 18439

Re: PostgreSQL?

I've learned enough about PostgreSQL now that I'm convinced I definitely want to support it with mojoPortal. Not sure of the timeline but its on the agenda.
2/11/2005 2:50:48 AM
Gravatar
Total Posts 1

Re: PostgreSQL?

Hey all,

Just linked to this project off the Monologue and I found a thread I can contribute to :-)

Postgres is excellent. As compared to MySQL it is a much older project (roots in DARPA, ARO, NSF, ESL and Berkeley in the 80's under Stonebraker) and more feature rich. I've only used MySQL a few times so I can't comment too much on whether Postgres is better however it is definatly something you should consider supporting. I hope to play around with mojoPortal soon and I'd like to be able to hook it up to my favorite database for sure :-D

I'll be poppin in and out and hope to contribute soon (I'm a big fan of the Mono project and can't think of a better way to learn ASP.Net)

Cheers

- flip

You must sign in to post in the forums. This thread is closed to new posts.