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

Poll: What databases does your company use?

news.ycombinator.com

Post reply on HN
Print view View original

81–84 of 84 posts

Re: Poll: What databases does your company use?

#81

Post by kt9 »

genwin wrote: post #80
kt9 wrote: post #28

Earlier quoted context omitted.

My production and staging/test environments are on AWS and I do development on my local linux box. Since DynamoDB is a web service I can connect to my DynamoDB tables from anywhere. If you have questions or need help feel free to contact me directly (or post here) and I'll be happy to answer any questions you have.

Nice, I didn't realize that ability to connect from anywhere. Have you found DynamoDB to be expensive in practice? Of course the cost is mitigated by the admin they handle.

Cost has not been an issue for me. I've got 14 tables on DynamoDB - most at 5 read, 5 write, and one at 20 read, 10 write - and its been costing me around $50-$60 per month. IMHO cheaper than running a MySQL database and a slave instances.

It was great during development because I would create the tables in the morning, code all day and then delete the tables at the end of the day so I would only pay for 6-8 hours of provisioned throughput!

Re: Poll: What databases does your company use?

#82

Post by bsg75 »

trebor wrote: post #13

We use MySQL exclusively, unless a client forces us into MsSQL/IIS. I am trying to convert us to PostgresQL over time, but I still have to get a good guide on how to use it.

http://shop.oreilly.com/product/0636920025061.do

http://www.packtpub.com/postgresql-9-admin-cookbook/book

http://www.packtpub.com/postgresql-server-programming/book (forthcoming)

Re: Poll: What databases does your company use?

#83

Post by alexatkeplar »

vosper wrote: post #74
alexatkeplar wrote: post #60

Earlier quoted context omitted.

We also use/support ICE at SnowPlow.

I'd be interested to know what other systems you looked at before settling on ICE? We evaluated HBase, Hypertable and Riak (kind of a wildcard entry) as analytics platforms but then found Infobright purely by luck, and were very impressed by the performance and ease of use.

Sorry Vosper - just saw this. We started with a Hive-based approach for SnowPlow but got tired of having to run a map-reduce for each query, so started looking at columnar databases. ICE is the first columnar database we have integrated SnowPlow with - mainly picked because the OSS project is quite well documented and supported, rather than because of any performance benchmarks. We will probably integrate with other columnar dbs in due course too (e.g. Vertica, Greenplum). Thanks for the Hypertable steer - will definitely take a look at that too.

Re: Poll: What databases does your company use?

#84

Post by genwin »

kt9 wrote: post #81
genwin wrote: post #80

Earlier quoted context omitted.

Nice, I didn't realize that ability to connect from anywhere. Have you found DynamoDB to be expensive in practice? Of course the cost is mitigated by the admin they handle.

Cost has not been an issue for me. I've got 14 tables on DynamoDB - most at 5 read, 5 write, and one at 20 read, 10 write - and its been costing me around $50-$60 per month. IMHO cheaper than running a MySQL database and a slave instances. It was great during development because I would create the tables in the morning, code all day and then delete the tables at the end of the day so I would only pay for 6-8 hours of…

Good report, thanks! I'll keep that idea in mind to delete tables to save $$.
Post reply on HN