Live data from Hacker News

Poll: What database does your company use?

news.ycombinator.com

261–270 of 378 posts

Re: Poll: What database does your company use?

#261

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."

Oracle Express actually has a free license. The Express version has most of the same functions as the expensive versions except the 5GB limit on database size. If your app doesn't require lots of data but needs all the SQL power, it's a good choice.

Re: Poll: What database does your company use?

#262

Earlier quoted context omitted.

As does Facebook I believe

Facebook uses MySQL as it's primary data store, with some hbase, cassandra, and other more minor usage storage solutions in various places.

Facebook uses Oracle for certain things.

Re: Poll: What database does your company use?

#263

Earlier quoted context omitted.

He means a flat file of JSON records. Your sarcasm is unnecessary and uncharitable.

The sarcasm was perhaps a little mean but he has a point. If a flat text file storing JSON could replace your database, then you probably never needed a DB in the first place.

If you can use SQLlite, you probably didn't need a real database. So the use cases overlap a bit with flat-files and JSON.

Re: Poll: What database does your company use?

#265
post #213
post #204

Earlier quoted context omitted.

I've heard this about Riak and I was quite excited to test it out for a new project, but in the limited testing I've done Cassandra and HBase both absolutely smoke Riak in terms of write performance. Not really apples to apples I suppose, but I was really surprised at how slow Riak was when handling many (millions) of small writes. We haven't finished our testing/profiling phase yet, so any hints on how to optimize a…

Without going too much into specifics and picking on individual databases (which I could do, boy do I have the scars...) When you hit a certain traffic level, scalability, latency and robustness become far more important than single-node ops/s. I need to be able to add nodes and repair failed nodes while under load--I need the 99.9% latency mark to stay ~100ms while doing so. I don't really care how many bajillions o…

For everything you've said about Riak re: stability and happy scalability, that's exactly why I was excited to include it in this test. I would like to prevent myself/my team from acquiring too many of those scars, so please elaborate on what caused them ;) Especially if those scars came from Cassandra or HBase!

The test hasn't been a "concocted scenario", it's measuring the performance[1] of a prototype implementations for what will be an essential piece of our infrastructure and process (bulk loads of large numbers of small records, very read heavy after the initial load). Riak's write performance was completely adequate, just nowhere near what we got out-of-the-box with the bulk insert operations available in Cassandra and HBase. I asked on #riak channel on freenode and got told to use protocol buffers (which we already were), I'd really appreciate advice beyond this.

> Also, realize that really small values aren't a great fit for Riak in some ways b/c the overhead per value is at least a few hundred bytes.

This is pretty much what I've chalked it up to. It's unfortunate because that is the use case for which we currently need to provide a solution for right now, and once we've got some of our data in one distributed data store, it's convenient (and considered less risky) to use that same technology for the next project. (This is really a culture thing though, it's taking us months to get the necessary buy-in and approval for a postgres 8.2 -> 9.0 upgrade rolled out for a different product, where we know it would solve a specific issue we have).

[1] We've been running our tests on a 4 node cluster, each node has an 8 core 2.8ghz xeon, 32gb of ram, and a woefully inadequate disk: the machines were repurposed from a system that required them to have redundancy and didn't require write performance, so the drives are RAID1. We also need to make recommendations to IT for their hardware purchase plan after our testing.

Re: Poll: What database does your company use?

#267

Earlier quoted context omitted.

The sarcasm was perhaps a little mean but he has a point. If a flat text file storing JSON could replace your database, then you probably never needed a DB in the first place.

If you can use SQLlite, you probably didn't need a real database. So the use cases overlap a bit with flat-files and JSON.

The JSON flat file sounds like variable length records where length is determined by parsing each record with global reader/writer locking?

It's like public storage where you have to sift through everyone else's crap to get to yours, every item is stored in a bulk cargo box and only one customer gets to store their stuff at a time.

If you're interested in db internals, here's a few algorithms that MySQL uses. Note this doesn't cover InnoDB which performs far better under high concurrency loads and offers row level locking, clustered indexes, an excellent caching algorithm, foreign key constraints with cascade, etc..etc...

http://forge.mysql.com/wiki/MySQL_Internals_Algorithms

Re: Poll: What database does your company use?

#268
post #61

Earlier quoted context omitted.

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

It would not surprise me if MS Access were used at more companies than MS SQL Server. I'll leave it to you whether you call it a database :-)

Hah! Don't discount it that quickly - MS Access can be surprisingly useful, particularly for RAD work at a large company where you need to push stuff out to a bunch of MS Office users. I've delivered a bunch of "light" Access/VBA applications to support business initiatives (cranked out in under a week or two) which probably account for over 80% of the value created by my hands on technical work (several of which provided the "chassis" for multi-million dollar performance improvement programs).

Access plays well with everyone (including Oracle, the MS Office family, and Sharepoint), can be heavily extended if you know VBA and are willing to hack a bit, and can often be handed off to a non-technical person for support. The trick is to try to use the same coding/design standards that you would use in a real langauge - the internal parts of my Access/VBA work is influenced by Python and C++.

And from a consulting perspective, it has the advantage of being aligned with what 90% of your Fortune 500 end-users are familar with (MS Office)... simpler handoffs.

That being said...not my first choice for after hours work (do a lot of MySQL, looking to step up to Postgres).

Incidently (for the other thread) - one really nice thing about oracle is their statistical analysis functions - very nice set of tools, co-located with your data, and can be accessed through SQL. Only free solution I've seen that is competitive in terms of functionality is Postgres...

Re: Poll: What database does your company use?

#269
FileMaker. Yes, just laugh. I also wish they would replace their proprietary database system with something more standard, however the developement process is really, really fast and easy to learn.

They should make the DB some SQL variant and use web technologies as their layout engine and it would be a pleasure to work with. I tried to learn Rails and find it hard to get into, though I'm lacking experience as a developer.

Post reply on HN