Learning web development

>learning web development
>have to choose a database between mysql and postgres
>choose mysql because dolphin

how many people did this?

Other urls found in this thread:

youtube.com/watch?v=b2F-DItXtZs
twitter.com/SFWRedditImages

Dolphins are smart.

Postgres and MySQL are really stable and mature RDBMS platforms with lots of support. Pick what you want. Large companies use both. Uber switched from Postgres to MySQL.

>not choosing elephant
what the fuck

I like postgres because of pgadmin.

>>Learning

MySQL and Postgre...

learn both, they aren't THAT different, i'm assuming you are on basic stuff.

sane here...
it does have a lack of useful functions, but it's handy as hell

I really don't have anything more I'd want to have from it. And the graphical output of explain analyze is something that, at least last I checked, is something none of competitors have.

I chose MariaDB

I like MySQL too. I do not like dolphins, fucking arrogant fish.

MariaDB has been a better MySQL for years now.

What is it better at?

well, sometimes i just wanted something automated... just incremental crap like the dev ides does today.

Wouldn't you just write a query to get your thing you want automated done?

FUCK YOU DOLPHIN!

Not being owned by Oracle.

Are there any practical benefits?

Haha jokes on you, I use redis and mongodb.

Open source. Also avoids oracles bad practices and general evilness so it's probably faster.

>Open source
That's not a practical benefit.

>probably faster.
Any practical benefits about which you are sure? Any at all?

See

That's not practical. This does not give you any advantages in practice.

>he fell for the mongo meme

Now he's a mongoloid

youtube.com/watch?v=b2F-DItXtZs

If they're so smart, why do they live in igloos?

...

And?

Im piping you to /dev/null and using ftp instead of databases

Oracle's license doesn't let you use their software to develop weapons of mass destruction, so there's that.

Seriously though, more storage engines to choose from, faster indexing, faster memory tables, better support for lots of connections, clusters supporting master-master replication, higher decimal precision...
There's a reason why most of the enterprise distros switched to MariaDB as their default database.

>not choosing seal

Postgres is actually the better database, but I like that mysql is pretty easy to configure.
I've had issues in the past with postgres' "clusters" and "users" configuration: It's stable, but if you fuck up the configuration you're doomed.

Seals are homophobic and dolphins are rapists.

humans are both, what's you're're're point?

>babby discovers OOP
yes it's conceptual shit for corporate monkeys

FUCK YOU SEAL!

I chose MySQL over PostgreSQL because it's pronounceable.

i say the latter as "post-gress-QL"

>MySEEKwuhl

I just call it Ogre SQL.

postgres

>can I get access to my data?
>I'm sorry Shadow it's ogre

i fell for the mongodb meme, then i realized my mistake and went back to mysql + redis

What's wrong with Mongo?

Because it sounds like
>DroolDB
>SpasticStorage
>InvalidInMemory(TM)

Also, it was made by a company who made it mainly for shilling when better document oriented databases exist. But that's just a minor point.

Check mate

Dolphins are mammals you ignorant

Thus proving once again that humans are truly the superior species.

So you guys are saying leaf is bad?

probably should use sqlite3 for most of these things.

unless you're expecting millions of db transactions and you have your DB properly scaled and sharded, no reason to use them.

it's not that great.
After they acquired WiredTiger, it has gotten significantly less shitty.

nothing really.

if you use to store object dumps and don't need super fancy aggregate handling and other advanced queries, it 'jus werks' for the most part.

Don't "modern" devs use some kind of javascript plugin for this anyway?

its fast man,,, rly fast

Day of rake

Is there a tool like MySQL Workbench for SQLite?
So that I can design the whole database as an EER Diagram and have the program convert that to SQL

What's the difference?
My guess is that Postgresql is more powerful but mysql is more stable.

DB2 is objectively the best database engine, but it costs a lot of money.

i recommend Oracle the best databases

>fish
I feel insulted.

...

Do people look at you like you're retarded?

>how many people did this?
right here, buddy.

If you are just learning there's really no difference. Postgres has a bit more complexity in setting up and maintaining so it may be a better platform to learn. In practice both have pros and cons, MySQL claims performance advantage in some cases while Postgres satisfies more standards and have some extra functionalities.

I save as little data to disk as possible so I am fine with any rdbms or xml file. A database is not a logging machine.

seconding. haven't found anything like this.

Is there something better than this to convince me? I use MongoDB with c# for a server for a game I'm devving (live on steam even).

Not some expert in databases but from some light research I ended up using it. Was easy to setup and secure.

The video you linked started out good but quickly devolved into Sup Forums tier shitposting and I'm genuinely interested in why mongo is bad

Yes.

leaf is trash

>not using mangoDB

Yep

MySql without strict mode on does insane shit. I think it's default now but before it wasn't.

Here's your (You) faggot

Bumping for this.