How to choose your database

[ganjasensation0098]

Hi guys, right now I'm thinking what database I will use in terms of daily transactions. I read already many articles about this but my head is still not clear about this topic. I just want to learn momre on what database is good and when it will be good to use.

 

[misson]

Are you asking about which RDBMS (e.g. MySQL, PostgreSQL, SQL Server, Oracle) to use? What are your requirements?

 

[wilron818]

MYSQL, MSSQL and oracle are the best db. You can choose either of the three...

 

[misson]

@wilron: "Best" depends entirely on the requirements. You've left out PostgreSQL.

 

[callumacrae]

@wilron: "Best" depends entirely on the requirements. You've left out PostgreSQL.

And included MSSQL

 

[wilron818]

@wilron: "Best" depends entirely on the requirements. You've left out PostgreSQL.

Sorry with that. I forgot to include PostgreSQL... It is also an open source DB

---------- Post added at 02:00 PM ---------- Previous post was at 01:58 PM ----------

And included MSSQL

@callumacrae: I already mentioned that DB...

 

[callumacrae]

@callumacrae: I already mentioned that DB...

Exactly

 

[misson]

callumacrae's just being a smart arse.

 

[murtazrocks58]

My sql is the best with all languages and daily use

 

[callumacrae]

My sql is the best with all languages and daily use

SQL isn't a database, it's a method of accessing databases The database would be something like MySQL / Firebird / PostgreSQL.

~Callum

 

[bidzey75]

unless your doing something that demands a specific task use the one your most comfortable with. You will create less bugs and less errors. All the one listed here I suspect are all capable of handle the most common everyday tasks.

I've been working with oracle for 8 years now and it's super duper powerful, there's functions for that database that makes my head spin, or at least what my boss shown me what you can do with them. But for code reduction and efficiency I like working with MySql, the code is quicker and phpMyAdmin is awesome. I am orienting towards the .Net frame work these days and getting acquainted with MSSQL. I can't say nothing about the others never worked with them.

SQL isn't a database, it's a method of accessing databases The database would be something like MySQL / Firebird / PostgreSQL. ~Callum

he ment MySql, but wrote My Sql...

 

[callumacrae]

he ment MySql, but wrote My Sql...

Proof? I read it as SQL, and I reckon most other people will. And I have heard people say it before.

 

[bidzey75]

maybe he ment "My" in the context like "oh my she is beautiful" or... he thinks he owns the technology? but behond that I can't prove it

 

[misson]

You can't outsmart a smart arse (and I wouldn't have it any other way).

 

[callumacrae]

You can't outsmart a smart arse (and I wouldn't have it any other way).

Your post had about six likes, but we've moved to the new system so you lost them

 

[misson]

I hereby bequeath all my missing likes to you.

 

[ganjasensation0098]

What if I used MySQL and PostgreSQL at the same time? Would it be possible?

 

[misson]

You could, but queries to each would have to be separate. You couldn't, for example, join a table stored under MySQL to a table stored under PostgreSQL.

Do you have a use-case in mind?

 

[ganjasensation0098]

I know that I can't join the tables from MySQL to PostgreSQL. What I'm trying to say is it would be possible to use those RDBMs separately in one application.

 

[callumacrae]

Yes, but why would you want to?