Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Poll: What database does your company use?

news.ycombinator.com

Post reply on HN
Print view View original

191–200 of 378 posts

Re: Poll: What database does your company use?

#191

Post by pyre »

ibejoeb wrote: post #143
msluyter wrote: post #19

I'm surprised to see that Oracle even has as many mentions as it does, given how rarely you read about it here on HN. We're locked into it at my workplace, and every time I'm reminded of this PG quote I cringe a little: "The more of an IT flavor the job descriptions had, the less dangerous was the company. The safest kind were the ones that wanted Oracle experience. You never had to worry about those."

I'm probably starting to sound like a broken record around here, but: 1. I build products on Oracle at a startup. 2. Oracle has many compelling features that really don't have first-class open source alternatives: OLAP, encryption (wire and at-rest), VPD, materialized views with query rewriting, object and document storage, monitoring and tracing, among others... 3. Oracle got more compelling since being offered--lic…

We actually have our own extensions to use Perl filehandles to write directly to Oracle LOBs. I don't know if that is Oracle-specific or if it can be used elsewhere. I've never cracked open the implementation.

Re: Poll: What database does your company use?

#192

Post by s00pcan »

upthedale wrote: post #136
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.

This isn't something I would do; I know that every tool has its use. I basically own the website and wanted to do a PHP/MySQL site, but we are under contract to use .Net and my supervisor wants to not do anything that could be considered a breach of contract. However, now that I'm using Linux as my main operating system I am constantly being reminded of how the different philosophies between the operating systems affect me. Ninite is a great tool, but installing everything I want from packages is simply awesome. And of course, Linux systems don't need to be restarted in order to apply updates, but on Windows you always need to. This is why I have to possibly go to our data center tomorrow morning if the Server 2008 box our database is on doesn't come back up for remote access when I update it tonight.

Re: Poll: What database does your company use?

#193

Post by s00pcan »

__rkaup__ wrote: post #142
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…

The GPL doesn't forbid charging for software licensed with it. The Free Software Foundation even encourages you to sell your GPL'ed software [1]. However, once you have the software, you can do whatever you like with it, and that includes giving it away for free. [1] http://www.gnu.org/philosophy/selling.html

Right, which is why some companies (such as MySQL AB) charge for support and custom tools instead of the software itself (which is always free to use). The senior programmer I spoke of called them and their marketing staff was of course desperate at the chance to make some money, so she came off thinking that we would have to pay for MySQL. And of course, there's the whole "you have to release all of your source code if you use MySQL anywhere our system!" fallacy.

Re: Poll: What database does your company use?

#194

Post by [deleted] »

tedunangst wrote: post #121
bad_user wrote: post #87

Earlier quoted context omitted.

Having Oracle as your db doesn't mean that you are not working on interesting problems First, I consider consultancy for customers using Oracle to be OK, as long as you earn something from it. But if your company chooses Oracle, it means that you're bogged down by legacy, stupid company processes and/or clueless managers. And in most such environments, the harder you try to change it for the better, the harder it fig…

Amazon uses Oracle. I think to completely disregard Amazon because of this fact would be a mistake.

[deleted]

Re: Poll: What database does your company use?

#196

Post by s00pcan »

blntechie wrote: post #153
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…

I've never worked much with other databases other than SQL Server. But one time I had to work with Oracle and MySQL, I had trouble getting a good enough client (like SQL Server Management Studio) even though I was ready to pay. May be it's my personal preference, I tried many clients (TOAD, DBArtisan, SQL Developer, SQL Plus etc.) and found that none was as polished (not that i'm mentioning functional) and integrates…

I will say that the SQL Server Management Studio is a great tool, but because it's a GUI tool everything has to be buried in menus. If you plan on using it, read a guide first, because it's not entirely intuitive. It has the occasional cryptic error message or even unhandled exception, but my biggest annoyance is this: You can copy in rows from results and paste them to insert rows, but say you made a mistake and paste in hundreds of rows that don't fit the database schema: you will get hundreds of messagebox popups. The only way out I've found is to end the process.

Re: Poll: What database does your company use?

#197

Post by dgallagher »

lawnchair_larry wrote: post #190
rosser wrote: post #79

I'd vote for PostgreSQL multiple times if I could. I'm a consultant DBA (-ish; I do other stuff as well, but that's what puts most of the food on my table), and have multiple clients using pg.

Why do you use pgsql over mysql? I've used mysql a lot, and pgsql a little. I can't tell the difference, other than pgsql being slower and having less support. Some people swear by it, so I'm curious what I am missing.

I personally picked PostgreSQL instead of MySQL since I don't trust Oracle. Why support a free database server when it competes with Oracle RDBMS? Granted Oracle RDBMS is extremely expensive, but still, something doesn't sit well with me...

Re: Poll: What database does your company use?

#198

Post by pvarangot »

lawnchair_larry wrote: post #190
rosser wrote: post #79

I'd vote for PostgreSQL multiple times if I could. I'm a consultant DBA (-ish; I do other stuff as well, but that's what puts most of the food on my table), and have multiple clients using pg.

Why do you use pgsql over mysql? I've used mysql a lot, and pgsql a little. I can't tell the difference, other than pgsql being slower and having less support. Some people swear by it, so I'm curious what I am missing.

I'm no longer a database "poweruser" due to changing requirements in my job, but not too long ago I used to be and MySQL had no CHECK constraints. Also triggers are less flexible than in Postgre, like in a cascading delete/update won't fire them.

Historically, PostgreSQL has been considerably more SQL-feature-rich than MySQL. It still is, yet to a lower extent (see previous paragraph) due to MySQL caching up. For example, MySQL only has views, triggers and stored procedures since version 5, and Postgre had them since at least 7 or 8 which were already mature at the time MySQL 5 was still development. I guess a lot of people became adepts at that time.

Re: Poll: What database does your company use?

#199

Post by dsl »

qrush wrote: post #20

Hey Redis folks, if you haven't played with http://radishapp.com/ yet I'd love to hear your feedback on it. Also, go Postgres! Woot!

Failure. You don't know your audience.

Fortune 500's will pay you to spit out graphs, but they don't use bleeding edge tools like Redis.

Anyone who uses Redis in any serious fashion already knows that the numbers you show on the homepage are easy to get to. Just write a script to pump them into $graphing_software.

My advice would be to give the current product away for free (yes right now), making the barrier to entry lower than doing it yourself and capturing future customers. Then focus on selling people things that are hard, like real actionable intelligence. Everything you charge for should answer a question like "what", "who", "where", "why". Free stuff should answer questions like "how many".

[Edit: Just realized you are the Hoptoad guys (of which I am a happy user), so I know you have the potential]

Re: Poll: What database does your company use?

#200

Post by rksprst »

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.

Microsoft has key-value database on Azure as Azure Tables. They also have Azure SQL which is different than just SQL Server (though very similar).
Post reply on HN