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

Re: Poll: What database does your company use?

#181

Post by espeed » Wed, Jun 22, 2011, 10:58 PM UTC

versae wrote: post #162

espeed wrote: post #5

You should add the Neo4j ( http://neo4j.org/ ) graph database to the list. Graphs are a much more modern and elegant way of storing relational data. I've used Postgres for over 10 years, but it's not a graph database. With graph databases you don't have to mess with tables or joins -- everything is implicitly joined. And Neo4j is ridiculously sweet -- store 32 billion nodes ( http://blog.neo4j.org/2011/03/neo4j-13-ab…

We are also using Neo4j in an academic environment and we are really pleased with it. We recommend it despite of the lack of a good native binding Python, we had to build a neo4j-rest-client ( https://github.com/versae/neo4j-rest-client ) through REST API.

There is an open-source Python persistence framework in the works called Bulbs that connects to Neo4j through the Rexster REST server, and there are binary bindings in the works as well.

There is also a Python open-source Web development framework for graph databases called Bulbflow that is based on Bulbs and Flask.

Both frameworks should be released in the next few weeks.

Re: Poll: What database does your company use?

#182

Post by lukencode » Wed, Jun 22, 2011, 11:01 PM UTC

thechangelog wrote: post #16

SQLite all over the place – it's great having a super portable DB format for quick little hits. There's nothing quite like sending a DB as an email attachment.

In the microsoft world SQL CE 4 is pretty nice for doing the same sort of thing.

Re: Poll: What database does your company use?

#183

Post by kahawe » Wed, Jun 22, 2011, 11:02 PM UTC

patrickaljord wrote: post #179

zacharypinter wrote: post #161

Earlier quoted context omitted.

At the very least, I'd say it has a bias towards younger/smaller companies for whom the price point of Oracle/DB2 doesn't make sense.

As a younger/smaller companies, I wouldn't use Oracle/DB2 even if it was free. Happy mongodb user here.

As someone who has worked in young, small and medium, old and larger companies: I wouldn't use mongo/couch outside of non-critical webapps even if I was paid to do so and for my own (cynic) understanding, it is as much a "database" as a folder with clear text files is.

Yes, Oracle is big, bad and "ebil" and I cannot stand their sales drones.. but if you ever had an "oh CRAP" moment, chances are very good that the db has got your back. Of course it also has its downsides like any other huge software product...

Re: Poll: What database does your company use?

#184

Post by kennystone » Wed, Jun 22, 2011, 11:04 PM UTC

gord wrote: post #83

thechangelog wrote: post #16

SQLite all over the place – it's great having a super portable DB format for quick little hits. There's nothing quite like sending a DB as an email attachment.

For me JSON has replaced SQLLite, with a large reduction in code and complexity. [ Admittedly I've written my own routines to access it more simply/directly on iOS ]

It's pretty handy, and an easy upgrade to a 'real' database if the need ever arises - especially mongo/couch.

Re: Poll: What database does your company use?

#185

Post by georgeott » Wed, Jun 22, 2011, 11:04 PM UTC

IBM DB2 on Big Iron

Re: Poll: What database does your company use?

#186

Post by s00pcan » Wed, Jun 22, 2011, 11:04 PM UTC

Maro wrote: post #118

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…

If licensing and running on Windows would not be an issue, I'd choose SQL Server over Mysql any day.

I only have experience with SQL Server Express (my employer was still using their licensed copy of SQL Server 2000 when I got there in 2009). There are a lot of features I'd love to have that are missing from the free version such as replication and automation tools.

Re: Poll: What database does your company use?

#187

Post by dsl » Wed, Jun 22, 2011, 11:04 PM UTC

jamwt wrote: post #70

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

I love Riak. It's become my go to for "this just has to work" (and I actually work on problems that need to scale, not ones I hope will have to scale).

The only improvement you could make to it would be adding some of the fancier bits that make Redis really nice, like sets and lists.

Re: Poll: What database does your company use?

#188

Post by s00pcan » Wed, Jun 22, 2011, 11:05 PM UTC

chrislomax wrote: post #154

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…

Just as a side note, make sure you had SQL browser service running! It is not running by default on some setups

As far as I can tell, it doesn't work with SQL Server Express. It's there on the configuration tool, but it's disabled completely.

Re: Poll: What database does your company use?

#189

Post by s00pcan » Wed, Jun 22, 2011, 11:06 PM UTC

Jacob4u2 wrote: post #94

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…

Have you tried to do the same thing with MySQL and had success? There's a lot of things in your example that could be causing you grief other than the type of SQL Server you are running; i.e. Network Security, Local Security Configuration (Both machines), User Error (is this something you setup all the time?)

I had similar problems with previous installs, but those are fairly infrequent. I'm sure I'll go in tomorrow and figure it out. This was one of the few things I didn't document how I did it, probably because I was so relieved at getting it to finally work. A student I went to school with just got a new job and one of the tests they had him perform was to log into a local instance of SQL Server using the Management Studio. The catch was the service wasn't started. Too easy... they should have made him do this!

Re: Poll: What database does your company use?

#190

Post by lawnchair_larry » Wed, Jun 22, 2011, 11:07 PM UTC

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.