>learning web development >have to choose a database between

>>59144531
Dolphins are smart.

>>59144531

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.

>>59144531
>not choosing elephant
what the fuck

File: ss+(2017-02-27+at+01.37.23).png (131KB, 1443x1160px) Image search: [Google]

131KB, 1443x1160px

I like postgres because of pgadmin.

>>59144531

>>Learning

MySQL and Postgre...

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

>>59144668

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

>>59144684
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.

>>59144531
I chose MariaDB

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

>>59144531
MariaDB has been a better MySQL for years now.

>>59144745
What is it better at?

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

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

File: FUCKYOUDOLPHIN.gif (267KB, 427x240px) Image search: [Google]

267KB, 427x240px

>>59144531
>>59144723
FUCK YOU DOLPHIN!

>>59144759
Not being owned by Oracle.

>>59144875
Are there any practical benefits?

Haha jokes on you, I use redis and mongodb.

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

>>59144935
>Open source
That's not a practical benefit.

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

>>59144887
See >>59144875

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

>>59144895

>he fell for the mongo meme

>>59145021
Now he's a mongoloid

>>59145021
>>59145041
https://www.youtube.com/watch?v=b2F-DItXtZs

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

File: Screenshot_20170227-192936(1).jpg (118KB, 1440x1013px) Image search: [Google]

118KB, 1440x1013px

>>59145055

>>59145171
And?

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

File: oracle.png (42KB, 693x462px) Image search: [Google]

42KB, 693x462px

>>59144759
>>59144887
>>59144946
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.

File: mariadb-icon.png (32KB, 512x512px) Image search: [Google]

32KB, 512x512px

>not choosing seal

>>59144531

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.

>>59145432
Seals are homophobic and dolphins are rapists.

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

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

File: FUCKYOUSEAL.jpg (14KB, 277x315px) Image search: [Google]

14KB, 277x315px

>>59145432
FUCK YOU SEAL!

I chose MySQL over PostgreSQL because it's pronounceable.

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

>>59145571
>MySEEKwuhl

>>59145571
>>59145604
I just call it Ogre SQL.

>>59145571
>>59145604
>>59145650
postgres

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

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

>>59145763
What's wrong with Mongo?

File: gondola.jpg (45KB, 400x400px) Image search: [Google]

45KB, 400x400px

>>59145868
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.

>>59145081
Check mate

>>59144723
Dolphins are mammals you ignorant

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

File: mongodb-logo.png (34KB, 325x225px) Image search: [Google]

34KB, 325x225px

>>59144531
So you guys are saying leaf is bad?

>>59144531
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.

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

>>59145868
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.

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

File: fust.png (9KB, 404x297px) Image search: [Google]

9KB, 404x297px

>>59148938
its fast man,,, rly fast

>>59148938

Day of rake

>>59148967
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

>>59144531

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

File: id.png (24KB, 650x200px) Image search: [Google]

24KB, 650x200px

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

>>59144531
i recommend Oracle the best databases

>>59144723
>fish
I feel insulted.

>>59145604
Do people look at you like you're retarded?

>>59144531
>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.

>>59144531
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.

>>59153166
seconding. haven't found anything like this.

>>59145055
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 4chan tier shitposting and I'm genuinely interested in why mongo is bad

File: sure.png (116KB, 354x302px) Image search: [Google]

116KB, 354x302px

>>59148938
Yes.

>>59148938
leaf is trash

>not using mangoDB

File: 1484968404208.png (431KB, 640x478px) Image search: [Google]

431KB, 640x478px

>>59144531
Yep

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

>>59144791
>>59145504
Here's your (You) faggot

>>59156586
>>59153166

Bumping for this.