This site is now 100% read-only, and retired.

What database system do you use?

Submitted by tonyfreeman on Sat 24 Apr 2010

Tags: none.
PostgreSQL  <-> 26% 507 votes
MySQL  <-> 59% 1131 votes
MariaDB  <-> 0% 18 votes
Oracle  <-> 5% 100 votes
None  <-> 3% 59 votes
Other  <-> 3% 72 votes
Total 1893 votes

 

 

 

Re: What database system do you use?
Posted by tttony (190.204.xx.xx) on Sun 25 Apr 2010 at 00:43
[ View Weblogs ]
Most the hosting sites has MySQL, it offers good perfomance for little sites and that is enough

[ Parent ]

Re: What database system do you use?
Posted by Anonymous (203.10.xx.xx) on Thu 29 Apr 2010 at 02:05
SQLite + PHP is a godsend. Seriously, MySQL really chokes old computers.

[ Parent ]

Re: What database system do you use?
Posted by Anonymous (95.93.xx.xx) on Thu 20 May 2010 at 10:59
How old is "old"?

[ Parent ]

Re: What database system do you use?
Posted by ajt (195.112.xx.xx) on Sun 25 Apr 2010 at 16:00
[ View Weblogs ]

This has been asked before, here are the previous surveys for comparison:

--
"It's Not Magic, It's Work"
Adam

[ Parent ]

Re: What database system do you use?
Posted by ajt (195.112.xx.xx) on Sun 25 Apr 2010 at 16:08
[ View Weblogs ]

All sorts...

At work our SAP ECC06 system runs on IBM DB2 on AIX. I've used SQLite in various Perl projects (work and home) and for storing stuff on my desktop system. My Squeeze Debian systems all want MySQL installed even though I didn't ask for it.

--
"It's Not Magic, It's Work"
Adam

[ Parent ]

Re: What database system do you use?
Posted by sweb (92.50.xx.xx) on Tue 27 Apr 2010 at 22:36
I'm using MySQL with PHP. But same az MySQL I'm using SQLite and PostgreSQL.

[ Parent ]

Re: What database system do you use?
Posted by fugit (68.198.xx.xx) on Fri 30 Apr 2010 at 02:04
[ View Weblogs ]
At work we use a lot of different DB's but since the question was you, I pretty much just use mysql. Clean and easy to use.

[ Parent ]

Re: What database system do you use?
Posted by Anonymous (186.18.xx.xx) on Wed 5 May 2010 at 00:59
Using Mysql and Sqlite for PHP and Python apps

[ Parent ]

Re: What database system do you use?
Posted by Anonymous (91.119.xx.xx) on Tue 11 May 2010 at 21:17

[ Parent ]

Re: What database system do you use?
Posted by Anonymous (79.54.xx.xx) on Sat 15 May 2010 at 09:00
We use several RDBMS but I must say that lately, due to the large number of records we manage, we started using partitioned tables on MySQL and we have discovered that they are incredibly fast, they manage automatically your index on all partitions and on top of it they are easy to maintain.

Finally MySQL is becoming enterprise ready.

QatQat

[ Parent ]

Re: What database system do you use?
Posted by Anonymous (122.60.xx.xx) on Mon 17 May 2010 at 01:25
SQLite! Fantastic read speed, and zero maintainance.

[ Parent ]

Re: What database system do you use?
Posted by Anonymous (218.248.xx.xx) on Tue 1 Jun 2010 at 05:27
Postgresql is very difficult to install on linux systems especially Debian ... :(

MySQL on the other hand is very easy to install as well as to understand and work upon :)

[ Parent ]

Re: What database system do you use?
Posted by daemon (146.231.xx.xx) on Wed 2 Jun 2010 at 21:15
[ View Weblogs ]

? Not sure I agree. This is how I install mysql on Debian:

`apt-get install mysql-server`

and this, surprisingly, is how I install postgres. Again, on Debian:

`apt-get install postgresql`

So, if anything, it's simpler to install postgresql, because you don't even need to remember to add the extra "-server" bit to the package name.

Cheers
:wq

[ Parent ]

Re: What database system do you use?
Posted by Anonymous (76.123.xx.xx) on Sat 5 Jun 2010 at 17:50
I much prefer Postgresql, and imagine that if you deal with multiple databases, Postgresql is a better choice.

But I thought I'd throw in that there is a project to port MySQL to the AS400 (iseries). This port uses the built-in AS400 database, which is DB2, as a storage platform for MySQL, but gives you the MySQL client.

The database purist might be horrified to consider using MySQL on a system that already has DB2, but the gain is of course compatibility with software that is built with MySQL. It makes it very easy to port MySQL-based software to the AS400, which is already running Apache by default, and can also run perl and PHP.

[ Parent ]

How can so many use MySQL?
Posted by Anonymous (189.33.xx.xx) on Sun 6 Jun 2010 at 14:59
Man, MySQL is a too bad database, not even a little enterprise ready. Please, when will someone see that?
Try postgreSQL and see the difference - postgreSQL is truly a database system.

[ Parent ]