Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Lite 7
 AfterLogic Forum : AfterLogic WebMail Lite 7
Subject Topic: Database access and abstraction ? Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
sfrippiat
Newbie
Newbie


Joined: 15 October 2013
Location: Belgium
Online Status: Offline
Posts: 3
Posted: 15 October 2013 at 8:05am | IP Logged Quote sfrippiat
Hello.

I am interested in using AfterLogic but with a PostGreSQL database rather than a MySQL. I looked a bit in the code and it seems there are two ways to access the database: several files (most of them DAV folders) access it with PDOs but it seems the core uses plain mysql commands (which have been deprecated). Is it normal ? Are both ways currently used ?

Using PDOs everywhere could be a way to easily change the database backend (as it would require only to change the connection string) but I'd like to know if there are plans about this ? Any suggestions about where I should look first ?

Thanks,
Sebastien
Back to Top View sfrippiat's Profile Search for other posts by sfrippiat
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6043
Posted: 15 October 2013 at 11:30pm | IP Logged Quote Igor
PDO is only used when accessing DAV storage, while for other operations, it's still mysql_ functions. We're planning to implement PDO way throughout webmail in subsequent versions.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
sfrippiat
Newbie
Newbie


Joined: 15 October 2013
Location: Belgium
Online Status: Offline
Posts: 3
Posted: 15 October 2013 at 11:55pm | IP Logged Quote sfrippiat
Igor wrote:
PDO is only used when accessing DAV storage, while for other operations, it's still mysql_ functions. We're planning to implement PDO way throughout webmail in subsequent versions.

--
Regards,
Igor, AfterLogic Support


Any ETA ? Are you already working on it ?

I'll need this soon and the best would be to add PDOs and Postgresql support in a way that you integrate our changes in the official version.

Any tips/suggestions on achieving that ?
Back to Top View sfrippiat's Profile Search for other posts by sfrippiat
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6043
Posted: 16 October 2013 at 12:04am | IP Logged Quote Igor
As far as I can tell, this will probably be implemented in next release scheduled for first quarter of 2014.

--
Regards,
Igor, AfterLogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
sfrippiat
Newbie
Newbie


Joined: 15 October 2013
Location: Belgium
Online Status: Offline
Posts: 3
Posted: 17 October 2013 at 6:51am | IP Logged Quote sfrippiat
Thanks ! I'll probably hack around to have a quick version with PostrgreSQL support and wait for your version to have clean support.
Back to Top View sfrippiat's Profile Search for other posts by sfrippiat
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide