Poll: What database does your company use? • Hacker News Board

Re: Poll: What database does your company use?

#131

Post by michaelschade » Wed, Jun 22, 2011, 9:32 PM UTC

sc68cal wrote: post #114

michaelschade wrote: post #68

Earlier quoted context omitted.

Love SQLite when doing some Django development. Great to easily scrap the database with a quick `rm` and repopulate with good data.

I've been breaking myself of that habit: I try and use the flush command so I don't have to keep doing the superuser creation step. https://docs.djangoproject.com/en/dev/ref/django-admin/?from...

Good point, as the superuser creation bit does tend to get annoying. But you have to admit–there's something much more fun about getting to rm your db ;)

Re: Poll: What database does your company use?

#132

Post by hkadejo » Wed, Jun 22, 2011, 9:33 PM UTC

The Ministry of Finance of the government of El Salvador, where I work, we use Oracle 11g

Re: Poll: What database does your company use?

#133

Post by [deleted] » Wed, Jun 22, 2011, 9:34 PM UTC

[deleted]

Re: Poll: What database does your company use?

#134

Post by tedkalaw » Wed, Jun 22, 2011, 9:36 PM UTC

Currently using MySQL, though I'm giving MongoDB a shot for part of the project.

Re: Poll: What database does your company use?

#135

Post by devongall » Wed, Jun 22, 2011, 9:37 PM UTC

jamwt wrote: post #70

Riak! We're ( http://bu.mp ) using more Riak every day. So far so good.

Loving Riak as well! Our balance is definitely on the write-heavy side of things.

Re: Poll: What database does your company use?

#136

Post by upthedale » Wed, Jun 22, 2011, 9:37 PM UTC

s00pcan wrote: post #90

SQL Server unfortunately. I was reminded why I hate it today when I was trying to set up a simple remote connection to the instance running on my new Windows 7 machine. TCP/IP enabled, IPv4 addresses activated and enabled, remote connections enabled, firewall disabled (for now), and it still didn't work! I tried introducing MySQL over a year ago only to have some hilarious emails with a senior programmer about how we…

> but some people don't consider anything not made by Microsoft worth using.

Also some people don't consider anything made by Microsoft worth using.

Perhaps your senior programmer did fall into the former category, I don't know. However, you should take care not to fall into the latter.

Re: Poll: What database does your company use?

#137

Post by smiler » Wed, Jun 22, 2011, 9:38 PM UTC

jpitz wrote: post #61

j-bone wrote: post #41

If SQLServer is going to be referred to as "Microsoft" shouldn't MySQL be lumped under the "Oracle" grouping?

MS really only has one relevant offering in this discussion, unless you want to add Exchange as a document-oriented store.

A nice distinction would be SQL Server and SQL Server Express. Express being free, it would be interesting to see how many people are using SQL Server Express as a free alternative to MySQL and how many are using SQL Server as the paid alternative

Re: Poll: What database does your company use?

#138

Post by arctangent » Wed, Jun 22, 2011, 9:40 PM UTC

I've voted MySQL because it's the one I personally choose where possible, but applications I write interact with various kinds of datastore including Oracle and Microsoft SQL Server. (We probably have more of those.) One application I made has its canonical datastore inside a series of SharePoint lists, which gets sent to me in CSV via Microsoft Access. Well-meaning but technically incompetent users will find all sorts of ways to store their data!

Re: Poll: What database does your company use?

#139

Post by r00fus » Wed, Jun 22, 2011, 9:42 PM UTC

jpitz wrote: post #61

j-bone wrote: post #41

If SQLServer is going to be referred to as "Microsoft" shouldn't MySQL be lumped under the "Oracle" grouping?

MS really only has one relevant offering in this discussion, unless you want to add Exchange as a document-oriented store.

Yes, sadly FoxPro died when it was acquired by Microsoft.

Re: Poll: What database does your company use?

#140

Post by arethuza » Wed, Jun 22, 2011, 9:43 PM UTC

bad_user wrote: post #112

brown9-2 wrote: post #96

Earlier quoted context omitted.

I hope you realize that a company might choose to use Oracle for a reason other than "brochures and lap dances", and that a "legacy" decision to use Oracle doesn't necessarily mean you are "bogged down" or that the decision was stupid. I don't understand how using Oracle for your RDBMS is suddenly equated with all the things you mention.

Such as? Really, I'd like to know the reason for why a company might choose Oracle.

Because they might want to run some of the applications that Oracle sells that run on top of their database - the example that I am most familiar with being Oracle Hyperion HFM which is by far the leading financial consolidation application for large corporations. Even Google uses Hyperion:

http://www.google.com/intl/en/jobs/uslocations/mountain-view...

[If 12 dimensional hierarchical databases with complex logic are your thing then Hyperion is really rather cool in a perverse kind of way].

BTW If anyone here is interested in this kind of space I have had some interesting experiences in building extensions to HFM...