News for hackers. Stuff that matters.
Re:Top Reasons I like Postgres Over SQL Server by cpher on Monday April 08, 2013 @01:53PM (#5513290)
Yeah, we have issues with SSRS and Crystal Reports in cross-browser environments. i.e. the "preview" never looks like what you intend. Instead, we work around it by exporting directly to disk, which seems to keep the WYSIWYG aspect.

I'm more interested to know how MS people have integrated PostGres into their environments. Which ORMs work? What are the gotchas, etc?

Re:Top Reasons I like Postgres Over SQL Server by hp50g on Monday April 08, 2013 @02:43PM (#5513638)
Nhibernate. No issues.

To be honest we're shifting to java. Our license fees are well into 7 figures for MS stuff for no gain. This is the first step. Some subsystems are moving from asp.net web forms+mvc to spring, tomcat, hibernate, postgres. Cost savings are huge, staff available are orders of magnitude better and reliability is higher as to be honest, windows has been a piece of shit to manage over the last 10 years.

Fortunately we've got a pretty well designed system so we can move it over piecemeal as and when we update major subsystem features.

Re:Top Reasons I like Postgres Over SQL Server by tracker1 on Monday April 08, 2013 @04:29PM (#5514342)
Wow, my experience has been a bit different. Every Java project I've worked on has been an exercise in frustration... Though a lot of the .Net projects I've worked on I can say the same.

I think that NodeJS + MongoDB has been the least resistance I've seen so far... though some of its' limitations are really frustrating (non-indexed result limitations). I like Postgres at least as much as MS-SQL Server. And the Entity Framework generators have been close to a blessing. That said, I'm much more of a fan of the DB as dumb storage, and not a big fan of SSIS. So changing from one DB to another is mostly transparent when things are how I prefer them.

Re:Top Reasons I like Postgres Over SQL Server by cpher on Monday April 08, 2013 @07:02PM (#5515309)
Well, we can't shift to Java--we're consultants. We're a total MS and esri (GIS) shop. I was hoping for some hints that ASP.NET could integrate smoothly w/ PostGres in order to offer something else to clients.
Re:Top Reasons I like Postgres Over SQL Server by avenger123 on Monday April 08, 2013 @03:44PM (#5514030)
I also think LLBLGEN PRO (http://www.llblgen.com/) is highly underrated.

There are commercial providers but npgsql- http://npgsql.projects.pgfoundry.org/, works well.

Re:Top Reasons I like Postgres Over SQL Server by sitharus on Tuesday April 09, 2013 @01:24AM (#5516575)
As someone who works on a project that extensively uses LLBLGen Pro I'd have to disagree with you.
Re:Top Reasons I like Postgres Over SQL Server by avenger123 on Tuesday April 09, 2013 @03:22AM (#5516863)
Would you mind elaborating on this a bit? I would love to hear about it.

I understand that some people get turned off by the code generation aspect of it, but what in particular didn't you like about it.

Re:Top Reasons I like Postgres Over SQL Server by HarshaThota on Monday April 08, 2013 @03:31PM (#5513942)
Re:Top Reasons I like Postgres Over SQL Server by cpher on Monday April 08, 2013 @06:57PM (#5515273)
I've looked at PetaPoco and Massive as a replacement for Linq2Sql, etc but don't know what experience others have had with it. We're mostly a MSSQL shop, but are seeing more Oracle projects. And now that PostGres is becoming stable in our GIS environment I'd like to know how people are dealing with multiple DB backends. Have you built anything in production with PetaPoco?
Re:Top Reasons I like Postgres Over SQL Server by avenger123 on Monday April 08, 2013 @09:45PM (#5515981)
I would really recommend you check out Llblgen Pro. The name is just weird but its a really good ORM.

The support it has for all the major databases (SQL Server, Oracle, Postgres) and others is really solid.

Also, there is a full Linq provider that works well.

Re:Top Reasons I like Postgres Over SQL Server by pbz on Tuesday April 09, 2013 @05:52AM (#5517157)
I would recommend BLToolkit (and the newer lighter version Linq2Db -- not to be confused with Linq to SQL). You keep an abstraction level above raw SQL via LINQ and with multiple DB providers you can easily switch between databases without rewriting your queries (provided you don't use any DB-specific features).
Re:Top Reasons I like Postgres Over SQL Server by taude on Tuesday April 09, 2013 @09:59AM (#5518051)
Check out the lightweight ServiceStack postgres ORM for light-weight usage, consider it more on par featurwise with Linq2SQL: http://nuget.org/packages/ServiceStack.OrmLite.PostgreSQL

Edit: just noticed someone posted this below. Sorry.