Re: [asterisk-users] PostgreSQL is asterisk friendly with it?
I use Postgres always and it is wonderful. Never use mysql so if you want a real DB just use Postgres *---* *-Edwin Quijada *-Developer DataBase *-JQ Microsistemas *-Soporte PostgreSQL *-www.jqmicrosistemas.com *-809-849-8087 *---* From: benny+use...@amorsen.dk To: brya...@zktech.com Date: Mon, 13 Sep 2010 20:24:25 +0200 CC: asterisk-users@lists.digium.com Subject: Re: [asterisk-users] PostgreSQL is asterisk friendly with it? Bryant Zimmerman brya...@zktech.com writes: As I look to move our systems to version 1.8 I am looking at making a change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully supported with asterisk? Yes. The ODBC drivers don't really care which database you access. Is there any down side to PostgreSQL over mySQL or will it be a big win? The only issue we have with Postgres is the dump/reload cycle when upgrading database version. This is being fixed in the latest versions though. Our database servers are linux but we access them from asterisk as well as windows are there any thing to be concerned with there? It works fine from Windows as well. /Benny -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
[asterisk-users] PostgreSQL is asterisk friendly with it?
As I look to move our systems to version 1.8 I am looking at making a change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully supported with asterisk? Is there any down side to PostgreSQL over mySQL or will it be a big win? Our database servers are linux but we access them from asterisk as well as windows are there any thing to be concerned with there? I use c#, vb.net and mono to do a lot of our stuff are there any issues I should know about? Thanks Bryant -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] PostgreSQL is asterisk friendly with it?
From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Bryant Zimmerman Sent: Monday, September 13, 2010 10:47 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] PostgreSQL is asterisk friendly with it? As I look to move our systems to version 1.8 I am looking at making a change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully supported with asterisk? Is there any down side to PostgreSQL over mySQL or will it be a big win? Our database servers are linux but we access them from asterisk as well as windows are there any thing to be concerned with there? I use c#, vb.net and mono to do a lot of our stuff are there any issues I should know about? Thanks Bryant In my experience, Asterisk plays much more nicely with MYSQL than POSTGRESQL. PostgreSQL is supported as ODBC vs NATIVE support for MYSQL. The downside that I'm aware of is that certain features of MYSQL aren't directly portable to PostgreSQL (blobs for example). Linux could care less. IMO, Asterisk will be a larger hurdle than C#, vb.net or mono to jump over. This is all in 1.4/1.6; some changes may have modified these answers regarding 1.8. -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] PostgreSQL is asterisk friendly with it?
On Mon, 13 Sep 2010, Danny Nicholas wrote: From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Bryant Zimmerman Sent: Monday, September 13, 2010 10:47 AM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] PostgreSQL is asterisk friendly with it? As I look to move our systems to version 1.8 I am looking at making a change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully supported with asterisk? Is there any down side to PostgreSQL over mySQL or will it be a big win? Our database servers are linux but we access them from asterisk as well as windows are there any thing to be concerned with there? I use c#, vb.net and mono to do a lot of our stuff are there any issues I should know about? Thanks Bryant In my experience, Asterisk plays much more nicely with MYSQL than POSTGRESQL. PostgreSQL is supported as ODBC vs NATIVE support for MYSQL. The downside that I'm aware of is that certain features of MYSQL aren't directly portable to PostgreSQL (blobs for example). Linux could care less. IMO, Asterisk will be a larger hurdle than C#, vb.net or mono to jump over. This is all in 1.4/1.6; some changes may have modified these answers regarding 1.8. Say what? I just looked at the 1.4 sources and PostgreSQL is NOT supported as ODBC. Those are direct library calls into libpq. Bryant, I've been using PostgreSQL with asterisk since I started using asterisk a number of years ago. There have been exactly ZERO issues with it. Vince. -- Michigan VHF Corp. http://www.nobucks.net/ http://www.CDupe.com/ -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] PostgreSQL is asterisk friendly with it?
On Mon, Sep 13, 2010 at 12:31:55PM -0400, Vince Vielhaber wrote: change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully [snippage and probably off topic] Why are you worried re the future of MySQL and it's new owners Oracle. a) MySQL is open source so anyone can take a fork and continue development. b) Oracle own InnoDB already which is the main storage engine for MySQL. c) Oracle dont have any low end DB products for start-ups etc. Developer licenses may be free, but commercial use certainly isn't. d) MySQL is now a business division within Oracle and MySQL (.com) makes money. e) Google have contributed a lot of code for MySQL v6, I'm sure they'd take it on if Oracle in madness decided to drop it. f) I'm sure Oracle will push Oracle on Sun hardware/Solaris for high-end DB platforms and optimise the two so the performance stats look great and so they'll develop a migration platform so high-end MySQL users can easily migrate to Oracle when the need arises. Steve -- NetTek Ltd UK mob +44 7775 755503 UK +44 20 7993 2612 / US +1 310 857 7715 / Fax +44 20 7483 2455 Skype/GoogleTalk/AIM/Gizmo/.Mac/Twitter/FriendFeed stevekennedyuk Euro Tech News Blog http://eurotechnews.blogspot.com MSN st...@gbnet.net -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] PostgreSQL is asterisk friendly with it?
I agree with Steve, I've had a couple of people speak with me about concerns of MySQL's new ownership, but I stand by the same reasons Steve doesMySQL will not be going anywhere, and if it does, someone'll just fork and keep it going under a new name. On Mon, Sep 13, 2010 at 11:46 AM, Steve Kennedy steve-aster...@gbnet.net wrote: On Mon, Sep 13, 2010 at 12:31:55PM -0400, Vince Vielhaber wrote: change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully [snippage and probably off topic] Why are you worried re the future of MySQL and it's new owners Oracle. a) MySQL is open source so anyone can take a fork and continue development. b) Oracle own InnoDB already which is the main storage engine for MySQL. c) Oracle dont have any low end DB products for start-ups etc. Developer licenses may be free, but commercial use certainly isn't. d) MySQL is now a business division within Oracle and MySQL (.com) makes money. e) Google have contributed a lot of code for MySQL v6, I'm sure they'd take it on if Oracle in madness decided to drop it. f) I'm sure Oracle will push Oracle on Sun hardware/Solaris for high-end DB platforms and optimise the two so the performance stats look great and so they'll develop a migration platform so high-end MySQL users can easily migrate to Oracle when the need arises. Steve -- NetTek Ltd UK mob +44 7775 755503 UK +44 20 7993 2612 / US +1 310 857 7715 / Fax +44 20 7483 2455 Skype/GoogleTalk/AIM/Gizmo/.Mac/Twitter/FriendFeed stevekennedyuk Euro Tech News Blog http://eurotechnews.blogspot.com MSN st...@gbnet.net -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
Re: [asterisk-users] PostgreSQL is asterisk friendly with it?
Bryant Zimmerman brya...@zktech.com writes: As I look to move our systems to version 1.8 I am looking at making a change from mySQL to PostgreSQL. I love mySQL but am getting very concerned about i'ts new owners. Should I be able to move all my realtime stuff to PostgreSQL is it fully supported with asterisk? Yes. The ODBC drivers don't really care which database you access. Is there any down side to PostgreSQL over mySQL or will it be a big win? The only issue we have with Postgres is the dump/reload cycle when upgrading database version. This is being fixed in the latest versions though. Our database servers are linux but we access them from asterisk as well as windows are there any thing to be concerned with there? It works fine from Windows as well. /Benny -- _ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
