Currently using Postgres, but not utilising any of its more powerful features.
I'd start with going over the points of this article (assuming you haven't done just that:) -- https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serv...
Poll: What database does your company/you use?
51–60 of 101 posts
Re: Poll: What database does your company/you use?
#52I'm really happy to see PostgreSQL doing so well. They've been up against MySQL and Oracle for so long and really deserve it due to all the hard work the team have put into the amazing OSS project.
As far as I'm concerned, PostgreSQL should be the standard for any new free software projects. It's just too bad so many older projects (Wordpress, etc.) are tied to MySQL.
Re: Poll: What database does your company/you use?
#53Sybase ASE and Sybase SQL Anywhere are not listed, yes they are different. If you are going to have column stores, you should have InfiniDB. And if you are going to have SQLite, you should also list MS SQL Server Compact. MS Access is also a viable option, also DBase and Filemaker. Clustrix and NuoDB should also be in the list if you are listing NewSQL systems like VoltDB. I am sure there are others :S as a DBA would…
Ask HN: Has anyone ever considered "MS Access a viable option"?
Re: Poll: What database does your company/you use?
#54Sybase ASE and Sybase SQL Anywhere are not listed, yes they are different. If you are going to have column stores, you should have InfiniDB. And if you are going to have SQLite, you should also list MS SQL Server Compact. MS Access is also a viable option, also DBase and Filemaker. Clustrix and NuoDB should also be in the list if you are listing NewSQL systems like VoltDB. I am sure there are others :S as a DBA would…
Ask HN: Has anyone ever considered "MS Access a viable option"?
I freelanced once for the local VA hospital and they sure tried!
Re: Poll: What database does your company/you use?
#55All the academic recordings, such as what student took what course and what grades he has a stored in Informix, at Middle East Technical University (metu.edu). It is such a pain in the ass that at the beginning of the semester, in the interactive registration the system always goes down. As far as I know it has something like maximum of 30-100 active sessions. They were unable to move it to some modern database. Here is some messaging https://groups.google.com/forum/#!topic/comp.databases.infor...
Re: Poll: What database does your company/you use?
#56Earlier quoted context omitted.
Only after you had voted and reloaded the page. Otherwise the effect would be to promote the most popular options. Ideally when you hadn't voted, the ordering would be random.
This is not a popularity vote, it's a vote on what DB you actually use. For a "Best DB system" question, you need to evaluate each DB and rank them all.
It has a lot of options, people will answer a few, get bored... scroll down and read some comments.
The options towards the bottom of the list may not get as much attention and votes even if they are used by people.
If it were alphabetical, people might hunt and peck for the one they use most, e.g. PostgreSQL, they might then see things around there (memcached) but fail to scroll back up and vote for Custom too.
Random deals with it well enough without even knowing the poll content or number of options.
Re: Poll: What database does your company/you use?
#57Currently using Postgres, but not utilising any of its more powerful features.
I'd start with going over the points of this article (assuming you haven't done just that:) -- https://wiki.postgresql.org/wiki/Tuning_Your_PostgreSQL_Serv...
The PostgreSQL 9.0 High Performance book has been great for us, goes in depth into most interest variables that you can tweak on your instance to make sure you're making the most out of your machine's resources: http://www.packtpub.com/postgresql-90-high-performance/book
A bit of a lengthy read, but worth it.
Re: Poll: What database does your company/you use?
#58A word of opinionated advice to anyone deciding on a database to use for their new project: Just go with something popular (MySQL, Postgres, Mongo, etc.), or go with an Amazon hosted cloud database if you really don't want to set anything up (RDS, SimpleDB, DynamoDB). There's no good reason to start a project with other databases. If you're worried about the scalability of something like MySQL when you haven't even g…
What exactly is wrong with Tokyo Cabinet?
Re: Poll: What database does your company/you use?
#59A word of opinionated advice to anyone deciding on a database to use for their new project: Just go with something popular (MySQL, Postgres, Mongo, etc.), or go with an Amazon hosted cloud database if you really don't want to set anything up (RDS, SimpleDB, DynamoDB). There's no good reason to start a project with other databases. If you're worried about the scalability of something like MySQL when you haven't even g…
I don't think this is terribly good advice. Many databases have specific domains in which they excel. I agree you shouldn't be worried about scaling before you have users, but you should absolutely evaluate different tools before picking one.
This is good advice. I've scaled multiple sites to +3 million registered users and more than 1 million unique visitors with heavy DB usage. This is excellent advice for starting out. Along the way we found areas that could be improved and we were able to move quickly to them because our underlying DB was standard stuff. We knew what areas were breaking down and then fixed them with targeted moves to other DBs and things like memcache. Yes, each DB has a specialty but a good general DB gets you a lot of mileage because those specialty DBs do very little a general DB can't but that is often not true the other way.
You would never start a journey with cloudy destination and of a million miles by asking for a moon rover as your vehicle. As your journey develops you would start looking at other options or options for certain segments. Apps follow similar patterns.
Re: Poll: What database does your company/you use?
#60A word of opinionated advice to anyone deciding on a database to use for their new project: Just go with something popular (MySQL, Postgres, Mongo, etc.), or go with an Amazon hosted cloud database if you really don't want to set anything up (RDS, SimpleDB, DynamoDB). There's no good reason to start a project with other databases. If you're worried about the scalability of something like MySQL when you haven't even g…
This might be good advice if you're building cookie cutter systems for clients that have high turnover of contractors, but for startups I think it's horrible.
I'd take one person that really groks devops and database internals well enough to make informed choices over a million one-size-fits-all SQL/Mongo+MVC devs. Any day of the week.