Project Website | Online Demo | Forum |
It is currently Tue Oct 20, 2020 2:24 pm

All times are UTC + 1 hour [ DST ]





Post new topic Reply to topic  [ 3 posts ] 
  Print view Previous topic | Next topic 
Author Message
 Post subject: Multiple database support
PostPosted: Tue Dec 09, 2008 4:17 am 
Offline

Joined: Tue Dec 09, 2008 4:03 am
Posts: 1
I have only just downloaded Badger and haven't had a good look at the code yet, but I have a question regarding database support.

Does Badger support databases other than MySQL? I'm interested in PostgreSQL support myself. I know that the database schema can be altered where necessary easily enough, but I'm wondering if any attention is being paid to writing SQL queries in the code to be compatible with non-MySQL databases?

Does Badger use some sort of database abstraction method, eg PDO or similar?

I think the project should consider this matter of database support (especially in the code/queries) carefully otherwise you could end up like Joomla which is basically tied to MySQL now and most efforts to fix the problem have failed due to the enormous size of task.

Multiple database support is desirable for any web application, but should be considered especially for a financial application given that even the original developer of MySQL has problems with where it is going now:

http://monty-says.blogspot.com/2008/11/oops-we-did-it-again-mysql-51-released.html

All the best, great project. My vote is for PHP5, forget PHP4.


Top
 Profile  
 
 Post subject: Re: Multiple database support
PostPosted: Thu Dec 11, 2008 11:01 pm 
Offline
Site Admin
User avatar

Joined: Tue Mar 07, 2006 7:34 pm
Posts: 331
Hi mickh,

thanks for your interest in Badger.

For your question: We use a database abstraction layer. However, we never did a single test on any database different from MySQL. From what I recall, we don't use any special MySQL features in everyday Badger code, so you might give it a try with PostgreSQL, without any warranty. However, the update mechanism uses some SQL statements which might break other DBMSs.

Niko

_________________
BADGER finance lead backend developer and site admin


Top
 Profile  
 
 Post subject: Re: Multiple database support
PostPosted: Sun Sep 27, 2009 8:07 am 
Offline

Joined: Sun Sep 27, 2009 8:00 am
Posts: 1
can you explain how to install in postgresql.thanks!


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron




Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
Style supported by CodeMiles Team.