Earlier quoted context omitted.
Yeah and like HTML5 has totally replaced our web server.
He means a flat file of JSON records. Your sarcasm is unnecessary and uncharitable.
How do you know he means that?
Poll: What database does your company use?
231–240 of 378 posts
Re: Poll: What database does your company use?
#232Sqlite++
Re: Poll: What database does your company use?
#233Is it possible HN has a very strong bias on web developers? Because in "serious business" or at least in my case in finance, you almost always find Oracle and DB2 being the leading DBs and maybe Sybase and maybe-maybe mysql or mssql but hardly ever postgre no matter how awesome it is and definitely never-ever something hip and cool and latest-fashion/fad like Mongo or Couch.
HN does have a strong web developer bias. Afaik I know most major massively multiplayer online games (like World of Warcraft for example) use Oracle. I worked on a game a few years ago that started with MySQL, and switched over to Oracle during development. This is probably only true in larger high budget games though. Social games and f2p games probably use MySQL (or NoSQL) databases because there is a lot more overlap with web development in those worlds.
Re: Poll: What database does your company use?
#234Earlier 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.
As does Facebook I believe
Re: Poll: What database does your company use?
#235Earlier quoted context omitted.
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.
Atomic transactions, perhaps at the expense of pgsql being slower. Subqueries, but we don't require this in production. Wariness of Oracle's conflict of interest.
Mysql has had subqueries since version 4.1, circa 2004!
Re: Poll: What database does your company use?
#236Earlier quoted context omitted.
SQLite is indeed built into iOS and Mac OS X as well. Core Data's store uses SQLite as an option (XML and Binary are the others), and it is accessible via third party frameworks like FMDB.
It's also built into Android.
Unfortunately, it's quite slow on Android. And make sure never to put your db on the sdcard, or else your whole phone becomes unusable while doing writes to the db.
Re: Poll: What database does your company use?
#237Earlier quoted context omitted.
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 :-)
I think it would be fair to say that Jet (Microsoft Access) is a least as much a database as SQLite.
I wont argue, but Jet hasn't been the default backend to Access in a long time. It is SQL Server Desktop Edition now, IIRC.
Re: Poll: What database does your company use?
#238Microsoft
Re: Poll: What database does your company use?
#239Earlier 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…
Was your experience with Cassandra different? Happy at server 10 and 100, that is?
Re: Poll: What database does your company use?
#240Earlier quoted context omitted.
Yeah and like HTML5 has totally replaced our web server.
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.